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 error it says the storage Issue ...

  ie...ORA-27301....check for the space on linux machine....


 df -hk or df-h....

   Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             3.9G  540M  3.2G  15% /
/dev/sda6             124G   25G   94G  21% /home
/dev/sda5             3.9G   75M  3.7G   2% /tmp
/dev/sda2             9.7G  4.4G  4.9G  47% /usr
tmpfs                 506M     0  506M   0% /dev/shm



once after seeing this what we can understand is the space is there and it not an issue...

So now lets concentrate on another error...in this 

ie..ORA-27300 OS system dependent....

  to check this....

  go to root and 

  [root@localhost ~]# cat /proc/sys/kernel/sem
  250     100     32      128

  [root@localhost ~]# echo " 250 1500 100 128 " > /proc/sys/kernel/sem

  [root@localhost ~]# cat /proc/sys/kernel/sem
   250     1500    100     128
 
  Update the segement sem like this and go start the database....

  export ORACLE_SID=oracle
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue May 6 16:13:53 2014

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  318046208 bytes
Fixed Size                  1336260 bytes
Variable Size             134220860 bytes
Database Buffers          176160768 bytes
Redo Buffers                6328320 bytes
Database mounted.
Database opened.


Thats it a rare...error...but have a look at this.....  

Comments

Post a Comment

Popular posts from this blog

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..
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 !!!
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 ...
Read more