Re: How to change the SID

> Thanks for all you suggestions.
> First, I forgot to mention the system is running on windows 2000.

In the world of Java, that is irrelevant. For the database, it just means translating some terms from the common Oracle useage - for example 'process' becomes 'thread'.

> Secondly, As i said, I can not change anything on th Java side (or
> anything under the weblogic, include the XML or other codes. If you were
> freshman or junior developer of a project, you know what I mean).

Nope ... no idea what you mean. I was never that young (Right, Dan? <g>)

(Actually, I do know what you mean.)

Keep the DataSources.xml info in the back of your mind for J2EE environments, because the J2EE standard has set up the file specifically to permit easy change of datasources, eg: SID.

> Third. I believe that if I am going to change the tnsnames.ora of my
> local station which is somehting like
> local_service_alias = ... ( SID=<old_SID>)..)

Change the TNSNAMES.ora on machines that have clients. This includes the JDBC client and any SQLNet client such as SQLPlus.

Personally, I just duplicate the line, change the index (what you list as local_service_index) and the SID as you describe. That way I know I have one that works.

> to (SID=<new_SID>), I hvae to also modify the Intance_name of my
> init.ora file of the database. Probably Sybrabd is more correct with
> his details. However, I just could not find the exact document. Maybe
> I have not found yet.

I've never found Sybrand's advice wrong. To add to it, if you have access to metalink, supplement his advice with Note:15390.1 "How to Determine and Change DB_NAME or ORACLE_SID"

FGB Received on Sat Mar 05 2005 - 09:57:57 CST