Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database Link for All users

Kam__apexAug 6 2020 — edited Aug 10 2020

Dear Friends

I have a two servers. (server1 and server2).  In server1 oracle10g is installed and server2 has oracle 18c. In server1 almost 10 users/schemas are created and several tables are created in different schemas. I want to make reports in server2 and some of the data want to fetch from server1 from different schemas. Can you please tell me, can i make one database link for all schemas?

Please help.

Regards

Kam

Comments

4297041
Hello,

If you review your error log what does it state? It might be good to clear it (Tools > Clear Error Log), reproduce the issue, and then review the error log (Tools > View Error Log).
The root cause of the issue will be just before the "Automation Error" notification as FDM write issues in order from the top down.

Thank you,
JeffJon
Is this a x64 server? Specified Cast is invalid indicates that the adpater was not registered properly. If it is a x64 server the adapter needs to be registered manually.

Follow document 1073992.1 to resolve the issue.
Jeo123
Try going into the mapping section and browsing for target value. 9 times out of 10 an automation error seems to be related to an inability to connect to the target system. The most common cause in my experience relates to entereing a Domain on the login page when one isn't required, but there are other causes as well.
1 - 3

Post Details

Added on Aug 6 2020
9 comments
133 views