Posts

Showing posts from 2014
ORA-00845: MEMORY_TARGET not supported on this system There is always something that gets in the way. One problem I regularly stumble upon when installing a new Oracle 11g R2 installation is the following error when I try to start the database: SQL> startup nomount; ORA-00845: MEMORY_TARGET not supported on this system So I keep this post mainly for my own reference when installing a new database on a Linux system. This error comes up because you tried to use the  Automatic Memory Management (AMM)   feature  of Oracle 11g R2. Well done, but it seems that your shared memory filesystem (shmfs) is not big enough. So let’s look at the steps necessary to enlarge your shared memory filesystem to avoid the error above. First of all, login as root and have a look at the filesystem: [root@oracle-em oracle]# df -h Filesystem Size Used Avail Use% Mounted on /dev/mapper/vg_oracleem-lv_root 93G 19G 69G 22% / tmpfs ...
Post a Comment
Read more
Space_Count **   select user_bytes/1024/1024 from dba_data_files         where tablespace_name='<tbs_name>'; ** select sum(user_bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';            This will give us the space used in a particular datafile..... Tablespace_Size ** select bytes/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>'; ** select sum(bytes)/1024/1024 from dba_data_files       where tablespace_name='<tbs_name>';             This command will give the tablespace size what size is the tablespace created of..
Post a Comment
Read more
Renaming Database Well Rename your database in a very easy way..without affecting the DBID or to the SID... Step 1 :  Backup Controlfile to text Step 2:  Create  a pfile of your database Step 3:  Edit your controlfile with database name...keeping only resetlogs Step 4:  Edit pfile with dbname and controlfile parameter.. Step 5:  Startup with nomount option with the updated pfile.. Step 6:  Create a new controlfile Step 7:  Update the new controlfile in pfile and Startup with that pfile Step 8:  Create a new Spfile from the updated Pfile....               Thats it Database is renamed.......... Sql > alter database backup controlfile to trace as '/home/oracle/control.txt [ oracle@localhost :~ ]  vi control.txt CREATE CONTROLFILE REUSE DATABASE "ORACLE" RESETLOGS  ARCHIVELOG     MAXLOGFILES 16     MAXLOGMEMBERS 3     MAXDATAFILES 100 ...
Post a Comment
Read more
Recovery Catalog Step 1: Create a user to own Recovery Catalog..and grant him the necessary privilage   **   create user recovery identified by recovery;   **   grant connect,resource,recovery_catalog_owner to recovery... Step 2 : Create a default tablespace for the recovery owner..      **   create tablespace recovery             datafile "....................path............." size 50m autoextend on; Step 3: Make the user use the default tablespace which is created      **  Alter user recovery default tablespace recovery; Step 4: Creating catalog In the other screen just connect rman catalog..        **    rman catalog username/password                 ex: rman catalog recovery/recovery later inside rman   rman > create catalog;              ---> Thi...
Post a Comment
Read more
Index Re-building.. ALTER INDEX <IDX_NAME> REBUILD ONLINE; If your issue is its huge table and it might take more time to execute then you can use Parallel execution method. 1. Take your session in Parallel DML mode. ALTER SESSION ENABLE PARALLEL DML; 2. Take your table in Parallel Mode ALTER TABLE <TABLE_NAME> PARALLEL; 3. Run Rebuild Index command. ALTER INDEX <IDX_NAME> REBUILD ONLINE; 4.  Take your session back to normal mode. ALTER SESSION DISABLE PARALLEL DML; That is it !!!
Post a Comment
Read more
Startup Issue...  Recent when I had to start my database...    When I give Startup to an existing database it is giving me this error which I have never come across please help.. here is the complete steps export ORACLE_SID=oracle [oracle@localhost oracle]$ sqlplus sys as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Tue May 6 15:57:07 2014 Copyright (c) 1982, 2009, Oracle.  All rights reserved. Enter password: Connected to an idle instance. SQL> startup   ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper SQL> startup ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsper So here the e...
Post a Comment
Read more