Re: non-RAC service names ?

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Mon, 6 Dec 2010 20:43:54 -0600
Message-ID: <AANLkTikBkfQwk1=svrC3HdrPDe7yA89nC11TTwh1U+Go_at_mail.gmail.com>

Don't forget, you can use a service with JDBC THin connections

server:port/service_name

Bradd Piontek

On Mon, Dec 6, 2010 at 5:56 PM, CRISLER, JON A (ATTCORP) <JC1706_at_att.com>wrote:

> If you are running your JDBC thick client on the same server, I imagine it
> would work fine, but if you are running jdbc thin drivers on a separate
> server where it does not use tnsnames, then an alias would not work, right ?
>
>
>
> Good tip about v$parameter2- I did not know that existed.
>
>
>
>
>
> *From:* Jared Still [mailto:jkstill_at_gmail.com]
> *Sent:* Monday, December 06, 2010 6:53 PM
>
> *To:* CRISLER, JON A (ATTCORP)
> *Subject:* Re: non-RAC service names ?
>
>
>
> On Mon, Dec 6, 2010 at 1:44 PM, CRISLER, JON A (ATTCORP) <JC1706_at_att.com>
> wrote:
>
> Can additional service names be defined for a non-RAC 10g database, similar
> to how multiple service names can be configured for RAC ? This would be to
> support JDBC connections, so a tnsnames alias would not work. I have
> looked over various docs and I do not see any way of creating them- and I
> tried DBCA as well as that allows managing service names on a RAC db, but
> that option is disabled for a non-RAC db.
>
>
>
> Hi Jon,
>
>
>
> I've never run into an issue using tns aliases with JDBC.
>
>
>
> Maybe I've just been lucky.
>
>
>
> What problems did you encounter?
>
>
>
> As for service names, I've been using several service names for quite some
> time without issue.
>
>
>
> BTW, in case you don't already know, if you use v$parameter2 rather than
> v$parameter
>
> to lookup service_names, they will each appear on a separate row.
>
>
>
> Jared
>
>
>
>
>
>
>

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

Received on Mon Dec 06 2010 - 20:43:54 CST