Br_env parameter has wrong value

[Former Member]

Hello,

I am running brconnect on MWQ system and I found that it shows wrong value in br_env parameter as follows:

oramwq> cat cenzkqiz.sta

BR0801I BRCONNECT 7.20 (36)

BR0805I Start of BRCONNECT processing: cenzkqiz.sta 2014-06-02 14.03.21

BR0484I BRCONNECT log file: /oracle/MWQ/sapcheck/cenzkqiz.sta

BR0101I Parameters

Name Value

oracle_sid MWQ

oracle_home /oracle/MWQ/112_64

oracle_profile /oracle/MWQ/112_64/dbs/initMWQ.ora

sapdata_home /oracle/MWQ

sap_profile /oracle/MWQ/112_64/dbs/initMWQ.sap

_mdm_owner ASTMWQ_M000

system_info oramwq/oramwq xxxxxx AIX 1 7 00F6A6394C00

oracle_info MWQ 11.2.0.3.0 8192 65 2884248 mdmqat AL32UTF8 UTF8 3578789179 &MWQ

sap_info SAPSR3

make_info rs6000_64 OCI_102 Mar  5 2014 720_REL

command_line /usr/sap/MWQ/SYS/exe/run/brconnect -u / -c -f stats -t oradict_stats

br_env SAPBACKUP=/oracle/MWQ/sapbackup,

NLS_LANG=AMERICAN_AMERICA.US7ASCII,

ORACLE_BASE=/oracle,

SAPTRACE=/oracle/MWQ/saptrace,

SAPCHECK=/oracle/MWQ/sapcheck,

ORACLE_SID=MWQ,

DB_SID=MWQ,

TNS_ADMIN=/oracle/CRB/autosys,

SAPEXE=/usr/sap/MWQ/SYS/exe/run,

SAPDATA_HOME=/oracle/MWQ,

ORA_NLS33=/oracle/client/92x_64/ocommon/nls/admin/data,

SAPARCH=/oracle/MWQ/saparch,

ORACLE_HOME=/oracle/MWQ/112_64,

SAPREORG=/oracle/MWQ/sapreorg,

SAPSYSTEMNAME=MWQ

stats_table ORADICT_STATS

stats_dict_method C

BR0280I BRCONNECT time stamp: 2014-06-02 14.03.21

BR0807I Name of database instance: MWQ

BR0808I BRCONNECT action ID: cenzkqiz

Does anyone know from where br_env paramater reads the value and how to correct it?

[former_member188883 · Accepted solution]

Hi Urvi,

brtools will be using environment parameters from user oramwq.

Please check and adjust environment for oramwq is something is not correct.

You need to look for .dbenv_<hostname>.sh/csh files

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hello,

My issue is solved.

There was a enviornment variable file on server /etc/auto.profile, it was picking up values from that server.

Thanks,

Urvi