could not login using sysdba

[Former Member]

Dear All,

We have ECC6.0 on oracle 10G,

here i am unable to login through sysdba

when i enter the password it says invalid username and password

but when u loign using user SYSTEM it takes me in.

if i login with nolog and connect /as sysdba it takes me in too.

please suggest some solution, why i am not able to login using sysdba,

because my backup team has scheduled the backup using sysdba but it keeps failing.

Regards,

SM

[stefan_koehler]

Hi,

>> here i am unable to login through sysdba

>> when i enter the password it says invalid username and password

Which command are you using... please post it here... normally if you are on the same machine and in the dba group you don't need to enter a password.

>> if i login with nolog and connect /as sysdba it takes me in too.

Please post this procedure, too.

Regards

Stefan

[Former Member]

Hi,

first i login using

sqlplus /nolog

connect /as sysdba

its working fine,

when i login using

sqlplus

user-name = sysdba

password = default password

its not able to login

when i login using user system with default password its working fine,,

i wonder why its not able to login using sysdba

please advise.

Thanks

[stefan_koehler]

Hello,

>> sqlplus

>>user-name = sysdba

>>password = default password

This is wrong. The "sysdba" is not a user... it is a privilege..

You can connect with sqlplus "/ as sysdba" directly from the shell.

If you don't specify a user (which is done with "/ as sysdba"), you authenticate with the OS user and the dba group.

There are 2 nice arcticles by Michael Braunstein, take a look at here:

/people/michael.braunstein/blog/2007/10/28/db-connect-mechanisms-in-oracle-and-sap--part-i

/people/michael.braunstein/blog/2007/11/01/db-connect-mechanisms-in-oracle-and-sap--part-ii

Regards

Stefan