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 |
Why do we need oracle client?
How to use select statement to count the number of rows in oracle?
What happens in oracle commit?
What is an oracle database table?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How do you store pictures in a database?
How can I combine multiple rows into a comma-delimited list in oracle?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is Public Database Link ?
What are the tools for Oracle ?
Explain the use of full option in exp command.
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.