Error shutdown immediate database oracle 11 aix

[Former Member]

Hi experts,

I upgrade the DB Oracle 10.2.0.4 to Oracle 11.2.0.2

During the dbua, appear an error that stop the upgrade, when start the steps post-upgrades. So, i continue and execute manually the scripts post-upgrade. When finish, i continue with the necesarry steps and all work fine; i can work with SAP i can execute the brtools, i can check the db with the trx db13, ....

The problem is, when i stop the database with shutdown immediate appear this error:

ORA-01313: end-of-file on communication channel

and i can not start the DB again in the same session, i have to exit from sql and start it again. I have this same problem: http://

www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_4.shtml

When i execute shutdown immediate in te alert_SOL.log seems all correct; instead, in the trace SOL_ora_3801168.trc appear something strange (i attach to you):

• 2011-12-02 09:26:52.359

Exception [type: SIGSEGV, Address not mapped to object]

[ADDR:0x2880000128000003] [PC:0x10000B334, strncpy()+84] [flags: 0x0,

count: 5]

What happend? Is it a bug?

Thanks in advance,

Regards,

[former_member184473]

Hello,

Do you have the recommended parameters as per note [1431798|http://service.sap.com/sap/support/notes/1431798] (script of note [1171650|http://service.sap.com/sap/support/notes/1171650])?

Regards,

Eduardo Rezende

[Former Member]

Yes i have, I used the script parameter_check_112.txt

Regards,

[former_member184473]

Hello,

Is there any add/remove/change/check why mentioned in the result?

Regards,

Eduardo

[Former Member]

I change the parameters before i posted the message...

There were not changes...

Regards,

[Former Member]

Hi Victor,

I also ran into the same issue and also the environment is almost same. AIX6.1. Upgrade from Oracle 10.2.0.5 to Oracle 11.2.0.2.

I dont see any error except the below exception in trace file DEV_ora_21102760.trc

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2880000128000003] [PC:0x10000B334, strncpy()+84] [flags: 0x0, count: 1]

Did you solve this problem, if so could you help me with the solution.

Thanks & Regards,

N.Amarnath

[nicholas_chang]

Hi All,

I ran into this problem before, if i still recall correctly, is the memory problem. Could you please check your physical RAM and SWAP File? Do ensure it is large enough for oracle db memory.

Also, please check the system log of your OS.

Please let me know how it goes,

Cheers,

Nicholas Chang

Edited by: Nicholas Chang on Dec 15, 2011 6:50 PM

[Former Member]

SAP solved the problem.

The steps were:

I apply the AIX patch IFIX IV09580 and execute

cd $ORACLE_HOME/rdbms/lib

make -f ins_rdbms.mk install

But now, i have another problem; i can not start SAP system, when i try to execute disp+work appear this error:

Could not load program disp+work:

rtld: 0712-001 Symbol itsp_setitscookie was referenced

from module disp+work(), but a runtime definition

of the symbol was not found.

rtld: 0712-002 fatal error: exiting.

Regards,

[Former Member]

Hi Victor,

Thank you fo ryour response. I also raised this to SAP and waiting for response. But as you mentioned after applying this AIX fix you run into different problem. Could you please let me know the SAP kernel version you are using?

Thanks & Regards,

N.Amarnath

[Former Member]

I update with the last level, 150; but i continue with the same problem (i try wth different kernel version).

Im waiting for SAP response about this problem.

Regards,

[ramesh_badham2]

I also ran into the same issue while installing Netweaver PI 7.1.1 on AIX 6.1 and oracle 11.2.0.2.

Please let me know the solution.

[Former Member]

Hi,

The problem was solved.

The solution for the first error is apply the AIX patch; and the solution for the second error is update all kernel.

Regards,