problem with dbverify on rac systems

[Former Member]

Hello ,

the customer have problems with dbverify on a few systems (oracle RAC Linux)

one system runs ok bu the other systems give's a BR0339E message

Service DVEBMGS51_sapnode13 is running on instance(s) A05001

Service D50_sapnode11 is running on instance(s) A05002

BR0339E Number of parallel instances is different from number of threads

BR0314E Collection of information on database files failed

I checked the .sap and .ora files and see no differences

anyone has an idea

Best regards,

Andre

[fidel_vales · Accepted solution]

Hi,

RAC is not my strong point (have to look more into it)

You mention that

> I checked the .sap and .ora files and see no differences

no differences with "what"?

The error you mention does not have anything to do with DBVERIFY (oracle tool) but with "BR*" (SAP Tool)

I assume that you are trying to perform a consistancy check with BRBACKUP and that is what fails, correct me if I'm wrong.

The error indicates that there is a mismatch between the number of threads in your DB and the services that you have configured.

> BR0339E Number of parallel instances is different from number of threads

Services are NOT configured on the init<sid>.ora, you are looking on the wrong place (but you can check the configured threads there)

Please, check the configuration of the services.

[Former Member]

and also the tnsnames.ora i may be able to help u

Reg

R

[Former Member]

Hi

Post the contents of your rac listener file

Reg

R

[Former Member]

Issue is with Br*tools.

init<SID>.ora file is not supported in Oracle RAC environment only, SPFILE with the specified name 'spfile.ora' is supported,

We had a similar issue we solved this issue by following the below SAPnote

905359 - Using BR* tools for Oracle RAC databases

5. All Oracle instances use a shared spfile named spfile.ora (not spfile<DBSID>.ora), which is located in the profile directory (Unix: dbs, Windows: database). All RAC instances use the spfile. It contains all instance-independent parameters and all instance-dependent parameters for all Oracle instances. You must have defined at least the following instance-dependent parameters there:

<INST_NAME>.instance_number

<INST_NAME>.instance_name

<INST_NAME>.thread

<INST_NAME>.service_names

<INST_NAME>.undo_tablespace

For a list of instance-dependent parameters, see Note 830982.

Thanks,

Surendra

[Former Member]

Hello,

I checked the spfile's on the systems for the instance-dependent parameters

*.audit_file_dest='/oracle/A04/saptrace/audit'

*.background_dump_dest='/oracle/A04/saptrace/background'

*.control_files='/oracle/A04/origlogA/cntrl/cntlrA04.dbf','/oracle/A04/origlogB/cntrl/cntrlA04.dbf','/oracle/A04/sapdata1/cntrl/cntrlA04.dbf'

*.core_dump_dest='/oracle/A04/saptrace/background'

A04001.db_cache_size=1073741824

A04002.db_cache_size=1073741824

*.db_name='A04'

A04001.instance_name='A04001'

A04002.instance_name='A04002'

A04001.instance_number=001

A04002.instance_number=002

A04001.local_listener='LISTENER_A04_SUESY073'

A04002.local_listener='LISTENER_A04_SUESY074'

*.log_archive_dest='/oracle/A04/oraarch/A04arch'

A04001.remote_listener='REMOTE_LISTENER_A04_SUESY073'

A04002.remote_listener='REMOTE_LISTENER_A04_SUESY074'

A04001.service_names='A04','A04001'

A04002.service_names='A04','A04002'

A04001.thread=001

A04002.thread=002

A04001.undo_tablespace='PSAPUNDO_001'

A04002.undo_tablespace='PSAPUNDO_002'

*.user_dump_dest='/oracle/A04/saptrace/usertrace'

on this system dbverify (brtools) is working

oraa05> strings spfile.ora | grep A0

*.audit_file_dest='/oracle/A05/saptrace/audit'

*.background_dump_dest='/oracle/A05/saptrace/background'

*.control_files='/oracle/A05/origlogA/cntrl/cntlrA05.dbf','/oracle/A05/origlogB/cntrl/cntrlA05.dbf','/oracle/A05/sapdata1/cntrl/cntrlA05.dbf'

*.core_dump_dest='/oracle/A05/saptrace/background'

*.db_name='A05'

A05001.instance_name='A05001'

A05002.instance_name='A05002'

A05001.instance_number=001

A05002.instance_number=002

A05001.local_listener='LISTENER_A05_SUESY073'

A05002.local_listener='LISTENER_A05_SUESY074'

*.log_archive_dest='/oracle/A05/oraarch/A05arch'

A05001.remote_listener='REMOTE_LISTENER_A05_SUESY073'

A05002.remote_listener='REMOTE_LISTENER_A05_SUESY074'

A05001.service_names='A05','A05001'

A05002.service_names='A05','A05002'

A05001.thread=001

A05002.thread=002

A05001.undo_tablespace='PSAPUNDO_001'

A05002.undo_tablespace='PSAPUNDO_002'

*.user_dump_dest='/oracle/A05/saptrace/usertrace'

on this system dbverify(brtools) is not working

Regards,

Andre