OraFAQ Forum: Server Administration » Requirements in changing the sys password.

Home » RDBMS Server » Server Administration » Requirements in changing the sys password. (oracle rdbms)

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

Requirements in changing the sys password. [message #285170]

Mon, 03 December 2007 16:41

ngonsuoi
Messages: 2
Registered: December 2007
Location: usa

Junior Member

Can any body share the requirements for changing the sys password...

Report message to a moderator

Re: Requirements in changing the sys password. [message #285172 is a reply to message #285170]

Mon, 03 December 2007 16:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You do NOT need the password if you log directly on to the DB server a user Oracle.
entering the 2 following line should get you logged in as "sys"
sqlplus
/ as sysdba

Report message to a moderator

Re: Requirements in changing the sys password. [message #285198 is a reply to message #285170]

Mon, 03 December 2007 22:24

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

What is your oracle version.
if <=10g then you should change your sys password becuase default password is "change_on_install" and oracle also recommeneded to change sys password.

as Ana said, you can directly connect to sys without password.
but you also change and configure sys password for security purpose.

Report message to a moderator

Re: Requirements in changing the sys password. [message #285200 is a reply to message #285170]

Mon, 03 December 2007 22:33

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

requirements for changing the sys password.

The user who has dba privilege can do the thing.

Report message to a moderator

Previous Topic:	tools to differentiate two database schemas?
Next Topic:	SPFILE OR PFILE RELATED QUERY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:05:57 CDT 2024