Database Networking (MOSC)

MOSC Banner

Tnsora and listener_* param changes after 11g upgrade

edited Apr 19, 2011 4:17PM in Database Networking (MOSC) 3 commentsAnswered
We have a 2-node RAC instance RACINST1 and RACINST2 on nodes racnode1 and racnode2.

We have upgraded the database from 10.2.0.5 to 11gR2.

Before the upgrade here is the tns entry we use to remotely connect to our database.

RACINST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode2vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = GNSTEST)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

1) After the upgrade to 11g, do we need to change the tns entry?
We were wondering if we should replace racnode1vip and racnode2vip with the scan ip?

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