URGENT!!!!! Oracle internal error 4194 1

[rvarman]

hi all,

i've a big problem. i'un unable to start oracle.

1) svrmgrl
2) connect internal
3) startup

by executing startup, the instance and database are mounted.
but i get a message:


Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORACLE instance started.
Total System Global Area 189464736 bytes
Fixed Size 73888 bytes
Variable Size 31924224 bytes
Database Buffers 157286400 bytes
Redo Buffers 180224 bytes
Database mounted.
ORA-00600: internal error code, arguments: [4194], [1], [23], [], [], [], [], []
SVRMGR>

it is very urgent, could you please give me your ideas.

 

[sybaseguru]

Hi rvarman,

Appears that Oracle did something strange. You should look in the Oracle alert log for more details about the error and for the name of the Oracle trace files that can provide more information. What O/s are you running your Oracle on Windows?

 

[sybaseguru]

Hi again,

rvarman, ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software. It is different from other Oracle errors in many ways in that each ORA-600 error comes with a list of arguments. They usually enclosed in square brackets and follow the error on the same line for example:

ORA-00600 [14000][51202][1][51200][][]

Each argument has a specific meaning which can only be interpreted by an Oracle support I believe because I do not think you can find help text for these errors. Also each ORA-600 error generates a database trace file.

Possible causes include 
time-outs, 
file corruption, 
failed data checks in memory, hardware, memory, or I/O messages, 
incorrectly restored files

good luck

 

[rvarman]

oracle 8.1.7 en sun 5.8
could you tell me where to see for the alert logs?


TNSLSNR for Solaris: Version 8.1.7.0.0 - Production on 23-JUL-2003 10:13:45

(c) Copyright 1998 Oracle Corporation. All rights reserved.

System parameter file is /users/oracle817/OraHome1/network/admin/listener.ora
Log messages written to /users/oracle817/OraHome1/network/log/listener.log
Trace information written to /users/oracle817/OraHome1/network/trace/listener.trc
Trace level is currently 0

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blade)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=blade)(PORT=2481))(PROTOCOL_STACK=(PRESENTATION=GIOP)(SESSION=RAW)))
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
23-JUL-2003 10:13:45 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=blade)(USER=vivaks))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSI
ON=135294976)) * status * 0
23-JUL-2003 10:13:55 * (CONNECT_DATA=(SERVICE_NAME=vivaID)(CID=(PROGRAM=)(HOST=blade)(USER=vivaks))) * (ADDRESS=(PROTOCOL=tcp)(HOST=
192.168.173.60)(PORT=32835)) * establish * vivaID * 0
2

 

[sybaseguru]

Look at the init.ora parameter file normally under $ORACLE_HOME/dbs. It should say among others
background_dump_dest='/u001/oracle/admin/mydb/bdump'
core_dump_dest='/u001/oracle/admin/mydb/cdump'
user_dump_dest='/u001/oracle/admin/mydb/udump'
Go to "background_dump_dest" and do
ls -t|head -1
and this will pickup a file called like &quot;alert_<SID>.log&quot;. do a tail on this file (tail -200 etc) and see what errors you are seeing!

 

[rvarman]

alert_vivaID.log

ORA-600 signalled during: alter database open ...
Wed Jul 23 12:32:59 2003
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 5000000
large_pool_size = 614400
java_pool_size = 20971520
control_files = /data/oracle/oradata/viva/oradata/vivaID/control01.ctl, /data/oracle/oradata/viva/oradata/vivaID/contro
l02.ctl, /data/oracle/oradata/viva/oradata/vivaID/control03.ctl
db_block_buffers = 19200
db_block_size = 8192
compatible = 8.1.0
log_buffer = 163840
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
distributed_transactions = 10
instance_name = vivaID
service_names = vivaID
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = vivaID
open_cursors = 300
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 60
background_dump_dest = /users/oracle817/OraHome1/admin/vivaID/bdump
user_dump_dest = /users/oracle817/OraHome1/admin/vivaID/udump
core_dump_dest = /users/oracle817/OraHome1/admin/vivaID/cdump
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Jul 23 12:33:01 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jul 23 12:33:01 2003
alter database mount
Wed Jul 23 12:33:08 2003
Successful mount of redo thread 1, with mount id 2678658820.
Wed Jul 23 12:33:08 2003
Database mounted in Exclusive Mode.
Completed: alter database mount
Wed Jul 23 12:33:08 2003
alter database open
Beginning crash recovery of 1 threads
Wed Jul 23 12:33:08 2003
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 2 Seq 2282 Reading mem 0
Mem# 0 errs 0: /data/oracle/oradata/viva/oradata/vivaID/redo02.log
Wed Jul 23 12:33:08 2003
Thread recovery: finish rolling forward thread 1
Thread recovery: 0 data blocks read, 0 data blocks written, 2 redo blocks read
Crash recovery completed successfully
Wed Jul 23 12:33:09 2003
Thread 1 advanced to log sequence 2283
Thread 1 opened at log sequence 2283
Current log# 3 seq# 2283 mem# 0: /data/oracle/oradata/viva/oradata/vivaID/redo01.log
Successful open of redo thread 1.
Wed Jul 23 12:33:09 2003
SMON: enabling cache recovery
Wed Jul 23 12:33:10 2003
Errors in file /users/oracle817/OraHome1/admin/vivaID/udump/vivaid_ora_18237.trc:
ORA-00600: internal error code, arguments: [4194], [1], [23], [], [], [], [], []
Wed Jul 23 12:33:12 2003
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2283 Reading mem 0
Mem# 0 errs 0: /data/oracle/oradata/viva/oradata/vivaID/redo01.log
Wed Jul 23 12:33:12 2003
SMON: disabling cache recovery
Wed Jul 23 12:33:12 2003
ORA-600 signalled during: alter database open ...

 

[sybaseguru]

Ok what file /users/oracle817/OraHome1/admin/vivaID/udump/vivaid_ora_18237.trc is saying

 

[rvarman]

(root@blade /users/oracle817/OraHome1/admin/vivaID/bdump)more /users/oracle817/OraHome1/admin/vivaID/udump/vivaid_ora_18237.trc
/users/oracle817/OraHome1/admin/vivaID/udump/vivaid_ora_18237.trc
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
ORACLE_HOME = /users/oracle817/OraHome1
System name: SunOS
Node name: blade
Release: 5.8
Version: Generic_108528-13
Machine: sun4u
Instance name: vivaID
Redo thread mounted by this instance: 1
Oracle process number: 14
Unix process pid: 18237, image: oracle@blade

*** SESSION ID11.1) 2003-07-23 12:33:10.427
*** 2003-07-23 12:33:10.427
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4194], [1], [23], [], [], [], [], []
Current SQL statement for this session:
update undo$ set name=:2,file#=:3,block#=:4,status$=:5,user#=:6,undosqn=:7,xactsqn=:8,scnbas=:9,scnwrp=:10,inst#=:11,ts#=:12 where u
s#=:1

 

[sybaseguru]

rvarman,

Did you shutdown this server with shutdown abort by any chance? It seems that it has a problem with recovery most probably due to failed data/log checks in memory. Is H/W OK?. The numbers in ORA-00600: internal error code, arguments: [4194], [1], [23], [], [], [], [], []
mean something to Oracle support. Do you have support from Oracle?

 

[rvarman]

no, i don't have the oracle support.
That is the problem.
I'm in deep trouble to reconstruct oracle.

The server shuts down itself twice a day (yesterday and today)
just announcing that the machine is going down.

 

[stefanhei]

I've no experience using solaris, but did you by any chance try to start your instance under root-account (unless you installed it using root)?

 

[sybaseguru]

That may be a valid point. rvarman you are using &quot;root@blade&quot; account. Can you su - oracle or look at /etc/password file to see the oracle account?

 

[rvarman]

i do always start oracle with a user in the dba group.

 

[sybaseguru]

rvarman,

Ok fine. what is the situation at the moment. Is this a production database? Are you more like a UNIX SA as opposed to dba (no offence) and also what is the situation with H/W is it running OK!

 

[rvarman]

it is a developpement platform (small office) where four people are developping.
i'm new and alone (not an expert in unix and oracle) in this office, in charge of everything.

Two disks are in disksuite mirroring which i suppose to give problem. i'm dealing in parallel with sun support to work out the problem.
Anyhow i suppose that one of the files shd be corrupted.
i've a backup copy. when i trace the corupted file, i'll try to repalce with the backup copy.

regards

 

[rvarman]

i've restored the /users/oracle817/OraHome1 ($ORACLE_HOME)
i get an error.
I've to redirect the data.dbf file in the oracle config file.
i've done it once but i don't know where it is .

(vivaks@blade ~/oracle)startOracle.sh

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.
Total System Global Area 217637024 bytes
Fixed Size 73888 bytes
Variable Size 79044608 bytes
Database Buffers 138338304 bytes
Redo Buffers 180224 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/data/oracle/oradata/viva/DATA.dbf'
SVRMGR> Server Manager complete.

could you plase tell me in which file it is referenced?


regards
rvarman

 

[sybaseguru]

Go and have a look at the alert_viva.log file to see what it says. The problem is the file
ORA-01157: cannot identify/lock data file 7 - see DBWR trace file
ORA-01110: data file 7: '/data/oracle/oradata/viva/DATA.dbf'
where is it? Also in the same directory there should be a trace file with viva_dbwr.trc. send the output

 

[rvarman]

i know wher is DATA.dbf'
but i want the file where i can point to this file

 

[sybaseguru]

rvarman,

The trace file and log file will give the clue. Have you checked them?

 

[rvarman]

Thank you all,

finaly i've solved the pb.
i've restored the $ORACLE_HOME directory,
dropped and recreated the database DATA and Tablespace DATA,
imported the different bases from the backed up export files.

Now, oracle is starting well without any problem.

but it reamins another one pb concerning the disksuite mirroring.
one of the metadevices is corrupt and i'm dealing with SUN to change the phycial disk.

Thanks to all.