Where is my init.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Where is my init.ora

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    474
    Hi all,

    I am running Oracle 9.2 on Linux redhat 7.3


    I created the database using DBCA and after the database creation was completed, I was loooking for the init.ora but I couldn't find it at all except there was an init.ora.8787082323.

    I tried to make the new init.ora by using this command:

    CREATE PFILE=/home/oracle/admin/db_name/pfile/initDB_name.ora from spfile=/home/oracle/product/9.2.0/dbs/spfileDB_NAME.ora

    but it tell me invalid file name

    could someone tell me where is my init.ora and how to fix this problem???

    Thanks

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Check:

    $HOME/admin/$SID/pfile
    Where : $HOME --> home directory for owner of database (oracle by default)

    Filename have to be: init$SID.ora
    Where $SID => $ORACLE_SID (ur environment parameter)

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    $ORACLE_BASE/admin/$ORACLE_SID/scripts/init.ora

  4. #4
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    It's possible you don't have one if you're using a SPFILE. If you were using an init.ora file the first place Oracle looks is the $ORACLE_HOME/dbs directory. The file it finds here is usually:

    - A symbolic link to the $ORACLE_HOME/admin/$SID/pfile directory
    - A file containing an IFILE reference to this directory.
    - A SPFILE reference.

    If you find the file in the DBS directory it will tell you where your file is if you have one.

    Cheers
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

  5. #5
    Join Date
    Jan 2002
    Posts
    474
    Tim and Shestakov and Pando

    Thanks your advise. I did look into $ORACLE_HOME/admin/DB_NAME/pfile/ before I posted the message in here. As I mentioned earlier, ini.ora is no where to be found except there is a file init.ora.80890943.

    I am aware of the spfile locate in $ORACLE_HOME/dbs/spfileDB_NAME.ora and I have the file.

    The question is how do I change the parameter for my database if I only have the spfile instead of pfile. and I think I can create the new pfile too right??? How come Oracle returns with INVALID FILE name.

    Please advise


    [Edited by ashley75 on 07-21-2002 at 01:12 PM]

  6. #6
    Join Date
    Jul 2002
    Posts
    132
    Try
    create pfile from spfile at the location of the spfile file.

  7. #7
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

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