- 论坛徽章:
- 0
|
操作系统:SCO OPENSERVER 5.0.7, ORACLE 7.3.4用户:ora734,SID: MODB (表示My Oracle DataBase)
$ pwd
/u/ora734
$ cat ./app/oracle/product/7.3.4/network/admin/listener.ora
#
# Installation Generated Net V2 Configuration
# Version Date: Sep-16-97
# Filename: Listener.ora
#
LISTENER =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= IPC)(KEY= MODB))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
(ADDRESS= (PROTOCOL= TCP)(Host= mysco507)(Port= 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME= mysco507.)
(ORACLE_HOME= /u/ora734/app/oracle/product/7.3.4)
(SID_NAME = MODB)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
如果将$ORACLE_HOME/network/admin/listener.ora 复制到 /etc/listener.ora ,或者这样启动 listener:
$ TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
$ lsnrctl start
就会报如下的错误:
LSNRCTL for SCO System V/386: Version 2.3.4.0.0 - Production on 21-NOV-10 20:13:48
Copyright (c) Oracle Corporation 1994. All rights reserved.
Starting /u/ora734/app/oracle/product/7.3.4/bin/tnslsnr: please wait...
TNSLSNR for SCO System V/386: Version 2.3.4.0.0 - Production
System parameter file is /u/ora734/app/oracle/product/7.3.4/network/admin/listener.ora
Log messages written to /u/ora734/app/oracle/product/7.3.4/network/log/listener.log
Attempted to listen on: (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=IPC)(KEY=MODB)))
TNS-12532: TNS:invalid argument
TNS-12560: TNS:protocol adapter error
TNS-00502: Invalid argument
SCO System V/386 Error: 22: Invalid argument
如果将 /etc/listener.ora中的两行:
(ADDRESS= (PROTOCOL= IPC)(KEY= MODB))
(ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
删除,并且不使用TNS_ADMIN环境变量,则lsnrctl start能启动成功:
$ unset TNS_ADMIN
$ lsnrctl start
LSNRCTL for SCO System V/386: Version 2.3.4.0.0 - Production on 21-NOV-10 20:18:01
Copyright (c) Oracle Corporation 1994. All rights reserved.
Starting /u/ora734/app/oracle/product/7.3.4/bin/tnslsnr: please wait...
TNSLSNR for SCO System V/386: Version 2.3.4.0.0 - Production
System parameter file is /etc/listener.ora
Log messages written to /u/ora734/app/oracle/product/7.3.4/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=10)(HOST=192.168.206.3)(PORT=1521))
Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=mysco507)(Port=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for SCO System V/386: Version 2.3.4.0.0 - Production
Start Date 21-NOV-10 20:18:04
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /etc/listener.ora
Listener Log File /u/ora734/app/oracle/product/7.3.4/network/log/listener.log
Services Summary...
MODB has 1 service handler(s)
The command completed successfully
请教这是为什么?$ORACLE_HOME/network/admin/listener.ora中IPC的KEY为SID和PNPKEY的两行到底起什么作用? |
|