topic Re: Oracle Database Export Over Network Connection in Operating System - HP-UX

Oracle Database Export Over Network Connection

Adrian Sobers2 — Thu, 25 Nov 2004 09:32:53 GMT

I have two Oracle Databases. Here is setup.

Testing Server (8.0.5.2) INLAND3
Production Server (8.1.7.4) inland8

Both are 64-bit running on HP-UX 11.00 and 11.11 respectively. I can tnsping test database from production. I can also tnsping production database from test. So the tnsnames.ora files are both correct.

I want to use 8.0.5.2 export utility to connect to production database so that I can get an 8.0.5.2 dmp file. However when I run the export:

exp uname/pwd@PROD_DB

it starts and then I get an error saying oracle core dump and something lots of hex and dec numbers and symbols, then it returns prompt.

Does anyone know what could be wrong here? Thanks so much for your help.

Re: Oracle Database Export Over Network Connection

Adrian Sobers2 — Thu, 25 Nov 2004 09:37:52 GMT

Part of Error:

******************************************************
HEAP DUMP heap name="Alloc environm" desc=0x40094270
extent sz=0x1028 alt=32 het=32767 rec=0 flg=3 opc=3
parent=0 owner=0 nex=0 xsz=0x50b8
EXTENT 0
Chunk 4009faa8 sz= 18856 free " "
Chunk 400a4450 sz= 304 freeable assoc with mark prv=0 nxt=0
Chunk 400a4580 sz= 1448 free " "
Chunk 400a4b28 sz= 24 freeable assoc with mark prv=0 nxt=0
Chunk 400a4b40 sz= 24 freeable assoc with mark prv=0 nxt=0
EXTENT 1
Chunk 4009c5c8 sz= 13512 freeable "Alloc server h " ds=4009c548
EXTENT 2
Chunk 4009b5a0 sz= 24 perm "perm " alo=24
Chunk 4009b5b8 sz= 1264 recreate "Alloc server h " latch=0
ds 4009c548 sz= 14776
4009c5c8 sz= 13512
Chunk 4009baa8 sz= 440 freeable assoc with mark prv=0 nxt=0
Chunk 4009bc60 sz= 1368 freeable assoc with mark prv=0 nxt=0
Chunk 4009c1b8 sz= 368 freeable assoc with mark prv=0 nxt=0
Chunk 4009c328 sz= 648 freeable assoc with mark prv=0 nxt=0
Total heap size = 38280
FREE LISTS:
Bucket 0 size=272
Bucket 1 size=528
Bucket 2 size=1040
Chunk 400a4580 sz= 1448 free " "
Chunk 4009faa8 sz= 18856 free " "
Total free space = 20304
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Chunk 4009b5a0 sz= 24 perm "perm " alo=24
Permanent space = 24
******************************************************
Hla: 0

kgepop: no error frame to pop to for error 0
Bus error(coredump)

Re: Oracle Database Export Over Network Connection

Jean-Luc Oudart — Thu, 25 Nov 2004 10:59:31 GMT

Hi Adrian,

did you run the old catexp.sql in the source database before you run the "old" exp utility ?

cf. Metalink note 158845.1

Regards
Jean-Luc