exp result in process death

From: <chiappa_at_my-deja.com>
Date: Fri, 01 Dec 2000 10:50:37 GMT
Message-ID: <907vpt$tau$1@nnrp1.deja.com>

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. Received on Fri Dec 01 2000 - 04:50:37 CST