ORA-02010: missing host connect string

Posted on December 3, 2020 by kishan1 Minute Read

Cause:

Silly ! Connection string and password should be placed inside quotes

SQL> create database link dblink_prod_qa connect to test identified by password using orcl19x;
create database link dblink_prod_qa connect to test identified by password using orcl19x
                                                                                 *
ERROR at line 1:
ORA-02010: missing host connect string

Solution:

SQL> create database link dblink_prod_qa connect to test identified by "password" using 'orcl19x';

Database link created.

Published by kishan

Hungry and obsessive to learn ! Generic technology enthusiast who have dynamic experience in database and other technologies. I have persistence to learn any niche skills faster. Served multiple DBA roles in fortune 500 companies to proactively prevent unexpected failure events. Inclined to take risks,face challenging situations and embrace fear! ***Last but not the least. I would like to share my thoughts and ideas to this world !*** View all posts by kishan