Service Name

From: Paul Harrison <cure_at_austin.rr.com>
Date: Mon, 19 Mar 2012 11:30:37 -0500
Message-ID: <000c01cd05ed$9dcf77e0$d96e67a0$_at_austin.rr.com>



Hi All,  

I'm using SQL Developer(windows)... I can connect using the database(rac-linux) using SID but not the Service Name... Any idea?  

The below is the output from Instance ORCL1:  

lsnrctl status  

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 19-MAR-2012 12:12:15  

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

STATUS of the LISTENER


Alias                     LISTENER_TEST1

Version                   TNSLSNR for Linux: Version 11.1.0.7.0 - Production

Start Date                19-MAR-2012 11:40:20

Uptime                    0 days 0 hr. 31 min. 55 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File /u01/base/rac/network/admin/listener.ora

Listener Log File
/u01/base/diag/tnslsnr/test1/listener_test1/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.203)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.201)(PORT=1521)))
 

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.localdomain)(PORT=8080))(Pre sentation=HTTP)(Session=RAW))  

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test1.localdomain)(PORT=7787))(Pre sentation=FTP)(Session=RAW))

Services Summary...

Service "+ASM" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "+ASM_XPT" has 1 instance(s).

  Instance "+ASM1", status READY, has 1 handler(s) for this service...

Service "ORCL" has 2 instance(s).

  Instance "ORCL1", status READY, has 2 handler(s) for this service...

  Instance "ORCL2", status READY, has 1 handler(s) for this service...

Service "ORCLXDB" has 2 instance(s).

  Instance "ORCL1", status READY, has 1 handler(s) for this service...

  Instance "ORCL2", status READY, has 1 handler(s) for this service...

Service "ORCL_XPT" has 2 instance(s).

  Instance "ORCL1", status READY, has 2 handler(s) for this service...

  Instance "ORCL2", status READY, has 1 handler(s) for this service...

The command completed successfully

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 19 2012 - 11:30:37 CDT

Original text of this message