| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> SOLVED: IFILE in node-specific init file in VMS
Blank lines in your init.ora are a very bad thing.
Oracle support and Metalink get beat up quite often on this list but I must say they solved this problem very quickly.
Thanks to everyone who replied.
Mark
-----Original Message-----
Sent: Thursday, August 01, 2002 9:38 AM To: Multiple recipients of list ORACLE-L Subject: RE: IFILE in node-specific init file in VMS
Is the logical defined as /system/exec? If so and doesn't work, I would open a tar b/c it must be something in your env. I am running Oracle 8.1.7.3 OpenVMS 7.2 and have no problem. I do put the ifile stmt 1st line in initSID.ora file so I can easily override any parameter.
Gene
>>> mstahlke_at_denvernewspaperagency.com 07/31/02 06:30PM >>> Hi Gene,
I've tried using both a logical (ora_system) and the full path. It doesn't work either way.
Tom -
I'm tempted but I would like the simplicity of maintaining a single
init.ora.
Mark
-----Original Message-----
Sent: Wednesday, July 31, 2002 3:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: IFILE in node-specific init file in VMS
I use ifile w/out a problem in OpenVMS. Do you reference it w/ full path or logical? I don't like using init...ora and config...ora. I use an instance specific initSID.ora that ifile's a common init.ora file into each db. Its nice to put a change in 1 file and its applied to all dbs.
Gene
>>> NDATFM_at_labor.state.ny.us 07/31/02 05:04PM >>> Mark,
throw away the IFILE thingy. it is not worth the trouble!
create instance specific init.ora files.
solves your problem.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, July 31, 2002 4:49 PM
To: Multiple recipients of list ORACLE-L
Greetings elitist *nix bigots,
I'm starting to upgrade our OPS databases on OpenVMS from 7.3 to 8.1.7.3 and I've run into a problem with the IFILE parameter in the node specific init file.
It appears Oracle is not reading the generic init.ora specified in the IFILE parameter in the node specific init file. Only parameters defined in the node specific init file are effective.
Has anyone "been there, done that"?
Thanks,
Mark Stahlke
Elitist VMS Bigot
Denver Newspaper Agency
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stahlke, Mark
INET: mstahlke_at_denvernewspaperagency.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: Gsais_at_co.palm-beach.fl.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Aug 01 2002 - 19:33:20 CDT
 |
 |