Password of ORACLE user 'SYSTEM' is wrong

[Former Member]

Hello

If i want to start sapdba, I receive an error:

"Password of ORACLE user 'SYSTEM' is wrong"

Where and how i can read or change this password?

Thank you very much.

Selim

-

---

INSTANCE STATUS : shut down

CONNECTED PROGRAMS: 0

SM1 : not connected

a - Startup normal

b - Startup RESTRICT

c - Startup NOMOUNT

d - Startup MOUNT

e - Refresh

q - Return

Please select ==> a

• SAPDBA - Startup instance SM1 ************************

SAPDBA: Trying to start and open instance SM1

using STARTUP OPEN ...

SQL*Plus: Release 9.2.0.7.0 - Production on Wed Jan 3 13:31:41 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

ORACLE instance started.

Total System Global Area 925966720 bytes

Fixed Size 455040 bytes

Variable Size 494927872 bytes

Database Buffers 429391872 bytes

Redo Buffers 1191936 bytes

Database mounted.

Database opened.

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release 9.2.0.7.0 - Production

Password of ORACLE user 'SYSTEM' is wrong.

Enter password (30 char. max.) for 'SYSTEM' ==>

-

---

[Former Member · Accepted solution]

Hi Mohiuddin,

first sapdba will connect to database with user SYSTEM

if you have resently done any db refresh that shuch thing happen

as the default password for SYSTEM is manager

just reset the password to default one

second thing if u r OS is one of unix flavour then always connect as ORA(SID)

Cheer

Paresh

[Former Member · Accepted solution]

Hello Paresh

How do i can change/reset the password of SYSTEM?

We use windows server.

Thanks

Selim

[brad_landry2 · Accepted solution]

Hi,

use sqlplus :

sqlplus / as sysdba

ALTER USER SYSTEM IDENTIFIED BY <new_password>;

Brad

[Former Member]

Try 'sapdba -u /' as the ora<sid> user. That should enable you to connect to the database similar to 'connect internal'

[Former Member]

Hi Selim,

Did the above solutions work for you....

I'm getting the same error after a hetrogenous copy from windows to unix.

The ops$ users are created and have the correct roles. I've given them sapdba,resource and connect.

I've even added the system user and password to the OPS$<SID>ADM.SAPUSER table but this did not help.

I know you should be able to access sapdba on unix with both ora<sid> and <sid>adm with out entering a password.

Thanks

Jim

[former_member192350]

Your OPS$ authentication is probably misconfigured, so it needs the system password to get sysdba rights in the database. Normally this is handled automatically via OPS$. Check out notes 361641 (unix) & 50088 (NT). Note 620540 has a good troubleshooting guide, and you may need the sapdba_role.sql from note 134592 or 834917 (oracle 10g).

Once the OPS$ stuff is configured correctly, you should be able to run "sapdba -u /" to connect.

Rich

[Former Member]

Hello,

The message is not "very" good.

when you connect with SAPDBA ( no options ), internally it connect to the database with the user SYSTEM and the default password for this user.

If this password has changed ( and it should be changed for security reasons ) the connection fails with the error you mention.

The "wrong" password is the one that SAPDBA tried to use. You only have to type the current password for the SYSTEM user.

YOU ( or your DBA ) should know the password for SYSTEM and it should be keep secret.

As far as I know, it is not possible to "know" the password for a user ( unless you try to crack it via brute force )

[Former Member]

Hello

I know the password. If i give the password - i can start/stop die Datenbank through SAPDBA.

I don't know why it requires the password of SYSTEM.

For other System it is not necessary.

best regards

Selim

[andreas_herzog]

which user do you use to start SAPDBA? <sid>adm or ora<sid>?

GreetZ, AH

[Former Member]

Hello

SID<adm>

best Regards

Selim