- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Database Export Over Network Connection
Operating System - HP-UX
1753531
Members
5482
Online
108795
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-25-2004 01:32 AM
тАО11-25-2004 01:32 AM
Oracle Database Export Over Network Connection
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.
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.
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-25-2004 01:37 AM
тАО11-25-2004 01:37 AM
Re: Oracle Database Export Over Network Connection
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)
******************************************************
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-25-2004 02:59 AM
тАО11-25-2004 02:59 AM
Re: Oracle Database Export Over Network Connection
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
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
fiat lux
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP