Re: exp result in process death

In article <907vpt$tau$1_at_nnrp1.deja.com>,   chiappa_at_my-deja.com wrote:
> Since some days ago, using in the night full export, I receive an
 error
> refering timeout disconnect in the export log files, and in the alert
> log I receive the following :
> "found dead multi-threaded server 'S001', pid = (15, 75) ".
> It begun only before I alter the exp batch to use direct=y
> This is the relevant exp command-line used in the batch :
> ...
> nomearq_prod="./export_files/prod/prod'date | awk '{print $6 "_"
 $2 "_"
> $3}''.dmp"                     
> ..
> exp system/manager_at_prod full=y file=$nomearq_prod log=prod.log
 direct=y
>
> and these (just for the case) r the relevant init params :
>
> NAME                            VALUE             ISDEFAULT ISMOD
 ISADJ
> ------------------------------- ------------------ --------- ----- ---
 --
> mts_dispatchers                (ADDRESS=(PARTIAL= FALSE    FALSE FALSE
>                                yes)(PROTOCOL=ipc)
>                                ),1
>
> _mts_fastpath                   TRUE               TRUE      FALSE
 FALSE
> mts_listener_address            (ADDRESS=(PROTOCOL FALSE    FALSE
 FALSE
>                                =ipc)(KEY=prod))
>
> _mts_listener_retry             120                TRUE      FALSE
 FALSE
> _mts_load_constants             3,0.75,0.25,0.1    TRUE      FALSE
 FALSE
> mts_max_dispatchers             10                FALSE    FALSE FALSE
> mts_max_servers                10                FALSE    FALSE FALSE
> mts_multiple_listeners          FALSE             TRUE      FALSE
 FALSE
> mts_servers                     1                  FALSE    FALSE
 FALSE
> mts_service                     prod               FALSE    FALSE
 FALSE
>
> and the .ora files (only listener and tnsnames - no sqlnet.ora here in
> the server)
>
> prod:/oracle/soft/network/admin> cat listener.ora
> #
> # Installation Generated Net V2 Configuration
> # Version Date: Sep-16-97
> # Filename: Listener.ora
> #
> LISTENER =
> (ADDRESS_LIST =
>        (ADDRESS= (PROTOCOL= IPC)(KEY= prod))
>        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
>        (ADDRESS= (PROTOCOL= TCP)(Host= bbvrs03)(Port= 1521))
> )
> SID_LIST_LISTENER =
> (SID_LIST =
>     (SID_DESC =
>       (GLOBAL_DBNAME= bbvrs03.)
>       (ORACLE_HOME= /oracle/soft)
>       (SID_NAME = prod)
>       (ENVS='EPC_DISABLED=TRUE')
>     )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
>
> prod:/oracle/soft/network/admin> cat tnsnames.ora
> #
> # Installation Generated NetV2 Configuration
> # Version Date: Sep-30-97
> # Filename: Tnsnames.ora
> #
> prod =
> (DESCRIPTION =
>     (ADDRESS = (PROTOCOL= TCP)(Host= bbvrs03)(Port= 1521))
>     (CONNECT_DATA = (SID = prod))
> )
> desa =
> (DESCRIPTION =
>     (ADDRESS = (PROTOCOL= TCP)(Host= bbvrs04)(Port= 1521))
>     (CONNECT_DATA = (SID = desa))
> )
> trad =
> (DESCRIPTION =
>     (ADDRESS = (PROTOCOL= TCP)(Host= bbvrs04)(Port= 1521))
>     (CONNECT_DATA = (SID = trad))
> )
>                               
> Oracle 7.3.4.5, AIX 4.3.3, 1 Gb RAM IBM F50 Risc machine here.
>
> []s
>        Jose Laurindo Chiappa
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Add
export ORACLE_SID=prod
leave out @prod in the export command
and you will bypass sqlnet completely.

Also I do think you should export using a dedicated connection.

Create an extra alias in your tnsnames.ora with the same parameters as prod and add (server=dedicated) before the last closing )

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.