RE: SOLVED: IFILE in node-specific init file in VMS

Interesting find. In my VMS env, I do not have blank lines but I do in Unix init.ora's. It must be a VMS thing, since it doesn't like blank lines in DCL scripts either :)

Gene

>>> Bruce.Reardon_at_comalco.riotinto.com.au 08/02/02 12:53AM >>>
Mark,
I'm glad you got it solved.
Maybe it is platform specific?
We don't have OPS but do use ifile notation We have lots of blank lines in addition to a number of comment lines beginning with "#" and we haven't had any problems, that I know of :-). We're running 81714 under NT4 SP6a.

Did support give a reference to a Metalink note describing issues with blank lines in init files?

Thanks,
Bruce Reardon

-----Original Message-----
Sent: Friday, 2 August 2002 10:33

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

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

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

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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au 

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).