Results 1 to 8 of 8
  1. #1
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139

    Unanswered: controfile were not installed

    Hi,

    Something strange is happening. I have had to install Oracle8i twice, but still get the same problem. Towards the end of the installation, a message comes up stating that "it cannot connect to oracle". The result is that my controlfiles are not created but the *.dbf files are there. So I complete the installation, start the listener and connect as internal. I connect to an idle instance. I then type this command and get the error at the bottom. Can you tell me how I can solve this and open the DB?

    SQL> startup nomount pfile='/export/home/oracle/admin/rich/pfile/initrich.ora'
    ORACLE instance started.

    Total System Global Area 80797856 bytes
    Fixed Size 73888 bytes
    Variable Size 30507008 bytes
    Database Buffers 50036736 bytes
    Redo Buffers 180224 bytes
    SQL> CREATE CONTROLFILE DATABASE "rich" RESETLOGS ARCHIVELOG
    2 MAXLOGFILES 32
    3 MAXLOGMEMBERS 2
    4 MAXDATAFILES 32
    5 MAXINSTANCES 16
    6 MAXLOGHISTORY 1815
    7 LOGFILE
    8 GROUP 1 '/export/home/oracle/oradata/rich/REDO03.LOG' SIZE 1M,
    9 GROUP 2 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M,
    10 GROUP 3 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M
    11 DATAFILE
    12 '/export/home/oracle/oradata/rich/system02.DBF' REUSE,
    13 '/export/home/oracle/oradata/rich/rbs02.DBF' REUSE,
    14 '/export/home/oracle/oradata/rich/temp02.DBF' REUSE,
    15 '/export/home/oracle/oradata/rich/tools02.DBF' REUSE,
    16 '/export/home/oracle/oradata/rich/indx02.DBF' REUSE,
    17 '/export/home/oracle/oradata/rich/users02.DBF' REUSE,
    18 '/export/home/oracle/oradata/rich/drsys02.DBF' REUSE
    19 CHARACTER SET WE8ISO8859P1
    20 ;
    CREATE CONTROLFILE DATABASE "rich" RESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file
    '/export/home/oracle/oradata/rich/system02.DBF'
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    Additional information: 3


    SQL> quit
    Disconnected

    Just in case you wanted to know if they were there.


    Alex:/export/home/oracle/oradata/rich # > ls
    drsys01.dbf rbs01.dbf temp01.dbf users01.dbf
    indx01.dbf system01.dbf tools01.dbf
    Alex:/export/home/oracle/oradata/rich # >

  2. #2
    Join Date
    Apr 2003
    Location
    Bahrain
    Posts
    11
    Hi,
    Really it is strange!

    Did u try

    startup mount;

    What is the output?

    Heber

  3. #3
    Join Date
    Sep 2002
    Location
    NJ
    Posts
    139
    startup mount won't work without the controlfile already in place. The controlfile don't exist.

  4. #4
    Join Date
    Oct 2002
    Location
    Plymouth UK
    Posts
    116
    The DATAFILE part refers to files with the *02 e.g. system02.dbf.

    The ls of the directory returned a list of similar files with *01 e.g. system01.dbf.

    It appears that the Oracle processes cannot the see the files expected (from error codes returned), and from your view of the directory it seems that they are not there. It looks to me like there is a problem with the numbering.

  5. #5
    Join Date
    Mar 2003
    Posts
    45
    Thanks, that was a stupid error of my part. However, I get this error when I correct it.

    SQL> CREATE CONTROLFILE DATABASE "rich" RESETLOGS ARCHIVELOG
    2 MAXLOGFILES 32
    3 MAXLOGMEMBERS 2
    4 MAXDATAFILES 32
    5 MAXINSTANCES 16
    6 MAXLOGHISTORY 1815
    7 LOGFILE
    8 GROUP 1 '/export/home/oracle/oradata/rich/REDO03.LOG' SIZE 1M,
    9 GROUP 2 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M,
    10 GROUP 3 '/export/home/oracle/oradata/rich/REDO02.LOG' SIZE 1M
    11 DATAFILE
    12 '/export/home/oracle/oradata/rich/system01.DBF' REUSE,
    13 '/export/home/oracle/oradata/rich/rbs01.DBF' REUSE,
    14 '/export/home/oracle/oradata/rich/temp01.DBF' REUSE,
    15 '/export/home/oracle/oradata/rich/tools01.DBF' REUSE,
    16 '/export/home/oracle/oradata/rich/indx01.DBF' REUSE,
    17 '/export/home/oracle/oradata/rich/users01.DBF' REUSE,
    18 '/export/home/oracle/oradata/rich/drsys01.DBF' REUSE
    19 CHARACTER SET WE8ISO8859P1
    20 ;
    CREATE CONTROLFILE DATABASE "rich" RESETLOGS ARCHIVELOG
    *
    ERROR at line 1:
    ORA-01503: CREATE CONTROLFILE failed
    ORA-01565: error in identifying file
    '/export/home/oracle/oradata/rich/system01.DBF'
    ORA-27037: unable to obtain file status
    SVR4 Error: 2: No such file or directory
    Additional information: 3

  6. #6
    Join Date
    Oct 2002
    Location
    Plymouth UK
    Posts
    116
    Looks like some sort of file permissions problem. I am not that conversent with *nix error codes and low level stuff. A few suggestions:

    - make sure that you have permissions on the files
    - make sure you can see the directory and permissions
    - the files may be corrupt
    - the block size may be different (check the block size in your initrich.ora file is suitable for your operating system environment)

    Sorry I couldn't be more helpful.

  7. #7
    Join Date
    Mar 2003
    Posts
    45
    HI,

    here is my initrich.ora file. Can you determine if anything is wrong or off?


    db_name = "rich"
    instance_name = rich
    service_names = rich
    control_files = ("/export/home/oracle/oradata/rich/control01.ctl", "/export/home/oracle/oradata/rich/control02.ctl", "/export/home/oracle/oradata/rich/control03.ctl")
    open_cursors = 300
    max_enabled_roles = 30
    db_block_buffers = 6108
    shared_pool_size = 6147456
    #shared_pool_size = 31457280
    large_pool_size = 614400
    java_pool_size = 20971520
    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800
    processes = 100 # INITIAL
    log_buffer = 163840 # INITIAL
    background_dump_dest = /export/home/oracle/admin/rich/bdump
    core_dump_dest = /export/home/oracle/admin/rich/cdump
    user_dump_dest = /export/home/oracle/admin/rich/udump
    db_block_size = 8192
    remote_login_passwordfile = exclusive
    os_authent_prefix = ""
    job_queue_processes = 4
    job_queue_interval = 60
    distributed_transactions = 10
    open_links = 4
    mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServ er)"
    compatible = "8.1.0"
    sort_area_size = 65536
    sort_area_retained_size = 65536

    here is my Kernel settings

  8. #8
    Join Date
    Oct 2002
    Location
    Plymouth UK
    Posts
    116
    Seems OK. Check your operating system block size is 8k.

    You are using 3 control files. Multiple control files are a good policy in case of disc failure. If you have another drive put duplicates on this so that there are copies on several drives.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •