change the default password of SYSTEM account

[sean_wu3]

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

[Former Member]

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

[former_member204746]

review SAP note 400241 to setup OPS$

after this, you will need to call SAPDBA this way:

sapdba -u /

You should think about stopping using SAPDBa and start using BRTOOLS. SAPDBA is not supported on Oracle 10g (and you will need to go there eventually)

[volker_borowski2]

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

[Former Member]

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