DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: ora 205 during 1st time Startup after Installation

  1. #1
    Join Date
    Oct 2006
    Posts
    5

    ora 205 during 1st time Startup after Installation

    Hi

    I am new to Oracle.

    I am trying to install Oracle 7.3.2 Workgroup Server Edition
    on SCO-UNIX Release 5.

    After the installation process got completed,

    1)I have made the necessary changes in listener.ora & tnsnames.ora.
    2)Have also added TWO_TASK & TNS_ADMIN environment variables.
    3)Listener is getting started normally.
    4)When I try to run svrmgrl,
    connect internal (does not ask for the "manager" password, which is

    weird), it gets connected.
    When I try to startup the database, it gives:

    ora 00205 error in identifying control file '?/dbs/cntrl@.dbf'
    ora 07360 sfifi stat error, unable to obtain information about file
    no such file or directory


    There is no such file in the said location.
    Now as I understand it, during the CD installation itself,
    Oracle has created the database.
    Then is it not but obvious that it should also create a control file??
    How do I get my database to startup & proceed with remaining steps??

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you actually created a database, are you sure there is one

  3. #3
    Join Date
    Oct 2006
    Posts
    5
    havent created database explicitly.
    but as a part of the CD Installation, I received a message saying DB Creation Successful

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    well check if there are database files created

  5. #5
    Join Date
    Oct 2006
    Posts
    5
    only the default ones are created like usersLIVE.dbf & toolsLIVE.dbf etc

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135

    I am trying to install Oracle 7.3.2 Workgroup Server Edition
    on SCO-UNIX Release 5.
    Oracle 7.3.2 ??

    Now 10g is available, why do you want to learn 15 years old tech, you will soon unlearn when you come to 10g.

    Tamil

  7. #7
    Join Date
    Oct 2006
    Posts
    5
    Guys.... i know the technology is old...

    but im stuck in a soup here...

    my client wants to restore an old application
    & get some history data

    & the clock is ticking...

    so plzzzz help me

  8. #8
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    The error message says clearly the control file does not exist in ./dbs/ dir.
    Cross check with init.ora file or config.ora file

    If you have backup control (ascii format) file, you can recreate it.

    Tamil

  9. #9
    Join Date
    Oct 2006
    Posts
    5
    Exactly, the controlfile does not exist.
    If Oracle created the database during CD Installation, shud a controlfile also not get created??

    Am pasting the initLIVE.ora below :

    #
    # $Header: initx.orc 1.1 95/02/27 12:14:56 wyim Osd $ Copyr (c) 1992 Oracle
    #

    db_name = oracle

    compatible = 7.3.2.0.0

    remote_login_passwordfile = exclusive

    rollback_segments = (r01,r02,r03,r04)

    # include async I/O configuration parameters, for Solaris Intel only
    #async_write = TRUE
    #async_read = TRUE
    #_lgwr_async_write = TRUE
    #use_ism = FALSE

    # include post-wait driver parameters, for UnixWare only
    #use_post_wait_driver = TRUE
    #post_wait_device = /dev/pw

    ##############################################################################
    # Example INIT.ORA file
    #
    # This file is provided by Oracle Corporation to help you customize
    # your RDBMS installation for your site. Important system parameters
    # are discussed, and example settings given.
    #
    # Some parameter settings are generic to any size installation.
    # For parameters that require different values in different size
    # installations, three scenarios have been provided: SMALL, MEDIUM
    # and LARGE. Any parameter that needs to be tuned according to
    # installation size will have three settings, each one commented
    # according to installation size.
    #
    # Use the following table to approximate the SGA size needed for the
    # three scenarious provided in this file:
    #
    # -------Installation/Database Size------
    # SMALL MEDIUM LARGE
    # Block 2K 4500K 6800K 17000K
    # Size 4K 5500K 8800K 21000K
    #
    # To set up a database that multiple instances will be using, place
    # all instance-specific parameters in one file, and then have all
    # of these files point to a master file using the IFILE command.
    # This way, when you change a public
    # parameter, it will automatically change on all instances. This is
    # necessary, since all instances must run with the same value for many
    # parameters. For example, if you choose to use private rollback segments,
    # these must be specified in different files, but since all gc_*
    # parameters must be the same on all instances, they should be in one file.
    #
    # INSTRUCTIONS: Edit this file and the other INIT files it calls for
    # your site, either by using the values provided here or by providing
    # your own. Then place an IFILE= line into each instance-specific
    # INIT file that points at this file.
    ###############################################################################

    # tuning parameters

    db_files = 20

    db_file_multiblock_read_count = 8 # SMALL
    # db_file_multiblock_read_count = 16 # MEDIUM
    # db_file_multiblock_read_count = 32 # LARGE

    db_block_buffers = 200 # SMALL
    # db_block_buffers = 550 # MEDIUM
    # db_block_buffers = 3200 # LARGE

    shared_pool_size = 3500000 # SMALL
    # shared_pool_size = 6000000 # MEDIUM
    # shared_pool_size = 9000000 # LARGE

    log_checkpoint_interval = 10000

    processes = 50 # SMALL
    # processes = 100 # MEDIUM
    # processes = 200 # LARGE

    dml_locks = 100 # SMALL
    # dml_locks = 200 # MEDIUM
    # dml_locks = 500 # LARGE

    log_buffer = 8192 # SMALL
    # log_buffer = 32768 # MEDIUM
    # log_buffer = 163840 # LARGE

    sequence_cache_entries = 10 # SMALL
    # sequence_cache_entries = 30 # MEDIUM
    # sequence_cache_entries = 100 # LARGE

    sequence_cache_hash_buckets = 10 # SMALL
    # sequence_cache_hash_buckets = 23 # MEDIUM
    # sequence_cache_hash_buckets = 89 # LARGE

    # audit_trail = true # if you want auditing
    # timed_statistics = true # if you want timed statistics
    max_dump_file_size = 10240 # limit trace file size to 5 Meg each

    # log_archive_start = true # if you want automatic archiving

    # global_names = TRUE

    What should be my course of action. Please help.
    Thanks :-)

  10. #10
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by anuttam_b
    Hi

    I am new to Oracle.

    I am trying to install Oracle 7.3.2 Workgroup Server Edition
    on SCO-UNIX Release 5.

    After the installation process got completed,

    1)I have made the necessary changes in listener.ora & tnsnames.ora.
    2)Have also added TWO_TASK & TNS_ADMIN environment variables.
    3)Listener is getting started normally.
    4)When I try to run svrmgrl,
    connect internal (does not ask for the "manager" password, which is

    weird), it gets connected.
    When I try to startup the database, it gives:

    ora 00205 error in identifying control file '?/dbs/cntrl@.dbf'
    ora 07360 sfifi stat error, unable to obtain information about file
    no such file or directory


    There is no such file in the said location.
    Now as I understand it, during the CD installation itself,
    Oracle has created the database.
    Then is it not but obvious that it should also create a control file??
    How do I get my database to startup & proceed with remaining steps??
    As you said,

    svrmgrl

    connect internal
    gives you "connected" status.

    Also, your init.ora doesn't specify the path of controlfile. Are you sure a default database has been created.

    I don't know much about oracle 7x, but the init.ora should have the path of control, udump, bdump, etc. which is not seen in yours.

Posting Permissions

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


Click Here to Expand Forum to Full Width