Home » RDBMS Server » Server Administration » Requirements in changing the sys password. (oracle rdbms)
Requirements in changing the sys password. [message #285170] Mon, 03 December 2007 16:41 Go to next message
ngonsuoi
Messages: 2
Registered: December 2007
Location: usa
Junior Member

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

Re: Requirements in changing the sys password. [message #285172 is a reply to message #285170] Mon, 03 December 2007 16:44 Go to previous messageGo to next message
BlackSwan
Messages: 25049
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
Re: Requirements in changing the sys password. [message #285198 is a reply to message #285170] Mon, 03 December 2007 22:24 Go to previous messageGo to next message
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.

Re: Requirements in changing the sys password. [message #285200 is a reply to message #285170] Mon, 03 December 2007 22:33 Go to previous message
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.
Previous Topic: tools to differentiate two database schemas?
Next Topic: SPFILE OR PFILE RELATED QUERY
Goto Forum:
  


Current Time: Fri Dec 09 10:04:07 CST 2016

Total time taken to generate the page: 0.15052 seconds