This discussion is archived
7 Replies Latest reply: Nov 20, 2012 10:17 AM by vlethakula RSS

authentication fail to auxiliary database

902332 Newbie
Currently Being Moderated
hi all,

i am trying to configure dataguard using rman in oracle 11gr2 version on linux 5.5

while connecting to auxiliary it is failing with following error:

RMAN> connect auxiliary sys/oracle@stdorcl

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: ORA-01031: insufficient privileges


I copied password file from primary and rename to standby instance name. and when i tried with sql it's getting connecting.


listener and tns is also working fine:

[oracle@localhost ~]$ lsnrctl status |grep stdorcl
Service "stdorcl" has 1 instance(s).
Instance "stdorcl", status BLOCKED, has 1 handler(s) for this service...
Service "stdorcl.taurus.com" has 1 instance(s).
Instance "stdorcl.taurus.com", status UNKNOWN, has 1 handler(s) for this service...
[oracle@localhost ~]$ tnsping stdorcl

TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 20-NOV-2012 20:23:33

Copyright (c) 1997, 2009, Oracle. All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = stdorcl.taurus.com)))
OK (0 msec)
[oracle@localhost ~]$


[oracle@localhost ~]$ sqlplus sys as sysdba@stdorcl

SQL*Plus: Release 11.2.0.1.0 Production on Tue Nov 20 20:19:28 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>



don't know where is the mistake.

thank you.

Edited by: 899329 on Nov 20, 2012 6:54 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points