BRCONNECT is reading init<sid>.ora file instead of spfile.

[Former Member]

Hi All,

When running the DBCHECK, BRCONNECT is picking init<sid>.ora instead of spfile. DB check is performed based on PFILE  for example a parameter compatible is having correct value in SPFILE as 11.2.0 , but it is reading from initSID.ora  as 10.2.0.

Regard's

Ruchi

[Reagan]

for example a parameter compatible is having correct value in SPFILE as 11.2.0 , but it is reading from initSID.ora  as 10.2.0.

Forgot to answer this question.

The check condition is reading from Tx DB17

You need to modify the COMPATIBLE condition from 10.2.0 to 11.2.0 then brconnect check will be fine.

Regards

RB

[Former Member]

Dear Reagan,

We have already modified COMPATIBLE condition from 10.2.0 to 11.2.0. Still is reading init<sid>.ora file. Please Provide us some another solution.

[ashish_vikas]

Hi Ruchi,

Is your system running with SPFILE ? when you run sql command : show parameter spfile   DO you get spfile file location & show parameter compatible.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

spfile                               string      /oracle/TB4/112_64/dbs/spfileSID.ora

SQL> show parameter compatible

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

compatible                           string      11.2.0

Also, just create a pfile from spfile if your system is running with spfile.

Have you modified DB17?

best regards

ashish

[Former Member]

Thanks a lot Ashish. It was really useful.

[Reagan]

Hello

Brconnect checks creates a pfile from the spfile.

Check the start of the .chk log and you can see this:

BR0477I Oracle pfile /oracle/SID/112_64/dbs/initSID.ora created from spfile /oracle/SID/112_64/dbs/spfileSID.ora

Regards

RB

[Former Member]

Download the latest Brtools  from portal install it and check.

[Former Member]

Dear Suresh,

We have already installed the latest Brtools, still it is showing this issue. Please provide me some other

solution.