| oracle10g sys user password [message #337966] |
Fri, 01 August 2008 14:57  |
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 #339028 is a reply to message #337973] |
Wed, 06 August 2008 10:40  |
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 #339801 is a reply to message #339039] |
Fri, 08 August 2008 09:46 |
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 #339887 is a reply to message #339804] |
Sat, 09 August 2008 07:50 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
