对于静默安装netca ,出现如下错误:
oracle@RAC:/home/oracle/10201_database>netca -silent -responsefile /home/oracle/10201_database/netca.rsp
****DISPLAY environment variable not set!
Oracle Net Configuration Assistant is a GUI tool
which requires that DISPLAY specify a location
where GUI tools can display.
Set and export DISPLAY, then re-run.
oracle@RAC:/home/oracle/10201_database>lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-NOV-2011 23:17:49
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
oracle@RAC:/home/oracle/10201_database>
所以采用编辑listener.ora 和tnsnames.ora 文件,然后启动监听的方法
oracle@RAC:/home/oracle/10201_database>cd /opt/app/oracle/10.2/db/network/admin/
oracle@RAC:/opt/app/oracle/10.2/db/network/admin>vi listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/11.2.0/alifpre)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = kbbi)
(ORACLE_HOME = /opt/oracle/11.2.0/alifpre)
(SID_NAME = kbbi)
)
)
kbbi=
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac)(PORT = 1521))
)
)
oracle@RAC:/opt/app/oracle/10.2/db/network/admin>vi tnsnames.ora
kbbi=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.249.212.200 )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = kbbi)
)
)
oracle@RAC:/opt/app/oracle/10.2/db/network/admin>lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 07-NOV-2011 23:23:01
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/app/oracle/10.2/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /opt/app/oracle/10.2/db/network/admin/listener.ora
Log messages written to /opt/app/oracle/10.2/db/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 07-NOV-2011 23:23:01
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/app/oracle/10.2/db/network/admin/listener.ora
Listener Log File /opt/app/oracle/10.2/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=RAC)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "kbbi" has 1 instance(s).
Instance "kbbi", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully