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]

rvarman,

I was just sending the instructions how to do it but anyway that is good that you did all this quickly

I am glad that it is over. So in conclusion it was a hardware problem?

Good luck and do not forget to turn on archiving in your database if you have not done so.

 

[rvarman]

sybaseguru,

achriving -> you mean backup
or how to enable it?

regards

 

[sybaseguru]

rvarman,

must have been a long day for you:
To turn on archving you need to put database in archivelog mode. This will cause oracle to create archived redo logs, which are backups of each online redo log, stored in one or more archive log directories. These are essential for point in time recovery of your database since the cold backup (i.e. you are backing up your transaction logs from Sybase or SQL Server terminology)

Do this as sys in oracle

SELECT log_mode FROM v$database;

If log_mode = noarchivelog then you need to turn on archving. Add this to your init file
log_archive_start=true
log_archive_dest=<A directory for archiving>
log_archive_format=&quot;ARCH%S.LOG&quot;
- shutdown the database
- startup mount
- alter database archivelog;
-alter database open;
-archive log list;
to verify the files are written to the directory
-alter system switch logfile;
Go to the archive directory (as specified in your init file) and check that log is written

I need a big star after all this help! good luck