RE: Service Name

From: Paul Harrison <cure_at_austin.rr.com>
Date: Mon, 19 Mar 2012 15:20:08 -0500
Message-ID: <000301cd060d$ae3bf980$0ab3ec80$_at_austin.rr.com>

I select service_name instead of SID within sql developer.

Service_name is ORCL

The below is from
/u01/base/diag/tnslsnr/test1/listener_test1/trace/listener_test1.log

Mon Mar 19 16:18:07 2012
19-MAR-2012 16:18:07 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=cure))(SERVICE_NAME=ORCL)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=cure))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.135)(PORT=52236)) * establish * ORCL * 0
19-MAR-2012 16:18:07 * (CONNECT_DATA=(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=cure))(SERVICE_NAME=ORCL)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=cure))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.135)(PORT=52237)) * establish * ORCL * 0

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martin Berger
Sent: Monday, March 19, 2012 1:07 PM
To: cure_at_austin.rr.com
Cc: oracle-l_at_freelists.org
Subject: Re: Service Name

what did you use as SID, what as SERVICE_NAME? there should be proper entries in the alert.log files for ANY conneciton attempt. can you post these, also?

Martin

On Mon, Mar 19, 2012 at 17:30, Paul Harrison <cure_at_austin.rr.com> wrote:
>
> 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?
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Mon Mar 19 2012 - 15:20:08 CDT