control file not created at the time of installation

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • KULJEET
    #1

    control file not created at the time of installation

    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.
    Tags: None
    • osy45
      #2
      Re: control file not created at the time of installation


      does the path e:\ORacle\orada ta\new\ exist ?

      the fully qualified path must be available before using it ...


      --
      Posted via http://dbforums.com

        Comment

        • Daniel Roy
          #3
          Re: control file not created at the time of installation

          Try:

          1- Shutdown
          2- Rename or delete the existing control files
          3- startup nomount
          4-

          create controlfile 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

          (note that in your case you should not use "reuse" and "resetlogs" ).

          5- Alter database open.

          HTH

          Daniel

            Comment

            Previous template Next
            Working...