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
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
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
Thanks for your reply,
let me be sure, on
Where c:\oracle\ora816\admin\DB1\pfile\initDB1.ora=the old init.ora
Is this correct ???
You must write like a parameter on the init:
Do you understand now?
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???
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
where $ORACLE_HOME is the path of your old software. And only write this in this init.ora
I think now is better explained.
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 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.
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]
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 ....
Click Here to Expand Forum to Full Width