Managed Standby

From: fahd mirza <fahd-m_at_aero.com.pk>
Date: Tue, 2 Nov 2004 12:58:02 +0500
Message-ID: <004101c4c0b1$ade559d0$6203a8c0@internethall>

Hi Listers,
I am trying to setup a standby database on a different host from primary. I am using Oracle 8.1.7 on WIN2K. I am unable to setup the standby database in managed recovery mode. It works in manual recovery mode. Also when on primary site, I give the command

Alter system archive log current;

the alert log file shows the following error

tns-12640 authentication adapter initialization failed.

I am sending you the parameters of primary and standby and also the listener and tnsnames of both files. Please help. I am really anxious. I have been trying to create standby database for the last two weeks. Thanks in advance.

Parameters of Primary:

db_name = "prod"
db_domain = awc.com
instance_name = prod
service_names = prod.awc.com

log_archive_start = true
log_archive_dest_1 = "location=G:\oracle\oradata\prod\archive mandatory reopen=5"
log_archive_dest_state_1=enable 
log_archive_format = %%ORACLE_SID%%T%TS%S.ARC
log_archive_dest_2="service=stdby optional reopen=5"
log_archive_dest_state_2=enable 
log_archive_min_succeed_dest=1;

TNSNAMES OF PRIMARY: PROD.AWC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DATASRV1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVICE_NAME = prod.awc.com)

    )
  )

INST1_HTTP.AWC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DATASRV1)(PORT = 1521))
    )
    (CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = prod.awc.com)
(PRESENTATION = http://admin)

    )
  )

stdby.AWC.COM =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = aero-v11knrvzlg)(PORT = 5112))
    )
    (CONNECT_DATA =(SID = prod)
    )
  )

PARAMETER OF STANDBY: db_name = "prod"
db_domain = awc.com

instance_name = prod
service_names = stdby.awc.com
control_files = ("C:\oracle\oradata\prod\STDBYCF.F")

log_archive_start = false
standby_archive_dest= C:\oracle\oradata\prod\archive log_archive_dest = "C:\oracle\oradata\prod\archive" log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

LISTENER.ORA OF STANDBY: STDBY_LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = aero-v11knrvzlg)(PORT = 5112))
      )

)
(DESCRIPTION =
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )


      (ADDRESS = (PROTOCOL = TCP)(HOST = aero-v11knrvzlg)(PORT = 2481))

)
)

SID_LIST_STDBY_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = prod.awc.com)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = prod)

    )
  )

Please help me.
Regards,
Fahd

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 02 2004 - 01:42:58 CST