Oracle sapdba password

[Former Member]

Hi,

I am using windows with oracle 9.2.0. When i enter sapdba in the command prompt to enter into the db administration, it prompted me for the password. I can acess after keying in the password. But my question is, why is he prompting me to enter the password ? During installation, I had enter all the necessary password. I had other servers but they did not prompt me for the password. Kindly advice.

Regards

Lauran

[former_member204746 · Accepted solution]

call SAPDBA this way:

sapdba -u /

if OPS$ is properly setup, it will not ask you for a password.

anyway, if using Oracle 9 or above, even if using SAP R/3 4.6, you should still use BRTOOLS version 6.40.

[fidel_vales · Accepted solution]

Hello Eric,

<i>>call SAPDBA this way:

>

>sapdba -u /

>

>if OPS$ is properly setup, it will not ask you for a password.</i>

That is a good option but I do not like it.

AFAIK, the "properly setup" for this combination imply that you have to give DBA to OPS$ and I do not think it is a good idea.

It would be better to create an specific DBA user and use:

SAPDBA -u <DBA user>/<password>

[Former Member]

Hi all,

Thanks for all the valuable answer.

Regards

Lauran

[fidel_vales]

Hello,

The answer is "easy" ( when you know it, of course )

Nothing to do with OPS$ or the user you are connected.

SAPDBA connects to the database using the database user "SYSTEM"

SAPDBA does not know this user's password, but it always tries with the default password.

If you still are using the default password for SYSTEM then it will not request a password ( but you have a security risk there )

If you change the default password, then you get an error ( something like wong password ) and then a prompt requesting the correct password.

Regards

Fidel

Message was edited by:

Fidel Vales

[Former Member]

yes. Im loggin in as SIDadm user

Thanks

[markus_doehr2]

Try to check if your OPS$ user is correctly configured:

Note 50088 - Creating OPS$ users on Windows NT/Oracle

--

Markus

[Former Member]

Since we are still using R3 4.6, we prefer to using sapdba. But just would like to find out the issue regarding the password prompting.

[markus_doehr2]

ah - ok you didn´T mention that

Are you logged on as adm when you execute sapdb?

--

Markus

[markus_doehr2]

sapdba is no longer supported, try with "brtools" instead.

--

Markus