Re: NT server: where is pfile specified??

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 Received on Tue Feb 02 1999 - 21:17:39 CST