This discussion is archived
2 Replies Latest reply: Jan 18, 2013 7:04 PM by Srini Chavali-Oracle RSS

ORA-01031: insufficient privileges from auxiliary database while connecting

983528 Newbie
Currently Being Moderated
i am getting this error ORA-01031: insufficient privileges from auxiliary database while connecting plz help.
TNS-01106: Listener using listener name VINAR has already been started
[oraclone@server VINTEST_server]$ tnsping VINAR
 
TNS Ping Utility for Linux: Version 11.1.0.7.0 - Production on 17-JAN-2013 19:10:49
 
Copyright (c) 1997, 2008, Oracle.  All rights reserved.
 
Used parameter files:
/d04/oraclone/db/tech_st/11.1.0/network/admin/VINTEST_server/sqlnet_ifile.ora
 
 
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=server.csacons.com)(PORT=1571)) (CONNECT_DATA= (SERVICE_NAME=VINAR) (INSTANCE_NAME=VINAR)))
OK (0 msec)
[oraclone@server VINTEST_server]$ rman target sys/change_on_install@VINAR auxiliary / 
 
Recovery Manager: Release 11.1.0.7.0 - Production on Thu Jan 17 19:11:38 2013
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database: 
ORA-01031: insufficient privileges
 
[oraclone@server VINTEST_server]$ sqlplus sys/change_on_install@VINAR as sysdba
 
SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jan 17 19:31:52 2013
 
Copyright (c) 1982, 2008, Oracle.  All rights reserved.
 
ERROR:
ORA-01031: insufficient privileges
 
 
Enter user-name: sys@VINAR as sysdba
Enter password: 
ERROR:
ORA-01031: insufficient privileges
 
 
Enter user-name: [oraclone@server VINTEST_server]$ 
[oraclone@server VINTEST_server]$ 
SQL> select * from v$pwfile_users;
 
no rows selected
 
SQL> 
 
listner.ora
 
SID_LIST_VINTEST =
  (SID_LIST =
    (SID_DESC =
      (ORACLE_HOME= /d04/oraclone/db/tech_st/11.1.0)
      (SID_NAME = VINTEST)
 
      #(GLOBAL_DBNAME = VINAR)
      #(ORACLE_HOME= /d03/oravnr/db/tech_st/11.1.0)
      #(SID_NAME = VINAR)
 
  )
      (SID_DESC =
      #(ORACLE_HOME= /d04/oraclone/db/tech_st/11.1.0)
      #(SID_NAME = VINTEST)
 
      (GLOBAL_DBNAME = VINAR)
      (ORACLE_HOME= /d03/oravnr/db/tech_st/11.1.0)
      (SID_NAME = VINAR)
 
    )
 
  )
                                   
tnsnames.ora
 
VINTEST=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=server.csacons.com)(PORT=1591))
            (CONNECT_DATA=
                (SERVICE_NAME=VINTEST)
                (INSTANCE_NAME=VINTEST)
            )
        )
 
                                                              
VINAR=
        (DESCRIPTION=
                (ADDRESS=(PROTOCOL=tcp)(HOST=server.csacons.com)(PORT=1571))
            (CONNECT_DATA=
                (SERVICE_NAME=VINAR)
                (INSTANCE_NAME=VINAR)
            )
        )
 
 
kind regards
plz help

Legend

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