-
If push comes to shove this will work. I've had the same problem(s) from NT to Solaris myself.
I've had to give the complete description in the "using" part of the create db_link statement.
So it ended up looking like this:
Create public database link epro
connect to epro1 identified by password
using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = Solaris host-name)(PORT = 1521))
(CONNECT_DATA = (SID = sid name from solaris)))';
(The description is from the database you are trying to connect to, in this case its the SUN Box).
This has and is working for me.....
Charles
-
Hi! Charles
I tried out and here's the result
SQL> ed
Wrote file afiedt.buf
1 Create public database link epro
2 connect to epro1 identified by password
3 using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
4 (HOST = 10.31.8.85)(PORT = 1521))
5* (CONNECT_DATA = (SID = EPRO)))'
SQL> /
Database link created.
SQL> select count(*) From company@epro;
select count(*) From company@epro
*
ERROR at line 1:
ORA-02085: database link EPRO.US.ORACLE.COM connects to EPRO
Shall I call this frustating or interesting???
There Nothing You cannot Do, The problem is HOW.
-
connect as sys and query props$ this will tell what are your domains, db name etc
-
global_name
Hi,
Select the table global_name .. and update the Record to
the SID name.
update global_name set global_name='SID';
...
-
Originally posted by sudip
Well now I got the following error
SQL> select count(*) from company@epro;
select count(*) from company@epro
*
ERROR at line 1:
ORA-02085: database link EPRO.US.ORACLE.COM connects to EPRO
Dear Sudip,
Change the global_names parameter to false in init.ora parameter file and then restart your database.
Then issue the select * from company@epro and check.
This will avoid the above based error.
-
Yess!!! Changing the Global_name worked.
Thanx a lot Guys.
There Nothing You cannot Do, The problem is HOW.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|