Home » RDBMS Server » Server Administration » What is the Default password for the SYS user in oracle 10g (oracle database version 10g)
What is the Default password for the SYS user in oracle 10g [message #351235] Tue, 30 September 2008 01:07 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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


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 Go to previous messageGo to next message
babuknb
Messages: 1734
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But we need to know the what is the default password

Why?

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Thanks for update.
Previous Topic: table partition drop with update global index class`
Next Topic: NLS Problem in 10g R2
Goto Forum:
  


Current Time: Sat Dec 03 01:31:51 CST 2016

Total time taken to generate the page: 0.12621 seconds