Problems with Designer 9i Repository on Oracle 8i

[Rorbac]

I've installed Designer 9i on my Pc and then created a
new database(8.1.7) on our server(Sun). After creating the
database I've run standard.sql, catalog.sql (which runs catexp.sql) and catexp7.sql.

Then I executed the scripts ckqa, ckvalqa, ckcreate and
ckreport on the database.

Now, when I try to connect to the database via the Repository Administration Tool on my PC, and install a new
repository, I receive an error message that points to a log
file that says ORA-00942 and IMP-00023 (Import views not
installed). Why? I ran catalog.sql and catexp.sql and catexp7.sql on the database! Is there any other script I need to execute? Why does my ckreport indicate that sys is the repository owner and not the user created by the scripts repos_owner?

Thanks.

- Rorbac

 

[oschmitt]

Hello Rorbac,

I am having the exact same problem!
Did you find any solution/workaround for this ?
Thanks for your help

Olivier SCHMITT

 

[skfox]

Things you want to check on: Did you run the Scripts (catalog.sql, catexp7.sql) under the SYS or INTERNAL account at the Server level? You also need to run the catproc.sql script under the SYS or INTERNAL account. Using the "SYSTEM" account or another USER account is not the correct way to build your database. It will cause problems in your data dictionary, your management views, etc. If you have not done this, I would drop the database and recreate it properly. The other scripts you mention must be locally created scripts, as they do not come with Oracle (that I have seen nor can I find these). Next you must create a USER for this database that will own the respository. This is why you get the 00942 error code - you don't have permissions. This user must be granted the privilege of Resource, Connect in order to connect properly to the repository, and they must be granted the privilege of IMP to import information in (the second error message).
Hopefully this helps.

 

[Rorbac]

I've now installled Oracle 9i on another server and tried to install the repository on that database and it worked. (After changing some settings for the temporary tablespaces needed, because those created by the script were too small.)

- Rorbac

P.S. I didn't run catproc.sql, perhaps that was the problem. The other scripts I mentionned are scripts that come with Designer for the Repository creation. They create the necessary user themselves.

 

[oschmitt]

Thank you both for your answers,
I am happy I have solved the problem.
A person on oracle technet discussion forum found the solution.
Apparently, the IMP utility shipped with the DeveloperSuite9i
is not compatible with the IMP shipped with Oracle 8.1.7.
The solution was to tell the DeveloperSuite not to use the IMP
of its own but the one of oracle 8.1.7.
regedit => HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1/REPOS61
(where HOME1 is the home of Developer suite 9i)
and set the following keys: EXECUTE_IMPORT, EXECUTE_EXPORT, EXECUTE_GUI_IMPORT, EXECUTE_GUI_EXPORT to the path of the IMP and EXP utilities of oracle817 ($Ora817Home/bin/imp.exe)
And it worked.

cheers,

Olivier

 

[meetme]

Hi Olivier,

That did the trick. Thanks a lot for you to put the details in this forum.

--meetme