| lose dba password in 9i [message #58177] |
Tue, 05 August 2003 10:54  |
Jadie
Messages: 64
Registered: January 2002
|
Member |
|
|
Hi all, I have a question about sys(dba) password. In 8i, if I lost sys password, I can simply login on to the operating system as superuser. Then connect internal as sysdba without password. But in 9i, there is no internal, how can I login onto the database and change the password if I lost it?
Thanks.
Jadie
|
|
|
|
| Re: lose dba password in 9i [message #58178 is a reply to message #58177] |
Tue, 05 August 2003 12:09  |
ora9iDBA
Messages: 31
Registered: March 2003
|
Member |
|
|
Hi
You can login to your O/S as oracle user then just simply open sql*plus as
sqlplus "/ as sysdba"
or there is a utility orapwd to change password of sys
check it out
|
|
|
|
| Re: lose dba password in 9i [message #58182 is a reply to message #58178] |
Tue, 05 August 2003 16:33 |
Jadie
Messages: 64
Registered: January 2002
|
Member |
|
|
Kishor,
Thanks for the reply. I got the answer:
"SQLPLUS / AS SYSDBA" does not work on Windows 2000. but I can use "SQLPLUS system/password" (or any user) to login on to the database first, then SQLPLUS / AS SYSDBA. Of course I am the OS superuser.
does SQLPLUS / AS SYSDBA works on Solaris or other Unix systems?
Thanks again.
|
|
|
|
|
|
| Re: lose dba password in 9i [message #58188 is a reply to message #58182] |
Wed, 06 August 2003 02:09 |
ora9iDBA
Messages: 31
Registered: March 2003
|
Member |
|
|
Hi,
you can also use "/ as sysdba" on windows 2000 prior to that you have to invoke your sql*plus on command line
e.g.
C:> sqlplus "/ as sysdba"
also on unix if you logges as oracle user you can do it
$ sqlplus "/ as sysdba"
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
