Database - RAC/Scalability (MOSC)

MOSC Banner

Remove DB_DOMAIN from DB_LINKS.

edited Feb 16, 2018 4:01AM in Database - RAC/Scalability (MOSC) 2 commentsAnswered

Hi Guys,

Need help from you. My environment is 4 nodes RAC 12cR2 database. i want to remove db domain name from by db links. Please have some parameter output from my database :

[oracle@raxdwdb01 ~]$ sqlplus

SQL*Plus: Release 12.2.0.1.0 Production on Wed Feb 7 00:30:12 2018

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Enter user-name: /as sysdba

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL>

SQL> show parameter db_domain

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_domain                            string      robi.com.bd

SQL> show parameter db_name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

db_name                              string      raxdw

SQL> SELECT * FROM GLOBAL_NAME;

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