listener.ora的配置发现的oracle bug（oracle9.2.0.8）

注：若listener端口号不是1521的时候，配置listener的 SID_NAME要区分大小写，否则tnsping可通，

但sqlplus 不能login 若以sysdba身份登陆报ORA-01031: insufficient privileges,权限不足的error；

若以普通用户身份登陆报：

 SQL> conn steven/steven@oemsh

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory。

$ echo $ORACLE_SID

DBPP

LISTENERSB =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = CTMESD1)(PORT = 1522))

    )

  )

SID_LIST_LISTENERSB =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME DBPP)

      (ORACLE_HOME = /oracle/ora9/product/9.2)

      (SID_NAME = dbpp)

    )

  )

$ lsnrctl start listenersb

LSNRCTL for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 20-MAR-2008 09:59:35

Copyright (c) 1991, 2006, Oracle Corporation.  All rights reserved.

Starting /oracle/ora9/product/9.2/bin/tnslsnr: please wait...

TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production

System parameter file is /oracle/ora9/product/9.2/network/admin/listener.ora

Log messages written to /oracle/ora9/product/9.2/network/log/listenersb.log

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CTMESD1)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CTMESD1)(PORT=1522)))

STATUS of the LISTENER

------------------------

Alias                     listenersb

Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production

Start Date                20-MAR-2008 09:59:35

Uptime                    0 days 0 hr. 0 min. 2 sec

Trace Level               off

Security                  OFF

SNMP                      OFF

Listener Parameter File   /oracle/ora9/product/9.2/network/admin/listener.ora

Listener Log File         /oracle/ora9/product/9.2/network/log/listenersb.log

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=CTMESD1)(PORT=1522)))

Services Summary...

Service "dbpp" has 1 instance(s).

  Instance "dbpp", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

$ tnsping dbstandby

TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production on 20-MAR-2008 10:09:40

Copyright (c) 1997, 2006, Oracle Corporation.  All rights reserved.

Used parameter files:

/oracle/ora9/product/9.2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.105.219)(PORT = 1522))) (CONNECT_DATA = (SERVER = DEDICATED) (SID = DBPP)))

OK (0 msec)

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Mar 20 10:10:17 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn sys/oracle@dbstandby as sysdba

ERROR:

ORA-01031: insufficient privileges

SQL> conn steven/steven@oemsh

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory。