cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
16,844

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

Accepted Solutions (1)

Accepted Solutions (1)

sebastian_sebaraj
Participant
0 Kudos

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
0 Kudos

Hi Sebastian Sebaraj,

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

regards

Naveen

Answers (5)

Answers (5)

sebastian_sebaraj
Participant
0 Kudos

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
Participant
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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

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

Former Member
0 Kudos

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
0 Kudos

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
Participant
0 Kudos

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
0 Kudos

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
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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