ORA-01102 Error Resolution method

sql> Startup

ORACLE instance started.

Total System Global area 599785472 bytes

Fixed Size 2022600 bytes

Variable Size 171967288 bytes

Database buffers 419430400 bytes

Redo buffers 6365184 bytes

Ora-01102:cannot mount Database in EXCLUSIVE mode

This error is mainly caused by the lk<sid> file, which is located under the DBS directory under Oralce_home,

The main function of this lk<sid> is to indicate that the database mount is not on Mount. Database unmount will be deleted, if the database does not mount, this file is on your mount, only manually deleted , so be sure to be careful.

The steps to solve the ORA-01102 problem specifically:

#/sbin/fuser-u Lktest

lktest:4918 (Oracle) 20726 (Oracle) 20728 (Oracle) 20730 (Oracle) 20732 (Oracle) 20734 (Oracle) 20736 (Oracle) 20738 (Oracle) 20740 (Oracle) 20742 (Oracle) 20744 (Oracle) 20746 (Oracle) 20754 (Oracle) 21781 (Oracle) 21783 (Oracle)

The file was not released and killed with the Fuser command:

#/sbin/fuser-k Lktest

lktest:6666 6668 6670 6672 6674 6676 6678 6680 6690 6692 6694 6696 6737 6830

#/sbin/fuser-u Lktest

And then:

Sql> Startup

ORACLE instance started.

Total System Global area 599785472 bytes

Fixed Size 2022600 bytes

Variable Size 171967288 bytes

Database buffers 419430400 bytes

Redo buffers 6365184 bytes

Database mounted.

Database opened.

Sql>

The database was successfully open.