Getting error while cloning prod pdb to test using database link.
Hi Everyone,
DATBASE VERSION: 12.1.0.2
WINDOWS OS
I am doing PDB refresh from prod to test database.
Below is process which I have followed.
ON TEST:
1.
Added TNS entry for prod in test envirnoment
PRODCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PROD)
)
)
2. Checked that tnsping from test to prod.
tnsping PRODCDB
3.create database link PROD_LINK connect to system identified by Password using 'PRODCDB';
4.Checked if database link is working by ,
select name,open_mode from v$database@PRODCDB;
Got the result
5.SQL> show parameter global
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
allow_global_dblinks boolean FALSE