Alias for database connection via jdbc
From: John Dunn <JDunn_at_sefas.com>
Date: Mon, 24 Sep 2012 13:26:57 +0100
Message-ID: <2F802216565E44489600A03F763219A8013DFFDF_at_MIA.SEFASBRISTOL>
My oracle database name(SID) is ORCL
Date: Mon, 24 Sep 2012 13:26:57 +0100
Message-ID: <2F802216565E44489600A03F763219A8013DFFDF_at_MIA.SEFASBRISTOL>
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-lReceived on Mon Sep 24 2012 - 07:26:57 CDT