BR0162E Parameter 'spfile' in file /oracle<SID>/112_64/initSID1.ora

[Former Member]

We have our DB on oracle RAC with three nodes on production environment.

We performed oracle services relocation to other nodes due to OS server reboot yesterday. And after that brbackup and braarchive are failing with the below error.

BR0162E Parameter 'spfile' in file /oracle/<SID>/112_64/dbs/initSID2.ora not supported

BR0158E Error reading Oracle profile /oracle/<SID>/112_64/dbs/initSID2.ora

Please suggest to solve this.

[former_member185239 · Accepted solution]

Hi Padmini,

First of all check the permission of /oracle/sid/112_64/dB's folder and init<SID>2.ora.

Secondly comment the parameter SPFILE in init<SID>2.ora. Just use # before SPFILE parameter.

Then run the brtool to take the backup.

With Regards

Ashutosh

[Former Member · Accepted solution]

Hi Ashutosh,

commenting the parameter wont cause any issue?

[Former Member · Accepted solution]

Hi

Padmini

BR0158E Error reading init_ora profile %s

BR0158E Fehler beim Lesen des init_ora-Profiles %s

Explanation:  Errors were determined during the reading of the init<DBSID>.ora profile.

Program reaction:  Processing terminates.

User action:  Check the syntax of the information in the init <DBSID>.ora profile. Note the detailed notes listed there. Then restart the operation.

BR0162E Parameter %s in file %s not supported.

BR0162E Parameter %s in Datei %s nicht unterstuetzt.

Explanation:  Profile error. The specified parameter should not be used. An init.ora parameter that is not supported is often corrected here.

Program reaction:  Processing terminates.

User action:  Delete the parameter, restart the database and repeat the action.

and also you can find all the error messages and codes related to BRTOOLS in the following sapnote 17163

[Former Member · Accepted solution]

Hi Ashutosh,

Commenting worked.

[fidel_vales]

unfortunately you have a "little problem"

you are using "init<sid>.ora"

In SAP (if you have read the installation of RAC in SAP environment document in this community) you are required to

1) use a shared ORACLE_HOME

2) use an spfile

3) because of the previous two, the spfile name should not contain the <SID> of any instance, it should be spfile.ora

In your case, it is clear that you are using a "pfile", and the <instance SID> is part of the name. So you have a bad configuration.

Please, review the installation documents, create an spfile shared by all the instances with a generic name "spfile.ora" and the pfile will not be necessary.

[former_member185239]

Hi ,

has told you a correct things.

Cross checked every thing as per him. Oracle should read spfile.As per the RAC environment it should use spfile.ora and not pfile.

You can discuss the same with your team member.

What i told you is a workaround  but not a solution.

With Regards

Ashutosh