Re: DB12c in Production?

From: John McHugh <john.mchugh_at_oracle.com>
Date: Mon, 19 May 2014 21:14:42 -0700
Message-ID: <537AD6B2.6010105_at_oracle.com>

12c: USE_SID_AS_SERVICE_listener_name
<http://docs.oracle.com/cd/E16655_01/network.121/e17611/listener.htm#NETRF2090>

Purpose

To enable the system identifier (SID) in the connect descriptor to be interpreted as a service name when a user attempts a database connection. Database clients with earlier releases of Oracle Database that have hard-coded connect descriptors can use this parameter to connect to a container or pluggable database.

When the database is an Oracle Database 12c container database, the client must specify a service name in order to connect to it. Setting this parameter to on instructs the listener to use the SID in the connect descriptor as a service name and connect the client to the specified database.

Default

off

Example

USE_SID_AS_SERVICE_listener=on

addresses the SID/SERVICE connect descriptor for Multitenant.

thanks,
jpm

On 5/19/2014 3:17 PM, Jeff Smith wrote:
>>> Then there are the myriad of folk who connect using _at_{SID} instead of _at_{Service}
> Yup, I'm already seeing this a lot. It's the first thing I ask a user to check when they have a login issue with 12c.
>
> -----Original Message-----
> From: Hans Forbrich [mailto:fuzzy.graybeard_at_gmail.com]
> Sent: Monday, May 19, 2014 5:22 PM
> To: oracle-l_at_freelists.org
> Subject: Re: DB12c in Production?
>
> On 19/05/2014 12:14 PM, Seth Miller wrote:
>> Those of us that don't have the luxury of connecting with "/" or "as
>> sysdba" will find it easier to adjust.
> To a certain extent.
>
> Then there are the myriad of folk who connect using _at_{SID} instead of _at_{Service}
>
> ... remembering that each database has a unique service within the container, and TNSNAMES.ora is not necessarily updated, and oratab can no longer be twisted to help a lot.
>
> /Hans
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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

Received on Tue May 20 2014 - 06:14:42 CEST