Service Name
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-lReceived on Mon Mar 19 2012 - 11:30:37 CDT