|
|
|
export ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH ORACLE_HOME_LISTNER
1. oratab 파일 (/var/opt/oracle/oratab) 열기 - 리눅스의 경우 (/etc/oratab)
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by the Database Configuration Assistant when creating
# a database.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third filed indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
orcl:/u01/app/oracle/oracle/product/10.2.0/db_1:Y
cassis:/u01/app/oracle/oracle/product/10.2.0/db_1:N
2. 자동으로 뜨기 원하는 원하는 SID의 자동 시작 여부 필드가 Y가 되도록 변경하기.
3. dbstart 실행.
4. lsnrctl start실행. (ORACLE_HOME_LISTNER 이 정확하게 등록되어 있다면 dbstart시 이미 실행됨.)
5. sqlplus로 연력되는 것으로 정상 동작 확인.
$ sqlplus /nolog
SQL> CONNECT system@dev101ee
Enter password: <Enter SYSTEM password>
