.ora-code.com

Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
RE: [suse-oracle] Problem during an Import with Oracle 8.1.7.4.0
   on SuSE Linu

RE: [suse-oracle] Problem during an Import with Oracle 8.1.7.4.0
   on SuSE Linu

2004-08-23       - By Istiqfar

This indicates there is problem in the Oracle built-in package in target DB.
Try running catalog.sql & utlrp.sql first before re-import.

Rgds,

-isa.

-- --Original Message-- --
From: Dietmar Simons [mailto:dietmar.simons@(protected)]
Sent: Mon, 23 Aug 2004 15:54
To: suse-oracle@(protected)
Subject: [suse-oracle] Problem during an Import with Oracle 8.1.7.4.0 on
SuSE Linux 8. Prof


Hello,

can anybody help me?

We have a Problem during Import with Oracle 8.1.7.4.0.

We get following Output:
s02:/usr/local/bin # ./impuser8i X_DBA usrspkac skac.dmp
Oracle Profile
Import: Release 8.1.7.4.0 - Production on Mo Aug 23 10:36:11 2004
(c) Copyright 2000 Oracle Corporation.  All rights reserved.
Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
Export file created by EXPORT:V08.01.06 via conventional path
import done in WE8ISO8859P1 character set and WE8ISO8859P1 NCHAR character
set
IMP-00017: following statement failed with ORACLE error 4068:
 "BEGIN  SYS.DBMS_REPCAT_MIG.PRE_IMPORT; END;"
IMP-00003: ORACLE error 4068 encountered
ORA-04068 (See ORA-04068.ora-code.com): existing state of packages has been discarded
ORA-04063 (See ORA-04063.ora-code.com): package body "SYS.DBMS_REPCAT_MIG_INTERNAL" has errors
ORA-06508 (See ORA-06508.ora-code.com): PL/SQL: could not find program unit being called
ORA-06512 (See ORA-06512.ora-code.com): at "SYS.DBMS_REPCAT_MIG", line 95
ORA-06512 (See ORA-06512.ora-code.com): at line 1
IMP-00000: Import terminated unsuccessfully

Thanks a lot and bye.
Dietmar Simons
--
__ ____ ____ ____ ____ ____ ____ ____ ____ _____

Simons IT-Service
Dietmar Simons
Matthiasstr. 18a
41468 Neuss
Germany

Phone +49 2131 15 34 98
Fax   +49 2131 15 34 99
Mobil +49 172 253 05 23
Email dietmar.simons@(protected)
__ ____ ____ ____ ____ ____ ____ ____ ____ _____

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting