Xref: alice comp.databases.oracle.server:39632
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.berkeley.edu!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: xyzzy@billthecat.net (D.M.(Mike) Mattix)
Newsgroups: comp.databases.oracle.server
Subject: Re: NT server: where is pfile specified??
Date: Tue, 2 Feb 1999 21:17:39 -0600
X-ELN-Insert-Date: Tue Feb  2 19:25:04 1999
References: <795sbi$h9k$1@newton.pacific.net.sg>
X-Newsreader: MicroPlanet Gravity v2.10
Organization: TMG Software
X-Posted-Path-Was: not-for-mail
Lines: 34
X-ELN-Date: 3 Feb 1999 03:17:37 GMT
Message-ID: <MPG.11217bd12c33cefe989680@news.earthlink.net>

In article <795sbi$h9k$1@newton.pacific.net.sg>, tcng@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@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@earthlink.net