ORA-24550:

[Former Member]

Hi Basis Expert,

We have done oracle 11g (11.2.0.2) upgrade in one of our UAT ECC system.

As a part of post upgrade when executing

brconnect -u / -c -f stats -t all -f collect -p 4 we are getting ORA-24550: signal received: [si_signo=0] [si_errno=0] [si_code=0] [si_addr=115b d45b]

ORA-24550: signal received: [si_signo=4] [si_errno=0] [si_code=30] [si_addr=0]

Illegal instruction(coredump)

Here is the detail log

BR0280I BRCONNECT thread 4: time stamp: 2011-11-03 10.05.10

BR0884I Statistics collected for table: SAPUCM.NSHIFT_ID, rows old/new: 0/0

BR0280I BRCONNECT thread 3: time stamp: 2011-11-03 10.05.10

BR0881I Collecting statistics for table SAPUCM.NSLF with method/sample C ...

BR0280I BRCONNECT thread 4: time stamp: 2011-11-03 10.05.10

KPEDBG_HDL_PUSH_FCPTRMAXBR0881I Collecting statistics for table SAPUCM.NSWFEATU

E with method/sample C ...

KPEDBG_HDL_PUSH_FCPTRMAXBR0280I BRCONNECT thread 6: time stamp: 2011-11-03 10.0

.10

BR0884I Statistics collected for table: SAPUCM.NSIGH, rows old/new: 0/0

BR0280I BRCONNECT thread 6: time stamp: 2011-11-03 10.05.10

BR0881I Collecting statistics for table SAPUCM.NTFI with method/sample C ...

BR0280I BRCONNECT thread 2: time stamp: 2011-11-03 10.05.10

BR0884I Statistics collected for table: SAPUCM.NSL2, rows old/new: 0/0

BR0280I BRCONNECT thread 2: time stamp: 2011-11-03 10.05.10

BR0881I Collecting statistics for table SAPUCM.NTMN with method/sample C ...

ORA-24550: signal received: [si_signo=0] [si_errno=0] [si_code=0] [si_addr=115b

d45b]

ORA-24550: signal received: [si_signo=4] [si_errno=0] [si_code=30] [si_addr=0]

Illegal instruction(coredump)

Please help us know in fixing this issue

Regards,

Anil Shenoy

[sunny_pahuja2 · Accepted solution]

Hi,

Check below thread:

Thanks

Sunny

[Former Member · Accepted solution]

Hi Basis Expert,

We have not faced this issue in any other system where we have upgraded the DB to 11g.

This is the first time where we are facing this error.

Please let us know what to do in order to fix this issue.

Regards,

Anil Shenoy

[Former Member · Accepted solution]

Hi DatabaseSAP , Stefan and others,

Can you please help me for fixing this issue.

Our Enviroment details is as follows

OS- AIX 5.3

DB upgrade completed from 10.2.0.4 to 11.2.0.2

Regards,

Anil Shenoy

[stefan_koehler · Accepted solution]

Hello Anil,

we don't have any stack information so it is some kind of guessing, but it seems to be an issue with the "Diagnosability features" introduced in Oracle 11g and OCI.

To verify this - please add the following lines to the sqlnet.ora file and collect the statistics again.

shell>vi ${TNS_ADMIN}/sqlnet.ora
DIAG_ADR_ENABLED=OFF
DIAG_SIGHANDLER_ENABLED=FALSE
DIAG_DDE_ENABLED=FALSE

If the collection works fine now you hit oracle bug #9342118 - contact SAP support.

Regards

Stefan

[Former Member · Accepted solution]

Hi Stefan,

Thanks for your support.

The ORA-24550 issue is fixed.

Solution

After entering the below two parameters in sqlnet.ora which is in /oracle/<SID>/112_64/network/admin

DIAG_ADR_ENABLED=FALSE

DIAG_DDE_ENABLED=FALSE

Regards,

Anil Shenoy

[Former Member · Accepted solution]

Quick question.

Do the sqlnet.ora changes need to be made on the Database Server or on the client machine?

Thanks.

[Former Member]

Hi Anil,

Just to confirm, have you already applied latest patch for 11.2.0.2 (SBP and others) ?

And what is the BR*Tools version, do you face this kind of error only during this stats collect statement or during every brtools/brconnect operation ?

Thanks

[Former Member]

Hi DatabaseSAP,

Thanks for your reply.

We have applied SAP Bundle Patches in the system.

BRTOOLS version is 7.00 (40). This issue we are facing only when we are running statistics collect (brconnect -u / -c -f stats -t all -f collect -p 4)

But other BR* operation ( brconnect -u / -c -f stats -t system_stats and brconnect -u / -c -f stats -t oradict_stats were successful).

Regards,

Anil Shenoy