Re: Oracle 8.0.5

Not quite. At least as recently as 8.0.5, if you look in <oracle_home>\database\ you will find the startup files for your Oracle start services . . . these include the pfile parameter, which could then be modified. Or one could use Oradim to delete and recreate the sid definition, specifying the correct pfile when creating the new sid.

• Ed Stevens

On Tue, 17 Jul 2001 18:55:33 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>"roblop" <roblop_at_friko2.onet.pl> wrote in message
>news:9j1bf5$fdj$1_at_news2.ipartners.pl...
>> > Hello!
>> >
>> > By default init<SID<.ora must be in %ORACLE_HOME%\database.
>> >
>> > If you want locate it to another place, you must type following:
>> >
>> > sqlplus
>> > sql>connect internal
>> > sql>startup pfile='NEW_PLACE'
>> > -------------------------------------
>>
>> My problem is: How to start Oracle Services (Oracle....) without error
 with
>> initorcl.ora in diffrent directory than %oracle_home%\database during
>> startup of Win NT.
>> My problem is'nt: How to start Oracle with initorcl.ora in diffrent
>> directory than default %oracle_home%\database
>>
>>
>> > Another way:
>> > I'm on unix machine usually use links; (same on NT);
>> > i.e. you file located f:\control\initorcl.ora and link on it is
>> > c:\orant\database\initorcl.ora .
>>
>> Not same on NT. On NT all links have .lnk extension.
>>
>> Regards, Roblop
>>
>>
>>
>
>Short answer:
>That's just the way it works.
>You can't
>
>Regards,
>
>Sybrand Bakker, Senior Oracle DBA
>
>
>

--
Ed Stevens
(Opinions expressed do not necessarily represent those of my employer.)