ORA-00205: error in identifying control file, check alert log for more info - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: ORA-00205: error in identifying control file, check alert log for more info

  1. #11
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    No i dint use dbca tool

    i manually created started creating database
    i dont hv any data
    i learnt DBA 1month back nw i started working out

    creatind database wt i did

    step 1 : Set Environment
    this is hw itt looks

    # .bash_profile.

    export ORACLE_SID=sun
    export ORACLE_HOME=/u01/ofa/product/10.2.0
    export PATH=$ORACLE_HOME/bin:$PATH:

    :wq

    2)created Pfile or Init file
    [oracle@ambi ~]$ cd $ORACLE_HOME/dbs [oracle@ambi dbs]$ ls
    hc_sun.dat initdw.ora init.ora initsun.ora lkSUN
    [oracle@ambi dbs]$ cd vi initsun.ora

    # replace DEFAULT with your database name
    db_name=sun

    db_files = 80 # SMALL
    # db_files = 400 # MEDIUM
    # db_files = 1500 # LARGE

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

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

    #shared_pool_size = 3500000 # SMALL
    # shared_pool_size = 5000000 # MEDIUM
    shared_pool_size = 90000000 # LARGE

    log_checkpoint_interval = 10000

    processes = 50 # SMALL
    # processes = 100
    undo_tablespace=UNDOTBS
    undo_management=auto
    user_dump_dest='/disk2/sun/udump'
    background_dump_dest='/disk2/sun/bdump'
    core_dump_dest='/disk2/sun/cdump'

    parallel_max_servers = 5 # SMALL
    # parallel_max_servers = 4 x (number of CPUs) # MEDIUM
    # parallel_max_servers = 4 x (number of CPUs) # LARGE

    log_buffer = 32768 # SMALL
    # log_buffer = 32768 # MEDIUM
    # log_buffer = 163840 # 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
    global_names = TRUE
    # define two control files by default
    control_files='/disk1/sun/controlfile/contro101.ctl'

    3)step i created dumps
    [oracle@ambi sun]$ pwd
    /disk2/sun
    [oracle@ambi sun]$ ls
    bdump cdump create udump
    [oracle@ambi sun]$

    4) created databasescript i.e createsun.sql
    [oracle@ambi create]$ pwd
    /disk2/sun/create
    [oracle@ambi create]$ ls
    createsun.sql
    [oracle@ambi create]$ vi createsun.sql

    create database sun
    datafile '/disk1/sun/datafile/system.dbf' size 170m
    sysaux datafile '/disk1/sun/datafile/sysaux.dbf' size 150m
    default temporary tablespace TEMP tempfile
    '/disk1/sun/datafile/temp1.dbf' size 10m
    default tablespace USERS datafile
    '/disk1/sun/datafile/user1.dbf' size 20m
    undo tablespace UNDOTBS datafile
    '/disk1/sun/datafile/undo1.dbf' size 20m
    logfile
    group 1 ('/disk1/sun/redologfile/redolog1a.log') size 4m,
    group 2 ('/disk1/sun/redologfile/redolog2a.log') size 4m;

    [oracle@ambi ~]$ sqlplus '/as sysdba';

    SQL*Plus: Release 10.2.0.1.0 - Production on Tue Sep 8 23:54:34 2009

    Copyright (c) 1982, 2005, Oracle. All rights reserved.

    Connected to an idle instance.

    SQL> startup
    ORACLE instance started.

    Total System Global Area 125829120 bytes
    Fixed Size 1218052 bytes
    Variable Size 117443068 bytes
    Database Buffers 4194304 bytes
    Redo Buffers 2973696 bytes
    ORA-00205: error in identifying control file, check alert log for more info



    this is wt i did

  2. #12
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Since you are learning Oracle, I would suggest that you delete the old database and use dbca to create a new database. You should also review the concepts manual, http://download.oracle.com/docs/cd/B...b28301/toc.htm, to see what the various parts of an Oracle database are and how they interact. Recreating the database should help you to learn more about Oracle.
    this space intentionally left blank

  3. #13
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    wt i hv to do nw

    should i delete
    /u01 folder contents

    and

    .bash_profile.

    and

    initsun.ora which is in [oracle@ambi ~]$ cd $ORACLE_HOME/dbs

    and

    [oracle@ambi sun]$ ls
    bdump cdump create udump

    delete this dimps nad

    delete createsun.sql

  4. #14
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    i am waiting fr ur reply

  5. #15
    Join Date
    Sep 2009
    Posts
    10

    ORA-00205: error in identifying control file

    one more problem i hv [oracle@ambi ~]$ su
    Password:
    [root@ambi 10.2.0]# cd
    [root@ambi ~]# su - oracle
    -bash-3.00$
    -bash-3.00$
    -bash-3.00$
    -bash-3.00$
    -bash-3.00$
    -bash-3.00$

    if i do
    -bash-3.00$ logout

    [root@ambi ~]#

    if i give
    [root@ambi ~]# su oracle

    its going
    [oracle@ambi ~]$

  6. #16
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    go to otn.oracle.com and read the concepts manual

    then go and learn the difference between su and su - in a unix environemnt, the help you needc cannot be give on a forum.

    I even severely doubt that you have even created a database

  7. #17
    Join Date
    Sep 2009
    Posts
    10
    so hw should i follow the steps

    wt i hv to do nw

    should i delete
    /u01 folder contents

    and

    .bash_profile.

    and

    initsun.ora which is in [oracle@ambi ~]$ cd $ORACLE_HOME/dbs

    and

    [oracle@ambi sun]$ ls
    bdump cdump create udump

    delete this dimps nad

    delete createsun.sql

  8. #18
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    have you even created a database?

  9. #19
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    You need to learn this yourself. I think you have been given enough help.
    this space intentionally left blank

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