Database - RAC/Scalability (MOSC)

MOSC Banner

Servive names in Oracle 11g

edited May 29, 2015 10:04AM in Database - RAC/Scalability (MOSC) 3 commentsAnswered

Hi Experts,

We are going to switch roles of databases in dataguard environment, I mean primary to standby and standby to primary.

But here real problem comes from client.

Our clients want to use same tns file , they don't want to add any entries , I mean they do not want to change hostnames etc.

then we used following approach.

TEST.world=

  (DESCRIPTION=

    (ADDRESS= (PROTOCOL=TCP) (HOST=prod.com) (PORT=1531))  

    (ADDRESS= (PROTOCOL=TCP) (HOST=stby.com) (PORT=1531))

    (CONNECT_DATA=

      (SERVICE_NAME=test)

    )

  )

Then we created services using srvctl utilty with same name in both primary and standby side.

srvctl add service -d prod -s test

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center