Interested to Buy Any Domain ? << Click Here >> for more details...
You create a private database link and upon connection,
fails with: ORA-2085: connects to . What is the problem? How
would you go about resolving this error?
- 1 Answers
- 8973 Views
- I also Faced
- E-Mail Answers
Answer / saraswathi muthuraman
SQL> select * from all_catalog@tg4msql_v91;
select * from all_catalog@tg4msql_v91
*
ERROR at line 1:
ORA-02085: database link TG4MSQL_V91.DE.ORACLE.COM
connects to HO.WORLD
Resolution:
This problem is related to GLOBAL NAMES.
The simplest way to disable global naming is to alter
the current session.
alter session set global_names=false;
The other solution is to add a global_name to the
gateway/hs:
HS_DB_NAME = <datasource>
HS_DB_DOMAIN = <DOMAIN>
But the HS_DB_NAME must not exceed 8 characters and
must not contain any extra characters. If this is not
possible, the globale naming can be disabled by setting
GLOBAL_NAMES = FALSE in the init.ora of the database
as well
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a dead lock in oracle?
How to create an oracle database?
What is the usage of save points in oracle database?
How do I spool in oracle?
what is Single Byte Overhead...?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What is the difference between post-database commit and post-form commit?
what is the bitmap index?
13. Display the second to fifth characters in each client name.
what is view?
What is a relational database management system?
Oracle General 
