In Previous article we have seen Primary Database Preparation for Data Guard Configuration.

Setting the parameter on primary database for physical standby database.

In this article we will see Oracle Net Configuration on Primary and Standby.

Step 1 : Configure tnsnames.ora file at Production.

Here we can see two net services. TESTDB for Primary Database Connection and STD_TESTDB for standby database configuration.

Step 2 : We need to add static entry for standby database in listener.ora file at standby side.

Step 3 : Add net service entry in tnsnames.ora at standby side for Primary and Standby Database.

Step 4 : Start listener at standby side.

Step 5: Check tnsping for standby and primary from both side.

Primary Database :

Standby Database.

In next articles we will see creating standby database using different methods.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.