control file not created at the time of installation

From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 9 Sep 2003 23:35:45 -0700
Message-ID: <febbed51.0309092235.3e089786_at_posting.google.com>

control file not created at time of installtion of oracle database

now how we can create it

see alert file
Dump file e:\ORacle\admin\new\bdump\newALRT.LOG Tue Sep 09 10:45:53 2003
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0. System parameters with non-default values:

  processes                = 59
  shared_pool_size         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = e:\ORacle\oradata\new\control01.ctl,

e:\ORacle\oradata\new\control02.ctl,
e:\ORacle\oradata\new\control03.ctl

  db_block_buffers         = 19200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  global_names             = TRUE
  distributed_transactions = 500
  instance_name            = new
  service_names            = new
  mts_dispatchers          =
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = new
  open_cursors             = 100
  os_authent_prefix        = 
  job_queue_processes      = 0
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = e:\ORacle\admin\new\bdump
  user_dump_dest           = e:\ORacle\admin\new\udump
  max_dump_file_size       = 10240

oracle_trace_collection_name=

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

Tue Sep 09 10:45:55 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 09 10:45:58 2003
create controlfile reuse set database new datafile 'e:\ORacle\oradata\new\system01.dbf',
'e:\ORacle\oradata\new\temp01.dbf',
'e:\ORacle\oradata\new\rbs01.dbf',
'e:\ORacle\oradata\new\indx01.dbf',
'e:\ORacle\oradata\new\tools01.dbf',
'e:\ORacle\oradata\new\dr01.dbf',
'e:\ORacle\oradata\new\users01.dbf'

logfile 'e:\ORacle\oradata\new\redo01.log' size 1M,

'e:\ORacle\oradata\new\redo02.log' size 1M,
'e:\ORacle\oradata\new\redo03.log' size 1M resetlogs
Tue Sep 09 10:46:03 2003
ORA-1503 signalled during: create controlfile reuse set database new datafile...
Tue Sep 09 10:46:03 2003
alter database new open resetlogs
ORA-1507 signalled during: alter database new open resetlogs... Tue Sep 09 10:46:14 2003
alter database new character set WE8ISO8859P1 Tue Sep 09 10:46:14 2003
ORA-1507 signalled during: alter database new character set WE8ISO8859P1...
Tue Sep 09 10:46:14 2003
alter database new national character set WE8ISO8859P1 ORA-1507 signalled during: alter database new national character set WE8ISO88...
Shutting down instance (normal)
License high water mark = 1
Tue Sep 09 10:46:15 2003
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL... archiving is disabled
Starting up ORACLE RDBMS Version: 8.1.6.0.0. System parameters with non-default values:

  processes                = 59
  shared_pool_size         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = e:\ORacle\oradata\new\control01.ctl,

e:\ORacle\oradata\new\control02.ctl,
e:\ORacle\oradata\new\control03.ctl

  db_block_buffers         = 19200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  global_names             = TRUE
  distributed_transactions = 500
  instance_name            = new
  service_names            = new
  mts_dispatchers          =
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = new
  open_cursors             = 100
  os_authent_prefix        = 
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = e:\ORacle\admin\new\bdump
  user_dump_dest           = e:\ORacle\admin\new\udump
  max_dump_file_size       = 10240

oracle_trace_collection_name=

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

Tue Sep 09 10:46:30 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 09 10:46:31 2003
alter database mount
Tue Sep 09 10:46:34 2003

ORA-00202: controlfile: 'e:\ORacle\oradata\new\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Sep 09 10:46:34 2003
ORA-205 signalled during: alter database mount... Dump file e:\ORacle\admin\new\bdump\newALRT.LOG Tue Sep 09 11:18:54 2003
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0. System parameters with non-default values:

  processes                = 59
  shared_pool_size         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = e:\ORacle\oradata\new\control01.ctl,

e:\ORacle\oradata\new\control02.ctl,
e:\ORacle\oradata\new\control03.ctl

  db_block_buffers         = 19200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  global_names             = TRUE
  distributed_transactions = 500
  instance_name            = new
  service_names            = new
  mts_dispatchers          =
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = new
  open_cursors             = 100
  os_authent_prefix        = 
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = e:\ORacle\admin\new\bdump
  user_dump_dest           = e:\ORacle\admin\new\udump
  max_dump_file_size       = 10240

oracle_trace_collection_name=

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

Tue Sep 09 11:18:57 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 09 11:18:58 2003
alter database mount exclusive
Tue Sep 09 11:19:01 2003

ORA-00202: controlfile: 'e:\ORacle\oradata\new\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Tue Sep 09 11:19:01 2003
ORA-205 signalled during: alter database mount exclusive... Shutting down instance (abort)
License high water mark = 5
Instance terminated by USER, pid = 1156
Dump file e:\ORacle\admin\new\bdump\newALRT.LOG Tue Sep 09 11:22:12 2003
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 , CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0. System parameters with non-default values:

  processes                = 59
  shared_pool_size         = 52428800
  large_pool_size          = 614400
  java_pool_size           = 20971520
  control_files            = e:\ORacle\oradata\new\control01.ctl,

e:\ORacle\oradata\new\control02.ctl,
e:\ORacle\oradata\new\control03.ctl

  db_block_buffers         = 19200
  db_block_size            = 8192
  compatible               = 8.1.0
  log_buffer               = 32768
  log_checkpoint_interval  = 10000
  log_checkpoint_timeout   = 1800
  db_files                 = 1024
  db_file_multiblock_read_count= 8
  max_enabled_roles        = 30
  remote_login_passwordfile= EXCLUSIVE
  global_names             = TRUE
  distributed_transactions = 500
  instance_name            = new
  service_names            = new
  mts_dispatchers          =
(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
  open_links               = 4
  sort_area_size           = 65536
  sort_area_retained_size  = 65536
  db_name                  = new
  open_cursors             = 100
  os_authent_prefix        = 
  job_queue_processes      = 4
  job_queue_interval       = 10
  parallel_max_servers     = 5
  background_dump_dest     = e:\ORacle\admin\new\bdump
  user_dump_dest           = e:\ORacle\admin\new\udump
  max_dump_file_size       = 10240

oracle_trace_collection_name=

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

Tue Sep 09 11:22:15 2003
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Sep 09 11:22:16 2003
alter database mount exclusive
Tue Sep 09 11:22:19 2003

ORA-00202: controlfile: 'e:\ORacle\oradata\new\control01.ctl'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Received on Wed Sep 10 2003 - 08:35:45 CEST

This message: [ Message body ]
Next message: Pascal: "number defined being truncated in select (sorry double posting ;-( )"
Previous message: Erohsik: "external table"
In reply to Daniel Roy: "Re: control file not created at the time of installation"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message