Error --ORA-01081: cannot start already-running ORACLE - shut it down first

[Former Member]

Hi Experts,

I have tried to start the Database (Oracle 10G) using the command startsap DB, i am getting the error as

ORA-01081: cannot start already-running ORACLE - shut it down first But i have already stopped the sap instances.

Kindly suggest me how to stop the database and start it again.

regards

Naveen

[sebastian_sebaraj · Accepted solution]

If you killed all the oracle process using kill -9 and cleaned up the semaphore you should be good to restart the Database.

Do not use startsap script.

type the following command and update this message with what you get.

-- make sure all the processes are cleanup.

$sqlplus "/as sysdba"

sqlplus>startup

If Oracle Startsup without error then you can shutdown

sqlplus>shutdown imemdiate;

and then user startsap script

Do you have access to Oracle Metalink.

It is a very good knowledge Base for Oracle Errors

[Former Member · Accepted solution]

Hi Sebastian Sebaraj,

Thanks, i have started the database by following your suggestions. Now it is working fine.

regards

Naveen

[sebastian_sebaraj]

If you are running multiple Oracle Version and Multiple Instance make sure you set the right value

for the following parameters

LIBPATH

you can check the value by typing

echo $LIBPATH

[sebastian_sebaraj]

check any process running with name ora by typing

ps -ef | grep ora

kill -9 process_name

try to start again, if you still get any problem, may be to do with Semaphores

Follow the steps to remove semaphore

Removing a semaphore set for Oracle

root> ipcs -sb|grep oracle

s 67 0x00000000 ra-r--- oracle dba 400

s 223 0x00000000 ra-r--- oracle dba 400

s 334 0x00000000 ra-r--- oracle dba 300

Now, you can remove the semaphores from the list. In this example, we assume that set 223 is the one for the crippled database.

root> ipcrm -s 223

hope it helps.

BY the way what is the operating system

[Former Member]

Hi Sebastian Sebaraj

Thanks for your reply, I did the steps which you have suggested me.

I have killed a processes running by ora. Then again i tried to stop the database, i am getting the following error

ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46], [1], [], [], [], [], [] kindly suggest me, how to stop the database.

regards

Naveen

[Former Member]

you can force database to shutdown using following commands

follow http://dba-oracle.com/t_oracle_shutdown_immediate_abort.htm

sqlplus "/as sysdba"

sql> shutdown abort

about ORA-00600 which database version and patch you are on.

Cheers,

-Sunil

[former_member204746]

After searching at Google with keywords keltnfy-ldminit, I have found this:

http://www.ora-600.net/ORA-00600_keltnfy-ldminit.html

[Former Member]

hi naveen,

login to your system using root

switch to ora<sid> user

#su - ora<sid>

connect to your Oracle

$sqlplus / nolog

connect to database using sysdba priviledge

SQL>conn / sysdba;

connected

shutdown your database

SQL>shutdown immediate;

After that, exit.

Start your database and SAP again.

ardhian

http://sapbasis.wordpress.com

http://ardhian.kioslinux.com

[Former Member]

Hi Ardhian Inaroka,

Thanks for your elaboreate reply, i have already tried to stop the database using SHUTDOWN IMMEDIATE by logging in as ora<SID>,

i am getting a message as SERVICE HANDLE NOT INITIALIZED .

kindly suggest

[rajeev_das]

Can you please check if the processes are still running by using (if its Unix system) -

ps -aef|grep -i ora_

Cheers,

Rajeev

[Former Member]

Hi Naveen

stoping SAP doesnt mean that Database is down its still running its still open as Mr.Sovon was sugesting you may login to oracle as SYSDBA and try to shutdown DataBase and may do nessecary activities and also check sapdb.log or the database alert logs

 ORA-01081: cannot start already-running ORACLE - shut it down first But i have already stopped the sap instances.  

regards

George

[Former Member]

Hi George,

Thanks for your reply, I have already tried what Mr. Sovon suggested me.

I connected to Database as SYSDBA and when i execute the command SHUTDOWN i am getting the message as SERVICE HANDLE NOT INITIALIZED and oracle is still running. Kindly suggest me how to stop the database.

regards

Naveen kumar

[former_member524429]

Hi

TNS Listener Status ?

Whether ORACLE_SID Env. variable is set Properly ?

1. set ORACLE_SID=whatever

2. connect internal or run sqlplus "/as sysdba"

3. "shutdown normal" or "shutdown immediate", and then

4. "startup" or "startup force"

Regards

Bhavik Shroff

[Former Member]

Hello Naveen,

Looks like your db has not shutdown properly.

Requesting you to perform the following steps :

1. From SQL prompt issue the command : shutdown immediate;

I am expecting you will get an error saying shutdown is in process... like this.

2. From SQL prompt issue the command : shutdown abort;

Now your db will be down...

3. From SQL prompt issue the command : startup

Best wishes...

Sovon Sengupta