Re: Alias for database connection via jdbc
- From: Gunawan Yuwono <gunawan.yuwono@xxxxxxxxx>
- To: JDunn@xxxxxxxxx
- Date: Tue, 25 Sep 2012 12:37:36 -0500
John,
Try using service. Either set service_names parameter, or use srvctl add
service command if you are using ASM (Grid Infrastructire).
Thanks,
Gunawan Yuwono
On Mon, Sep 24, 2012 at 7:26 AM, John Dunn <JDunn@xxxxxxxxx> wrote:
> My oracle database name(SID) is ORCL
>
> However in order to make it easier to support a customer I would like to
> be able to refer to the same database in my JDBC string as e.g. JOHNTEST
> rather than ORCL
>
> What changes do I need to make to listener config files to enable me to
> do this? I tried adding JOHNTEST to tnsnames.ora on the Oracle server
> but I get a message
> ORA-12505, TNS:listener does not currently know of SID given in connect
> descriptor
>
> Oracle is 11G on linux.
>
> Any help appreciated.
>
>
>
>
>
>
>
>
> John
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Only the wisest and the stupidest of men never change - Confucius
--
//www.freelists.org/webpage/oracle-l
Other related posts:
