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
- 8963 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
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is query image?
How to create a new user account in oracle?
Explain a private synonyms?
When do I need to use a semicolon vs a slash in oracle sql?
Why do we use bulk collect in oracle?
What is different types of joins?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
In oracle there is column command, how will you explain that?
Explain the use of tables option in exp command.
Give the different types of rollback segments.
What is the usage of analyze command in oracle?
How do you find current date and time in oracle?
What are the attributes that are found in a cursor?
How to execute a stored program unit?
