| Urgent! Cannot Change sys pw. [message #56675] |
Wed, 16 April 2003 07:47  |
newbie2
Messages: 8
Registered: October 2002
|
Junior Member |
|
|
How do you change the sys password in 9i?
It is still saying it is "change_on_install".
I logged in as sys/change_on_install as sysdba and then made and alter statement.
Here is the log file from what I have done:
SQL> set echo on
SQL> connect sys@imrs_test as sysdba
Connected.
SQL> sho user
USER is "SYS"
SQL> alter user sys identified by gondola;
User altered.
SQL> connect sys/gondola@imrs_test as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> spool off
For some reason, this did not work.
Please Help!
|
|
|
|
|
|
|
|
| Re: Urgent! Cannot Change sys pw. [message #56690 is a reply to message #56675] |
Wed, 16 April 2003 16:00  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
You have to make sure that the user has SYSDBA role granted before trying to connect as such:
SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP
------------------------------ ----- -----
INTERNAL TRUE TRUE
SYS TRUE TRUE
To grant the SYSDBA role use:
SQL> GRANT SYSDBA TO "username";
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
