Standard jobs : (Check and update optimizer statistics) and (Adapt next extent) are scheduled by using DB13 ,but they are getting failed regularly

[Former Member]

Snapshot For update optimizer statistics:-

[Former Member]

this error is coming..

08.02.2013      06:51:10        Parameters: -jid CHECK20130208065110 -u / -c -f check

08.02.2013      06:51:10        ld.so.1: brconnect: fatal: libclntsh.so.11.1: open failed: No such file or directory

08.02.2013      06:51:10        Process died due to signal 9

08.02.2013      06:51:10        SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: unknown

08.02.2013      06:51:10        Job cancelled after system exception ERROR_MESSAGE

[Former Member]

Hi,

Can you please paste the entire screenshot?

As well as please confirm whehter sapcheck folder is available in /oracle/PBW.

if not, please create and give the necessary permission and try again.

Make sure that even /oracle  has full permission  & /oracle/PBW has access to orapbw user.....

Thanks and Regards,

Vimal

[Former Member]

Check that you have correct environment variable (LD_LIBRARY_PATH for linux, LIBPATH for aix, etc.) point to oracle client directory like /oracle/client/11x_64/instantclient. After adjust double check with ldd brconnect that all dependencies resolved. After that try again.

Regards,

Roman

[Former Member]

Hi,

sapcheck folder is available in /oracle/PBW

/oracle/PBW has access to orapbw user

Regards,

Avadhesh Sharma

[Former Member]

Okay.

Please go to /sapmnt/PBW/exe  and see what is the brconnect permission.

Please find the attached picture of how brconnect permission should be...

If not, please  perform the following.

1. login as root user

2.navigate to /sapmnt/PBW/exe

3.chmod 4755 brconnect

And try again.

Thanks and Regards,

Vimal

[Former Member]

Hey sorry...

I just noticed the error.

ld.so.1: brconnect: fatal: libclntsh.so.11.1: open failed: No such file or directory

Please go to /oracle/client/instantclient .. Check whether you are able to see the file  libclntsh.so.11.1

Create a link like the attached picture and check whether it works.

I hope it helps.

Please check and provide the feedback.

Thanks and Regards,

Vimal

[Former Member]

ya ryt but issue is that , i don't have root access ..I access orasid and sidadm through sudo.so please can you suggest some alternative in this regard

.

[Former Member]

you can change the permission using orasid also.

Please check the below suggestions that could be the real reason for your issue.

[Former Member]

without root access how you are going to change permission that the gurus are telling?

[shyam_dontamsetty]

Hi sharma,

Have you checked the necessary permissions for brtools?check the below two links.

Note 113747 - Owners and authorizations for BR*Tools

http://scn.sap.com/thread/1690949

Best Regards,

Shyam

[Former Member]

hi,

Acoording to the note,  I need to change permissions , But i am not having root access ,  i access through sudo . any suggestion in this regard.

[Former Member]

Hi,

Can you paste the permission of brconnect in /sapmnt/PBW/exe folder?

Thanks and Regards,

Vimal

[Former Member]

Hi,

Please make sure that the /oracle/PBW/sapcheck folder can be accessed by orapbw user.

Better you can give 777 permission to /oracle/PBW/sapcheck and try to schedule the  checkDB and update stats again.

It will work.

Please check and provide your feedback.

Thanks and Regards,

Vimal