ORA-02010 missing host connect string

Question: What is the cause of the error “ORA-02010 missing host connect string”?

    SELECT * FROM [email protected]_link
    *
    ERROR at line 2:
    ERROR: ORA-02010: missing host connect string

Cause: The Oracle error utility oerr returns this description for the ORA error.

    ORA-02010 missing host connect string

    A quoted character string does not follow the keyword USING in the USING clause of a CREATE DATABASE LINK statement.
    Specify the host connect string, then retry the operation.

The DB Link was created without strings in the tns string.

    CREATE DATABASE LINK db1_link
    CONNECT TO ecomm IDENTIFIED BY ‘ecommpass’
    USING ecomm_db;

Solution: Recreate the DB Link with the tns string appearing after the USING clause within quotes and try again.

    CREATE DATABASE LINK db1_link
    CONNECT TO ecomm IDENTIFIED BY ‘ecommpass’;
    USING ‘ecomm_db’;

Retry selecting from the remote table.

Issue resolved!

Related OraTips

– Recovering your OLR.With the OCR and Voting disks being placed in ASM, these files are accessible only when the cluster processes have started up and ASM instance is up and running. However without the OCR file the clusterware processes cannot start up. Read more about Oracle Local Registry Recovery.

– Proxy User Authentication with Connect Through in Oracle Database – The Proxy authentication mechanism allows a user to login as their own user but land into a different schema without knowing the password for that user. For example the USER_B may want to create an object in the SCHEMA_A or want to use the privileges/roles of the SCHEMA_A user. You can now connect through your […]

Other Articles

– Connecting Applications from Desktop to your VirtualBox Database If you are trying to connect between VirtualBox Machines or trying to setup the network to communicate from the Desktop to the VirtualBox machines, follow these simple to use instructions.

– Provision VirtualBox using Pre-Built Developer VMs Step by step guide to setup the Oracle VM VirtualBox and import the prebuilt template to quickly create a portable (on your laptop) testing environment in 10 minutes!


Note: This Oracle documentation was created for reference for use by Vitalsofttech DBA’s. If you have any questions please post by clicking on the ASK A QUESTION link above.

Leave a Reply

Your email address will not be published.