4 Replies Latest reply on Apr 25, 2014 1:04 AM by Subhrangshu Mondal

    CMN_1022[Database driver error...] :--Error while connecting to source

    Subhrangshu Mondal New Member


      Hi,

       

      I'm facing a problem in connectivity as below : --

      1.When i'm importing table metadata in source analyzer(Designer),using Datasource name & server_name(service name as specified in tns file),

       

      i'm able to do so.

      2.when i'm connecting to the source database using Toad,SQLPLUS in cmd using the service name,i'm able to do so.

      3.But i'm not able to ping to the source server from my local env.

      4

       

      .But,the main problem is when i'm creating a relational connection in workflow manager(relational connection browser) giving

         giving connect string : --- Source_IP:port/service_name & assigning it as source connection in connection value,it's throwig error : --

       

      Severity Timestamp Node Thread Message Code Message
      ERROR 4/24/2014 5:51:19 PM node01_D-219031904 MAPPING CMN_1022 Database driver error...
      CMN_1022 [
      Database driver error...
      Function Name : Logon
      ORA-12154: TNS:could not resolve the connect identifier specified

      Database driver error...
      Function Name : Connect
      Database Error: Failed to connect to database using user [username] and connection string [connect_string].]

       

      Please note : --I'm not able to ping to the source server from my local env.

       

      Please suggest.

       

       

      Thanks & regards,

      Subhrangshu sekhar Mondal