RE: Service Name
- From: "Paul Harrison" <cure@xxxxxxxxxxxxx>
- To: <martin.a.berger@xxxxxxxxx>
- Date: Mon, 19 Mar 2012 15:20:08 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Martin Berger
Sent: Monday, March 19, 2012 1:07 PM
To: cure@xxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx> 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?
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
