Tjyylli

Partial sums of primes

Calculating the number of days between 2 dates in Excel

The One-Electron Universe postulate is true - what simple change can I make to change the whole universe?

Invariance of results when scaling explanatory variables in logistic regression, is there a proof?

Can I rely on these GitHub repository files?

For airliners, what prevents wing strikes on landing in bad weather?

Should my PhD thesis be submitted under my legal name?

Why are on-board computers allowed to change controls without notifying the pilots?

Can I Retrieve Email Addresses from BCC?

How can I raise concerns with a new DM about XP splitting?

How can a jailer prevent the Forge Cleric's Artisan's Blessing from being used?

What was required to accept "troll"?

How do ultrasonic sensors differentiate between transmitted and received signals?

A workplace installs custom certificates on personal devices, can this be used to decrypt HTTPS traffic?

How can I successfully establish a nationwide combat training program for a large country?

Does "Dominei" mean something?

A known event to a history junkie

Blender - show edges angles “direction”

Freedom of speech and where it applies

Teaching indefinite integrals that require special-casing

How to deal with or prevent idle in the test team?

Is infinity mathematically observable?

How to check participants in at events?

Resetting two CD4017 counters simultaneously, only one resets

Oracle RMAN-06136: ORA-17629: Cannot connect to the remote database server

Cannot connect to databaseCan't import a dmp file to oracle 12c database (imp-00037)Something drops my 1521-portrequest for OracleOraDB12Home1TNSListener - what and why?Change the name of an object within an archiveCannot access Linux Oracle Databse with Perl Script after connecting with PuTTYOracle ODBC Error 12170 - Accessing over Internetlogin on oracle database 12c release 2“Unable to enlist in the transaction” with Oracle linked server from MS SQL ServerOracle sqldeveloper cannot connect with default role default connectionError while getting status of instane and database in Oracle?

0

I am creating a standby database using rman (Oracle 18c) from my main database which is an Oracle restart that uses ASM but when I issue the command

duplicate target database for standby from active database nofilenamecheck;

I keep getting the same error :

RMAN-03002: failure of Duplicate Db command at 03/26/2019 02:22:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

So it's clear that the error means that there is something wrong with the connection to to the standby database but here the strange part, I checked tnsnames.ora and listener.ora on both servers and everything is OK.

I tested the connection to bothe DBs from both sides using tnsping and it works just fine (A DB to B DB from A DB & A DB to A DB from A DB & B DB to A DB from B DB and B DB to B DB from B DB).

I also tested the connection using sqlplus from both sides and again it works fine.

I even tried to connect to each database from RMAN from both DBs and it always works

So what is wrong? Am I missing something?

database standby oracle-12c oracle-database

share

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am creating a standby database using rman (Oracle 18c) from my main database which is an Oracle restart that uses ASM but when I issue the command

duplicate target database for standby from active database nofilenamecheck;

I keep getting the same error :

RMAN-03002: failure of Duplicate Db command at 03/26/2019 02:22:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

So it's clear that the error means that there is something wrong with the connection to to the standby database but here the strange part, I checked tnsnames.ora and listener.ora on both servers and everything is OK.

I tested the connection to bothe DBs from both sides using tnsping and it works just fine (A DB to B DB from A DB & A DB to A DB from A DB & B DB to A DB from B DB and B DB to B DB from B DB).

I also tested the connection using sqlplus from both sides and again it works fine.

I even tried to connect to each database from RMAN from both DBs and it always works

So what is wrong? Am I missing something?

database standby oracle-12c oracle-database

share

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am creating a standby database using rman (Oracle 18c) from my main database which is an Oracle restart that uses ASM but when I issue the command

duplicate target database for standby from active database nofilenamecheck;

I keep getting the same error :

RMAN-03002: failure of Duplicate Db command at 03/26/2019 02:22:24
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: Oracle error from auxiliary database: ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-12154: TNS:could not resolve the connect identifier specified
ORA-17629: Cannot connect to the remote database server

So it's clear that the error means that there is something wrong with the connection to to the standby database but here the strange part, I checked tnsnames.ora and listener.ora on both servers and everything is OK.

I tested the connection to bothe DBs from both sides using tnsping and it works just fine (A DB to B DB from A DB & A DB to A DB from A DB & B DB to A DB from B DB and B DB to B DB from B DB).

I also tested the connection using sqlplus from both sides and again it works fine.

I even tried to connect to each database from RMAN from both DBs and it always works

So what is wrong? Am I missing something?

database standby oracle-12c oracle-database

share

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

duplicate target database for standby from active database nofilenamecheck;

share

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Asker2000Asker2000

1

New contributor

Asker2000 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

Asker2000Asker2000

1