Re: File otrace/admin/process.dat hang my Oracle server

Pierre Didierjean wrote:
>
> Hello
>
> My server V7.3.2 hang when this file otrace/admin/process.dat
> is too big (7745120 bytes)
> The database won't start until i remove this file.
>
> I've got an 'oracle not available' error.
>
> Cordialement
>
> Pierre

Hi Pierre,
I guess you have not disabled a default tracing introduced in Oracle 7.3. Try the following workaround:

    Workaround on Unix:

1. Shut down all 7.3 databases.
2. Reinitialise the Oracle Trace output files:

                cd $ORACLE_HOME/otrace/admin 
                rm -f process.dat regid.dat 
                otrccref 
 
      3. Set the environment variable EPC_DISABLED to TRUE for all
users. 
         If you have a common environment script where ORACLE_HOME is
set 
         this is probably the best place to set this. 
         Eg: In a Bourne script: 
                EPC_DISABLED=TRUE; export EPC_DISABLED 
 
             In the C-Shell: 
                setenv EPC_DISABLED TRUE 
 
      4. Make sure any SQL*Net connections have EPC_DISABLED in the 
         environment. To ensure this you can modify the
'SID_LIST_listener' 
         clause in the 'listener.ora' file and add: 
 
                (ENVS='EPC_DISABLED=TRUE') 
 
         to the SID_DESC for each 7.3 database. Add the entry AFTER the 
         (ORACLE_HOME=...) clause. 
 
         Eg: 
            SID_LIST_LISTENER= 
             (SID_LIST= 
              (SID_DESC= 
                (SID_NAME=DB1) 
                (ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2) 
                (ENVS='EPC_DISABLED=TRUE') 
              ) 
              (SID_DESC= 
                (SID_NAME=DB2) 
                (ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2) 
                (ENVS='EPC_DISABLED=TRUE') 
              ) 
            ) 
 
        5. Restart and databases and SQL*Net listeners. 
 

Hope this helps!

-- 

Timo Haatainen
TT-Tieto Oy