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]$

ITPub博客

ORA-01092: ORACLE instance terminated. Disconnection forced

最新文章