ORA-01092 error:::please help urgent! [message #212009] |
Wed, 03 January 2007 08:18 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Hi, I am new to Oracle. I am trying to upgrade the test box from 8.1.7 to 9.2.0.6 version. I have installed the newer version and applied the patches to the newer version. I changed the all the dump destinations and set the environment variables for 9i.
Now when i do startup migrate pfile='../init.ora' gives me the following error:
ORA-25138: JOB_QUEUE_INTERVAL initialization parameter has been made obsolete
ORA-25138: DISTRIBUTED_TRANSACTIONS initialization parameter has been made obsolete
ORA-32006: MTS_DISPATCHERS initialization parameter has been deprecated
ORACLE instance started.
Total System Global Area 526353976 bytes
Fixed Size 730680 bytes
Variable Size 218103808 bytes
Database Buffers 307200000 bytes
Redo Buffers 319488 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
When I comment out JOB_QUEUE_INTERVAL, DISTRIBUTED_TRANSACTIONS,MTS_DISPATCHERS parameters in the init file, I get just the ORA-01092 error.
Please somebody help me.I really appreciate it.
Thanks in advance.
[Updated on: Wed, 03 January 2007 09:07] Report message to a moderator
|
|
|
|
|
Re: ORA-01092 error:::please help urgent! [message #212039 is a reply to message #212029] |
Wed, 03 January 2007 10:29 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Thanks for your messages. The database 9.2.0.6 is already installed and the patches are applied to it. I just need to upgrade it and its giving me the above mentioned error.
In the alert log, I couldnt really figure out anything. Below is what it is in the alert log, I apologize if the msg is quite big:
SMON: enabling tx recovery
Wed Jan 3 10:47:33 2007
Errors in file /oracle92/oracle/admin/AR314T/udump/ar314t_ora_3269.trc:
ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []
Wed Jan 3 10:47:33 2007
Errors in file /oracle92/oracle/admin/AR314T/bdump/ar314t_smon_3261.trc:
ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []
Wed Jan 3 10:47:34 2007
ARC0: Completed archiving log 3 thread 1 sequence 9912
Wed Jan 3 10:47:34 2007
Errors in file /oracle92/oracle/admin/AR314T/udump/ar314t_ora_3269.trc:
ORA-00000: normal, successful completion
Wed Jan 3 10:47:34 2007
Error 1 happened during db open, shutting down database
USER: terminating instance due to error 1
Instance terminated by USER, pid = 3269
ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE...
Thanks,
awaiting your response
Sangeetha
|
|
|
|
Re: ORA-01092 error:::please help urgent! [message #212042 is a reply to message #212039] |
Wed, 03 January 2007 10:37 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []
you are getting ora-00600 error.
for better solution call oracle support or if you have Metalink access then see note about ora-00600 error.
i was search on net and found.
http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_cid624686_tax296095,00.html
check above link it is based on oracle 7 to oracle 9 but you can also set o7_dictionary_accessibility=TRUE parameter and try your operation.
some related links are
http://www.dbforums.com/archive/index.php/t-326196.html
http://www.dbasupport.com/forums/history/topic.php/49225-1.html
regards
Taj
[Updated on: Wed, 03 January 2007 10:42] Report message to a moderator
|
|
|
Re: ORA-01092 error:::please help urgent! [message #212043 is a reply to message #212009] |
Wed, 03 January 2007 10:40 |
plshelp
Messages: 205 Registered: January 2007
|
Senior Member |
|
|
Below is the info in that file:
*** 2007-01-03 10:47:33.924
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []
Current SQL statement for this session:
select value$ from sys.props$ where name = :1
ksh: KCRA:: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>*** 2007-01-03 10:47:31.975
ksh: ar314t_ora_2628.trc: cannot execute
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Recovery of Online Redo Log: Thread 1 Group 3 Seq 9912 Reading mem 0
ksh: Recovery: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>----- Recovery Hash Table Statistics ---------
ksh: -----: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Hash table buckets = 32768
ksh: Hash: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Longest hash chain = 1
ksh: Longest: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Average hash chain = 3/3 = 1.0
ksh: Average: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Max compares per lookup = 1
ksh: Max: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Avg compares per lookup = 97/97 = 1.0
ksh: Avg: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>----------------------------------------------
ksh: ----------------------------------------------: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>*** 2007-01-03 10:47:33.924
ksh: ar314t_ora_2628.trc: cannot execute
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>ksedmp: internal or fatal error
ksh: ksedmp:: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [1], [1], [4000], [0], []
ksh: ORA-00600:: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>Current SQL statement for this session:
ksh: Current: not found
[teaubkp01]:/oracle92/oracle/admin/AR314T/udump>select value$ from sys.props$ where name = :1
ksh: syntax error: `from' unexpected
|
|
|
|
|
|