ORA-12532: TNS:invalid argument

Hi Experts,

I am getting the below error while using DB links.

  

SQL> select * from xx_bapl_in4_inv_hdr_stg@DBLINK.BENGALAERO.COM;
select * from xx_bapl_in4_inv_hdr_stg@DBLINK.BENGALAERO.COM
                                      *
ERROR at line 1:
ORA-12532: TNS:invalid argument

 

Dblink Syntax:

 

CREATE DATABASE LINK "DEV_TO_PROD.BENGALAERO.COM"
        cONNECT TO APPS
        IDENTIFIED BY xxxx
         USING '(DESCRIPTION=
          (ADDRESS_LIST =
                (ADDRESS=(PROTOCOL=tcp)(HOST=

124.153.101.225)(PORT=1525))
                 )
           (CONNECT_DATA=
            (SID=PROD)
        )
        )';


Please help,




Regards,
Raaza