'database/ORACLE'에 해당되는 글 93건

  1. 2009.10.21 oracle 장애 ORA-27140 / ORA-01034 / ORA-27101 / SVR4 Error

반응형

(장애발생>
# 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

재구동 처리


 

반응형
Posted by 공간사랑
,