AIX下Oracle 10g的安装后的监听问题
资料简介:
曾在CentOS安装过很多次Oracle 10g,但是从未配置过监听,但是也好用。这次在Oracle上说什么也无法在client获取。监听未侦测到服务。继而简单查了一下资料。自己 google一下:sqlnet.ora listener.ora tnsnames.ora
C/S架构中。
服务器必配的:listener.ora
客户端必配的:tnsnames.ora
多的不说了,看别人介绍吧。但是10g之后,这个服务器端的监听文件就简略了,不需要配也好用的。我试验过很多次了。但是这次AIX上的安装,就必需配。让我很是头痛!
AIX上的出错。无非是1158:em无法访问。客户端提示找不到监听。
监听状态如下:
引用
$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-AUG-2007 09:54:10
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2007 09:52:09
Uptime 0 days 0 hr. 2 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fundoa.glfsoft.com)(PORT=1521)))
The listener supports no services
The command completed successfully
我用netmgr配置过监听后,就可以找到服务了。
引用
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-AUG-2007 10:33:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.248)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.248)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2007 10:33:50
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.248)(PORT=1521)))
Services Summary...
Service "fundoa.glfsoft.com" has 1 instance(s).
Instance "fundoa", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
相应的查看一下文件。
引用
$ cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = fundoa.glfsoft.com)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(SID_NAME = fundoa)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.248)(PORT = 1521))
)
C/S架构中。
服务器必配的:listener.ora
客户端必配的:tnsnames.ora
多的不说了,看别人介绍吧。但是10g之后,这个服务器端的监听文件就简略了,不需要配也好用的。我试验过很多次了。但是这次AIX上的安装,就必需配。让我很是头痛!
AIX上的出错。无非是1158:em无法访问。客户端提示找不到监听。
监听状态如下:
引用
$ lsnrctl status
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-AUG-2007 09:54:10
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2007 09:52:09
Uptime 0 days 0 hr. 2 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=fundoa.glfsoft.com)(PORT=1521)))
The listener supports no services
The command completed successfully
我用netmgr配置过监听后,就可以找到服务了。
引用
$ lsnrctl start
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-AUG-2007 10:33:50
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
System parameter file is /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.248)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.101.248)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2007 10:33:50
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.101.248)(PORT=1521)))
Services Summary...
Service "fundoa.glfsoft.com" has 1 instance(s).
Instance "fundoa", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
相应的查看一下文件。
引用
$ cat listener.ora
# listener.ora Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = fundoa.glfsoft.com)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(SID_NAME = fundoa)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.101.248)(PORT = 1521))
)
2011-02-18
浏览3023
下载0