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?
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
Explain the difference between sap and oracle?
What to do if dba lost the system password?
What is an oracle table?
What is the difference between Delete, Truncate and Drop in Oracle?
What is the difference between a primary key & a unique key?
what is the use of system.effective.date variable in oracle?
Give syntax for SQL and ORACLE joins.
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is a nvl function?
What is blob data type in oracle?
What is a select query statement in oracle?
What is instant client oracle?
What is literal?
How to get a list of all user accounts in the database?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?