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 / 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 will be the syntax to find current date and time in format "yyyy-mm-dd"?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
How to revoke create session privilege from a user in oracle?
what is difference between foreign key and reference key
How to change program global area (pga) in oracle?
What is the use of Control File ?
does Oracle has only one table space?
what is pragma?
What is the difference between PFILE and SPFILE in Oracle?
is there a tool to trace queries, like profiler for sql server?
What is literal?
How many types of table in Oracle?