AIX下Oracle 10g的安装后的监听问题。

时间服务器，以后用得着。

AIX上Oracle 10g的EM无法启动问题。

[

2007/08/31 14:09]

大 | 中 | 小

曾在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))
  )