NT server: where is pfile specified??

From: Tse <tcng_at_yas.com.sg>
Date: Tue, 2 Feb 1999 11:46:45 +0800
Message-ID: <795sbi$h9k$1@newton.pacific.net.sg>

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 ) Received on Mon Feb 01 1999 - 21:46:45 CST