Managed Standby

From: "fahd mirza" <fahd-m@xxxxxxxxxxx>
To: "Active DBA" <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 2 Nov 2004 12:58:02 +0500
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


--
//www.freelists.org/webpage/oracle-l
Managed Standby

Other related posts:
