Re: How to change the SID

From: GreyBeard <Fuzzy.GreyBeard_at_gmail.com>
Date: Sat, 05 Mar 2005 13:13:17 GMT
Message-Id: <pan.2005.03.05.14.14.05.912109@gmail.com>

On Fri, 04 Mar 2005 23:49:01 -0500, cschang wrote:

> I have a 9.2.0.5 databse set up locally. I wan to change the SID so my
> weblogic 8.1.4 can talk to it. Sorry I can not change Weblogic side to
> match Oracle side. When I look into the solutions (most of them are for

Realizing you stated that the Weblogic side can not be changed - the last few times I'd heard that, the comment was related to the Java code. If so, the following may help:

If this is a J2EE app, then all that's needed is to change the Data Sources, which is kept in an XML file in the J2EE server. No rewrite or touching the code at all.

Also, what kind of JDBC driver is being used on the Weblogic side? If the OCI driver, then you likely have a TNSNAMES.ora that can be changed.

/FGB Received on Sat Mar 05 2005 - 07:13:17 CST