Want to change sys password [message #429735] |
Thu, 05 November 2009 09:22 |
rhnilu
Messages: 12 Registered: January 2009 Location: Bangladesh
|
Junior Member |
|
|
I don't know sys password. But I need the password for DBA activities. How can I logon into sys user with sysdba or How can I change the old password to new password. Any one can help me plz..
|
|
|
|
|
|
Re: Want to change sys password [message #435222 is a reply to message #429735] |
Tue, 15 December 2009 04:52 |
SreeQ8
Messages: 1 Registered: December 2009 Location: Kuwait
|
Junior Member |
|
|
Windows follow step 1,2,4,5
Linux Users follow 3,4,5
1. Open Dos Prompt using CMD in windows ,(Click Start , Run Type CMD)
2. SET ORACLE_SID=(your database SID)
3. Type the following command on linux shell prompt
export ORACLE_SID=(your database SID)
4. Type sqlplus "/ as sysdba"
5. Type password
make sure the logged user has DBA_ROLE in windows.
and
Check you have the following line in your sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
[Updated on: Tue, 15 December 2009 04:55] Report message to a moderator
|
|
|