| i want to enter sys as sysdba in oracle 8 server, it gives error [message #57485] |
Thu, 19 June 2003 00:18  |
vasanth
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
hello
thanking in advance,
I have an doubt in oracle 8 server,
I can not enter sys as sysdba in command prombt mode
It gives an error ,invalid username password
but it accept sys user without sysdba, from there i can not shutdown the database. I
the same thing is accepted in oracle 9i(sys as sysdba)
i want to enter sys as sysdba in command prombt
and i want to do some recovery operation,
So please help me as soon as possible,
bye
|
|
|
|
|
|
|
|
| Re: i want to enter sys as sysdba in oracle 8 server, it gives error [message #57502 is a reply to message #57485] |
Thu, 19 June 2003 08:15  |
ctg
Messages: 146
Registered: July 2002
|
Senior Member |
|
|
not sure on 8, but another thing to check.
are you using a password file? SQL> show parameter passwordfile (if set to shared or exclusive then you are)
if so, the password in your password file may not be matching the password in the database. ALTER USER sys IDENTIFIED BY pwd; this will update both the database (when you connect sys) and the passwordfile (when you connnect sys as sysdba).
and then try again.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
