Home » RDBMS Server » Security » forget my sys password
forget my sys password [message #165561] Thu, 30 March 2006 23:02 Go to next message
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 #165573 is a reply to message #165561] Thu, 30 March 2006 23:40 Go to previous messageGo to next message
kmsalih
Messages: 197
Registered: March 2006
Senior Member
hi,

Try this

Go to Server
$ sqlplus "/as sysdba"


Regards
SALIH KM
Cool
Re: forget my sys password [message #165886 is a reply to message #165561] Mon, 03 April 2006 03:38 Go to previous messageGo to next message
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>;
Re: forget my sys password [message #165909 is a reply to message #165886] Mon, 03 April 2006 04:52 Go to previous message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
to proceed with the above method , OS user should be in dba or (what ever group authorized )

Thanks & Regards
Madhu
Previous Topic: Using sticky bit on Oracle directory & umask
Next Topic: logon trigger cannot prevent DBA account from logging in database
Goto Forum:
  


Current Time: Fri Mar 29 09:33:42 CDT 2024