2 Replies Latest reply: Aug 23, 2013 3:25 AM by umikhail RSS

    RMAN connect target ORA-01031

    umikhail

      Hi All,

      I have one question about connect with database.

       

      [oracle@srv-deeps-01 ~]$ sqlplus / as sysdba
      SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 23 09:11:26 2013
      Copyright (c) 1982, 2011, Oracle.  All rights reserved.
      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options
      SQL> select * from v$pwfile_users;
      
      USERNAME                       SYSDB SYSOP SYSAS
      ------------------------------ ----- ----- -----
      SYS                            TRUE  TRUE  FALSE
      MON                            TRUE  FALSE FALSE
      
      [oracle@srv-deeps-01 ~]$sqlplus /nolog
      SQL*Plus: Release 11.2.0.3.0 Production on Fri Aug 23 09:00:35 2013
      Copyright (c) 1982, 2011, Oracle.  All rights reserved.
      SQL> connect mon/mon@deeps as sysdba
      Connected.
      

       

      Also I can connect to database with rman

      [oracle@srv-deeps-01 ~]$ rman target /
      Recovery Manager: Release 11.2.0.3.0 - Production on Fri Aug 23 09:12:45 2013
      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
      connected to target database: deeps (DBID=3218868617)
      RMAN>
      
      [oracle@srv-deeps-01 ~]$ rman
      Recovery Manager: Release 11.2.0.3.0 - Production on Fri Aug 23 09:14:30 2013
      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
      RMAN> connect target mon/mon
      connected to target database: deeps (DBID=3218868617)
      RMAN>
      

       

       

      But when I trying connect to database remotely I get ORA-01031

      [oracle@srv-deeps-01 ~]$ rman
      Recovery Manager: Release 11.2.0.3.0 - Production on Fri Aug 23 09:16:20 2013
      Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
      RMAN> connect target mon/MonDEEPDB2013@deepdb
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      ORA-01031: insufficient privileges
      RMAN>
      

       

      In what may be the problem?

      P.S. This is a RAC database

        • 1. Re: RMAN connect target ORA-01031
          Aman....

          What is the value for the parameter remote_login_passwordfile ?

           

          Aman....

          • 2. Re: RMAN connect target ORA-01031
            umikhail

            I check this parameter when tryibg to solve problem.

            SQL> sho parameter remote_login
            NAME                                 TYPE        VALUE
            ------------------------------------ ----------- ------------------------------
            remote_login_passwordfile            string      EXCLUSIVE
            

             

            I found solution, but I can not explain it ) I grant "SYSDBA" right to user on both nodes instead of "sysdba" and all works fine. May be this command renew password file only on local node, may be command case sensivity I don't know...

            But this command help me resolve problem.

            grant SYSDBA to MON; --on both nodes
            

             

            Aman, thanks for you reply