静态监听，SYS用户远程连接不上，提示ORA-01031: insufficient privileges

今天QQ群里有位朋友，在配置静态监听后，使用该静态监听远程连接未打开的数据库，提示如下：

[oracle@target admin]$ sqlplus sys/oracle@orcl as sysdba 


SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 18 15:41:27 2013


Copyright (c) 1982, 2011, Oracle.  All rights reserved.


ERROR:
ORA-01031: insufficient privileges

确认过监听正常：

[oracle@target admin]$ lsnrctl status


LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-NOV-2013 16:00:57


Copyright (c) 1991, 2011, Oracle.  All rights reserved.


Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.64)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date                18-NOV-2013 14:53:02
Uptime                    0 days 1 hr. 7 min. 54 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/target/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.64)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl2" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

listener.ora与tnsnames.ora配置如下：

[oracle@target admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER =
   (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
    (PROGRAM = extproc)
    ) 
    (SID_DESC =
      (GLOBAL_DBNAME = orcl2)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = ORCL)  －－最终问题改成小写orcl解决了
    )
  )


LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.64)(PORT = 1521))
  )


ADR_BASE_LISTENER = /u01/app/oracle


[oracle@target admin]$ cat tnsnames.ora 
orcl =
  (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.64)(PORT = 1521))    
      (CONNECT_DATA =   
      (SERVER = DEDICATED)      
      (SERVICE_NAME = orcl2)    
      )  
  )

看配置也没什么问题，后来把上面标红部分改成小写，就OK了，真是坑爹啊。