Remove DB_DOMAIN from DB_LINKS.
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;