OS:REDHAT AS 4.6

DB:ORACLE 10.2.0.1

 

CREATE DATABASE mydb
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

 

SQL> !oerr ora 1092
01092, 00000, "ORACLE instance terminated. Disconnection forced"
// *Cause:  The instance this process was connected to was terminated
//          abnormally, probably via a shutdown abort. This process
//          was forced to disconnect from the instance.
// *Action: Examine the alert log for more details. When the instance has been
//          restarted, retry action.

alert.log

 

The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths

 

[root@localhost /]# find / -name libocrb10.so

/opt/oracle/app/oracle/product/10.2.0/db_1/lib/libocrb10.so

[root@localhost /]# find / -name libocrutl10.so
/opt/oracle/app/oracle/product/10.2.0/db_1/lib/libocrutl10.so

 

 

oracle user  .bash_profile  add:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

 

 

[oracle@localhost mydb]$ pwd
/opt/oracle/oradata/mydb
[oracle@localhost mydb]$ rm -rf *

 

[oracle@localhost mydb]$ cd $ORACLE_HOME/dbs
[oracle@localhost dbs]$ ls
afiedt.buf  ed.hup  hc_mydb.dat  initdw.ora  initmydb.ora  init.ora  lkMYDB  ora_control1  ora_control2  spfilemydb.ora
[oracle@localhost dbs]$ rm -rf ora_control*
[oracle@localhost dbs]$