| suri |
Posted: Jul 24, 2007 01:13:12 AM |
Total Post: 20
Joined: Sep, 2006
|
Hello gurus,
I forgotten the sys password. When i logon as sys without giving the password, it is giving an error like ORA-01031 - Insufficient privilieges.
so, How can i logon to the sys user. Please help me to resolve this issue.
with regards,
Suresh. |
|
|
 ankur |
| Posted: Jul 24, 2007 07:34:36 AM |  |
|
Total Post: 59
Joined: Nov, 2006
|
use Orapwd utility to generate a new password for sys.
Usage: orapwd file=<fname> password=<password> entries=<users>
where
file - name of password file (mand),
password - password for SYS and INTERNAL (mand),
entries - maximum number of distinct DBA and OPERs (opt),
There are no spaces around the equal-to (=) character.
|
|
|
|
|
| DreamzZ |
| Posted: Jul 24, 2007 12:50:29 PM | |
|
Total Post: 23
Joined: Jul, 2007
|
http://www.orafaq.com/forum/t/85550/105911/
|
|
|
|
|
| jogi |
| Posted: Aug 29, 2007 02:28:53 PM | |
|
Total Post: 21
Joined: Jul, 2007
|
remove the password file whic was created by you in the dbs directory.
and o to sqlnet.ora comment the sql.authentication
conn sys as sysdba
password:change_on_install
sql:>sho user;
user is sys
thanks
prasad jogi
9886241382
tooracledba@gmail.com
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
