Database Administration (MOSC)

MOSC Banner

Second database with the same SID in the network

edited Aug 15, 2012 10:33AM in Database Administration (MOSC) 6 commentsAnswered
I am given a project to upgrade a host server(Win2003 Server R2) on a vendor based system, which is currently using Oracle 9 database.

One of the requirement to me is that I am going to create or migrate the orginal Oracle database, say in Host A(Win2003 Server), to  new host, say, Host B(Wind2008 Server R2).  Both hosts reside on the same network.

Now, my question is, can they both exist at the same time?  It is my undestanding that as long as the host names are different, I could use a same database name/SID/ ServiceName  on both hosts.  Both databases will need to be up together for some time.  Is my understanding correct ?  The database version on Host A is 9, and Host B will be 11g.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center