Re: Alias for database connection via jdbc

From: Gunawan Yuwono <gunawan.yuwono_at_gmail.com>
Date: Tue, 25 Sep 2012 12:37:36 -0500
Message-ID: <CAPJkHXFYFUAk51-xJLLYuHuS+sErs2R8NMyZE5CkFCe=YpnbQQ_at_mail.gmail.com>

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_at_sefas.com> 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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Only the wisest and the stupidest of men never change - Confucius


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

Received on Tue Sep 25 2012 - 12:37:36 CDT