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
- 9045 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different types of modules in oracle forms?
what is normalisation?what are its uses?
What is the recommended interval at which to run statspack snapshots, and why?
What are the various types of snapshots ?
What is an Oracle index?
What is the difference between Delete, Truncate and Drop in Oracle?
Is insert autocommit in oracle?
Can select statements be used on views in oracle?
What is the string concatenation operator in oracle?
Explain database link?
how to do daily transactions with out sql* loader control file regesterd in apps?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Can we insert data in view oracle?
What are the predefined tablespaces in a database?
How to create a new tablespace in oracle?
