
November 13th, 2003, 10:38 AM
|
|
Registered User
|
|
Join Date: Oct 2003
Posts: 5
Time spent in forums: 12 m 59 sec
Reputation Power: 0
|
|
|
testing access oracle 9i client -> oracle 7.x db ee ...
Hello,
has anybody already been able to establish a successful communication between: an Oracle 9i client and an Oracle 7.x DB Enterprise Edition?
I do only recognize a partial success. Setting up an appropriate tns-service (identifying the database via SID) has been quite easy. The login test via Scott/Tiger works fine. Unfortunately I've still not been capable to run SQL*Plus Worksheet correctly. Applying the same authentication - settings SQL*Plus Worksheet always refuses to work depicting an error message, that indicates a problem with the table PRODUCT_USER_PROFILE. The system advises me to start up the PUPBLD.SQL - script in order to create the table (and the appropriate view).
It would be easy if there would be none of the following strange circumstances:
1. The Oracle 7.x DB server is running different databases. As far as I know the PUPBLD.SQL is started automatically when databases are created. PRODUCT_USER_PROFILE does not exist, but a similar file (PRODUCT_PROFILE) referenced within the view PRODUCT_PRIVS.
2. An Oracle 8i client gets access to the database via the appropriate SQL*PLUS Worksheet. Everything is running fine ...
Is anybody familiar with a problem like that? That's a quite sensitive topic to me, because the Oracle 7.x DB server has got a big load. I don't want to disgruntle my users.
I'd appreciate your help. Bye Sysadv
|