Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Gyan Bahadur.

Asked: April 21, 2017 - 10:55 am UTC

Last updated: April 22, 2017 - 1:25 pm UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Hi tom,

For the testing purpose, I have a remote DR database, how to startup the DR database from DC using the static listener registration method??
Please, provide me the sample listener.ora and tnsnames.ora file with connection to remote database idea.

Thanks
Gyan

and Connor said...

You need

1) a static entry in listener.ora, eg

   (SID_DESC =
      (GLOBAL_DBNAME = DBETC)
      (ORACLE_HOME = /u01/app/oracle/product/12.2.0/db_1)
      (SID_NAME = DB12)
    )


2) a password file so you can authenticate

3) remote_password_file set in int.ora

Then you should be able to do:

connect sys/syspass@remote_db as sysdba



Is this answer out of date? If it is, please let us know via a Comment