리눅스에서 오라클에 대해서 ... 0 2 1,729

by 규니 [2004.10.21 16:00:03]


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]$

 

도움 부탁드립니다.

by 올아클 [2004.10.21 00:00:00]
리눅스 system 환경설정파일을 살펴보세요...

by nmccm [2004.10.21 00:00:00]
system 환경설정 파일이란것은 어떤걸 말씀하시는건가요?

커널 파라메타 같은걸 말씀하시는건지? 맞다면.. 이런부분이 설정이 안되고서야 오라클은 설치시 에러가 났을꺼 같은데요..

system 환경설정 파일이란것은 어떤걸 말씀하시는건지.. 구체적인 설�
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입