Error ORA-03137 & ORA-12012

[Brian Hogantara]

Hi Erman,


i want to ask you about alert log from my database, i'm using oracle database 11g

alert.log

Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/trace/PROD_ora_17693.trc  (incident=2307):
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code
Incident details in: /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/incident/incdir_2307/PROD_ora_17693_i2307.trc
-------------------------------------------------------------------------------------------
Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/trace/PROD_j000_13184.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_10082"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538

any suggestErrors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/trace/PROD_ora_17693.trc  (incident=2307):
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code
Incident details in: /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/incident/incdir_2307/PROD_ora_17693_i2307.trc

Errors in file /u01/PROD/db/tech_st/11.2.0/admin/PROD_production-ebs-2/diag/rdbms/prod/PROD/trace/PROD_j000_13184.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_10082"
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ADVISOR", line 201
ORA-06512: at "SYS.DBMS_SPACE", line 2276
ORA-06512: at "SYS.DBMS_SPACE", line 2538

how to fix this issue? any suggestion?

[ErmanArslansOracleBlog]

Client / server message exchanges use an Oracle specific protocol (TTC). ORA-3137 is reported if something unexpected is seen that does not conform to the expected protocol

What is your client version ? (Oracle Client version?)
What is your DB version?
Seems like a bug..

Here is a bug reference: Bug 14489591  ORA-3137 [3149] on server due to bad bind attempt in client
and another one : Bug 13087066 - ORA-3137 [3149] - superseded fix (Doc ID 13087066.8)

Also, check the client code as it is likely binding an invalid or over large value.

[ErmanArslansOracleBlog]

For your ORA-12012 error, the base error is "ORA-06502: PL/SQL: numeric or value error "

Here is the document for it -> Bug 13840704 - ORA-12012 / ORA-6502 from Segment Advisor (DBMS_SPACE/DBMS_ADVISOR) for LOB segments (Doc ID 13840704.8)

[Brian Hogantara]

i believe my DB version is 11.2.0.3 so on client version

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit
PL/SQL Release 11.2.0.3.0
CORE    11.2.0.3.0
TNS for xxxxx: Version 11.2.0.3.0
NLSRTL Version 11.2.0.3.0

regarding to (Doc ID 13087066.8) it's bug 14489591 and to solved this issue patching from patch 14489591 in database tier must be done using opatch utility. am i right? is this bug mandatory to be resolved?

[ErmanArslansOracleBlog]

You should do your plan for applying it..
First apply it on your TEST instance, then apply it on your PROD accordingly.

[Brian Hogantara]

ok,
first i try to create clone and patching on TEST instance, see the alert log if the message error is gone then apply it on PROD.

for error ORA-12012 i thing it's only because of Datatypes(LOBs/CLOB/BLOB/BFILE) so none workaround needed

Thanks Erman

[Brian Hogantara]

after patching using opatch utility result show with complete warning.

--------------------------------------------------------------
Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ld: warning: symbol '_start' has differing types:
        (file /u01/DEVNEW/db/tech_st/11.2.0/lib/prod/lib/v9/crt1.o type=FUNC; file /u01/DEVNEW/db/tech_st/11.2.0/lib//libserver11.a(skds.o) type=OBJT);



Verifying the update...
Patch 14489591 successfully applied
OPatch Session completed with warnings.
Log file location: /u01/DEVNEW/db/tech_st/11.2.0/cfgtoollogs/opatch/14489591_Apr_18_2018_12_51_12/apply2018-04-18_12-51-11PM_1.log

OPatch completed with warnings.

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

i give you log to.
apply2018-04-18_12-51-11PM_1.log

[ErmanArslansOracleBlog]

Your DB server is Solaris right?

Check this -> "ld: warning: symbol `_start' has differing types:" While Installing or Patching 11gR2 or 11gR1 on Oracle Solaris (Doc ID 1446945.1)

[Brian Hogantara]

Thanks erman, the issue was solved using 2 patch from the doc you give to me :)

[ErmanArslansOracleBlog]

Good

20 Nis 2018 Cum 05:43 tarihinde Brian Hogantara [via Erman Arslan's Oracle Forum] <[hidden email]> şunu yazdı:

Thanks erman, the issue was solved using 2 patch from the doc you give to me :)

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Error-ORA-03137-ORA-12012-tp5670p5722.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML