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
    4,166
    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.

  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,334
    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,334
    have you even created a database?

  9. #19
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    You need to learn this yourself. I think you have been given enough help.

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