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
- 8934 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 define an oracle sub procedure?
How to add a new column to an existing table in oracle?
How to write date and time interval literals in oracle?
what is insert all statement in sql
What is a Garbage Collection? and what is full recursive Garbage collection?
what is a Nested Loop join?
Which is better Oracle or MS SQL? Why?
can u plz provide me oca sql dumps please i need them
What is a data lock in oracle?
How to convert a date to char in oracle? Give one example.
What are the different types of trigger and explain its various uses and functions?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is a table in oracle?
What is an oracle and why it is used?
How to drop an existing table in oracle?
