| 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
|
|
|
|
| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
