Urgent: ORACLE initialization or shutdown in progress

I can't log to Oracle database and I get this error message
ORACLE initialization or shutdown in progress

Open in new window


What the solution ?
egovernmentAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
check the alertlog file and post the error in it, this will be mostly the space issuse for the datafiles of the database.

you can also try this.

c:>sqlplus /nolog
sql> connect sys as sysdba
password: *******

check out this doc for more info
http://dbaforums.org/oracle/index.php?showtopic=16688
Wasim Akram ShaikCommented:
first of all as mentioned check out for any errors in alert log.

after this connect to database as

sqlplus "/ as sysdba"

and shutdown the database using shut immediate command

after this startup the database, incase there are any accidental errors, the database will not startup, it will throw an error while starting up.

if it starts up without any error, then your issue is resolved, if there are any errors, please post them here..
awking00Information Technology SpecialistCommented:
Are you an end user or developer? If so, your DBA or SA has probably taken the database down for some reason and you should contact them.
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

egovernmentAuthor Commented:
first of all as mentioned check out for any errors in alert log
How I do that ?

Are you an end user or developer? If so, your DBA or SA has probably taken the database down for some reason and you should contact them.
There no DBA or SA
I'm a developer
ajexpertCommented:
If you are developer, do you know where the DB is hosted?   Who is the owner of the machine?

You will find Alert logs where the DB is hosted

Wasim Akram ShaikCommented:
first of all as mentioned check out for any errors in alert log
How I do that ?

ok.. have you done the rest of steps??? shutting down and starting up?

if not, can you please do them to see if your problem is solved..

if the error persists, login to oracle db server

to locate the location of alert log, you can easily get it in case your db is running, using the command.

 select name,value from v$parameter where name ='background_core_dump';

incase your db is not running, go to the $ORACLE_HOME folder(in case db is hosted on windows, you can go to environment variables to find out what your oracle_home is, in case of unix you have to login using oracle login to find out this).

try to do a shutdown and startup, if this doesnot work then come back with details, what is OS of your db, then we can analyze further
awking00Information Technology SpecialistCommented:
There is bound to be a database administrator or system administrator of some sort. Who is it that has the ability to shut down or start up the database? That's who you need to answer your question.
egovernmentAuthor Commented:
Hi wasimibm

after this startup the database, incase there are any accidental errors, the database will not startup, it will throw an error while starting up.

Can you tell me what I write with the startup command ?
egovernmentAuthor Commented:
I do the following: -

sqlplus "/ as sysdba"
shutdown
startup

Open in new window


And the result in attach file
1.jpg
egovernmentAuthor Commented:
Hi awking00

There is bound to be a database administrator or system administrator of some sort. Who is it that has the ability to shut down or start up the database?

No there any DBA or SA in our company only I'm available as a developer
Wasim Akram ShaikCommented:
execute these commands

recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF';

Open in new window


if this doesnot work, then execute this

startup mount;

Open in new window


after this execute the above command again

recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF';

Open in new window


it will give you a message as

Media recovery complete.

after this execute the command

alter database open;

Open in new window


more info can be seen on these links

http://www.orafaq.com/forum/t/62097/2/

www.dba-oracle.com/t_ora_01113_file_string_needs_media_recovery.htm

egovernmentAuthor Commented:
Hi wasimibm

Please check attach files 2 3 4
Wasim Akram ShaikCommented:
type exit over there
and login to database again as sqlplus " / as sysdba"

shutdown immediate;

startup mount;

alter database open;

this should work

else follow the suggestions from the burleson site on resolving this error, you just need to restart the ipcs process for allocating memory to oracle background process.

http://www.dba-oracle.com/t_ora_24324_service_handle_not_initialized.htm
Wasim Akram ShaikCommented:
as this is a windows machine.. you might have problems finding the root user, just restart the machine.. all processes will automatically restart...
egovernmentAuthor Commented:
wasimibm

I restart the machine after that I do the following command:
shutdown immediate;

startup mount;

alter database open;

Open in new window


Please check attach file 5
Wasim Akram ShaikCommented:
ok.. i think you have got some problem with datafiles, they might need a proper recovery...

try to recover the files in the same way we did earlier..

recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF';

Open in new window

after recovery is complete
shutdown immediate;

startup mount;

alter database open;

Open in new window

lets try to see what happens, even if this shows another file needs recovery we will do the same process, we will recover one file at a time and will repeat these steps..



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
egovernmentAuthor Commented:
wasimibm

Please check the result

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jan 4 23:39:50 2012

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF'


SQL> recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF';
Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\UNDOTBS01.DBF'


SQL> recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\UNDOTBS01.DBF';

Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 3 needs media recovery
ORA-01110: data file 3:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSAUX01.DBF'


SQL> recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSAUX01.DBF';
Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 4 needs media recovery
ORA-01110: data file 4: 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF'


SQL> recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF';
Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01034: ORACLE not available


SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF'


SQL> recover datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF';
Media recovery complete.
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced


SQL>

Open in new window

Wasim Akram ShaikCommented:

shutdown immediate;
startup mount;
alter database recover;
alter database open;

if this doesn't help then

Well.. i think, its time to examine your alert log..
some thing has probably gone wrong..!!

paste last 200 lines of your alert log to examine further..


try these steps once now..

all these sites are saying that there might be problem at OS level (ie., file system)

http://www.dba-oracle.com/t_ora_01092_oracle_instance_terminated.htm

https://forums.oracle.com/forums/thread.jspa?threadID=1059824
egovernmentAuthor Commented:
wasimibm

I execute the commands

SQL> shutdown immediate;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup mount;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> alter database recover;
ERROR:
ORA-03114: not connected to ORACLE


SQL> alter database open;
ERROR:
ORA-03114: not connected to ORACLE

Open in new window

egovernmentAuthor Commented:
Any solution please ?
Wasim Akram ShaikCommented:
you haven't posted the contents of your alert log file..

we need to examine it.. to check out why the errors have occured..!!
egovernmentAuthor Commented:
ok wasimibm

Tell me step by step how I can go to the alert log file
Wasim Akram ShaikCommented:
:) .. if your database is mount state even we could have found out easily.. now its a little bit difficult...

how ever try this...

go to command prompt and type echo %ORACLE_HOME%

normally it would be present in directory like this

C:\admin\local\bdump

where admin and bdump are standard folder and local is the sid of your oracle database..

if you are on oracle10g try to search out for admin folder in your machine or simply search for alert.log in all directories..

Wasim Akram ShaikCommented:
sorry.. oracle home is different.typo mistake.. ignore abt ORACLE_HOME.. try to find out the directory structure mentioned over there

C:\admin\local\bdump

where in admin and bdump would be present in your system too, local will not be present as it is <ORACLE_SID>

ie., your oracle_sid name folder would be present ideally in your case...

if you can post in next 15 mins, i would be able to have a look at your alert log, else i am logging for today.. will check it out 2mrow..
egovernmentAuthor Commented:
There no command give me the folder contain alert log file ?
Wasim Akram ShaikCommented:
bdump is the folder which will contain the alert log, alert_<oracle_sid>.log is the alert log of the database where the alert is written normally..

if your database is up, then we would have found out easily by doing the following steps


C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 6 00:11:09 2012

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show parameter background;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------
background_core_dump                 string      partial
background_dump_dest                 string      [b]C:\ADMIN\LOCAL\BDUMP[/b]
SQL>

Open in new window


these are results of my machine. your machine will have a different output..!!!



egovernmentAuthor Commented:
You can found alert file from this link
alert file
egovernmentAuthor Commented:
SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> alter database recover;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced

Open in new window

Wasim Akram ShaikCommented:
I'm afraid.. what file have you placed over there.. i just opened it and my system has got hung..
later on i found that is little more than 1GB, i just requested a some last few lines(200-300).



egovernmentAuthor Commented:
Hi wasimibm

This is alert log file and size near 1 giga so this database since many years

I can't open this log file or need pc with big memory more than 6 giga
egovernmentAuthor Commented:
There a command to display last 200 lines from SQL ?
egovernmentAuthor Commented:
Ok I copy these lines from alert log file

Wed Jan 04 22:35:08 2012
alter database open
Wed Jan 04 22:35:08 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 22:35:52 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USER01.DBF'  
Wed Jan 04 22:35:52 2012
ORA-1179 signalled during: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USER01.DBF'  ...
Wed Jan 04 22:36:10 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF'  
Wed Jan 04 22:36:10 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 22:36:10 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF'  
Wed Jan 04 22:36:20 2012
alter database open
Wed Jan 04 22:36:21 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 22:37:01 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF'  
Wed Jan 04 22:37:01 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 22:37:02 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF'  
Wed Jan 04 22:37:08 2012
alter database open
Wed Jan 04 22:37:08 2012
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Wed Jan 04 22:37:09 2012
Started redo scan
Wed Jan 04 22:37:09 2012
Completed redo scan
 0 redo blocks read, 0 data blocks need recovery
Wed Jan 04 22:37:09 2012
Started redo application at
 Thread 1: logseq 1, block 3, scn 34367875
Wed Jan 04 22:37:09 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Wed Jan 04 22:37:09 2012
Completed redo application
Wed Jan 04 22:37:09 2012
Completed crash recovery at
 Thread 1: logseq 1, block 3, scn 34387876
 0 data blocks read, 0 data blocks written, 0 redo blocks read
Wed Jan 04 22:37:09 2012
Thread 1 advanced to log sequence 2
Thread 1 opened at log sequence 2
  Current log# 2 seq# 2 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Successful open of redo thread 1
Wed Jan 04 22:37:09 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Wed Jan 04 22:37:09 2012
SMON: enabling cache recovery
Wed Jan 04 22:37:10 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_7740.trc:
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Wed Jan 04 22:37:11 2012
Doing block recovery for file 1 block 22
Block recovery from logseq 2, block 3 to scn 34387883
Wed Jan 04 22:37:11 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Block recovery stopped at EOT rba 2.5.16
Block recovery completed at rba 2.5.16, scn 0.34387882
Doing block recovery for file 1 block 9
Block recovery from logseq 2, block 3 to scn 34387881
Wed Jan 04 22:37:11 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Block recovery completed at rba 2.5.16, scn 0.34387882
Wed Jan 04 22:37:11 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_7740.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Wed Jan 04 22:37:11 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_psp0_6816.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:11 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_5236.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:13 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_reco_6844.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:13 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_smon_5040.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:13 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_ckpt_2300.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:13 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_lgwr_6588.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:14 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw1_4924.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:14 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw0_1092.trc:
ORA-00604: error occurred at recursive SQL level 

Wed Jan 04 22:37:14 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_mman_8040.trc:
ORA-00604: error occurred at recursive SQL level 

Instance terminated by USER, pid = 7740
ORA-1092 signalled during: alter database open...
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=2096
PSP0 started with pid=4, OS id=7288
MMAN started with pid=6, OS id=5960
DBW0 started with pid=8, OS id=5348
DBW1 started with pid=10, OS id=7780
LGWR started with pid=12, OS id=7836
CKPT started with pid=14, OS id=2300
SMON started with pid=16, OS id=5092
RECO started with pid=18, OS id=6016
CJQ0 started with pid=20, OS id=4760
MMON started with pid=22, OS id=4936
MMNL started with pid=24, OS id=7360
Wed Jan 04 23:23:39 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:23:40 2012
alter database mount exclusive
Wed Jan 04 23:23:44 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:23:44 2012
Successful mount of redo thread 1, with mount id 3025588540
Wed Jan 04 23:23:44 2012
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Jan 04 23:23:44 2012
alter database open
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:24:33 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:24:33 2012
Stopping background process CJQ0
Wed Jan 04 23:24:34 2012
Stopping background process MMNL
Wed Jan 04 23:24:35 2012
Stopping background process MMON
Wed Jan 04 23:24:36 2012
Shutting down instance (immediate)
License high water mark = 2
Wed Jan 04 23:24:36 2012
Stopping Job queue slave processes
Wed Jan 04 23:24:36 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:24:38 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:24:38 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:25:13 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:25:13 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=5964
PSP0 started with pid=4, OS id=7824
MMAN started with pid=6, OS id=5756
DBW0 started with pid=8, OS id=7788
DBW1 started with pid=10, OS id=6612
LGWR started with pid=12, OS id=2548
CKPT started with pid=14, OS id=6324
SMON started with pid=16, OS id=7468
RECO started with pid=18, OS id=6728
CJQ0 started with pid=20, OS id=7812
MMON started with pid=22, OS id=4924
MMNL started with pid=24, OS id=6640
Wed Jan 04 23:25:13 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:25:14 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:25:18 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:25:18 2012
Successful mount of redo thread 1, with mount id 3025587610
Wed Jan 04 23:25:18 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:25:47 2012
alter database open
Wed Jan 04 23:25:47 2012
ORA-1113 signalled during: alter database open...
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PSP0 started with pid=4, OS id=3052
MMAN started with pid=6, OS id=3056
DBW0 started with pid=8, OS id=3240
DBW1 started with pid=10, OS id=3268
LGWR started with pid=12, OS id=3276
CKPT started with pid=14, OS id=3300
SMON started with pid=16, OS id=3312
RECO started with pid=18, OS id=3320
CJQ0 started with pid=20, OS id=3328
MMON started with pid=22, OS id=3336
MMNL started with pid=24, OS id=3344
Wed Jan 04 23:33:19 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:33:19 2012
alter database mount exclusive
PMON started with pid=2, OS id=3048
Setting recovery target incarnation to 2
Wed Jan 04 23:33:24 2012
Successful mount of redo thread 1, with mount id 3025561983
Wed Jan 04 23:33:24 2012
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Wed Jan 04 23:33:24 2012
alter database open
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:40:28 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:40:28 2012
Stopping background process CJQ0
Wed Jan 04 23:40:28 2012
Stopping background process MMNL
Wed Jan 04 23:40:29 2012
Stopping background process MMON
Wed Jan 04 23:40:30 2012
Shutting down instance (immediate)
License high water mark = 1
Wed Jan 04 23:40:30 2012
Stopping Job queue slave processes
Wed Jan 04 23:40:30 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:40:32 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:40:32 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:41:00 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:41:00 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=416
PSP0 started with pid=4, OS id=888
MMAN started with pid=6, OS id=1416
DBW0 started with pid=8, OS id=2024
DBW1 started with pid=10, OS id=4776
LGWR started with pid=12, OS id=7028
CKPT started with pid=14, OS id=1008
SMON started with pid=16, OS id=7032
RECO started with pid=18, OS id=5504
CJQ0 started with pid=20, OS id=5684
MMON started with pid=22, OS id=6348
MMNL started with pid=24, OS id=5888
Wed Jan 04 23:41:01 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:41:02 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:41:06 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:41:06 2012
Successful mount of redo thread 1, with mount id 3025552718
Wed Jan 04 23:41:06 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:41:26 2012
alter database open
Wed Jan 04 23:41:26 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:47:42 2012
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Jan 04 23:51:32 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF'  
Wed Jan 04 23:51:33 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 23:51:34 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF'  
Wed Jan 04 23:52:15 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:52:15 2012
Stopping background process CJQ0
Wed Jan 04 23:52:16 2012
Stopping background process MMNL
Wed Jan 04 23:52:17 2012
Stopping background process MMON
Wed Jan 04 23:52:18 2012
Shutting down instance (immediate)
License high water mark = 16
Wed Jan 04 23:52:18 2012
Stopping Job queue slave processes
Wed Jan 04 23:52:18 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:52:20 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:52:20 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:52:49 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:52:49 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=1360
PSP0 started with pid=4, OS id=6700
MMAN started with pid=6, OS id=1660
DBW0 started with pid=8, OS id=188
DBW1 started with pid=10, OS id=6436
LGWR started with pid=12, OS id=5512
CKPT started with pid=14, OS id=6724
SMON started with pid=16, OS id=3468
RECO started with pid=18, OS id=2828
CJQ0 started with pid=20, OS id=6232
MMON started with pid=22, OS id=3472
MMNL started with pid=24, OS id=6568
Wed Jan 04 23:52:49 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:52:50 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:52:55 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:52:55 2012
Successful mount of redo thread 1, with mount id 3025590546
Wed Jan 04 23:52:55 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:53:21 2012
alter database open
Wed Jan 04 23:53:21 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:54:24 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\UNDOTBS01.DBF'  
Wed Jan 04 23:54:24 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 23:54:25 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\UNDOTBS01.DBF'  
Wed Jan 04 23:54:53 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:54:53 2012
Stopping background process MMNL
Wed Jan 04 23:54:54 2012
Stopping background process MMON
Wed Jan 04 23:54:54 2012
Stopping background process CJQ0
Wed Jan 04 23:54:55 2012
Shutting down instance (immediate)
License high water mark = 16
Wed Jan 04 23:54:55 2012
Stopping Job queue slave processes
Wed Jan 04 23:54:55 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:54:56 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:54:56 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:55:09 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:55:09 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=6712
PSP0 started with pid=4, OS id=7144
MMAN started with pid=6, OS id=6496
DBW0 started with pid=8, OS id=1932
DBW1 started with pid=10, OS id=1948
LGWR started with pid=12, OS id=6648
CKPT started with pid=14, OS id=5764
SMON started with pid=16, OS id=2900
RECO started with pid=18, OS id=5720
CJQ0 started with pid=20, OS id=6916
MMON started with pid=22, OS id=568
MMNL started with pid=24, OS id=1572
Wed Jan 04 23:55:10 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:55:11 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:55:15 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:55:15 2012
Successful mount of redo thread 1, with mount id 3025594015
Wed Jan 04 23:55:15 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:56:04 2012
alter database open
Wed Jan 04 23:56:04 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:56:52 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSAUX01.DBF'  
Wed Jan 04 23:56:52 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 23:56:53 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSAUX01.DBF'  
Wed Jan 04 23:57:09 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:57:09 2012
Stopping background process MMNL
Wed Jan 04 23:57:10 2012
Stopping background process CJQ0
Wed Jan 04 23:57:11 2012
Stopping background process MMON
Wed Jan 04 23:57:11 2012
Shutting down instance (immediate)
License high water mark = 16
Wed Jan 04 23:57:11 2012
Stopping Job queue slave processes
Wed Jan 04 23:57:11 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:57:13 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:57:13 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:57:27 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:57:27 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=3240
PSP0 started with pid=4, OS id=5956
MMAN started with pid=6, OS id=2664
DBW0 started with pid=8, OS id=6968
DBW1 started with pid=10, OS id=2844
LGWR started with pid=12, OS id=5964
CKPT started with pid=14, OS id=3488
SMON started with pid=16, OS id=4712
RECO started with pid=18, OS id=2492
CJQ0 started with pid=20, OS id=6208
MMON started with pid=22, OS id=6580
MMNL started with pid=24, OS id=2768
Wed Jan 04 23:57:27 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:57:28 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:57:33 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:57:33 2012
Successful mount of redo thread 1, with mount id 3025564712
Wed Jan 04 23:57:33 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:57:44 2012
alter database open
Wed Jan 04 23:57:44 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:58:15 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF'  
Wed Jan 04 23:58:16 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 23:58:16 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\USERS01.DBF'  
Wed Jan 04 23:58:30 2012
Shutting down instance: further logons disabled
Wed Jan 04 23:58:30 2012
Stopping background process MMNL
Wed Jan 04 23:58:31 2012
Stopping background process MMON
Wed Jan 04 23:58:31 2012
Stopping background process CJQ0
Wed Jan 04 23:58:32 2012
Shutting down instance (immediate)
License high water mark = 16
Wed Jan 04 23:58:32 2012
Stopping Job queue slave processes
Wed Jan 04 23:58:32 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Wed Jan 04 23:58:34 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Wed Jan 04 23:58:34 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Wed Jan 04 23:58:57 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Wed Jan 04 23:58:57 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=6476
PSP0 started with pid=4, OS id=7084
MMAN started with pid=6, OS id=6248
DBW0 started with pid=8, OS id=824
DBW1 started with pid=10, OS id=1584
LGWR started with pid=12, OS id=1992
CKPT started with pid=14, OS id=6996
SMON started with pid=16, OS id=2488
RECO started with pid=18, OS id=6264
CJQ0 started with pid=20, OS id=1324
MMON started with pid=22, OS id=6720
MMNL started with pid=24, OS id=6004
Wed Jan 04 23:58:57 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Wed Jan 04 23:58:58 2012
ALTER DATABASE   MOUNT
Wed Jan 04 23:59:02 2012
Setting recovery target incarnation to 2
Wed Jan 04 23:59:02 2012
Successful mount of redo thread 1, with mount id 3025566082
Wed Jan 04 23:59:02 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Wed Jan 04 23:59:16 2012
alter database open
Wed Jan 04 23:59:16 2012
ORA-1113 signalled during: alter database open...
Wed Jan 04 23:59:57 2012
ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF'  
Wed Jan 04 23:59:57 2012
Media Recovery Start
 parallel recovery started with 15 processes
Wed Jan 04 23:59:58 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Completed: ALTER DATABASE RECOVER  datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\EARCHIVE.DBF'  
Thu Jan 05 00:00:12 2012
Shutting down instance: further logons disabled
Thu Jan 05 00:00:12 2012
Stopping background process MMNL
Thu Jan 05 00:00:13 2012
Stopping background process CJQ0
Thu Jan 05 00:00:14 2012
Stopping background process MMON
Thu Jan 05 00:00:14 2012
Shutting down instance (immediate)
License high water mark = 16
Thu Jan 05 00:00:14 2012
Stopping Job queue slave processes
Thu Jan 05 00:00:14 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Thu Jan 05 00:00:16 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Thu Jan 05 00:00:16 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thu Jan 05 00:00:28 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Thu Jan 05 00:00:28 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=6408
PSP0 started with pid=4, OS id=1340
MMAN started with pid=6, OS id=7156
DBW0 started with pid=8, OS id=6776
DBW1 started with pid=10, OS id=7160
LGWR started with pid=12, OS id=1752
CKPT started with pid=14, OS id=5796
SMON started with pid=16, OS id=6824
RECO started with pid=18, OS id=1032
CJQ0 started with pid=20, OS id=6312
MMON started with pid=22, OS id=3472
MMNL started with pid=24, OS id=6836
Thu Jan 05 00:00:29 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Jan 05 00:00:30 2012
ALTER DATABASE   MOUNT
Thu Jan 05 00:00:34 2012
Setting recovery target incarnation to 2
Thu Jan 05 00:00:34 2012
Successful mount of redo thread 1, with mount id 3025561822
Thu Jan 05 00:00:34 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Thu Jan 05 00:00:43 2012
alter database open
Thu Jan 05 00:00:43 2012
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Thu Jan 05 00:00:44 2012
Started redo scan
Thu Jan 05 00:00:45 2012
Completed redo scan
 2 redo blocks read, 0 data blocks need recovery
Thu Jan 05 00:00:45 2012
Started redo application at
 Thread 1: logseq 2, block 3
Thu Jan 05 00:00:45 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Thu Jan 05 00:00:45 2012
Completed redo application
Thu Jan 05 00:00:46 2012
Completed crash recovery at
 Thread 1: logseq 2, block 5, scn 34407882
 0 data blocks read, 0 data blocks written, 2 redo blocks read
Thu Jan 05 00:00:47 2012
Thread 1 advanced to log sequence 3
Thread 1 opened at log sequence 3
  Current log# 3 seq# 3 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO03.LOG
Successful open of redo thread 1
Thu Jan 05 00:00:47 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Thu Jan 05 00:00:47 2012
SMON: enabling cache recovery
Thu Jan 05 00:00:48 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_6232.trc:
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Thu Jan 05 00:00:49 2012
Doing block recovery for file 1 block 22
Block recovery from logseq 3, block 3 to scn 34407889
Thu Jan 05 00:00:49 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO03.LOG
Block recovery stopped at EOT rba 3.5.16
Block recovery completed at rba 3.5.16, scn 0.34407888
Doing block recovery for file 1 block 9
Block recovery from logseq 3, block 3 to scn 34407887
Thu Jan 05 00:00:49 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO03.LOG
Block recovery completed at rba 3.5.16, scn 0.34407888
Thu Jan 05 00:00:49 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_6232.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_lgwr_1752.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_psp0_1340.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_mman_7156.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw0_6776.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_ckpt_5796.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw1_7160.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:50 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_6408.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:51 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_reco_1032.trc:
ORA-00604: error occurred at recursive SQL level 

Thu Jan 05 00:00:51 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_smon_6824.trc:
ORA-00604: error occurred at recursive SQL level 

Instance terminated by USER, pid = 6232
ORA-1092 signalled during: alter database open...
Thu Jan 05 22:49:37 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Thu Jan 05 22:49:37 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=3056
PSP0 started with pid=4, OS id=2492
MMAN started with pid=6, OS id=4772
DBW0 started with pid=8, OS id=1852
DBW1 started with pid=10, OS id=6380
LGWR started with pid=12, OS id=6524
CKPT started with pid=14, OS id=1212
SMON started with pid=16, OS id=6984
RECO started with pid=18, OS id=1944
CJQ0 started with pid=20, OS id=6288
MMON started with pid=22, OS id=6656
MMNL started with pid=24, OS id=5968
Thu Jan 05 22:49:37 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Thu Jan 05 22:49:38 2012
ALTER DATABASE   MOUNT
Thu Jan 05 22:49:42 2012
Setting recovery target incarnation to 2
Thu Jan 05 22:49:43 2012
Successful mount of redo thread 1, with mount id 3025619650
Thu Jan 05 22:49:43 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Thu Jan 05 22:49:43 2012
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Thu Jan 05 23:04:41 2012
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jan 06 00:10:27 2012
Shutting down instance: further logons disabled
Fri Jan 06 00:10:27 2012
Stopping background process MMNL
Fri Jan 06 00:10:28 2012
Stopping background process MMON
Fri Jan 06 00:10:28 2012
Stopping background process CJQ0
Fri Jan 06 00:10:29 2012
Shutting down instance (immediate)
License high water mark = 2
Fri Jan 06 00:10:29 2012
Stopping Job queue slave processes
Fri Jan 06 00:10:29 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Jan 06 00:10:31 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Jan 06 00:10:31 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jan 06 00:10:34 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 00:10:34 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=5468
PSP0 started with pid=4, OS id=7120
MMAN started with pid=6, OS id=6264
DBW0 started with pid=8, OS id=6632
DBW1 started with pid=10, OS id=6744
LGWR started with pid=12, OS id=5796
CKPT started with pid=14, OS id=7024
SMON started with pid=16, OS id=6616
RECO started with pid=18, OS id=6628
CJQ0 started with pid=20, OS id=5444
MMON started with pid=22, OS id=5720
MMNL started with pid=24, OS id=3452
Fri Jan 06 00:10:35 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 00:10:35 2012
ALTER DATABASE   MOUNT
Fri Jan 06 00:10:40 2012
Setting recovery target incarnation to 2
Fri Jan 06 00:10:40 2012
Successful mount of redo thread 1, with mount id 3025658299
Fri Jan 06 00:10:40 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 00:10:41 2012
alter database recover
Media Recovery Start
 parallel recovery started with 15 processes
Fri Jan 06 00:10:42 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO03.LOG
Completed: alter database recover
Fri Jan 06 00:10:50 2012
alter database open
Fri Jan 06 00:10:50 2012
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Fri Jan 06 00:10:51 2012
Started redo scan
Fri Jan 06 00:10:51 2012
Completed redo scan
 2 redo blocks read, 0 data blocks need recovery
Fri Jan 06 00:10:51 2012
Started redo application at
 Thread 1: logseq 3, block 3, scn 34407886
Fri Jan 06 00:10:51 2012
Recovery of Online Redo Log: Thread 1 Group 3 Seq 3 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO03.LOG
Fri Jan 06 00:10:51 2012
Completed redo application
Fri Jan 06 00:10:51 2012
Completed crash recovery at
 Thread 1: logseq 3, block 5, scn 34427888
 0 data blocks read, 0 data blocks written, 2 redo blocks read
Fri Jan 06 00:10:51 2012
Thread 1 advanced to log sequence 4
Thread 1 opened at log sequence 4
  Current log# 1 seq# 4 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Successful open of redo thread 1
Fri Jan 06 00:10:51 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 06 00:10:51 2012
SMON: enabling cache recovery
Fri Jan 06 00:10:52 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_1184.trc:
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Fri Jan 06 00:10:53 2012
Doing block recovery for file 1 block 22
Block recovery from logseq 4, block 3 to scn 34427895
Fri Jan 06 00:10:53 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Block recovery stopped at EOT rba 4.5.16
Block recovery completed at rba 4.5.16, scn 0.34427894
Doing block recovery for file 1 block 9
Block recovery from logseq 4, block 3 to scn 34427893
Fri Jan 06 00:10:53 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Block recovery completed at rba 4.5.16, scn 0.34427894
Fri Jan 06 00:10:53 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_1184.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Fri Jan 06 00:10:54 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_5468.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:54 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_reco_6628.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:54 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_smon_6616.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_ckpt_7024.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_lgwr_5796.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw1_6744.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw0_6632.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_mman_6264.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 00:10:55 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_psp0_7120.trc:
ORA-00604: error occurred at recursive SQL level 

Instance terminated by USER, pid = 1184
ORA-1092 signalled during: alter database open...

Open in new window

egovernmentAuthor Commented:
The previous lines from alert log file is the last 1000 lines from alert log file
Wasim Akram ShaikCommented:
everything can't be done from SQL...!!!  

:) .. It would have been possible in unix, by i dont think there is any command in windows which will do this task..

As far as i think, in your database some of the data files might have got corrupted. which is causing the database crash while starting up..!!

if you had gone through the links from my earlier comments the ORA-01041 errors says that a severe problem occured while starting up..!!

Though you can't find solutions based on assumptions(that a severe problem occured while starting up database ).. you need to investigate the root cause and find out what has caused the actual error...

to check what has gone wrong, we would definitely need to have a look at your alert_log.

I'm not sure whether this is a standard approach, you can try one thing....

take the backup of existing alert_log(rename the existing alert log) create a new alert log with the same name and stop and start the database.. i think this should work, you will get fresh errors in alert log and the alert log will be very small,may be in just kbs, you can upload it here.
egovernmentAuthor Commented:
WasimIbm I do that
take the backup of existing alert_log(rename the existing alert log) create a new alert log with the same name and stop and start the database.. i think this should work, you will get fresh errors in alert log and the alert log will be very small,may be in just kbs, you can upload it here.

Fri Jan 06 10:33:33 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 10:33:33 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=5804
PSP0 started with pid=4, OS id=6908
MMAN started with pid=6, OS id=6300
DBW0 started with pid=8, OS id=7132
DBW1 started with pid=10, OS id=6388
LGWR started with pid=12, OS id=1356
CKPT started with pid=14, OS id=1848
SMON started with pid=16, OS id=1244
RECO started with pid=18, OS id=5752
CJQ0 started with pid=20, OS id=5440
MMON started with pid=22, OS id=1972
MMNL started with pid=24, OS id=6628
Fri Jan 06 10:33:34 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 10:33:35 2012
ALTER DATABASE   MOUNT
Fri Jan 06 10:33:39 2012
Setting recovery target incarnation to 2
Fri Jan 06 10:33:40 2012
Successful mount of redo thread 1, with mount id 3025700031
Fri Jan 06 10:33:40 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 10:33:40 2012
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...

Open in new window

Wasim Akram ShaikCommented:
here you go...

The ORa-1113 error means that your Backup implementation ("Retrospect") does an ALTER TABLESPACE BEGIN BACKUP and END BACKUP for each tablespace.

retry again those steps,

shutdown immediate;
startup mount;

ALTER DATABASE END BACKUP;
alter database open;



see how it goes, paste the results of activity and also the alert log file content.. hope this helps..!!!
Wasim Akram ShaikCommented:
hope you are executing the activity. i wish no new errors come up now :) ...

pls post some good news... its understood that even if its bad news, you'll post it though  :))
egovernmentAuthor Commented:
The result is

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> ALTER DATABASE END BACKUP;
ALTER DATABASE END BACKUP
*
ERROR at line 1:
ORA-01142: cannot end online backup - none of the files are in backup


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1:
'E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\SYSTEM01.DBF'


SQL>

Open in new window

egovernmentAuthor Commented:
Any solution ?
Wasim Akram ShaikCommented:
one last try,..

shutdown immediate;
startup mount;
Alter database recover;
alter database end backup;
alter database open;
Wasim Akram ShaikCommented:
also post the alert log of this activity,
egovernmentAuthor Commented:
The result of command

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 6 19:09:08 2012

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

Connected to an idle instance.

SQL> shutdown immediate;
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SQL> startup mount;
ORACLE instance started.

Total System Global Area  293601280 bytes
Fixed Size                  1330520 bytes
Variable Size             103461544 bytes
Database Buffers          184549376 bytes
Redo Buffers                4259840 bytes
Database mounted.
SQL> Alter database recover;
Alter database recover
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL> alter database end backup;
ERROR:
ORA-03114: not connected to ORACLE


SQL> alter database open;
ERROR:
ORA-03114: not connected to ORACLE


SQL>

Open in new window


The alert log file as
Fri Jan 06 10:33:33 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 10:33:33 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=5804
PSP0 started with pid=4, OS id=6908
MMAN started with pid=6, OS id=6300
DBW0 started with pid=8, OS id=7132
DBW1 started with pid=10, OS id=6388
LGWR started with pid=12, OS id=1356
CKPT started with pid=14, OS id=1848
SMON started with pid=16, OS id=1244
RECO started with pid=18, OS id=5752
CJQ0 started with pid=20, OS id=5440
MMON started with pid=22, OS id=1972
MMNL started with pid=24, OS id=6628
Fri Jan 06 10:33:34 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 10:33:35 2012
ALTER DATABASE   MOUNT
Fri Jan 06 10:33:39 2012
Setting recovery target incarnation to 2
Fri Jan 06 10:33:40 2012
Successful mount of redo thread 1, with mount id 3025700031
Fri Jan 06 10:33:40 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 10:33:40 2012
ALTER DATABASE OPEN
ORA-1113 signalled during: ALTER DATABASE OPEN...
Fri Jan 06 10:48:37 2012
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Fri Jan 06 12:14:57 2012
Shutting down instance: further logons disabled
Fri Jan 06 12:14:57 2012
Stopping background process MMNL
Fri Jan 06 12:14:58 2012
Stopping background process MMON
Fri Jan 06 12:14:58 2012
Stopping background process CJQ0
Fri Jan 06 12:14:59 2012
Shutting down instance (immediate)
License high water mark = 2
Fri Jan 06 12:14:59 2012
Stopping Job queue slave processes
Fri Jan 06 12:14:59 2012
Job queue slave processes stopped
Waiting for dispatcher 'D000' to shutdown
All dispatchers and shared servers shutdown
Fri Jan 06 12:15:01 2012
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Fri Jan 06 12:15:01 2012
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Fri Jan 06 12:15:24 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 12:15:24 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=6740
PSP0 started with pid=4, OS id=1976
MMAN started with pid=6, OS id=6768
DBW0 started with pid=8, OS id=6248
DBW1 started with pid=10, OS id=5404
LGWR started with pid=12, OS id=1396
CKPT started with pid=14, OS id=7144
SMON started with pid=16, OS id=5496
RECO started with pid=18, OS id=6224
CJQ0 started with pid=20, OS id=6884
MMON started with pid=22, OS id=568
MMNL started with pid=24, OS id=6532
Fri Jan 06 12:15:25 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 12:15:26 2012
ALTER DATABASE   MOUNT
Fri Jan 06 12:15:30 2012
Setting recovery target incarnation to 2
Fri Jan 06 12:15:30 2012
Successful mount of redo thread 1, with mount id 3025696414
Fri Jan 06 12:15:30 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 12:15:51 2012
ALTER DATABASE END BACKUP
Fri Jan 06 12:15:51 2012
ORA-1142 signalled during: ALTER DATABASE END BACKUP...
Fri Jan 06 12:16:25 2012
alter database open
Fri Jan 06 12:16:25 2012
ORA-1113 signalled during: alter database open...
Fri Jan 06 12:22:34 2012
Shutting down instance (abort)
License high water mark = 2
Instance terminated by USER, pid = 5584
Fri Jan 06 12:22:56 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 12:22:56 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=6792
PSP0 started with pid=4, OS id=4760
MMAN started with pid=6, OS id=6288
DBW0 started with pid=8, OS id=6728
DBW1 started with pid=10, OS id=1572
LGWR started with pid=12, OS id=6724
CKPT started with pid=14, OS id=6996
SMON started with pid=16, OS id=868
RECO started with pid=18, OS id=804
CJQ0 started with pid=20, OS id=508
MMON started with pid=22, OS id=2644
MMNL started with pid=24, OS id=6268
Fri Jan 06 12:22:57 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 12:22:58 2012
ALTER DATABASE   MOUNT
Fri Jan 06 12:23:02 2012
Setting recovery target incarnation to 2
Fri Jan 06 12:23:02 2012
Successful mount of redo thread 1, with mount id 3025678178
Fri Jan 06 12:23:02 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 12:23:17 2012
alter database open resetlogs
Fri Jan 06 12:23:17 2012
ORA-1139 signalled during: alter database open resetlogs...
Fri Jan 06 12:32:59 2012
ALTER DATABASE RECOVER  database  
Fri Jan 06 12:32:59 2012
Media Recovery Start
 parallel recovery started with 15 processes
Fri Jan 06 12:33:01 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Completed: ALTER DATABASE RECOVER  database  
Fri Jan 06 12:33:55 2012
alter database open

Fri Jan 06 12:33:55 2012
Beginning crash recovery of 1 threads
 parallel recovery started with 15 processes
Fri Jan 06 12:33:56 2012
Started redo scan
Fri Jan 06 12:33:57 2012
Completed redo scan
 2 redo blocks read, 0 data blocks need recovery
Fri Jan 06 12:33:58 2012
Started redo application at
 Thread 1: logseq 4, block 3
Fri Jan 06 12:33:58 2012
Recovery of Online Redo Log: Thread 1 Group 1 Seq 4 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO01.LOG
Fri Jan 06 12:33:58 2012
Completed redo application
Fri Jan 06 12:33:59 2012
Completed crash recovery at
 Thread 1: logseq 4, block 5, scn 34447894
 0 data blocks read, 0 data blocks written, 2 redo blocks read
Fri Jan 06 12:34:01 2012
Thread 1 advanced to log sequence 5
Thread 1 opened at log sequence 5
  Current log# 2 seq# 5 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Successful open of redo thread 1
Fri Jan 06 12:34:01 2012
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Jan 06 12:34:01 2012
SMON: enabling cache recovery
Fri Jan 06 12:34:03 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_2428.trc:
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Fri Jan 06 12:34:04 2012
Doing block recovery for file 1 block 22
Block recovery from logseq 5, block 3 to scn 34447901
Fri Jan 06 12:34:04 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Block recovery stopped at EOT rba 5.5.16
Block recovery completed at rba 5.5.16, scn 0.34447900
Doing block recovery for file 1 block 9
Block recovery from logseq 5, block 3 to scn 34447899
Fri Jan 06 12:34:04 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Block recovery completed at rba 5.5.16, scn 0.34447900
Fri Jan 06 12:34:04 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_2428.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4193], [49], [55], [], [], [], [], []

Error 604 happened during db open, shutting down database
USER: terminating instance due to error 604
Fri Jan 06 12:34:05 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_lgwr_6724.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:06 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_mman_6288.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:06 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_6792.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:06 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_psp0_4760.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:07 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw1_1572.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:07 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_ckpt_6996.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:07 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw0_6728.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:07 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_reco_804.trc:
ORA-00604: error occurred at recursive SQL level 

Fri Jan 06 12:34:07 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_smon_868.trc:
ORA-00604: error occurred at recursive SQL level 

Instance terminated by USER, pid = 2428
ORA-1092 signalled during: alter database open
...
Fri Jan 06 19:10:33 2012
Adjusting the default value of parameter parallel_max_servers
from 320 to 135 due to the value of parameter processes (150)
Fri Jan 06 19:10:33 2012
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on. 
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
  processes                = 150
  __shared_pool_size       = 92274688
  __large_pool_size        = 4194304
  __java_pool_size         = 4194304
  __streams_pool_size      = 0
  spfile                   = E:\ORACLE\PRODUCT\10.2.0\DB_1\DBS\SPFILEMOJDMS01.ORA
  sga_target               = 293601280
  control_files            = E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\CONTROL03.CTL
  db_block_size            = 8192
  __db_cache_size          = 184549376
  compatible               = 10.2.0.1.0
  db_file_multiblock_read_count= 16
  db_recovery_file_dest    = E:\oracle\product\10.2.0\db_1/flash_recovery_area
  db_recovery_file_dest_size= 2147483648
  undo_management          = AUTO
  undo_tablespace          = UNDOTBS1
  remote_login_passwordfile= EXCLUSIVE
  db_domain                = 
  dispatchers              = (PROTOCOL=TCP) (SERVICE=MOJDMS01XDB)
  job_queue_processes      = 10
  audit_file_dest          = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\ADUMP
  background_dump_dest     = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\BDUMP
  user_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\UDUMP
  core_dump_dest           = E:\ORACLE\PRODUCT\10.2.0\DB_1\ADMIN\MOJDMS01\CDUMP
  db_name                  = MOJDMS01
  open_cursors             = 300
  pga_aggregate_target     = 96468992
PMON started with pid=2, OS id=3488
PSP0 started with pid=4, OS id=5956
MMAN started with pid=6, OS id=188
DBW0 started with pid=8, OS id=5740
DBW1 started with pid=10, OS id=6508
LGWR started with pid=12, OS id=2436
CKPT started with pid=14, OS id=2528
SMON started with pid=16, OS id=1660
RECO started with pid=18, OS id=5476
CJQ0 started with pid=20, OS id=6372
MMON started with pid=22, OS id=1140
MMNL started with pid=24, OS id=1656
Fri Jan 06 19:10:34 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
starting up 1 shared server(s) ...
Fri Jan 06 19:10:35 2012
ALTER DATABASE   MOUNT
Fri Jan 06 19:10:39 2012
Setting recovery target incarnation to 2
Fri Jan 06 19:10:39 2012
Successful mount of redo thread 1, with mount id 3025685739
Fri Jan 06 19:10:39 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Fri Jan 06 19:10:55 2012
Alter database recover
Fri Jan 06 19:10:55 2012
Media Recovery Start
 parallel recovery started with 15 processes
Fri Jan 06 19:10:57 2012
Recovery of Online Redo Log: Thread 1 Group 2 Seq 5 Reading mem 0
  Mem# 0 errs 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\MOJDMS01\REDO02.LOG
Fri Jan 06 19:11:03 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_6808.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kews_sqlst_flush_level+23] [PC:0x2ED8543] [] [] []

Fri Jan 06 19:11:05 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\udump\mojdms01_ora_6808.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kews_sqlst_flush_level+23] [PC:0x2ED8543] [] [] []

Fri Jan 06 19:11:31 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p001_2856.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:31 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p003_5552.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:31 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p000_6940.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p005_3480.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p011_5712.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p004_7160.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p002_1504.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p006_1932.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p009_6956.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p007_6876.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p010_5860.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p008_5980.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p013_5520.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p014_5472.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:32 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_p012_6220.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__kxfprdp+3609] [PC:0x2E36F7D] [] [] []
ORA-10389: parallel query server interrupt (cleanup)

Fri Jan 06 19:11:34 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_3488.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__ksqxferieq+7791] [PC:0x2D45C5B] [] [] []

Fri Jan 06 19:11:48 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_3488.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__ksqxferieq+7791] [PC:0x2D45C5B] [] [] []

Fri Jan 06 19:11:48 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_pmon_3488.trc:
ORA-07445: exception encountered: core dump [IN_PAGE_ERROR] [__VInfreq__ksqxferieq+7791] [PC:0x2D45C5B] [] [] []

Fri Jan 06 19:12:37 2012
RECO: terminating instance due to error 472
Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw1_6508.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_ckpt_2528.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_psp0_5956.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_mman_188.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_lgwr_2436.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_dbw0_5740.trc:
ORA-00472: PMON  process terminated with error

Fri Jan 06 19:12:38 2012
Errors in file e:\oracle\product\10.2.0\db_1\admin\mojdms01\bdump\mojdms01_smon_1660.trc:
ORA-00472: PMON  process terminated with error

Instance terminated by RECO, pid = 5476

Open in new window

egovernmentAuthor Commented:
Any solution ?
slightwv (䄆 Netminder) Commented:
If this is an important database I would open an SR with Oracle Support.

If you do not have support I would encourage you to hire a local consultant to come in and physically assist you.

Disaster recovery is very difficult to respond to in a Q&A site like this.  There are so many things that 'can' go wrong and you might end up digging the hole deeper.


Did you take a backup of your data files (and control files) before you started any of the recovery attempts?
egovernmentAuthor Commented:
Did you take a backup of your data files (and control files) before you started any of the recovery attempts?

I not get your question
egovernmentAuthor Commented:
If this is an important database

Yes is important database
slightwv (䄆 Netminder) Commented:
When you first realized you had a corrupt/crashed database and posted this question:  Before you attempted and recovery commands, did you backup what you had so you could get back to that point?
slightwv (䄆 Netminder) Commented:
>>Yes is important database

My opinion:

Contact Oracle Support.

If you do not have a support contract:  Hire a local Oracle Consultant.
egovernmentAuthor Commented:
My opinion:

Contact Oracle Support.

If you do not have a support contract:  Hire a local Oracle Consultant.

I used oracle 10g database without any lisence
slightwv (䄆 Netminder) Commented:
>>I used oracle 10g database without any lisence

Is this a production database?
egovernmentAuthor Commented:
Is this a production database?

I download it from Oracle web site free
slightwv (䄆 Netminder) Commented:
>>I download it from Oracle web site free

That is the software.  What about the database?  You said the database is important.  Typically data in a development database isn't considered 'important'.

What is this database being used for?
egovernmentAuthor Commented:
I download it from the Oracle web site to use with application to store documents as images and using since 5 years
slightwv (䄆 Netminder) Commented:
That doesn't answer my question.  Who are the users of the application that store documents and is this for development or daily business use?

I understand you downloaded it from Oracle but 'free' has very specific uses per their license agreement.

Back to your question: I still suggest you hire a local consultant to help you recover the database.
egovernmentAuthor Commented:
That doesn't answer my question.  Who are the users of the application that store documents and is this for development or daily business use?
for dialy business uses

slightwv (䄆 Netminder) Commented:
I have offered my opinion on the answer: Hire a local consultant.

Based on what you have posted, you have an illegal Oracle install and I will not be able to help any further.

I suggest you look at Oracle XE.  This is the only free version for non-education or development.
egovernmentAuthor Commented:
I suggest you look at Oracle XE.  This is the only free version for non-education or development

First I should recover my database after that I can shift to Oracle XE
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Sorry, but I have to support slightwv here. Not in regard of licensing and we cannot help at all (that is something you need to resolve yourself anyway, now that you are aware of it), but having a corrupt database, and that it is a bad idea to rely on an online forum for repair at this point. The steps to recommend have been posted and tried, without success, and now it is the time to hire somebody. Any further actions need physical access and sophisticated knowledge about Oracle Recovery.

BTW, this are the steps to take for an important productive database:
Choose a DB technology you know something about.
Perform regular backups!
Have an emergency plan, e.g. somebody you can call fast to get into the issue, if you are not versed.
Make sure you have properly licensed the DBMS, which allows to have support by the DBMS manufacturer. Without licensing, the manufacturer will deny any help for sure, even if offering payment for it.
I know that does not help in your situation, as the emergency case is already there, but you should consider that for the future.
egovernmentAuthor Commented:
Hi Qlemo and thanks for all about help

In future I will follow these points: -
    * Choose a DB technology you know something about.

    * Perform regular backups!

    * Have an emergency plan, e.g. somebody you can call fast to get into the issue, if you are not versed.

    * Make sure you have properly licensed the DBMS, which allows to have support by the DBMS manufacturer. Without licensing, the manufacturer will deny any help for sure, even if offering payment for it.


I can now delete this question ?
Qlemo"Batchelor", Developer and EE Topic AdvisorCommented:
Don' think you should delete the question. wasimibm has tried to help you, and put some reasonable effort into it. Coming to the conclusion you need somebody on site after that effort is a valid recommendation. So you should award points IMO.
Wasim Akram ShaikCommented:
Hi egovernment, i think we had tried out every possible step, and i think i can't be of much help now...

go for slightvw recommendation of hiring a consultant, as your db is not licensed oracle won't provide you support for this..

and if you feel , you haven't got any help from this question , of course go ahead and delete it..
egovernmentAuthor Commented:
I found some steps can this help me in this problem ?
download.pdf
slightwv (䄆 Netminder) Commented:
Aren't those steps basically what has already been covered here?

The main step in that doc is: RECOVER DATABASE;

I believe you have already tried this and it was unsuccessful.

Also, in the future pay attention to step 1 in that doc.  It is what I mentioned in http:#a37390099

Step 1: Backup what you have before you start.
egovernmentAuthor Commented:
slightwv and other experts in data recovery for this software
http://www.stellarinfo.com/database-recovery/oracle-recovery/oracle-recovery.php
slightwv (䄆 Netminder) Commented:
I know nothing about that product but from looking at the quick description of what it does:  I do not think this will work for what you need.  This software still needs to be able to connect to the database.

I do not think you can find some magic software that will magically recover your database.

Oracle is pretty fault tolerant.  Since the basic recovery commands are not working you need more assistance than some piece of software can provide.

Since it appears your Oracle knowledge is limited, this is why I keep suggesting hiring a local consultant to come in and assist you hands-on.
egovernmentAuthor Commented:
slightwv

I download this software and run it as demo and it's recover the data and I browse the tables but I can't save the recovered data until I buy it
slightwv (䄆 Netminder) Commented:
I guess I stand corrected.

If you believe this software does what you need it to, then I guess you need to buy it.  Only you know the answer to this.
slightwv (䄆 Netminder) Commented:
I should add that for $599 you can likely hire that local Oracle Expert cheaper.

Since that software could look at the files, they might not be as bad as we thought.

I would spend some time in the Backup and Recovery guide and try a manual recovery again.
Wasim Akram ShaikCommented:
egovernment, your issue needs a detailed investigation and i think as far as possible we have diagnosed every possibility  to assist you to sort out your issue...

but unfortunately, this issue couldn't be get resolved..

We can point you the probable reasons and methods to resolve your issue, but can't provide the detailed step of each and every activity as you would have more knowledge on your system. As you have got the visual of your system and you could see the result of each and every activity performed...

we  could just assume and it is not necessary that what ever we had said might have happened exactly..

As far as the issue is concerned, i can say that some data files need recovery and some thing has gone wrong with those data files as they are not getting recovered via the normal process.

egovernmentAuthor Commented:
Thank for everybody try to help me in this issue

I thing this issue without solution

I will delete this question
egovernmentAuthor Commented:
I've requested that this question be deleted for the following reason:

This issue without solution
Wasim Akram ShaikCommented:
i think, the question is well answered and have given the probable analysis to the user where could have been the problem...

a detailed analysis has been done on this to find the root cause that datafiles mentioned in my comments  that data files got corrupted and they needs a recovery,  we can just tell him how to do, and ways to do and what to do, the end user has to do the actuals. if the end user is not well aware of the problem and expect the experts to perform this task on his behalf this is not for which this site is for. I belive.. the reason for my objection is the same , where in user has not agreed with the solution provided and expected experts to resolve his issue..
Wasim Akram ShaikCommented:
i think, the question is well answered and have given the probable analysis to the user where could have been the problem...

a detailed analysis has been done on this to find the root cause that datafiles mentioned in my comments  that data files got corrupted and they needs a recovery,  we can just tell him how to do, and ways to do and what to do, the end user has to do the actuals. if the end user is not well aware of the problem and expect the experts to perform this task on his behalf this is not for which this site is for. I belive.. the reason for my objection is the same , where in user has not agreed with the solution provided and expected experts to resolve his issue..
egovernmentAuthor Commented:
Hi alias99

I need #2 delete / no refund
egovernmentAuthor Commented:
I've requested that this question be deleted for the following reason:

I'm sorry I press over request attenstion by wrong<br /><br />Exactly I need to delete question because no answer to solve problem
Wasim Akram ShaikCommented:
thanks modus...!!! agree with your comment...
egovernmentAuthor Commented:
modus_in_rebus

I hope this is not a policy of expert-exchange that select award the question without solve it.

I actully not solve my issue with software or not.

I'm delete the courpted database and I start a new one.

So why I should aware somebody without solve the problem ?

I know the expert try to help me but there no effect

The correct option for this question deleted and not awarded to any body not solve it
So please understand me and delete this question ASAP and if you see many answers going outside the scope of work for delete or not delete.

Regards
egovernmentAuthor Commented:
modus_in_rebus
I still not agree with you

Either get an expert to look at it in person, or use recovery software that can retrieve the data.
I get expert this is not a solution
Why I comming here to found somebody tell me go and find expert ?

 use recovery software that can retrieve the data
I tested money softwares but it is not recover any data
egovernmentAuthor Commented:
modus_in_rebus
I think you want forced award this project and I think this is not the policy of this web site
egovernmentAuthor Commented:
Please I want to delete this question immedialy
egovernmentAuthor Commented:
modus_in_rebus

I'm still not agree with you

and I hope to delete this question

Now I'm follow all EE rools one by one

But I don't like force action
Wasim Akram ShaikCommented:
solutions have been provided in the comments shown below

http:#a37386290

http:#a37376844
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.