Home » RDBMS Server » Networking and Gateways » Database Links Oracle 8.0.5.1 -> 7.3.3
Database Links Oracle 8.0.5.1 -> 7.3.3 [message #367596] Wed, 27 January 1999 13:31 Go to next message
Brianz32
Messages: 3
Registered: January 1999
Junior Member
I have a production database in v7.3.3 that I"m trying to create a database link to from an 8.0.5.1 instance. When I try to use the link to select from a table on the 7.3.3 instance I'm getting the error:

ORA-12663: Services required by client not available on the server

When I try and link to an 8.0.4.3 instance, it works fine. It appears as though some type of configuration change has to occur to link from an Oracle 8 instance to an Oracle7 instance.

The error message guide was little help. It states something like "delete the requirement from the configuration file of the client (least secure)".

I'm not sure which configuration file it's refering to.

Anyone have any ideas?

Thanks.

Brian
The answer [message #367597 is a reply to message #367596] Wed, 27 January 1999 14:26 Go to previous message
Brianz32
Messages: 3
Registered: January 1999
Junior Member
I just was able to find the answer for my own problem. I was assuming that the database link was not working due to the error message generated when I tried to do as follows:

DESC all_objects@pldw1;

Then I received the ORA-12663 Error.

Here's the deal: In ORACLE8 there is a KNOWN bug (all versions of Oracle8 I believe, we have 8.0.4.3 and 8.0.5.1 here and affects both). Database links created in Oracle 8 referencing Oracle 7 instances will NOT allow you to DESC an object. You CAN however do all other operations. For example, selects and create table as selects have worked just fine.

There is no planned fix coming for this bug yet.

Brian
Previous Topic: Database links
Next Topic: ODBC connection read-only
Goto Forum:
  


Current Time: Wed Feb 21 08:48:52 CST 2024