Home » Server Options » Data Guard » 9i Dataguard standby resolution (Oracle EE 9.2.0.7 on AIX 5.2)
9i Dataguard standby resolution [message #277698] Wed, 31 October 2007 04:15 Go to next message
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 #278036 is a reply to message #277698] Thu, 01 November 2007 10:46 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Proper format your question.

2nd thing did you configure STANDBY or you are in the process of creating one.
More precise your question.
Re: 9i Dataguard standby resolution [message #278101 is a reply to message #277698] Thu, 01 November 2007 16:22 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: REDO log in STANDBY database
Next Topic: Data broker GUI
Goto Forum:
  


Current Time: Thu Mar 28 07:15:39 CDT 2024