Error ORA-03137 & ORA-12012

Posted by Brian Hogantara on Apr 16, 2018; 1:49am
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Error-ORA-03137-ORA-12012-tp5670.html

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?