| 9i Dataguard standby resolution [message #277698] |
Wed, 31 October 2007 04:15  |
jesc99
Messages: 3
Registered: October 2007
|
Junior Member |
|
|
Hi. Can anyone explain this behaviour please.
We have two AIX 5.2 servers - PRIM and STBY. PRIM hosts a 9.2.0.7 database - PROD, and STBY hosts a 9.2.0.7 Dataguard standby (for TNS purposes referred to as PROD2).
On PRIM, we're able to tnsping PROD2:
oracle@ireaix5 >tnsping prod2
TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 31-OCT-2007 09:07:20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PROD)))
OK (0 msec)
However, STBY's listener.ora only contains the following:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1512))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 2481))
)
)
STANDBY_LISTENER = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(PORT=1512)(HOST=STBY))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /apps/proddb/9.2)(PROGRAM = extproc))
(SID_DESC = (ORACLE_HOME = /apps/proddb/9.2) (SID_NAME = PROD)
)
)
STARTUP_WAIT_TIME_PROD = 0
CONNECT_TIMEOUT_PROD = 10
TRACE_LEVEL_PROD = OFF
LOG_DIRECTORY_PROD = /apps/proddb/9.2/network/admin
LOG_FILE_PROD = PROD
TRACE_DIRECTORY_PROD = /apps/proddb/9.2/network/admin
TRACE_FILE_PROD = PROD
#----ADDED BY TNSLSNR 26-OCT-2007 15:35:52---
PASSWORDS_LISTENER = BCDA28ADEDDEC168
#--------------------------------------------
i.e. no mention of PROD2.
So how is PRIM resolving PROD2?
(There are two other listeners running on STBY, but neither of their listener.oras contain any reference to PROD2).
Thanks in advance,
Jes
|
|
|
|
|
|
| Re: 9i Dataguard standby resolution [message #278101 is a reply to message #277698] |
Thu, 01 November 2007 16:22  |
jesc99
Messages: 3
Registered: October 2007
|
Junior Member |
|
|
Hi DreamzZ.
The standby configuration has been created and is working fine. My query related to name resolution, that's why it was posted in the networking and not the Data Guard forum.
Proper format your reply.
Regards,
Jes
|
|
|
|
| Re: 9i Dataguard standby resolution [message #278105 is a reply to message #277698] |
Thu, 01 November 2007 16:45 |
jesc99
Messages: 3
Registered: October 2007
|
Junior Member |
|
|
As we can see below, on the primary server, PROD2 is being resolved:
oracle@ireaix5 >tnsping prod2
TNS Ping Utility for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production on 31-OCT-2007 09:07:20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = PROD)))
OK (0 msec)
But, as we can see below, the listener on the standby server does not know about PROD2:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 1512))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = STBY)(PORT = 2481))
)
)
STANDBY_LISTENER = (ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(PORT=1512)(HOST=STBY))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC = (SID_NAME = PLSExtProc)(ORACLE_HOME = /apps/proddb/9.2)(PROGRAM = extproc))
(SID_DESC = (ORACLE_HOME = /apps/proddb/9.2) (SID_NAME = PROD)
)
)
STARTUP_WAIT_TIME_PROD = 0
CONNECT_TIMEOUT_PROD = 10
TRACE_LEVEL_PROD = OFF
LOG_DIRECTORY_PROD = /apps/proddb/9.2/network/admin
LOG_FILE_PROD = PROD
TRACE_DIRECTORY_PROD = /apps/proddb/9.2/network/admin
TRACE_FILE_PROD = PROD
#----ADDED BY TNSLSNR 26-OCT-2007 15:35:52---
PASSWORDS_LISTENER = BCDA28ADEDDEC168
#--------------------------------------------
So, my properly formatted question is how is the TNS alias for the standby database (PROD2) being resolved on the primary server when the listener on the standby server isn't aware of it? Properly.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
