OraFAQ Forum: Server Administration » lost sys

Home » RDBMS Server » Server Administration » lost sys_password

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

lost sys_password [message #61552]

Wed, 05 May 2004 01:01

ECI
Messages: 10
Registered: May 2004

Junior Member

I forgot my sys password... pls help ... asap

ty

Report message to a moderator

Re: lost sys_password [message #61555 is a reply to message #61552]

Wed, 05 May 2004 02:31

Sujit Sarkar
Messages: 40
Registered: September 2003

Member

You make sure the OS user belongs to ORADBA group in windows or DBA group in Linux, then to connect as sys as sysdba try following command.
connect / as sysdba

note : also make one change in SQLNET.ORA file add this entry if it was not there
SQLNET.AUTHENTICATION_SERVICES=(NTS)

best of luck

Thanx & Rgrds

Sujit

Report message to a moderator

Re: lost sys_password [message #61557 is a reply to message #61552]

Wed, 05 May 2004 03:04

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

Login to system as OS user, which apart to dba groop and then in sqlplus:
a)In Oracle 8 exec connect internal
b)In Oracle 9 start sqlplus with option /nolog and then connect as any user(for example username aaa) and any password.
Then you can change password of any user.

Report message to a moderator

Re: lost sys_password [message #61570 is a reply to message #61557]

Wed, 05 May 2004 17:04

ECI
Messages: 10
Registered: May 2004

Junior Member

hi, our system is 8i, when i log_in as internal, an error prompted "ORA-01031: insufficient privileges"...
I've tried other user its ok, but how can i change password?
thanks again!

Report message to a moderator

Previous Topic:	protocol.ora - I can't find this file? (Oracle 8.1.7)
Next Topic:	Deallocating unused table space

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 13:53:10 CST 2025