5 Replies Latest reply: Mar 25, 2013 4:44 AM by Vikas0204 RSS

    RMAN duplicate database coonect to auxiliary database

    Vikas0204
      Hello every one

      i am trying to connect to auxiliary database but it show me insufficient privileges

      i have created my passwrd file on primary i.e. orcl as orapworcl and copy it on standby i.e. orcl10 as orapworcl10

      RMAN> connect auxiliary sys/vikas@orcl10

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

      standby tnsname.ora

      ORCL10 =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.107.151)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl10)
      )
      )

      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )


      tnsorcl10 =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = testmachine.icfre.org)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = testorcl10)
      )
      )


      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =172.16.103.51 )(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )


      primary tnsname.ora

      ORCL =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = portalnode01.icfre.org)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
      )
      )


      orcl10=
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST =172.16.107.151 )(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl10)
      )
      )


      EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      )
      (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
      )
      )

      Edited by: 993776 on Mar 14, 2013 2:43 AM