DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ERROR: ORA-02019: connection description for remote database not found

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598

    ERROR: ORA-02019: connection description for remote database not found

    Hi All,

    Please help on the below error.

    ERROR:
    ORA-02019: connection description for remote database not found
    ORA-02063: preceding line from EDWTX03@TRAFFIC_OWNER

    I am getting the above error when I try to run the below query.

    The query works fine when I remove the seq_tap_td_imsi_id.NEXTVAL. The owner of this sequence and package are same. They exist on the same schema.

    In the FROM clause, I have a local table (calendar_time) and a remote table (TAP).

    problem query from package:
    -------------------------------
    SELECT seq_tap_td_imsi_id.NEXTVAL, -- sequence in local database/schema
    ....
    FROM (
    SELECT /*+ DRIVING_SITE (T) NO_MERGE FULL(t) FULL(ct) */
    ....
    FROM
    tap --remote_table accessed by dblink -> synonym remote database
    , calendar_time ct -- table local database/schema
    WHERE t.source_system_id = '016'
    ....
    GROUP BY to_number(to_char(t.charge_start_date, 'YYYYMMDD')),
    ....

    Please.

    Let me know if you need more information.


    Thanks in Advance.
    Cheers!
    OraKid.

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Check DBLink
    Check TNSNAMES entry referenced by DBLink
    tnsping TNSNAMES entry referenced by DBLink
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Talking View instead of synonym

    Quote Originally Posted by balajiyes View Post
    ....
    FROM (
    SELECT /*+ DRIVING_SITE (T) NO_MERGE FULL(t) FULL(ct) */
    ....
    FROM
    tap --remote_table accessed by dblink -> synonym remote database
    , calendar_time ct -- table local database/schema
    WHERE t.source_system_id = '016'
    ....
    After you check what Pablo recommends and you still have an issue, change the "tap" from synonym to a view:
    Code:
    CREATE OR REPLACE VIEW tap
    AS
       SELECT *
         FROM remote_table@dblink;
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  4. #4
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    Thanks guys.

    I checked the TNSPING. I am able to get a positive response from both the databases.
    I cannot create a view because, this code is working in one environment. The code in our production environment works, but we are getting an error when we are running the jobs in our new testing environment.

    Not sure if we need to check any specific parameters in the databases.

    Any info on that.

    Thanks again
    Cheers!
    OraKid.

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool domain name?

    Check:

    init.ora (db_domain vs global_names={true|false}) vs sqlnet.ora (NAMES.DEFAULT_DOMAIN) vs tnsnames.ora(database alias and service name)
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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