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\newA LRT.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_siz e = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = e:\ORacle\orada ta\new\control0 1.ctl,
e:\ORacle\orada ta\new\control0 2.ctl,
e:\ORacle\orada ta\new\control0 3.ctl
db_block_buffer s = 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_multibl ock_read_count= 8
max_enabled_rol es = 30
remote_login_pa sswordfile= EXCLUSIVE
global_names = TRUE
distributed_tra nsactions = 500
instance_name = new
service_names = new
mts_dispatchers =
(PROTOCOL=TCP)( PRE=oracle.auro ra.server.SGiop Server)
open_links = 4
sort_area_size = 65536
sort_area_retai ned_size = 65536
db_name = new
open_cursors = 100
os_authent_pref ix =
job_queue_proce sses = 0
job_queue_inter val = 10
parallel_max_se rvers = 5
background_dump _dest = e:\ORacle\admin \new\bdump
user_dump_dest = e:\ORacle\admin \new\udump
max_dump_file_s ize = 10240
oracle_trace_co llection_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=(PART IAL=YES)(PROTOC OL=TCP))'...
Tue Sep 09 10:45:58 2003
create controlfile reuse set database new
datafile 'e:\ORacle\orad ata\new\system0 1.dbf',
'e:\ORacle\orad ata\new\temp01. dbf',
'e:\ORacle\orad ata\new\rbs01.d bf',
'e:\ORacle\orad ata\new\indx01. dbf',
'e:\ORacle\orad ata\new\tools01 .dbf',
'e:\ORacle\orad ata\new\dr01.db f',
'e:\ORacle\orad ata\new\users01 .dbf'
logfile 'e:\ORacle\orad ata\new\redo01. log' size 1M,
'e:\ORacle\orad ata\new\redo02. log' size 1M,
'e:\ORacle\orad ata\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_siz e = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = e:\ORacle\orada ta\new\control0 1.ctl,
e:\ORacle\orada ta\new\control0 2.ctl,
e:\ORacle\orada ta\new\control0 3.ctl
db_block_buffer s = 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_multibl ock_read_count= 8
max_enabled_rol es = 30
remote_login_pa sswordfile= EXCLUSIVE
global_names = TRUE
distributed_tra nsactions = 500
instance_name = new
service_names = new
mts_dispatchers =
(PROTOCOL=TCP)( PRE=oracle.auro ra.server.SGiop Server)
open_links = 4
sort_area_size = 65536
sort_area_retai ned_size = 65536
db_name = new
open_cursors = 100
os_authent_pref ix =
job_queue_proce sses = 4
job_queue_inter val = 10
parallel_max_se rvers = 5
background_dump _dest = e:\ORacle\admin \new\bdump
user_dump_dest = e:\ORacle\admin \new\udump
max_dump_file_s ize = 10240
oracle_trace_co llection_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=(PART IAL=YES)(PROTOC OL=TCP))'...
Tue Sep 09 10:46:31 2003
alter database mount
Tue Sep 09 10:46:34 2003
ORA-00202: controlfile: 'e:\ORacle\orad ata\new\control 01.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\newA LRT.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_siz e = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = e:\ORacle\orada ta\new\control0 1.ctl,
e:\ORacle\orada ta\new\control0 2.ctl,
e:\ORacle\orada ta\new\control0 3.ctl
db_block_buffer s = 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_multibl ock_read_count= 8
max_enabled_rol es = 30
remote_login_pa sswordfile= EXCLUSIVE
global_names = TRUE
distributed_tra nsactions = 500
instance_name = new
service_names = new
mts_dispatchers =
(PROTOCOL=TCP)( PRE=oracle.auro ra.server.SGiop Server)
open_links = 4
sort_area_size = 65536
sort_area_retai ned_size = 65536
db_name = new
open_cursors = 100
os_authent_pref ix =
job_queue_proce sses = 4
job_queue_inter val = 10
parallel_max_se rvers = 5
background_dump _dest = e:\ORacle\admin \new\bdump
user_dump_dest = e:\ORacle\admin \new\udump
max_dump_file_s ize = 10240
oracle_trace_co llection_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=(PART IAL=YES)(PROTOC OL=TCP))'...
Tue Sep 09 11:18:58 2003
alter database mount exclusive
Tue Sep 09 11:19:01 2003
ORA-00202: controlfile: 'e:\ORacle\orad ata\new\control 01.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\newA LRT.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_siz e = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = e:\ORacle\orada ta\new\control0 1.ctl,
e:\ORacle\orada ta\new\control0 2.ctl,
e:\ORacle\orada ta\new\control0 3.ctl
db_block_buffer s = 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_multibl ock_read_count= 8
max_enabled_rol es = 30
remote_login_pa sswordfile= EXCLUSIVE
global_names = TRUE
distributed_tra nsactions = 500
instance_name = new
service_names = new
mts_dispatchers =
(PROTOCOL=TCP)( PRE=oracle.auro ra.server.SGiop Server)
open_links = 4
sort_area_size = 65536
sort_area_retai ned_size = 65536
db_name = new
open_cursors = 100
os_authent_pref ix =
job_queue_proce sses = 4
job_queue_inter val = 10
parallel_max_se rvers = 5
background_dump _dest = e:\ORacle\admin \new\bdump
user_dump_dest = e:\ORacle\admin \new\udump
max_dump_file_s ize = 10240
oracle_trace_co llection_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=(PART IAL=YES)(PROTOC OL=TCP))'...
Tue Sep 09 11:22:16 2003
alter database mount exclusive
Tue Sep 09 11:22:19 2003
ORA-00202: controlfile: 'e:\ORacle\orad ata\new\control 01.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.