ORA-1157, 0RA-01034 ORACLE NOT FOUND

From: john.connors <john.connors_at_virgin.net>
Date: 2000/08/13
Message-ID: <3996573E.3C73@virgin.net>#1/1

On trying to open oracle 8.04 Personal edition on win 98, I get the following sequence:

ORA-1157 CANNOT OPEN DATABASE; ORA-01034 ORACLE NOT FOUND; i HAVE LOCATED AN ALRT FILE WHICH POINTS TO THE OFFENDING FILE , I THINK: 'T_TEST', AND HAVE FOUND THE FILE MENTIONED AS IN LOG BELOW. EXCUSE THE NAIVE QUESTION , WHAT DO I DO NEXT ? I AM STILL PUTTING MY L-PLATES ON.
THANS IN ADVANCE, JOHN
ORA-1157 signalled during: alter database open... Dump file C:\orawin95\RDBMS80\trace\orclALRT.LOG Mon Aug 07 21:07:20 2000
ORACLE V8.0.4.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows 95 V4.10, OS V192.0, CPU type 586 Starting up ORACLE RDBMS Version: 8.0.4.0.0. System parameters with non-default values:

  processes                = 50

  shared_pool_size         = 3500000

  disk_asynch_io           = FALSE

  control_files            = C:\orawin95\DATABASE\ctl1orcl.ora

  db_block_buffers         = 200

  db_block_size            = 2048

  log_buffer               = 8192

log_checkpoint_interval = 10000

  db_files                 = 1024

db_file_multiblock_read_count= 8

sequence_cache_entries = 10

sequence_cache_hash_buckets= 10

remote_login_passwordfile= SHARED

global_names = TRUE

  db_name                  = oracle

  job_queue_processes      = 2

  parallel_max_servers     = 5

  background_dump_dest     = %RDBMS80%\trace

  user_dump_dest           = %RDBMS80%\trace

  max_dump_file_size       = 10240

Mon Aug 07 21:07:20 2000

PMON started with pid=2
Mon Aug 07 21:07:20 2000

DBW0 started with pid=3
Mon Aug 07 21:07:20 2000

LGWR started with pid=4
Mon Aug 07 21:07:20 2000

CKPT started with pid=5
Mon Aug 07 21:07:20 2000

SMON started with pid=6
Mon Aug 07 21:07:20 2000

RECO started with pid=7
Mon Aug 07 21:07:20 2000

SNP0 started with pid=8
Mon Aug 07 21:07:20 2000

SNP1 started with pid=9
Mon Aug 07 21:07:20 2000
ALTER DATABASE MOUNT EXCLUSIVE
Mon Aug 07 21:07:20 2000
Successful mount of redo thread 1.
Mon Aug 07 21:07:20 2000
Completed: ALTER DATABASE MOUNT EXCLUSIVE Mon Aug 07 21:07:20 2000
alter database open
Mon Aug 07 21:07:20 2000
Errors in file C:\orawin95\RDBMS80\trace\orclDBW0.TRC:

ORA-01157: cannot identify data file 5 - file not found
ORA-01110: data file 5: 'T_TEST'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-1157 signalled during: alter database open... Dump file C:\orawin95\RDBMS80\trace\orclALRT.LOG Mon Aug 07 21:07:59 2000
ORACLE V8.0.4.0.0 - Production vsnsta=0
vsnsql=c vsnxtr=3
Windows 95 V4.10, OS V192.0, CPU type 586 Starting up ORACLE RDBMS Version: 8.0.4.0.0. System parameters with non-default values:

  processes                = 50

  shared_pool_size         = 3500000

  disk_asynch_io           = FALSE

  control_files            = C:\orawin95\DATABASE\ctl1orcl.ora

  db_block_buffers         = 200

  db_block_size            = 2048

  log_buffer               = 8192

log_checkpoint_interval = 10000

  db_files                 = 1024

db_file_multiblock_read_count= 8

sequence_cache_entries = 10

sequence_cache_hash_buckets= 10

remote_login_passwordfile= SHARED

global_names = TRUE

  db_name                  = oracle

  job_queue_processes      = 2

  parallel_max_servers     = 5

  background_dump_dest     = %RDBMS80%\trace

  user_dump_dest           = %RDBMS80%\trace

  max_dump_file_size       = 10240

Mon Aug 07 21:07:59 2000

PMON started with pid=2
Mon Aug 07 21:07:59 2000

DBW0 started with pid=3
Mon Aug 07 21:07:59 2000

LGWR started with pid=4
Mon Aug 07 21:08:00 2000

CKPT started with pid=5
Mon Aug 07 21:08:00 2000

SMON started with pid=6
Mon Aug 07 21:08:00 2000

RECO started with pid=7
Mon Aug 07 21:08:00 2000

SNP0 started with pid=8
Mon Aug 07 21:08:00 2000

SNP1 started with pid=9
Mon Aug 07 21:08:00 2000
ALTER DATABASE MOUNT EXCLUSIVE
Mon Aug 07 21:08:00 2000
Successful mount of redo thread 1.
Mon Aug 07 21:08:00 2000
Completed: ALTER DATABASE MOUNT EXCLUSIVE Mon Aug 07 21:08:00 2000
alter database open
Mon Aug 07 21:08:00 2000
Errors in file C:\orawin95\RDBMS80\trace\orclDBW0.TRC:

ORA-01157: cannot identify data file 5 - file not found
ORA-01110: data file 5: 'T_TEST'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

ORA-1157 signalled during: alter database open... Received on Sun Aug 13 2000 - 00:00:00 CDT