| forget my sys password [message #165561] |
Thu, 30 March 2006 23:02  |
mfa786
Messages: 210
Registered: February 2006
Location: karachi
|
Senior Member |
|
|
Hi master
Sorry for disturb you
I forget my sys password and I want create new user with dba how I create new user with dba roles or how I get my sys password
Thanking you
Aamir
|
|
|
|
|
|
| Re: forget my sys password [message #165886 is a reply to message #165561] |
Mon, 03 April 2006 03:38  |
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
|
Senior Member |
|
|
Yes,
I have had good luck using kmsalih's method.
or
>sqlplus
>username: sys / as sysdba
>password: <enter anything> - I think it is os authcated?
Now change sys's password to something you know:
sql>alter user sys identified by <a good password>;
You can also:
create user <some username, like oradba> identified by <a good password>
assign oradba a profile and grant connect and dba roles to him.
Then log in as oradba and issue the sql statement:
alter user sys identified by <a different good password>;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
