部署informatica出现0ra 01280

之前在跨境电商项目中部署informatica，期间报错0ra 01280。百思不得其解，因当时数据库是新装，并未开始运行业务。只记得因为要部署ggs需要打补丁，会不会是补丁问题呢？

问了下同事说打好了补丁，姑且看一下执行的脚本。

后来发现跨界电商打补丁22576728，打完忘记运行postinstall.sql，导致部署informatica出现0ra 01280

其实补丁文档也说了

(II) Installation  

-----------------

To install the patch, follow these steps:

1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:

 $ cd <PATCH_TOP_DIR>/22576728

 $ opatch apply

2. Verify whether the patch has been successfully installed by running the following command:

 $ opatch lsinventory

3. Start the services from the Oracle home.

 

  

(III) Postinstallation

---------------------- 

The following steps load modified SQL files into the database. For a RAC environment, perform these steps on only one node.

1. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the below script as follows:

 $ sqlplus /nolog

 SQL> CONNECT / AS SYSDBA

 SQL> @?/sqlpatch/22576728/postinstall.sql

2. Check the output for any errors.

下面是在metalink上找到的

ORA-7445 [lnxsni()+1874] After Patch Installationl (文档 ID 2017872.1) 转到底部转到底部

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]

Information in this document applies to any platform.

SYMPTOMS

After installing new patches, applications issues are observed on multiple databases while raising next error:

ORA-07445: exception encountered: core dump [lnxsni()+1874] [SIGSEGV] [ADDR:0x0] [PC:0x90DAC72] [Address not mapped to object] []~ORA-01280: Fatal LogMiner error.

The call stack from the trace file shows functions like:

... lnxsni krviuld spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 psdextp pefccal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe ...

 

CHANGES

Interim patch was installed on the Oracle Home.

CAUSE

The issue is caused by a mismatch between the PL/SQL code in the database and the software version due to "postinstall.sql" not being executed after patch application.

 

The same is explained in

Bug 19520463 - ORA-07445 [LNXSNI+1874] closed as not a bug.

closed with status 'Not a Bug'.

SOLUTION

Make sure you have run the patch "postinstall.sql" or followed the proper steps in installing the patch you have applied.

 

REFERENCES

BUG:19520463 - ORA-07445 [LNXSNI+1874] WITH STARTING OGG TO IE MODE