3 Replies Latest reply on Oct 12, 2021 8:49 PM by Namratha Dhoolipalla

    WRT_8001 Error Connecting to Database ORA-12154

    inuser553983 New Member

      Hi All,

      I'm trying to do data profiling using Informatica Developer (10.4.1)

      In Informatica Data Quality Getting Started - Part 2 - Lesson 3 - Task 3, I run a profile and get this error :

      Source : Flat File All_Customers
      So, I don't know why it need to connect to oracle?
      Anyone know how to fix it?

       

      Thank you

        • 1. Re: WRT_8001 Error Connecting to Database ORA-12154
          Namratha Dhoolipalla Guru

          Hi Ryan,

           

          When a profile or scorecard is executed, the results are stored in a Profile WareHouse (PWH) Connection which is a Database Connection that is associated with the DIS.

           

          Even though the Source being profiled is a Flat File, the results will be stored in the Profile Warehouse connection which in this case looks to be an Oracle Connection based on the error message.

           

          Based on the error: "ORA-12154: TNS:could not resolve the connect identifier specified", it looks like the PWH  connection Data Access Connection String has some issues.

          For Oracle Connections, the Data Access Connection string should match the TNS entry name specified in the tnsnames.ora file. Please change the Connection string to the tns entry and rerun the profile.

           

          Thanks,

          Namratha

          • 2. Re: WRT_8001 Error Connecting to Database ORA-12154
            inuser553983 New Member

            Hi Nam,

             

            But when I test connection in Connection, it's success

            Is it tnsnames.ora in server, right? or in client, that has to be fixed?

            Thanks

            • 3. Re: WRT_8001 Error Connecting to Database ORA-12154
              Namratha Dhoolipalla Guru

              Hi Ryan,

               

              The test connection only verifies the Metadata Access Connection String.

               

              If the TNS entry is as follows:

              MYSID=

                (DESCRIPTION =

                  (ADDRESS_LIST =

                    (ADDRESS = (PROTOCOL = TCP)(HOST = mydnshostname)(PORT = 1521))

                  )

                  (CONNECT_DATA =

                    (SERVICE_NAME = MYSID)

                  )

                )

              The Data Access Connection String should be "MYSID" which is the tns entry name in the tnsnames.ora file.The change needs to be at the Connection level not the tnsnames.ora file.

               

              Thanks,

              Namratha