Re: error 600 with oracle 8.1.7 for linux

Did you follow the upgrade instructions? Often, 2114 is associated with upgrades failing to upgrade the control file correctly. I suspect that you might need to recreate them.

Andy
<ellisjb_at_my-deja.com> wrote in message news:91bai9$cbo$1_at_nnrp1.deja.com...
> I'm trying to upgrade from 8.0.5.1. I get through the installation OK,
> but when I try to startup from svrmgrl, I get
>
> SVRMGR> startup restrict
> ORACLE instance started.
> Total System Global Area 125517984 bytes
> Fixed Size 73888 bytes
> Variable Size 72937472 bytes
> Database Buffers 52428800 bytes
> Redo Buffers 77824 bytes
> ORA-03113: end-of-file on communication channel
>
> I checked the alert log, and found an error 600 but nothing else that
> means anything to me:
>
> Thu Dec 14 15:39:58 2000
> 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 = 50
> shared_pool_size = 50000000
> control_files
> = /disk/oracle/oradata1/advocast/control01.ctl, /usr/oracle/oradata2/adv
> ocast/control02.ctl
> db_block_buffers = 12800
> db_block_size = 4096
> compatible = 8.0.5.1.0, 8.0.5.1.0, 8.0.5.1.0,
> 8.0.5.1.0, 8.0.5.1.0
> log_buffer = 32768
> log_checkpoint_interval = 9999999
> db_files = 20
> db_file_multiblock_read_count= 8
> dml_locks = 100
> rollback_segments = r01, r02, r03, r04
> db_domain = world
> sort_area_size = 65536
> sort_area_retained_size = 65536
> db_name = advocast
> ifile
> = /disk/oracle/app/oracle/admin/advocast/pfile/configadvocast.ora
> background_dump_dest
> = /disk/oracle/app/oracle/admin/advocast/bdump
> user_dump_dest
> = /disk/oracle/app/oracle/admin/advocast/udump
> max_dump_file_size = 10240
> core_dump_dest
> = /disk/oracle/app/oracle/admin/advocast/cdump
> PMON started with pid=2
> Load Indicator not supported by OS !
> DBW0 started with pid=3
> LGWR started with pid=4
> CKPT started with pid=5
> SMON started with pid=6
> Thu Dec 14 15:39:58 2000
> alter database mount
> Thu Dec 14 15:39:58 2000
> Errors in
> file /disk/oracle/app/oracle/admin/advocast/bdump/ckpt_31630.trc:
> ORA-00600: internal error code, arguments: [2114], [13], [752], [736],
> [], [], [], []
> RECO started with pid=7
> Thu Dec 14 15:39:59 2000
> CKPT: terminating instance due to error 600
> Instance terminated by CKPT, pid = 31630
>
> I'm running RH 6.2 with kernel 2.2.16 with the suggested mods to
> shmparam.h and sem.h. 256MB RAM and 450 MB swap so I should be okay
> there, too. Any clues?
>
> -Jonathan
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Dec 15 2000 - 08:04:24 CST