Cannot create database link - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Cannot create database link

  1. #11
    Join Date
    Nov 2000
    Location
    Charlotte
    Posts
    88
    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


  2. #12
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    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.

  3. #13
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    connect as sys and query props$ this will tell what are your domains, db name etc

  4. #14
    Join Date
    Apr 2001
    Posts
    126

    Thumbs up global_name

    Hi,

    Select the table global_name .. and update the Record to
    the SID name.

    update global_name set global_name='SID';

    ...

  5. #15
    Join Date
    Jul 2001
    Location
    Singapore
    Posts
    2
    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.

  6. #16
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Smile

    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
  •  



Click Here to Expand Forum to Full Width