eygle.com - 留言簿 - 回复留言

eygle.com - 留言簿 - 回复留言 - Powered by eYgLe.Com

返回留言簿

回复留言

留言ID:

留言原文:

To: eygle
　　根据《循序渐进》中第 P17 中指出的 listener.ora中 sid_name来自instance_name 可是我自己做实验的时候就发现
instance_namestringtest1
service_namesstringtest

[root@rac2 dbs]# ps -ef|grep ora_
oracle3160 10 03:39 ?00:00:04 ora_pmon_test
oracle3162 10 03:39 ?00:00:02 ora_psp0_test

(SID_DESC =
 (ORACLE_HOME = /opt/u01/app/oracle/product/10201/db1)
 (SID_NAME = test1)
 )

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
就会远程连接时这样报错，请指教

From: balsilliy
2008.12.11 00:21

管理密码:

请输入管理密码, 否则无法回复.

斑竹昵称:

信息图标: ( 随机 )

BB 代码:

内容:

如果想删除回复, 请点击最下面的删除回复按钮.

我说tnsnames.ora中配置的SID_NAME来自instance_name，但是不意味着，instance_name和SID不一致就能如此连接数据库。

10g中实际上和9i已经有所不同，如果要在以上模式下连接数据库，需要指定SID连接。
看我以下测试：
[oracle@jumper admin]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:44:33

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                11-DEC-2008 17:43:51
Uptime                    0 days 0 hr. 0 min. 41 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         /opt/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jumper.hurray.com.cn)(PORT=1521)))
The listener supports no services
The command completed successfully
[oracle@jumper admin]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:45:08

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                11-DEC-2008 17:43:51
Uptime                    0 days 0 hr. 1 min. 16 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Log File         /opt/oracle/product/9.2.0/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jumper.hurray.com.cn)(PORT=1521)))
Services Summary...
Service "eygle" has 1 instance(s).
  Instance "JULIA", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@jumper admin]$ sqlplus eygle/eygle@lia

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Dec 11 17:45:43 2008

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
[oracle@jumper admin]$ tnsping lia

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 11-DEC-2008 17:45:48

Used parameter files:
/opt/oracle/product/9.2.0/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.33.11)(PORT = 1521))) (CONNECT_DATA = (SID = julia)))
OK (0 msec)
[oracle@jumper admin]$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Dec 11 17:46:04 2008

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production

SQL> show parameter ins

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
active_instance_count                integer
cluster_database_instances           integer     1
instance_groups                      string
instance_name                        string      JULIA
instance_number                      integer     0
open_links_per_instance              integer     4
parallel_instance_group              string
parallel_server_instances            integer     1
SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
mts_service                          string      eygle
service_names                        string      eygle

删除回复
管理密码:	请输入管理员密码, 只有版主才能删除回复.