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