OraFAQ Forum: Server Administration » What is the Default password for the SYS user in oracle 10g

Home » RDBMS Server » Server Administration » What is the Default password for the SYS user in oracle 10g (oracle database version 10g)

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

What is the Default password for the SYS user in oracle 10g [message #351235]

Tue, 30 September 2008 01:07

krishnakumari
Messages: 6
Registered: September 2008
Location: hyderabad

Junior Member

Hi,
can anybody please help me what is the default password for the SYS user in 10g.
As i know it was chane_on_install till 9i.But same is not working with 10g.

please help me out in this senario

Best Regards
Krishna Kumari

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351237 is a reply to message #351235]

Tue, 30 September 2008 01:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends on how you create your database (manually or via dbca).
Anyway it does not matter, connect "/ as sysdba" and change it.

Regards
Michel

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351242 is a reply to message #351237]

Tue, 30 September 2008 01:24

krishnakumari
Messages: 6
Registered: September 2008
Location: hyderabad

Junior Member

Thanks a lot Michel,

But we need to know the what is the default password for SYS like change_on_install before.

Best Regards
Krishna Kumari

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351244 is a reply to message #351242]

Tue, 30 September 2008 01:29

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

But we need to know the what is the default password for SYS like change_on_install before.

It's only for previous version (Oracle 8 ) not in 10g.

If you don't know SYS password. Re-create your password file.

Babu

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351259 is a reply to message #351242]

Tue, 30 September 2008 02:09

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But we need to know the what is the default password

Why?

Regards
Michel

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351524 is a reply to message #351235]

Wed, 01 October 2008 06:18

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

Senior Member

There is no Default password for sys and system in 10g or later.
During database creation time oracle will prompt for the SYSTEM/SYS/SYSMAN/DBSNMP password.

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351526 is a reply to message #351524]

Wed, 01 October 2008 06:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

During database creation time oracle will prompt for the SYSTEM/SYS/SYSMAN/DBSNMP password.

If you are using dbca.

If you are using CREATE DATABASE there is still the default behaviour in 10g and 11g:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5004.htm#sthref6241

Regards
Michel

Report message to a moderator

Re: What is the Default password for the SYS user in oracle 10g [message #351662 is a reply to message #351526]

Thu, 02 October 2008 03:57

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

Senior Member

Thanks for update.

Report message to a moderator

Previous Topic:	table partition drop with update global index class`
Next Topic:	NLS Problem in 10g R2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:51:36 CST 2024