brtools and init<SID>.ora

[Former Member]

Hello,

I've had to change the standard location of file init<SID>.ora.

After that, when I execute brtools I've several errors because it's not find the file in the path E:\oracle\EPP\102\dtabase\init<SID>.ora

How an I do to specific the correct path of init<SID>.ora to brtools ?

Thank's in advanced

[Former Member · Accepted solution]

you can do as suggested by sushil .One more way on SQL prompt

SQL > Startup pfile=<NewPath as you changed>

SQL > Create spfile from pfile;

SQL > Shutdown immediate;

$ Rename pfile init<SID>.ora to init<SID>.ora.old

SQL > Startup (Now it will start through spfile)

SQL > create pfile from spfile ; (If you want create pfile on orgional path)

[Former Member]

Hi Francesc,

Oracle searches for the parameter file in the platform-dependent default

location (Unix: $ORACLE_HOME/dbs; Windows: %ORACLE_HOME%\DATABASE) using

the following names and in the specified sequence:

1. spfile<SID>.ora

2. spfile.ora

3. init<SID>.ora

You should not change this path. From oracle 9i, oracle usees SPFILE. For details on spfile please chech SAP note 601157.

Hope this helps.

Thanks

Sushil

[lbreddemann]

Hi Sushil,

you're right, but you missed the point here.

It's about the BR*TOOLS and what they do with the pfile (even when a spfile is used).

regards,

Lars

[former_member204746]

leave file E:\oracle\EPP\102\dtabase\init<SID>.ora in place and insert only 1 line:

ifile=(location of an external initSID.ora)

[lbreddemann]

Hi Eric,

sorry, but although that would work for Oracle alone it will lead to two problems:

1. the usual DBA won't ever remember to have used this little 'hack'

2. the BRTOOLS will issue a 'create pfile from spfile' the next time you fire them up and this little trick is gone.

From the support point of view, point 1) is the more annoying one ("No, we never changed that...!").

regards,

Lars

[lbreddemann]

> I've had to change the standard location of file init<SID>.ora.

What for?

I mean, nowadays you should use the spfile anyhow.

Keeping the init<sid>.ora up to date is just a security measure of the BRTOOLS.

> After that, when I execute brtools I've several errors because it's not find the file in the path E:\oracle\EPP\102\dtabase\init<SID>.ora

>

> How an I do to specific the correct path of init<SID>.ora to brtools ?

No option for that.

Put the file back where it belongs.

regards,

Lars