BR*Tools 7.40 weird issue on AIX 6.1

[former_member204618]

Hi All

Me yet again.

I have just installed BR*Tools 7.40 as per my previous posting and correcting an issue with it not running for ora<SID> user.

Unbeknown until this morning that as a result of correcting that issue, sqlplus now doesn't work for either <SID>adm or ora<SID> users.

Error is :-

sqlplus -version
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Now for the life of me I couldn't figure this out.  For <SID>adm user no environment settings were changed when I patched Oracle from 10.2.0.4 to 10.2.0.5 for prep to 12c and so I was confused as to why it stopped working.  The only thing I changed for ora<SID> user was to add /oracle/client/11x_64/instantclient to the LIBPATH environment variable to get it to work.  Otherwise you get the error I posted before as below.

brspace -p init<SID>.sap -s 20 -l E -u / -f dbshow -c dbstate
exec(): 0509-036 Cannot load program brspace because of the following errors:
rtld: 0712-001 Symbol modf was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol strcat was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol strcpy was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol strcmp was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol strncat was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol strncpy was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol fsav was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol fres was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol floor was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol ceil was referenced
      from module brspace(), but a runtime definition
      of the symbol was not found.
rtld: 0712-002 fatal error: exiting.

So this is a change to the way BR*Tools used to work it seems.

Now for the problem encountered.

With /oracle/client/11x_64/instantclient added to LIBPATH at the end you still get the above error.  Moving it before /oracle/<SID>/102_64/lib fixes it for user ora<SID>

However the side affect to this is that sqlplus now no longer functions and you get the error at the start of this thread!

Now what's strange is that if you unsetenv LIBPATH and replace it with LD_LIBRARY_PATH both programs work.  I know that with AIX 5.3 onwards they use LD_LIBRARY_PATH by default but will also use LIBPATH if set IBM Managing LIBPATH and LD_LIBRARY_PATH environment variables for LSF jobs on AIX5.3 - United State...

However that's not how the .dbenv scripts are written, they explicitly set LIBPATH if it detects AIX.

Also strange is that I can't run sqlplus any more as the user <SID>adm without again changing LIBPATH and adding in /oracle/<SID>/102_64/lib which again isn't part of the logon scripts.

So do I replace LIBPATH in those logon scripts with LD_LIBRARY_PATH or what?  What's the consequence of doing that?

Thanks

Craig

[volker_borowski2]

Check Note 830578

Never put $ORACLEHOME/lib AND the instantclient LIBS into the same LIBPATH for whatever user

sidadm should use INSTANTCLIENT only in LIBPATH

orasid should use $ORACLE_HOME/lib only in LIBPATH

Volker

[JamesZ]

hi Craig,

sqlplus -version

SP2-1503: Unable to initialize Oracle call interface

SP2-0152: ORACLE may not be functioning properly

You need to check oracle_home environment variable for the calling user.

Also the brtools error is related to environment variables setting.

For 12c, if the environment variables are not set automatically after logging os, you need to run .dbenv before trying to work with database

[former_member204618]

Hi James,

Sorry it's been a while, the ORACLE_HOME env setting was set correctly for both users!

Anyways after upgrading to Oracle 12c I had to leave the environment settings as follows :-

sidadm user
LIBPATH=/usr/lib:/lib:/usr/sap/SID/DVEBMGS00/exe
LD_LIBRARY_PATH=/usr/lib:/lib:/oracle/client/12x/instantclient:/usr/sap/SID/DVEBMGS00/exe

orasid user
LIBPATH=/usr/lib:/lib:/usr/sap/SID/DVEBMGS00/exe
LD_LIBRARY_PATH=/usr/lib:/lib:/oracle/SID/121/lib:/usr/sap/SID/DVEBMGS00/exe

Otherwise as mentioned I could get some of the tools to run but not all.

I have still yet to figure out what the problem is, I tried it with having just LD_LIBRARY_PATH set but then sapstart complained about ICU libraries and wouldn't start saying env LIBPATH needed setting!  I am running kernel 721 ext patch 700.

Any ideas?

Cheers

Craig

[JamesZ]

Hi Craig,

Is sqlplus working? Sqlplus not working is caused by wrong environment variables.

You can use oraenv to set environment variables for oracle since 12c.

Best regards,
James

[former_member204618]

UPDATE

Well I know what the consequence of doing the change I mentioned.  The SAP dispatcher refuses to start.

So now I am in a dilemma, if I keep it as is and leave LIBPATH set as follows :-

LIBPATH=/usr/lib:/lib:/usr/sap/SID/DVEBMGS00/exe:/oracle/client/11x_64/instantclient

I can run brtools with user SIDadm, but not sqlplus.  If I change to using LD_LIBRARY_PATH together with LIBPATH like so (they are set in different logon scripts)

LIBPATH=/usr/lib:/lib:/usr/sap/SID/DVEBMGS00/exe
LD_LIBRARY_PATH=/usr/lib:/lib:/oracle/client/11x_64/instantclient

I can run both programs but the sap dispatcher fails to stay up, as in comes up and then dies.  Should I therefore replace LIBPATH completely in all scripts with LD_LIBRARY_PATH?

Thanks

Craig