SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 3 10:04:12 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected.
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> conn test/test@127
Connected.
在配置静态监听时要注意数据库实例名本身是区分大小写的，因此在配置静态监听配置SID_NAME时一定要注意大小写