DB13 - Scheduled Update Statistics not run - Error

[joo_migueldimas]

Hello gurus,

I´m faccing with an error in DB13, I scheduled Update statistics every day but it did not run due an error.

I think this may resulted because an authorization problem.

In /usr/sap is with this permissions:

drwxr-xr-x  15 orad01 dba   4096 Oct 18 16:34 sap

The /oracle/D01/sapcheck is with the following permissions:

drwxr-xr-x  2 orad01 dba     4096 Nov 14 20:28 sapcheck

Inside of sapcheck directory I can see the following files with permissions:

-rw-r--r-- 1 orad01 dba       32262 Oct 14 13:16 ceeimamu.sta
-rw-r--r-- 1 orad01 dba        2705 Oct 15 17:42 ceeisafo.sta
-rw-r--r-- 1 orad01 dba        2705 Oct 15 17:50 ceeisazq.sta
-rw-r--r-- 1 orad01 dba        1932 Oct 15 17:58 ceeisbie.sta
-rw-r--r-- 1 orad01 dba        1791 Oct 15 22:16 ceeisyhm.sta
-rw-r--r-- 1 orad01 dba        1931 Oct 15 22:24 ceeisyta.sta
-rw-r--r-- 1 orad01 dba    19394261 Oct 15 23:45 ceeiszph.sta
-rw-r--r-- 1 orad01 dba        1930 Nov  9 11:27 ceenjunx.sta
-rw-r--r-- 1 orad01 dba        1790 Nov  9 11:38 ceenjvuv.sta
-rw-r--r-- 1 orad01 dba      143103 Nov  9 11:40 ceenjwnr.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:46 ceeosxxw.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:49 ceeosydo.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 14:54 ceeosyqi.sta
-rw-r--r-- 1 d01adm sapsys      521 Nov 16 15:57 ceeotefd.sta
-rw-r--r-- 1 orad01 dba       18530 Nov 16 16:27 ceeotgun.sta
-rw-r--r-- 1 orad01 dba         996 Nov 16 16:27 connD01.log

In DB13 at details error, it show the following statements:

Job executado
Etapa 001 executada (program.RSDBAJOB, variante &0000000000016, nome usuário XNSJAD)
Execução do comando lógico BRCONNECT No host segoviad04
Parâmetros: -u / -jid STATS20101123153214 -c -f stats -t ALL
BR0801I BRCONNECT 7.20 (7)
BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:
'ENABLE THREADS'
BR0806I End of BRCONNECT processing: ceeqbmqh.sta2010-11-23 15.32.15
BR0280I BRCONNECT time stamp: 2010-11-23 15.32.15
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job encerrado

Can you help me please!? I do not know how to solve this situation...

Best regards,

João Dimas - Portugal

[former_member395192]

Yes, this thread really helpfull!

I have same trouble on solaris x86-64 when install SAP NW 7.30.

I reinstall instant oracle client software (ORACLE 10.2.0.5 Client) according note 819829 as recomended for problem 2 in note 1449619 and now installation cotinued.

Thank experts! 😃

[former_member189546]

hello,

Check whetherthe softlink from note #1430669 (ln -s libnnz11.so

libnnz10.so) is missing; if so, after creation - BRCONNECT statistic

runs under ora<sid

To use it, you have either to copy the spfile to $ORACLE_HOME/dbs

or rename the file "init<sid>.ora" (e.g. to "init<sid>.ora.s") and

- using SQLPLUS - create pfile from spfile;

In that way, you can now create statistics.

Please check version of Oracle Instant Client 10.2 V3 from SAPMarketplace,

as per note #819829.

regards,

John Feely

[joo_migueldimas]

Hello John Feely,

That link is not missing...I checked and it actually exists!

It seems to me this problem is related with that problem 2 that is mentioned in note 1449619. It has mentioned this:

Problem 2

+----

---

+

The BRCONNECT statistic function cannot be started on Oracle 11g and under the user <sid>adm on HP-UX platforms.

My platform isn´t HP-UX... is Red Hat Enterprise Linux (X86_64) but the error is the same as mentioned for HP-UX. When I execute BRCONNECT update statistics it show exactly the same error... as you can see below:

<server>:d01adm 62> brconnect -u / -c -f stats -t all
BR0801I BRCONNECT 7.20 (7)
BR0301E SQL error -2133 at location BrOraThrEnable-1, SQL statement:
'ENABLE THREADS'

BR0806I End of BRCONNECT processing: ceeqkodc.sta 2010-11-25 11.45.28
BR0280I BRCONNECT time stamp: 2010-11-25 11.45.28
BR0804I BRCONNECT terminated with errors

But as mentioned in message above, for this problem 2 the solution isn´t for my platform and maybe because of it I can´t find the directory cd /usr/lib/hpux64 and also /usr/lib/pa20_64 (I have in my case two directory called /usr/lib/i386-redhat-linux4E and /usr/lib/x86_64-redhat-linux4E... but I don´t know if this is the same directory (for red hat) they wanted mentioned in the note 1449619)

In fact I have in /oracle/client/10x_64/instantclient the file libclntsh.so.10.1

Any other tips?

Kind regards,

João Dimas - Portugal

[Former Member]

Permissions are not right to your /usr/sap folder.

Is this new installation? have you installed the system with correct permissions? also are you able to exeucte any other job from DB13 ie dbcheck clean logs etc...

I suggest you must set the correct permission for your /usr/sap folder and sub folders as per help.sap.com/saphelp_nw04/helpdata/EN/0a/0a2e39ef6211d3a6510000e835363f/frameset.htm

all database related filesystem must have <ora>sid and dba as group.

[joo_migueldimas]

This wasn´t a new installation... this was a migration from windows/sql server to linux/oracle... and after that migration process I made an oracle upgrade to 11.2g and during this oracle upgrade we upgrade the BRtools to 7.20 version.

I set up other job from DB13 (Verify database) and also it not ran well, it show an error too, but a diferent one:

...

Parameters:-u / -jid VERIF20101110030000 -c force -w only_dbv -p initD01.sap -m ALL
BR0051I BRBACKUP 7.20 (7)
BR0055I Start of database backup: beeqitms.dbv 2010-11-25 03.00.06
BR0484I BRBACKUP log file: /oracle/D01/sapbackup/beeqitms.dbv
BR0477I Oracle pfile /oracle/D01/112_64/dbs/initD01.ora created from spfile /oracle/D01/112_64/dbs/spfileD01.ora

BR0068E SAP system is running or SAP user is connected to database D01 - database cannot be shut down
BR1025I Please shut down SAP system first or use the 'offline_force' option

BR0056I End of database backup: beeqitms.dbv 2010-11-25 03.00.09
BR0280I BRBACKUP time stamp: 2010-11-25 03.00.09
BR0054I BRBACKUP terminated with errors
External program terminated with exit code 3
BRBACKUP returned error status E

...

I also checked the permissions in /usr/sap folder and sub folders as per the link you put here... and everything is well... but tell me one thing which owner/group must have set in /usr/sap/ directory? In that help sap link it doesn´t show any suggestion in this column, so I don´t know in this case which owner and group must have set... In my case the /usr/sap/ and dba as group:

drwxr-xr-x 28 orad01 dba      4096 Nov 23 15:20 D01

Kind regards,

João Dimas - Portugal

[Former Member]

The permission for /usr/sap/<SID> has to be <SID>adm:sapsys

The logs you have given from DB13 for database verification is failing due to you are trying to verfiy database, but SAP can;t shutdown as normal mean you have to use parameter 'offline_force'

Try below command from your <SID>adm and see check the logs.

brconnect -u / -f check

[Former Member]

Hi,

As mentioned by Sunil Read the error message for DBVERIFY failure

BR1025I Please shut down SAP system first or use the 'offline_force' option

Reagrding the brconnect issue , i will suggest you to open a call with SAP-OSS as this is a known issue for HP_UX and might be they will provide workaround suitable to your environment.

Regards,

[joo_migueldimas]

Hello Sunil,

Forget this test that I made in DB13 for Verify Database... ofcourse it doesn´t run because the database isn´t stop!

It was a bad example... sorry!

Regarding the permission for /usr/sap/adm:sapsys, but this error in DB13 (BRCONNECT) may be caused by this?... it does not seems to be... this does not seems to have any relationship!

Best regards,

João Dimas - Portugal

[Former Member]

The issue may not be related with the permission on /usr/sap/<SID> but good to follow SAP standard practice to se the permission to <SID>adm:sapsys

[joo_migueldimas]

Ok Sunil Bujade,

I understand your point. Thank you. But by the away I want to understand why this happened, what was the reason to this path /usr/sap/adm and sapsys...?! You know? Because is very weird, I did the migration without errors... for example, without permission errors... which was supposed to occur during the installation of target side (importing DB phase). Certainly this was during the sap installation, sapinst decide itself how to manage all things that he create during the installation, so how this happens... he certainly did that with an intention!

?! If sap create this directory with this permissions setings I assumed it was correct, do not you think?

This changing that you recommended is not mentioned in installation guide at post-installation procedures neither in sap notes!

Kind regards

João Dimas - Portugal

[joo_migueldimas]

Hello,

I already know what was the error here... I checked the version of Oracle Instant Client (OIC), the version that we had installed here is the old 10.2.0.2 version (the first version of this OIC 10.2.0.2)!

Today I performed the update of oracle instant client (OIC) to version 10.2.0.4 V3. In fact this error was due to the version of OIC that was installed! The error was solved!

I guess John Feely, in a message above, said some words about this OIC, which could be the cause for this error... He was right, so I'll give him some points.

Thank you very much to all

Best regards,

João Dimas - Portugal

[Former Member]

Hi,

Is this oracle 11g , Note is there for this error

Note 1449619 - BR*Tools cannot be started on Oracle 11g

Regards,

[joo_migueldimas]

Hello Gagan,

Thank you very much for your answer... it helped me... but I didn´t apply yet the solution because as you understood my problem is describe as the problem 2 in that sap note... but they mentioned HP-UX platforms and not mentioned my platform... (Linux - Red Hat) So I don´t how to do the solution to the problem 2 because they mentioned /usr/lib/hpux64 and /usr/lib/pa20_64 and in my platform I don´t see any of this two paths... hpux64 or pa20_64!??

Can you help me... ? In which path I have to create a soft link in Linux platform (RHEL X86_64)

Kind regards,

João Dimas - Portugal