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 |
Draw E-R diagram for many to many relationship ?
How do I find my oracle client driver version?
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What happens if you set the sga too low in oracle?
How to update rows in table, suppose i have lacks of rows in table how to update total table with update statement. Can u please any one answer this question with update statement.
What is a Sequence ?
definition of cluster and non-clustered index?
Is rowid unique in oracle?
What does ROLLBACK do ?
how to get last monday of a month?
IS it possible to built the oracle database without setting the kernal parameters?
What is the sql query to concatenate column values from multiple rows in oracle?