Skip to Content
author's profile photo Former Member
Former Member

ora-01017 after change system password

Dear all,

i attempt this error during the brbackup, after the change of system password on oracle

"ora-01017 invalid username password logon denied

system/*********"

Infact, if i restore the default password (manager) the brbackup works fine.

The question is: could be sufficient change the password on brtools?

brconnect -f chpass -o system -p <new_password>

or i have to drop and recreate the OPS$ too?

DELETE FROM "OPS$<sid>ADM".SAPUSER;

INSERT INTO "OPS$<sid>ADM".SAPUSER VALUES ('<sapowner>', '<password>');

But the OPS$ mechanism works, because the sqlplus /@SID works!

the ossnote

Note 562863 - FAQ: Logon mechanisms

SYSTEM: By default, sapdba and the BR tools are connected to the database with the SYSTEM user and standard password. If you change this now, you can only start the tools by explicitly specifying the user name and password. To do this, use the option "-u <username>/<password>". Otherwise, calling sapdba, brbackup, brconnect, brarchive and brrestore fails with ORA-01017.

A useful alternative to the SYSTEM user when using the BR*TOOLS is to use the OPS$ mechanism by specifying "-u/". This mechanism is also used by DB13 actions by default.

so, there is not solution if i change the default password of SYSTEM user????

i have to run the brbackup with a crontab script, so i CANNOT use the workaround "brbackup -u system/newpassword" because i cannot leave this password clear on a file, but i must use the option "brbackup -u /"

Any idea?

tks!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 10:13 PM

    In case of crontab script, we used to explicitly specify the updated password for the system user (clear on a file) whereas DB13 uses "brbackup -u /"

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2011 at 10:15 PM

    Hi,

    >> The question is: could be sufficient change the password on brtools?

    brconnect -f chpass -o system -p <new_password>

    It is good enough to change the password. It will create the entry on SAPUSER table,

    >> or i have to drop and recreate the OPS$ too?

    No, you don't need this.

    You can use brbackup -u / without any problem. What makes trouble with it?

    Best regards,

    Orkun Gedik

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.