on 12-31-2009 8:50 AM
Dear all,
I use SAPDBA to backup redo logs, but I can't backup redo logs after changing the default password of SYSTEM account(Oracle).
Could I use another account to backup redo logs through SAPDBA? Or is there better solution? Many thanks.
SAP R/3 4.7
Oracle 9i
Hi Sean
Use the SAPDBA to change the password of the SYSTEM account account, your problrm will be solved.
It is not adviced to change the password of the SYSTEM account using the SQL, you should always use the SAPDBA to do this.
Thanks
Pavan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You should use the OPS$ Connect
to do any kind of backup.
Setup requires :
oradbusr.sql -> Is attached to a sapnet note
sapdba_role.sql -> is in the kernel archive DBATOOLS.
Both scripts have to be for verison 9.x not for version 10.
Stop using sapdba and start using brtools.
Volker
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I use SAPDBA to backup redo logs, but I can't backup redo logs after changing the default password of SYSTEM account(Oracle)
doesn't matter if you are not using any tools for backup(other than standards)
Could I use another account to backup redo logs through SAPDBA? Or is there better solution?
try with some other DB user(must have sysdba privil)
Regards
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.