RMAN duplication: connect auxiliary --> RMAN-04006 / ORA-12528
Hello,
I want to duplicate DUP_DB from TARGET_DB.
The database DUP_DB already exists, with exactly the same structure than TARGET_DB.
On DUP_DB server:
DUP_DB shtudown immediate
DUP_DB startup nomount
On target server:
rman
RMAN> connect catalog rman/rman@RMAN
--> connected to recovery catalog database
RMAN> connect target /
--> connected to target database: TARGET_DB
RMAN> connect auxiliary sys/xxxx@DUP_DB
...
--> RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
The file tnsnames.ora on target server contains an entry for DUP_DB.
After some readings on internet, I have stopped and started several times the listener on DUP_DB server.
The database DUP_DB already exists, with exactly the same structure than TARGET_DB.
On DUP_DB server:
DUP_DB shtudown immediate
DUP_DB startup nomount
On target server:
rman
RMAN> connect catalog rman/rman@RMAN
--> connected to recovery catalog database
RMAN> connect target /
--> connected to target database: TARGET_DB
RMAN> connect auxiliary sys/xxxx@DUP_DB
...
--> RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections
The file tnsnames.ora on target server contains an entry for DUP_DB.
After some readings on internet, I have stopped and started several times the listener on DUP_DB server.
0