|
 |
|
< Data GuardDonald K. Burleson
Oracle Data GuardChapter 3 - Implementing Standby
Databases
Verify the Physical Standby
Database
From
V$ARCHIVE_DEST
SEE
CODE DEPOT FOR FULL SCRIPT
Status Error
--------- ----------------------------------------------
ERROR ORA-12541: TNS:no listener
This view can be a starting point for
troubleshooting any problem in Data Guard configuration. The same
information can be gathered from the alert log file on the primary
database. The content of the alert log file will look like the
following:
Tue Sep 23 09:02:04 2003
Errors in file /oracle/appsdb/admin/bdump/appsdb_arc0_11977.trc:
ORA-12541: TNS:no listener
There will not be any error seen in the alert log
file of the standby database. When the listener is started on both
the databases and an Oracle Net connection is established, the arch
process of the primary database will transfer the archived redo logs
to the Oracle instance
when the next redo log is archived on the
primary database. An extract from the alert log file is given in the
following example to explain this scenario:
Errors in
file /oracle/appsdb/admin/bdump/appsdb_arc0_11977.trc:
|
