歡迎您光臨本站 註冊首頁

oracle 監聽服務起不了

←手機掃碼閱讀     火星人 @ 2014-03-25 , reply:0

centos 6 靜默安裝oracle10g 啟動監聽服務報錯

[oracle@cent admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-DEC-2011 08:49:40

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=1.1.1.88)(PORT=1521)))
TNS-01192: Missing SID_LIST_ value left of equation for SID description in LISTENER.ORA

Listener failed to start. See the error message(s) above...

listen 設置
ID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.88)(PORT = 1521))
)
)
tns設置

orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.88)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cent)
)
)

環境變數
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=orcl
#export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export TNS_ADMIN=/u01/app/oracle/product/10.2.0/db_1/network/admin
#export LANG=AMERICAN_AMERICA.ZHS16GBK
export LANG=en_US
export LC_ALL=C
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export ORACLE_DOC=$ORACLE_HOME/doc

[火星人 ] oracle 監聽服務起不了已經有507次圍觀

http://coctec.com/docs/linux/show-post-156849.html