4 Replies Latest reply: Dec 11, 2013 5:34 AM by Mahir M. Quluzade RSS

    Error from Logical Standby

    misterimran

      Dear All,

       

      I have configured Logical Standby Database 10gR2, on Windows 2003 Server.

      Logs are shipped and applied on the standby, without any issue.

      I can log on logical database using sys account, but if i use any other user's account i get this error message:

       

      SQL> connect user/pass
      ERROR:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-06550: line 11, column 52:
      PL/SQL: ORA-16224: Database Guard is enabled
      ORA-01017: invalid username/password; logon denied
      ORA-06550: line 11, column 4:
      PL/SQL: SQL Statement ignored
      ORA-06550: line 17, column 28:
      PL/SQL: ORA-16224: Database Guard is enabled
      ORA-01017: invalid username/password; logon denied
      ORA-06550: line 14, column 8:
      PL/SQL: SQL Statement ignored
      ORA-06550: line 20, column 12:
      PLS-00513: PL/SQL function called from SQL must return value of legal SQL type
      ORA-06550: line 12, column 4:
      PL/SQL: Statement ignored
      ORA-01017: invalid username/password; logon denied

       

      I have copied the password file from live to standby.

       

      Kindly help