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 "" has 1 instance(s).
Instance "", status UNKNOWN, has 1 handler(s) for this service...
[oracle@localhost ~]$ tnsping stdorcl

TNS Ping Utility for Linux: Version - 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 =
OK (0 msec)
[oracle@localhost ~]$

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

SQL*Plus: Release 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 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


don't know where is the mistake.

thank you.

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


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