(장애발생>
# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 21 13:42:39 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-27140: attach to post/wait facility failed
Enter user-name:
(해결방법)
chmod 6775 $ORACLE_HOME/bin/oracle 권한 부여
(장애발생)
# sqlplus
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 21 13:20:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
Enter user-name:
(해결방안)
.profile 환경변수값 확인
# PS1 Variable
export PS1=[$LOGNAME@`hostname`:{\!}:'$PWD]# '
# LANG
export LANG=ko
# ORACLE
export ORACLE_SID=orcl
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_OWNER=oracle
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
sqlplus /nolog
connect /as sysdba
startup
재구동 처리
