Erman Arslan's Oracle Forum - Re: Error message: ORA-48913

Re: Error message: ORA-48913

Posted by Brian Hogantara on May 23, 2018; 1:12am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Error-message-ORA-48913-tp5965p6067.html

ok,

in DEVELOPMENT_ora_29179.trc contain trace information like this:

----------------------------------------------------------------------------
2018-05-23 07:15:20.164876 : --- TRACE CONFIGURATION INFORMATION FOLLOWS ---
2018-05-23 07:15:20.165989 : New trace stream is /u01/DEVELOPMENT/db/tech_st/11.2.0/admin/DEVELOPMENT_development-2/diag/rdbms/DEVELOPMENT/DEVELOPMENT/trace/DEVELOPMENT_ora_29179.trc
2018-05-23 07:15:20.166020 : New trace level is 16
2018-05-23 07:15:20.166044 : --- TRACE CONFIGURATION INFORMATION ENDS ---
2018-05-23 07:15:20.166067 : --- PARAMETER SOURCE INFORMATION FOLLOWS ---
2018-05-23 07:15:20.166123 : Attempted load of system pfile source /u01/DEVELOPMENT/db/tech_st/11.2.0/network/admin/DEVELOPMENT_development-2/sqlnet.ora
2018-05-23 07:15:20.166147 : Parameter source loaded successfully
2018-05-23 07:15:20.166169 :
2018-05-23 07:15:20.166190 : -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
2018-05-23 07:15:20.166212 : Successful parameter table load
2018-05-23 07:15:20.166233 : -> PARAMETER TABLE HAS THE FOLLOWING CONTENTS <-
2018-05-23 07:15:20.166257 : SQLNET.EXPIRE_TIME = 10
2018-05-23 07:15:20.166278 : TRACE_LEVEL_SERVER = SUPPORT
2018-05-23 07:15:20.166299 : TRACE_LEVEL_CLIENT = SUPPORT
-------------------------------------------------------------------------------

open the sqlnet.ora try to see what is written inside and compare it from production
and found a different value from production
on Development there is value like this :
++++++++++++++++++++++++
TRACE_LEVEL_CLIENT = SUPPORT
TRACE_LEVEL_SERVER = SUPPORT
++++++++++++++++++++++++
whether this can be one cause of error?

already check application tier and i'm sure enough that trace file has been disabled from application layer. you right about "Enabling sql trace in application layer also makes Oracle produce sql traces" and there's the message error created.