ORACLE常见问题集锦

ORA-29702: error occurred in Cluster Group Service operation
1. Shutdown the database completely.
2. Relink with RAC OFF :

$ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk rac_off
$ make -f ins_rdbms.mk ioracle

3. Startup the database.

 

ORA-01012: not logged on

kill oracle progress

$ ps -ef|grep ora_dbw0_$ORACLE_SID

$ kill -9 pid

 

oracle数据库环境变量配置

export PATH
export ORACLE_BASE=/opt/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib