IFILE set up
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: IFILE set up

  1. #1
    Join Date
    Aug 2001
    Posts
    391
    Could someone please tell me how to set up the IFILE if I have two Oracle on the box (8.1.6 and 8.1.7)

    this is the case: If I have two home say
    c:\oracle\ora816\admin\DB1\pfile\initDB1.ora

    After I upgrade this DB1 database to 8.1.7, how do I set up the pfile pointed to the old initDB1.ora by using IFILE ???


    and my new home c:\oracle\ora817\admin\

    Where do I put the IFILE at ??? and how to set it up to point to the old init.ora file

    Thanks


  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi Mike,

    In your Oracle8.1.7 Home in the database directory is the init.ora for the Oracle database. Put the same name as your Oracle 8.1.6 and in put:

    ifile=path to point exactly the old init.ora file.

    Hope this helps

    Angel

  3. #3
    Join Date
    Aug 2001
    Posts
    391
    aarroyob,

    Thanks for your reply,

    let me be sure, on


    c:\oracle\ora817\admin\DB1\IFILE\c:\oracle\ora816\admin\DB1\pfile\initDB1.ora


    Where c:\oracle\ora816\admin\DB1\pfile\initDB1.ora=the old init.ora

    Is this correct ???


  4. #4
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi Mike,

    You must write like a parameter on the init:

    ifile=c:\oracle\ora816\admin\DB1\pfile\initDB1.ora

    Do you understand now?

    Regards

    Angel

  5. #5
    Join Date
    Aug 2001
    Posts
    391
    aarroyb,

    sorry to bother you now, I undertsand to set the IFILE to the old init.ora what I am not clear is where can I place the IFILE at ???

    accordign to you email , you told me to put it on the init.ora could you please give me an example???

    Thanks

  6. #6
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Hi Mike,

    Normally in authomatic start of Oracle Database it search the init.ora in $ORACLE_HOME/database, then you must create a text file with the same name that init_old.ora from older version and write in this init.ora

    ifile=$ORACLE_HOME/database/init_old.ora

    where $ORACLE_HOME is the path of your old software. And only write this in this init.ora

    I think now is better explained.

    Angel

  7. #7
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Exclamation

    Hi Mike,

    Say for example,
    c:\oracle\ora816\admin\DB1\pfile\initDB1.ora is the the old init file.
    Make a new file with this same name where a file named init.ora is placed in your new install.

    In this new file just write :
    ifile=c:\oracle\ora816\admin\DB1\pfile\initDB1.ora

    regards
    Shruti

  8. #8
    Join Date
    Feb 2001
    Posts
    389
    ifile is a general paramter which can be used to break the parameter files
    into sub parts,
    For example u can have a standard init.ora parameter file for all instances and
    another file containing specific paramters tuned to specific instances.
    You can use ifile parameter in your general init.ora parameter file to point to this specific
    instance paremer file.

    Simillarly you can use ifile paremeter to break tnsnames.ora file into sub parts.

  9. #9
    Join Date
    Aug 2001
    Posts
    391
    Thank you all for your responses and I apologize for not making myself clear. The question I have is where can I place the IFILE at the new home which will run on 8.1.7

    Where is the IFILE suppose to be ??? I understand how to set up to point to the old init.ora but I am not clear how to pit the IFILE at on the new home. Another word, I like to know where in the new Oracle Home I can put the IFILE in???


    Thank you very much for all your help and please let me know

    [Edited by mike73 on 11-23-2001 at 04:29 PM]

  10. #10
    Join Date
    May 2001
    Location
    Delhi
    Posts
    341
    Dear Mike,

    As angel said

    Normally in authomatic start of Oracle Database it search the init.ora in $ORACLE_HOME/database

    either you can place your new init.ora file there or anyothe rplace where u want it to be and then when u start ur db u can point to that file with pfile.

    i hope u got it cleared
    --------------------------
    The Time has come ....

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