Results 1 to 3 of 3

Thread: dblink

  1. #1
    Join Date
    Jul 2002
    Location
    Rome
    Posts
    4

    Question Unanswered: dblink

    HI!

    this is a script of a dblink that i have to create:

    create database link odslnk
    connect to odsguest
    identified by odsguest
    using 'SGTS1'

    after the creation of the dblink if a list the view v$dblink i have this error:
    ORA-02085: il database link ODSLNK.US.ORACLE.COM si connette a SGTS1.US.ORACLE.COM
    etc.

    Why the name of the dblink is ODSLNK.US.ORACLE.COM when i call the same as ODSLNK? and why the istance is SGTS1.US.ORACLE.COM when my istance is SGTS1?

    thank's for an answer Alessio

  2. #2
    Join Date
    Oct 2002
    Location
    Mountain View, CA
    Posts
    1
    Ciao Alessio,
    Puo' darsi che Lei dovrebbe cambiare il "domain" nel init.ora. E' probabile che dice "us.oracle.com".

    auguri,
    stephen boesch

  3. #3
    Join Date
    Jul 2002
    Location
    Rome
    Posts
    4

    Talking

    Ciao Stephen,
    ti ringrazio per la risposta, comunque ho risolto provvisoriamente eseguendo:
    alter system set global_names = false
    così è tutto ok!
    grazie ancora
    Alessio

    Originally posted by rollerdanz
    Ciao Alessio,
    Puo' darsi che Lei dovrebbe cambiare il "domain" nel init.ora. E' probabile che dice "us.oracle.com".

    auguri,
    stephen boesch

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •