2 Replies Latest reply: Jan 18, 2013 9:04 PM by Srini Chavali-Oracle RSS

    ORA-01031: insufficient privileges from auxiliary database while connecting

    983528
      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