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
- 8971 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
How to update a table row with a record?
What is a trigger and what are its types in oracle?
How many types of database triggers exist?
What is a read write transaction in oracle?
Can we create trigger on materialized view in oracle?
What is the meaning of recursive hints in oracle?
How to write date and time interval literals in oracle?
Does facebook use oracle?
What is data block in Oracle?
What is the difference between substr and instr?
Is the After report trigger fired if the report execution fails ?
How many types of tables are there in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What is an oracle database table?
what are steps for interface? where is exchange rate defined in which table?
