Database Administration (MOSC)

MOSC Banner

Domain and Server Name change

We have a 12C (12.2.0.1) database with 2 non-CDBs using the same listener running on Windows 2016. Our domain name and database server name need to change.

I'm thinking all I need to do update the database is:

1) modify listener.ora with "HOST='NEW_SERVERNAME.NEW_DOMAIN'"

2) modify tnsnames.ora with "HOST='NEW_SERVERNAME.NEW_DOMAIN'"

3) (for each instance) alter database rename global_name to 'SID.NEW_DOMAIN.COM';

4) alter system set db_domain='NEW_DOMAIN.COM' scope=spfile;

5) shutdown immediate

6) startup

Have I missed anything? ... Seems too easy.

Thanks in advance!

Steve

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center