[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Oracle Designer Repository - replication question.

Posted on 2004-11-03
4
Medium Priority
?
3,194 Views
Last Modified: 2013-12-03
Hi all

I have a designer repository installed at work. I am looking to replicate the repository at my designer instance at home.

What is the best way to do this ?


Thanks


Leon
0
Comment
Question by:Leon5178
  • 3
4 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 2000 total points
ID: 12481448
I would use export/import option in RON. But export to a text file not to a database ...
0
 

Author Comment

by:Leon5178
ID: 12481790
I attempt to do a text export like you say to a text file but the program RON crashes at 96% every time. Have you encountered this problem ?

Is there any other way to do an export ?


Thanks


Leon
0
 
LVL 22

Assisted Solution

by:Helena Marková
Helena Marková earned 2000 total points
ID: 12482406
This export/import is rather buggy.
This experience is from this question -http://www.experts-exchange.com/Databases/Oracle/Q_21084361.html?query=designer&topics=43-
"Ok, it was something wrong with the "Container" field in the Summary Information. I removed it, exported it, imported it, and all ok."
0
 
LVL 22

Assisted Solution

by:Helena Marková
Helena Marková earned 2000 total points
ID: 12542159
Here is Note:160378.1 from Metalink, I hope this will help you:

Common causes of CDI-22582 during export/import in Designer 6i and 9i

Generic issues related to the following error message when using the IMP/EXP utilities:

CDI-22582 - Error occurred running the export/import utility.

CONTENTS
--------

1. Import/Export Utilities used against an older database version
2. The dmp-file has been created by a newer export utility then you try to import with
3. You did not install Designer 6i and 8.1.7 export/import tools into a different Home
4. Ocx Pack has not been installed at client in a Network Installation
5. The value of the registry setting for execute_export/execute_import is not valid
6. The path specified for .ERR or .DMP file is not valid
7. The tnsnames.ora file used by the export utility does not contain an entry for the repository database.
8. A pre-release 6.5 export is imported into a 6.5 repository
9. You tried to import a full user export from the Repository Object Navigator
10. You do not have DBA or IMP_FULL_DATABASE privileges trying to import a DBA export
11. You have set ORACLE_HOME in the Environment

1. Import/Export Utilities used against an older database version
-----------------------------------------------------------------

Problem:
--------
In Designer 9i Repository Object Navigator connected to an 8.1.7 Repository Database, you try to export an Application System. Trying to export, Repository Object Navigator fails with
CDI-22582 - Error occurred running the export utility.

Check log file d:\work\errlog.err

errlog.err contains the following error message:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

JServer Release 8.1.7.0.1 - Production

EXP-00056: ORACLE error 942 encountered

ORA-00942: table or view does not exist

EXP-00000: Export terminated unsuccessfully

Explanation:
------------
Designer 9i uses the 9.0.1 export/import utilities by default.
You cannot use the 9.0.1 export/import utilities against an 8.1.7 database.

Solution:
---------
If not already installed, install the 8.1.7 export/import utilities from the Oracle 8i Release 3 (8.1.7) Client Cd into a new Oracle Home.
In the Registry, change [hklm]\software\oracle\HOMEx\repos61\EXECUTE_EXPORT
and EXECUTE_IMPORT to point to the 8.1.7 export/import utitilites.
(HOMEx corresponds to your Designer 9i Oracle Home)

A typical value for them would be:
EXECUTE_EXPORT=d:\des_817\bin\exp.exe
EXECUTE_IMPORT=d:\des_817\bin\imp.exe

or

EXECUTE_EXPORT=d:\V817\bin\exp.exe
EXECUTE_IMPORT=d:\V817\bin\imp.exe

After changing the parameters in the Registry, verify if they are active by going into the Repository Administration Utility, Check Requirements,Parameter Settings and look for EXECUTE_EXPORT and EXECUTE_IMPORT.

References:
-----------
Note:132904.1 Compatibility Matrix for Export & Import Between Different Oracle Versions

2. The dmp-file has been created by a newer export utility then you try to import with
---------------------------------------------------------------------------

Problem:
--------
Using Designer 6i you try to import a dumpfile which has been created by Designer 9i. Repository Object Navigator fails with

CDI-22582 - Error occurred running the export utility.

Check log file d:\work\errlog.err

errlog.err shows:

Connected to: Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production

JServer Release 9.0.1.3.0 - Production

IMP-00010: not a valid export file, header failed verification

IMP-00000: Import terminated unsuccessfully

Explanation:
------------
Designer 6i uses the 8.1.7 export utility by default. You cannot use the 8.1.7 import utility to import a dumpfile created by the 9.0.1 export utility.

Solution:
---------
If not already installed, install the 9.0.1 export/import utilities from the Oracle 9i Release 1 (9.0.1) Client Cd into a new Oracle Home.
In the Registry, change [hklm]\software\oracle\HOMEx\repos61\EXECUTE_EXPORT
and EXECUTE_IMPORT to point to the 8.1.7 export/import utitilites.
(HOMEx corresponds to your Designer 6i Oracle Home)

A typical value for them would be:

EXECUTE_EXPORT=d:\des9i\bin\exp.exe
EXECUTE_IMPORT=d:\des9i\bin\imp.exe

or

EXECUTE_EXPORT=d:\V901\bin\exp.exe
EXECUTE_IMPORT=d:\V901\bin\imp.exe

After changing the parameters in the Registry, verify if they are active by going into the Repository Administration Utility, Check Requirements,Parameter Settings and look for EXECUTE_EXPORT and EXECUTE_IMPORT.

References:
-----------
Note:132904.1 Compatibility Matrix for Export & Import Between Different Oracle Versions

3. You did not install Designer 6i and 8.1.7 export/import tools into a different Home
---------------------------------------------------------------------

Problem:
--------
Application Export from the Repository Object Navigator starts and stops immediately without producing any file. The RON displays a dialog with the following message:

CDI-22582 Error occured running the export utility. Check log file errlog.err

The errlog.err file contains the following lines:

EXP-00056:

EXP-00000: Export terminated unsuccessfully

Explanation:
------------
Designer 6i needs two Oracle Homes:

- one Oracle Home, based on the 8.0.6 tools stack, for the Designer 6i software in itself
- another Oracle Home, based on the 8.1.7 tool stack, for the Export/Import utilities, used by the RON for example when exporting/importing application systems.

Mixing 8.1.7-based and 8.0.6-based Oracle Homes can result in unpredictable results, such as the one described in this note. Therefore, make sure to have two Oracle Homes containing the appropriate client software and then the export/import works fine.

Solution:
---------
This is a client side installation issue. Make sure the Oracle 8i Export/Import utilities are installed in an own Oracle Home. Do NOT install any Oracle Products into this Oracle Home.

To solve it:
1) De-install Designer 6i client software
2) De-install Oracle8i Export/Import utilities
3) Install Designer 6i client software into its own Oracle Home
4) Install Oracle8i Export/Import utilities (shipped with Designer 6i) into a new Oracle Home, different from Designer 6i's Oracle Home.

References:
-----------
Designer 6i Installation Guide, Chapter 1, Client-side installation

4. Ocx Pack has not been installed at client in a Network Installation
----------------------------------------------------------------------

Problem:
--------
Importing an application in the Repository Object Navigator fails with
CDI-22582 - Error occurred running the export utility.

Check log file errlog.err.

The error refers to "export" even though the error occurs on import.

You are using Designer 6i at a client while the software has been installed on the network.

Explanation:
------------
Even when the designer software has been installed on the network, you must make some specific setup steps on every client. For example the ocx-files must be registered, otherwise this can lead to unpredicted results like export/import is failing.

Solution:
---------
See Oracle Designer 6i Installation Guide, Chapter 3 Installing on a local area network, Step 6 - Install OCX files
You need to be a user with write access to the file server to carry out this step.
Run Oracle Installer from the client workstation and select Custom mode to display the Software Asset Manager window. In the Available Products list, double-click Product Components, select the product named Oracle OCX Pack and click Install. Doing so will also register the Oracle OCXs in the HKEY_CLASSES_ROOT subtree of the registry.

References:
-----------
Oracle Designer 6i Installation Guide, Chapter 3 Installing on a local area network

Step 6 - Install OCX files

5. The value of the registry setting for execute_export/execute_import is not valid
----------------------------------------------------------------------

Problem:
--------
Trying to export an Application System from the Repository Object Navigator you get:

CDR-22612: Executable file d:\des_817\bin\exp1.exe

USERID=des6i/des6i@lin817.world PARFILE=D:\TEMP\ckronexp.tmp not found

CDI-22582 - Error occurred running the export utility.

Check log file errlog.err.

Explanation:
------------
The value of the registry setting for Export/Import Utilities has been modified or the Export/Import Utilities has been removed or deinstalled.

Solution:
---------
The value of the following registry setting is invalid or points to non-existing export/import utilities:
Hkey_Local_Machine\software\oracle\Homex\repos61\EXECUTE_EXPORT or

EXECUTE_IMPORT is invalid.

(HOMEx corresponds to your Designer 6i Oracle Home)

If not already installed, install the corresponding export/import utilities from the Oracle Rdbms Client Cd into a new Oracle Home.
For Designer 6i install the 8.1.7 client, for Designer 9i install the 9.0.1 client.

In the Registry, change [hklm]\software\oracle\HOMEx\repos61\EXECUTE_EXPORT and EXECUTE_IMPORT to point to the export/import utitilites.

A typical value for them would be:

EXECUTE_EXPORT=d:\des9i\bin\exp.exe
EXECUTE_IMPORT=d:\des9i\bin\imp.exe

or

EXECUTE_EXPORT=d:\V901\bin\exp.exe
EXECUTE_IMPORT=d:\V901\bin\imp.exe

After changing the parameters in the Registry, verify if they are active by going into the Repository Administration Utility, Check Requirements, Parameter Settings and look for EXECUTE_EXPORT and EXECUTE_IMPORT.

6. The path specified for .ERR or .DMP file is not valid
--------------------------------------------------------

Problem:
--------
When trying to export an Application System from the Repository Object Navigator, you get the following error message:

CDI-22582- Error occurred running the export utility.

Check log file d:\wor\errlog.err

The errlog.err does not exist in the specified directory.

Explanation:
------------
- The path specified for .ERR or .DMP file is not valid:

- it does not exist
- the current OS user does not have write privileges on the directory
- the filesystem you tried to write onto is full

Solution:
---------
You find out, that the directory d:\wor does not exist, you do not have write permission on it or the filesystem containing it is full. Retry the export and specify an existing directory where you have write permission on and which has sufficient free space.

7. The tnsnames.ora file used by the export utility does not contain an entry for the repository database.
-----------------------------------------------------------------------

Problem:
--------
In the Repository Object Navigator (RON), the following error message occurs when you export an application system:

CDI - 22582 - Error occured running the export utility.

Check log file errlog.err

The log contains the following:

EXP-00056: ORACLE error 12154 encountered

ORA-12154: TNS:could not resolve service name

EXP-00000: Export terminated unsuccessfully

Explanation:
-------------
This error occurs if an entry for the repository database is not included in the tnsnames.ora file used by the Oracle Client Tools.

Solution:
---------
Ensure the tnsnames.ora file used is the correct one and contains an entry for the repository database.

a) Make the file tnsnames.ora in the following directory:

<Oracle Client Tools home>\network\admin

identical to the file tnsnames.ora in the following directory:

<Oracle Designer home>\net80\admin

b) Alternatively, you can use the registry string value TNS_ADMIN to point to the correct tnsnames.ora file:

- Add the registry string value TNS_ADMIN to the following registry key:

[hklm]\software\oracle\homeX

where homeX refers to the oracle home in which the Oracle Client tools (among which exp.exe) reside.

- The value of this registry string should point to the directory in which the tnsnames.ora file resides that is used to start Designer.

8. A pre-release 6.5 export is imported into a 6.5 repository
-------------------------------------------------------------

Problem:
--------
In Repository Object Navigator you try to import an Application Export created by Designer 1.3.2, 2.1.2 or 6.0. You get:

CDI-22582 - Error occurred running the export utility.

Check log file errlog.err

in errlog.err you see:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

JServer Release 8.1.7.0.1 - Production

Export file created by EXPORT:V08.00.05 via conventional path

Warning: the objects were exported by DES60, not by you

import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set

. importing DES60's objects into DES6I

IMP-00033: Warning: Table "XTSYS_EXPORT_OBJECTS" not found in export file

IMP-00033: Warning: Table "XTSYS_IMPORT_IRID_MAPPING" not found in export file

IMP-00033: Warning: Table "XTSYS_IMPORT_IVID_MAPPING" not found in export file

IMP-00033: Warning: Table "XTSYS_TABS_EXPORTED" not found in export file

IMP-00033: Warning: Table "XTSYS_RM$REPOSITORIES" not found in export file

Import terminated successfully with warnings.

Explanation:
------------
There is no way to restore an archive file exported from Designer 1. 3.2,2.1.2 or 6.0 to Designer 6.5. The changes in the repository structure between Designer 6.5 and the previous releases are so important that it's not possible to archive application systems from previous releases of Designer and restore them into Designer 6.5.

Solution:
---------
Instead of importing using Ron, you can use the 'Migration Wizard':

a. in the RAU (Repository Administration Utility), click button 'Migration'
b. enter a Username, Password and Connect String to connect to your old repository
c. enter the name of the new workarea where you want the applications to be migrated to
d. click button 'Start Migration...'
e. select the applications you want to be migrated to the new workarea and click the 'OK' button.

9. You tried to import a full user export from the Repository Object Navigator
------------------------------------------------------------------------------

Problem:
--------
You have a full user export dump file done by the Repository Owner and you are trying to import it into the Designer Repository from the RAU (Repository Administration Utility). The IMPORT button is not available in RAU. You then go to RON (Repository Object Navigator) and then try to use the IMPORT utility from there. You get the following error messages:

CDI-22582 - Error occurred running the export utility.

Check log file errlog.err

in errlog.err you see:

Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production

JServer Release 8.1.7.0.1 - Production

Export file created by EXPORT:V08.00.05 via conventional path

Warning: the objects were exported by DES60, not by you

import done in WE8ISO8859P1 character set and US7ASCII NCHAR character set

. importing DES60's objects into DES6I

IMP-00033: Warning: Table "XTSYS_EXPORT_OBJECTS" not found in export file

IMP-00033: Warning: Table "XTSYS_IMPORT_IRID_MAPPING" not found in export file

IMP-00033: Warning: Table "XTSYS_IMPORT_IVID_MAPPING" not found in export file

IMP-00033: Warning: Table "XTSYS_TABS_EXPORTED" not found in export file

IMP-00033: Warning: Table "XTSYS_RM$REPOSITORIES" not found in export file

Import terminated successfully with warnings.

Explanation:
------------
The reason for failure is because:

a. You can only IMPORT the whole repository from RAU and before you do that, the old repository should be deleted first. If the IMPORT button is not available then it means that there is already a repository existing and you cannot import another one.

b. In RON it gives you the above messages because you can ONLY import individual applications and not the whole repository. The export file which you have contains the whole repository. In RON it is assumed that you already have a repository installed.

Solution:
---------
Use IMPORT/EXPORT from RAU for the complete Import and Export of the repository, including the repository objects.
Use IMPORT/EXPORT from RON for the Import and Export of applications and not of the whole repository.
To determine the type of export file you have (either full repository export or container export), you can list the content of the dump file using the IMP utility in a DOS box as dscribed below:

> imp userid=<user>/<password>@<alias> file=<dump file name> full=y show=y

This will not create nor import any object into the database: it only describes the content of the export file.

For example, if the export file list shows the following statements:

"CREATE TABLE "XTSYS_EXPORT_OBJECTS" ...

"CREATE TABLE "XTSYS_IMPORT_IRID_MAPPING" ...

"CREATE TABLE "XTSYS_IMPORT_IVID_MAPPING" ...

...

This means it is a container export: tables names are XT_ and XTSYS_

As opposite, if the export file list shows the following statements:

"CREATE TYPE "JR_NUM_LIST" ...

"CREATE TYPE "JR_STR_LIST" ...

"CREATE TYPE "SDD_ACC_PRIV_LIST" ...

"CREATE TYPE "SDD_SYS_PRIV_LIST" ...

"CREATE SEQUENCE "CDB_LOG_SESSION" ...

"CREATE SEQUENCE "CDI_TMP_RPT_SEQ" ...

...

"CREATE TABLE "CDDL_TMP_TBL" ...

"CREATE UNIQUE INDEX "TMP_DDL_TBL_PRIME" ...

...

Then it is likely to be a full export of a 6i Repository.

References:
-----------
Note:114875.1 Repository Administration Utility - New features in Designer 6i

10. You do not have DBA or IMP_FULL_DATABASE privileges trying to import a DBA export
------------------------------------------------------------------------

Problem:
--------
In the Repository Object Navigator (RON), you try to import a workarea or a container export using the menu 'Utilities' -> 'Import...' and get the following error message:

CDI-22582 - Error occurred running the export utility.

Check log file errlog.err.

The logfile 'errlog.err' looks like this:

Connected to: Oracle9i Enterprise Edition Release 9.0.1.3.0 - Production

JServer Release 9.0.1.3.0 - Production

Export file created by EXPORT:V08.01.07 via conventional path

IMP-00013: only a DBA can import a file exported by another DBA

IMP-00000: Import terminated unsuccessfully

Solution:
---------
- Login to SQL*Plus as SYS or as a DBA
- grant the privilege IMP_FULL_DATABASE to the user having the error in the RON:

GRANT IMP_FULL_DATABASE TO <user>;

Explanation:
------------
The repository was exported as a user having DBA or EXP_FULL_DATABASE privilege. Trying to import the .dmp file as a user without DBA or IMP_FULL_DATABASE privileges will cause the above errors.

11. You have set ORACLE_HOME in the Environment
-----------------------------------------------

Problem:
--------
Exporting an Application System to a Database Export File Fails.

CDI-22582 - Error occurred running the export utility.

Check log file errlog.err.

The log file errlog.err is empty.

Explanation:
------------
The ORACLE_HOME is defined as an environment variable in the system, whereas it should be normally read from the registry. As environment variables usually take precedence over the registry, an inappropriate ORACLE_HOME definition can totally confuse Oracle Tools when used in a multiple Oracle-Home architecture.

Solution:
---------
Remove the ORACLE_HOME environment variable from the Windows Control Panel On Windows2000:

1. Start Menu -> Settings -> Control Panel
2. Double click on System icon
3. Click the Advanced tab
4. Click Environment Variables button
5. Delete any ORACLE_HOME from User Variables list
6. Delete any ORACLE_HOME from System Variables list
7. Reboot the workstation
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question