Redhat Enterprise Linux AS 3.0 에 Oracle 10g 를 설치하였습니다.
리스너.ora 와 tnsxxxx.ora 도 제대로 설정되어서..
sqlplus system/비번 하면 제대로 오라클 접속이 되어
select * from tab; 했을경우 테이블 목록도 제대로 보았습니다.
그런데 ;;; 리눅스 서버를 재부팅 하고 나서는 아래의 데몬들만 떠있는 상태로 아무것도 되질 않는군요..
[root@localhost oracle]# ps -ef | grep ora
root 4330 1 0 Oct20 ? 00:00:00 /bin/su oracle -c exec /data1/oracle/product/10.1.0/db_1/bin/ocssd
oracle 4343 4330 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4345 4343 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4346 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4347 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4348 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4349 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4350 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4351 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4352 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4354 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4355 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4356 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4357 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4358 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4359 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
root 18547 1 0 10:09 ? 00:00:00 login -- oracle
oracle 18548 18547 0 10:09 tty1 00:00:00 -bash
root 19209 19054 0 15:56 pts/0 00:00:00 grep ora
[root@localhost oracle]#
그래서 dbstart 도 해보았습니다만.. 이것역시 먹통 ㅡ,.ㅡ;;
[oracle@localhost oracle]$ $ORACLE_HOME/bin/dbstart
[oracle@localhost oracle]$ ps -ef | grep ora
root 4330 1 0 Oct20 ? 00:00:00 /bin/su oracle -c exec /data1/oracle/product/10.1.0/db_1/bin/ocssd
oracle 4343 4330 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4345 4343 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4346 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4347 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4348 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4349 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4350 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4351 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4352 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4354 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4355 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4356 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4357 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4358 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 4359 4345 0 Oct20 ? 00:00:00 /data1/oracle/product/10.1.0/db_1/bin/ocssd.bin
oracle 18548 18547 0 10:09 tty1 00:00:00 -bash
oracle 19213 19211 0 15:57 ? 00:00:00 sshd: oracle@pts/0
oracle 19214 19213 0 15:57 pts/0 00:00:00 -bash
oracle 19272 19214 0 15:58 pts/0 00:00:00 ps -ef
oracle 19273 19214 0 15:58 pts/0 00:00:00 grep ora
[oracle@localhost oracle]$
.bashrc 파일의 내용입니다.
[oracle@localhost oracle]$ cat .bashrc
# .bashrc
# User specific aliases and functions
# Source global definitions
if [ -f /etc/bashrc ]; then
. /etc/bashrc
fi
export ORACLE_BASE=/data1/oracle
export ORACLE_HOME=/data1/oracle/product/10.1.0/db_1
export ORACLE_OWNER=oracle
export ORACLE_SID=OCP
export TNS_ADMIN=$ORACLE_HOME/network/admin
export PATH=$PATH:$ORACLE_HOME/bin
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
export PATH ORACLE_BASE ORACLE_HOME ORACLE_OWNER ORACLE_SID TNS_ADMIN NLS_LANG LD_LIBRARY_PATH ORA_NLS33 PATH LD_ASSUME_KERNEL TEMPDIR THREADS_FLAG PATH CLASSPATH EDITOR LANG NLS_DATE_FORMAT
unset USERNAME
[oracle@localhost oracle]$
도움 부탁드립니다.