1 Reply Latest reply: May 7, 2012 2:16 AM by AliD RSS

    monitoring Physical standby database through OEM

    778979
      HI ,

      We are monitoring Physical standby database through OEM and we monitor from console using SYS user

      As per our company policy we change our sys password every month so after change it we need to change SYS password from console also

      so is any way we can change SYS password on console using command line utility? if yes then please give us the command

      Thanks
        • 1. Re: monitoring Physical standby database through OEM
          AliD
          we monitor from console using SYS user
          You have to monitor it using a SYSDBA user not necessarily SYS. So you can create a user e.g. SYS_MONITOR which has different policy than SYS. Although it is best to change that password on regular bases too, maybe every 3 months.
          so is any way we can change SYS password on console using command line utility?
          I don't get your question. Are you asking if it is possible to change the monitoring username/password using some command line utility? If so, I haven't heard of such tool. But there could be a package like MGMT_TARGET which you can manipulate the credentials if you know how to use it.