Well, here I am again... I've recreated the entire DGTEST environment and did a switchover (using instructions from http://www.visi.com/~mseberg/data_guard/Data_Guard_switchover.html), and after the switchover to standby (now primary) my log files are not being shipped to the original primary server.
I can't find anything wrong, and tnsping works as it should to the services as well as the database.
Ref. thread:
2522206
Perhaps I have a net configuration error somewhere...
From the NEW primary database server: "brahe"
===================================
$ [brahe] <DGTEST> /oracle/product/db/11.2.0.2/dbs>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Wed Apr 3 12:36:01 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> connect sys/sys@DGTEST_DG1 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Warning: You are no longer connected to ORACLE.
SQL> connect sys/sys@DGTEST as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
But yet, I can tnsping all day long without any problems....
From the NEW primary database server: "brahe"
===================================
$ [brahe] <DGTEST> /oracle/product/db/11.2.0.2/dbs>tnsping DGTEST
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 03-APR-2013 12:00:46
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = kepler.nnet)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DGTEST) (UR = A)))
OK (0 msec)
$ [brahe] <DGTEST> /oracle/product/db/11.2.0.2/dbs>tnsping DGTEST_DG1
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 03-APR-2013 12:00:52
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = kepler.nnet)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DGTEST) (UR = A)))
OK (0 msec)
$ [brahe] <DGTEST> /oracle/product/db/11.2.0.2/dbs>tnsping DGTEST_DG2
TNS Ping Utility for Linux: Version 11.2.0.2.0 - Production on 03-APR-2013 12:00:59
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = brahe.nnet)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = DGTEST) (UR = A)))
OK (10 msec)
On the new Standby server: "kepler"
=========================
$ [kepler] <DGTEST> /oracle/product/db/11.2.0.2/dbs>lsnrctl services
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 03-APR-2013 12:39:53
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kepler.nnet)(PORT=1521)))
Services Summary...
Service "DGTEST_DG1" has 1 instance(s).
Instance "DGTEST", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
$ [kepler] <DGTEST> /oracle/product/db/11.2.0.2/dbs>lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 03-APR-2013 12:39:57
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=kepler.nnet)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 02-APR-2013 14:20:11
Uptime 0 days 22 hr. 19 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/product/db/11.2.0.2/network/admin/listener.ora
Listener Log File /oracle/product/diag/tnslsnr/kepler/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=kepler.nnet)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary...
Service "DGTEST_DG1" has 1 instance(s).
Instance "DGTEST", status READY, has 1 handler(s) for this service...
The command completed successfully