Re: NT server: where is pfile specified??

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Feb 1999 08:50:15 -0800
Message-ID: <36B87E47.547A3882@us.oracle.com>

There were (in an earlier version that I can't remember, but it may have been 7.3) some registry settings for the pfile location, but I found them very problematic to use (some tools looked there, others didn't). The easiest approach I found was to create a one line initSID.ora in the default location that would say:

ifile= k:\...

HTH. Pete

"D.M.(Mike) Mattix" wrote:

> In article <795sbi$h9k$1_at_newton.pacific.net.sg>, tcng_at_yas.com.sg says...
> > Hi,
> > I have an NT Oracle Database 7.3.4, the instance name is 'YSIS'. The
> > initysis.ora is sitting on the K: drive.
> >
> > I defined a system variable ORACLE_SID and set the value to 'YSIS'.
> >
> > Using svrmgr23, I tried to startup the database by issueing the command
> > 'startup', but there is a prompt saying something like this: cannot open
> > parameter file "C:\ORANT\DATABASE\initYSIS.ora". I had to specify the pfile
> > parameter together with the startup command: "startup
> > pfile=k:\sis\config\initysis.ora"
> >
> > Where is this default directory (c:\orant\database\) specified? What do I
> > have to do so I wont have to type the pfile parameter?
> >
> > Thanks in advance.
> >
> > Regards,
> > Tse
> > (Please also reply to mailto:tcng_at_yas.com.sg )
> >
> You can check the strtysis.cmd file for the specific example but the
> pfile is specified in the startup command using svrmgr23.
>
> An example would be (using the default database):
>
> svrmgr23 -startup -sid ORCL -intpass oracle -starttype srvc,inst -pfile
> c:\orant\database\initorcl.ora
>
> You replace the above with your specifics..
>
> Mike Mattix
> dmmattix_at_earthlink.net

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Feb 03 1999 - 10:50:15 CST