OraFAQ Forum: Networking and Gateways » Database Links Oracle 8.0.5.1 -> 7.3.3

Home » RDBMS Server » Networking and Gateways » Database Links Oracle 8.0.5.1 -> 7.3.3

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database Links Oracle 8.0.5.1 -> 7.3.3 [message #367596]

Wed, 27 January 1999 13:31

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

Report message to a moderator

The answer [message #367597 is a reply to message #367596]

Wed, 27 January 1999 14:26

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

Report message to a moderator

Previous Topic:	Database links
Next Topic:	ODBC connection read-only

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 18:21:30 CDT 2025