|
-
Originally posted by JP_KIRAN
May be a silly question,
Do you have the tnsnames in the source machine pointing to the remote machine?
Well, I would be he has it :-)
Now, from your messages I assume that select * from global_name; returns SPRODEV.AEL (people usually use WORLD, but perhaps your choice of AEL is well-motivated).
Tell me, in sqlnet.ora, is NAMES.DEFAULT_DOMAIN set to AEL?
Bounce the instances with GLOBAL_NAME set to false and add NAMES.DEFAULT_DOMAIN = AEL in sqlnet.ora.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: [email protected]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|