Hello,
This sounds like a library missing. You should check the required packages for this platform and make sure the versions are correct.
Hth,
Seagull
Hello Jason,
You should determine which user account is used by your application (monitor v$session and v$sqlarea).
Then you can search the privileges used in the dba_privs, dba_sys_privs or something like that to see which privileges are used by that specific user. You might also check the...
Hi!
I guess you should first verify that the db link works and that you can successfully connect to the remote db.
Then grant select rights on the v$instance or v$database views to the user the db link connection is made for, and select these views.
HTH
Seagull69
Hello,
Maybe it's a good idea to investigate the network side of the process of node discovering. Can you connect to the server(s) in question using Net*8 ? (with an entry on the local tnsnames.ora file) ? Connections from different computers may take different routes. A good idea is to...
Another tip if the data volume is not high: generate a script with insert's from sql-server and then execute it in sql*plus (oracle side). Don't forget to set autocommit 100 (or so) to go smoothly.
HTH
seagull69
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.