Home » RDBMS Server » Server Administration » oracle10g sys user password
oracle10g sys user password [message #337966] Fri, 01 August 2008 14:57 Go to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
I installed the below oracle version in my desktop.

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>


Then i tried to connect the sys user and it accept any string as a possword. Any comments on this...

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\gthan>set oracle_sid=PRIM

C:\Documents and Settings\gthan>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Aug 1 15:36:02 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect sys/sys as sysdba
Connected.
SQL> connect sys/password as sysdba
Connected.
SQL> connect sys/dddd as sysdba
Connected.
SQL> connect sys/ouowieur as sysdba
Connected.
SQL> startup force
ORACLE instance started.

Total System Global Area  289406976 bytes
Fixed Size                  1248600 bytes
Variable Size             100663976 bytes
Database Buffers          184549376 bytes
Redo Buffers                2945024 bytes
Database mounted.
Database opened.
SQL>

Re: oracle10g sys user password [message #337968 is a reply to message #337966] Fri, 01 August 2008 14:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Working normally (when you are logged onto the OS as user "oracle" which owns the software.)
Re: oracle10g sys user password [message #337973 is a reply to message #337966] Fri, 01 August 2008 15:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
...or in ORA_DBA Windows group as you are on Windows.

By the way, why startup force?

Regards
Michel
Re: oracle10g sys user password [message #337995 is a reply to message #337966] Sat, 02 August 2008 02:19 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member
You are able to login as a sys user with any password, because, your oracle is set to use OS authentication scheme. See your sqlnet.ora file. You will get idea..

Regards,
Dipali.
Re: oracle10g sys user password [message #339028 is a reply to message #337973] Wed, 06 August 2008 10:40 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
Michel, It is my test database, Instead of shutting down and restarting the database, i use startup force. Thanks

Michel Cadot wrote on Fri, 01 August 2008 16:38
...or in ORA_DBA Windows group as you are on Windows.

By the way, why startup force?

Regards
Michel


Re: oracle10g sys user password [message #339039 is a reply to message #339028] Wed, 06 August 2008 11:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Instead of shutting down and restarting the database, i use startup force.

So you don't know what you are really doing, just use a short cut.

Regards
Michel
Re: oracle10g sys user password [message #339801 is a reply to message #339039] Fri, 08 August 2008 09:46 Go to previous messageGo to next message
shrinika
Messages: 306
Registered: April 2008
Senior Member
So you don't know what you are really doing, just use a short cut.


startup force shutdown the database in abort mode and restart the database. This is very small database and i am using this for learning purpose. That is the reason, i used startup force.

What do you mean "you don't know what you are really doing"?
Re: oracle10g sys user password [message #339804 is a reply to message #339801] Fri, 08 August 2008 10:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read last paragraph of http://www.orafaq.com/forum/m/263448/102589/?#msg_263448

Regards
Michel
Re: oracle10g sys user password [message #339887 is a reply to message #339804] Sat, 09 August 2008 07:50 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>>>It is my test database, Instead of shutting down and restarting the database, i use startup force.

Short cut are always dangerous when your going to handle Production/Live DB.

Previous Topic: 11G migration
Next Topic: Log_checkpoint_interval and Log_checkpoint_timeout
Goto Forum:
  


Current Time: Sat Dec 07 04:53:12 CST 2024