export / import beteen oracle 8.1.7 and 8.0.3 under VMS

From: Manser <nmanser_at_progis.de>
Date: 5 Nov 2002 04:04:29 -0800
Message-ID: <2178d61f.0211050404.5a5f7f54@posting.google.com>

Hi oracle users

i have the following system configuration

node 1 and node 2 are connected via TCPIP (wan)

sqlnet are configured on both sides, tnsnames.ora match in both nodes so connection via sqlplus is possible

+--------------+                                +--------------+
!    node1     !                                !   node2      !
! vms 7.3      !                                !  vms 7.2-1   !
! oracle SRV   !                                ! oracle SRV   !
!   8.1.7      !                                !   8.0.3      !
+--------------+                                +--------------+

catexp.sql and catexp7 were run both at node 1 and node 2

i want to transfer Data from node1 to node 2

i run on node 1 the export utility to create a dump file expdat.dmp i transfer this file via ftp in binary mode to node 2 at node 2 i run import to import the file NODE2> imp <username>/<password>

Import: Release 8.0.3.2.0 - Production on Fri Nov 1 0:8:40 2002

Connected to: Oracle8 Enterprise Edition Release 8.0.3.2.0 - Production
With the Partitioning and Objects options PL/SQL Release 8.0.3.2.0 - Production

Import file: DISK$ORACLE:[000000.IMPORTS]EXPDAT.DMP > Enter insert buffer size (minimum is 4096) 30720>

IMP-00010: not a valid export file, header failed verification
IMP-00021: operating system error - error code (dec 2, hex 0x2)
IMP-00000: Import terminated unsuccessfully

2) on node 2 i run the export utility against 8.1.7 (node 1)

NODE2> exp <username>/<password>@<db_name>.<db_domain>

Export: Release 8.0.3.2.0 - Production on Fri Nov 1 0:31:49 2002

%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=77774500000000E0, PC=0000000000668F40, PS=0000001B %TRACE-F-TRACEBACK, symbolic stack dump follows image module routine line rel PC abs PC
ORACLIENT64_V803 NTTUTIL nttbnd2addr

                                        84536 0000000000000AF0

0000000000668F40
ORACLIENT64_V803 NTAC ntacbnd2addr 80395 0000000000000384 000000000056FAC4
ORACLIENT64_V803 NSC2 nsc2addr 91273 0000000000000AA8 00000000005CF5B8
ORACLIENT64_V803 NSCALL nscall1 91477 0000000000000D88 00000000005D0468
ORACLIENT64_V803 NSCALL nscall 91254 000000000000059C 00000000005CFC7C
ORACLIENT64_V803 NRICALL nricdt 92178 0000000000001554 00000000005C02A4
ORACLIENT64_V803 NRICALL nricall 91909 0000000000000CC8 00000000005BFA18
ORACLIENT64_V803 NIO niotns 100006 0000000000005E24 000000000059D284
ORACLIENT64_V803 NIG nigcall 95089 0000000000000054 0000000000596954
ORACLIENT64_V803 NIGCON osncon 96370 0000000000000CEC 000000000057897C
ORACLIENT64_V803 UPIPRV upiini 194027 0000000000000FCC 00000000004A351C
ORACLIENT64_V803 UPICDC upiah0 169170 00000000000000C8 00000000004A3CA8
ORACLIENT64_V803 UPICDC upiahm 169222 0000000000000154 00000000004A3D34
ORACLIENT64_V803 KPU kpuatch 268352 0000000000000848 00000000004795D8
ORACLIENT64_V803 OCI8 OCIServerAttach

                                       162404 0000000000000194
0000000000493384
 EXP  EXULON  exulon                   259471 0000000000000684
00000000000C5584
 EXP  EXUDRV  main                     259952 00000000000007E8
00000000000B07E8
 EXP  EXUDRV  __main                        0 000000000000006C
00000000000B006C
 PTHREAD$RTL                                0 0000000000030E7C
000000007BC04E7C
 PTHREAD$RTL                                0 0000000000012B48
000000007BBE6B48
                                            0 FFFFFFFF84CBD3D4

FFFFFFFF84CBD3D4 3) i try the same with the import utility

NODE2> imp <username>/<password>@<db_name>.<db_domain>

Import: Release 8.0.3.2.0 - Production on Fri Nov 1 0:32:3 2002

%SYSTEM-F-ACCVIO, access violation, reason mask=00, virtual address=77774500000000E0, PC=0000000000648F40, PS=0000001B %TRACE-F-TRACEBACK, symbolic stack dump follows image module routine line rel PC abs PC
ORACLIENT64_V803 NTTUTIL nttbnd2addr

                                        84536 0000000000000AF0

0000000000648F40
ORACLIENT64_V803 NTAC ntacbnd2addr 80395 0000000000000384 000000000054FAC4
ORACLIENT64_V803 NSC2 nsc2addr 91273 0000000000000AA8 00000000005AF5B8
ORACLIENT64_V803 NSCALL nscall1 91477 0000000000000D88 00000000005B0468
ORACLIENT64_V803 NSCALL nscall 91254 000000000000059C 00000000005AFC7C
ORACLIENT64_V803 NRICALL nricdt 92178 0000000000001554 00000000005A02A4
ORACLIENT64_V803 NRICALL nricall 91909 0000000000000CC8 000000000059FA18
ORACLIENT64_V803 NIO niotns 100006 0000000000005E24 000000000057D284
ORACLIENT64_V803 NIG nigcall 95089 0000000000000054 0000000000576954
ORACLIENT64_V803 NIGCON osncon 96370 0000000000000CEC 000000000055897C
ORACLIENT64_V803 UPIPRV upiini 194027 0000000000000FCC 000000000048351C
ORACLIENT64_V803 UPICDC upiah0 169170 00000000000000C8 0000000000483CA8
ORACLIENT64_V803 UPICDC upiahm 169222 0000000000000154 0000000000483D34
ORACLIENT64_V803 KPU kpuatch 268352 0000000000000848 00000000004595D8
ORACLIENT64_V803 OCI8 OCIServerAttach

                                       162404 0000000000000194
0000000000473384
 IMP  IMPLON  implon                   177779 0000000000000664
00000000000B2974
 IMP  IMPDRV  main                     178285 000000000000075C
00000000000A075C
 IMP  IMPDRV  __main                        0 000000000000006C
00000000000A006C
 PTHREAD$RTL                                0 0000000000030E7C
000000007BC04E7C
 PTHREAD$RTL                                0 0000000000012B48
000000007BBE6B48
                                            0 FFFFFFFF84CBD3D4

FFFFFFFF84CBD3D4 4) on node 1 i try the following

NODE1> exp <username>/<password>@<db_name>.<db_domain>

Export: Release 8.1.7.0.0 - Production on Fri Nov 1 00:07:12 2002

EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully

5) NODE1> imp <username>/<password>@<db_name>.<db_domain>

Import: Release 8.1.7.0.0 - Production on Fri Nov 1 00:02:16 2002

IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00023: Import views not installed, please notify your DBA
IMP-00000: Import terminated unsuccessfully

can someone tell me what's going wrong ? any help is greatly appreciated.

reguards

Nazim Manser Received on Tue Nov 05 2002 - 06:04:29 CST