Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2004
    Posts
    102

    Unanswered: dbstart not working in linux RH 9

    Hi all,

    i installed oracle 9i on linux RH 9. when i execute the command dbstart the the following errors occured.

    can't find init file for database "ORCL"

    but i can start the database by using sqlplus /nolog. and it is working.

    I don't know why dbstart not working? where is ithe problem ?

    Please help me.

    advance thanks for your help.
    Working Together...

  2. #2
    Join Date
    Nov 2004
    Location
    Temple University
    Posts
    36

    Cool

    Make a link in $ORACLE_HOME/dbs to the correct init<SID>.ora file. You will want to do the same with an SPFile if decide to use one.

    HTH

  3. #3
    Join Date
    Oct 2004
    Posts
    145
    Other option is to specify the location of the init file.

    startup pfile=/location/name_of_init_file

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    The default behavior for Oracle on *nix is to only use the spfile and NOT even produce a initSID.ora "pfile".
    I admit the default action can be overridden, but doing so requires manual intervention.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2004
    Posts
    102
    Thanks all . i copy it from pfile to $ORACLE_HOM/dbs by rename initSID.ora
    and problem solved.
    Working Together...

  6. #6
    Join Date
    Oct 2004
    Posts
    145
    If you copied the file instead of creating a link, be careful.

    Any updates to the init file must be done to the one in $ORACLE_HOME/dbs.

    Typicall you would create a link using ln command from $ORACLE_HOME/dbs directory.

  7. #7
    Join Date
    Jul 2004
    Posts
    102
    Quote Originally Posted by JimYoo
    If you copied the file instead of creating a link, be careful.

    Any updates to the init file must be done to the one in $ORACLE_HOME/dbs.

    Typicall you would create a link using ln command from $ORACLE_HOME/dbs directory.
    Do u mean ln -s /pfile/init........ $ORACLE_HOME/dbs/initSID.ora
    Working Together...

  8. #8
    Join Date
    Jul 2003
    Posts
    2,296
    Quote Originally Posted by Momin
    Do u mean ln -s /pfile/init........ $ORACLE_HOME/dbs/initSID.ora
    that is exactly what he means.
    many times someone edits the wrong init.ora file if you don't use a
    symbolic link.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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