Database Administration (MOSC)

MOSC Banner

Connect-Time Failover For Primary/Standby Configuration in 11gR2 with Same Service Name and Port: OR

edited Jul 13, 2015 3:45AM in Database Administration (MOSC) 1 commentAnswered ✓

Dear MOS Community,

I have a question regarding the client-side connect-time failover for a primary/standby configuration in 11gR2 where both primary and standby have the same (static) service name and port, because after a switchover the clients receive an ORA-01033 error when trying to connect...

My setup is as follows:

  1. Primary database failoverDB (this is both unique name and database name) is running on hostA with service name failoverDB.
  2. Standby database with same database name (but unique name failoverDBstdby) is running on hostB with same service name as primary database.
  3. Although the database name is the same for primary and standby, the unique names of both databases differ; but the database name shall be the same as well as the service name(s) as well as the port.
Tagged:

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