TNS:address already in use Database driver error (Doc ID 577348.1)

Last updated on JANUARY 31, 2017

Applies to:

Siebel Analytics - Version 10.1.3.2.1 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
21st May 2013 - Checked for relevancy. Also added Note 21476.1 for completeness.
08-Nov-2014 - Checked for relevancy

Symptoms


While running an ETL the customer received this error message: -


CMN_1022 Database driver error... CMN_1022 [ ORA-12542: TNS:address already in use Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [CRMREP_SDM] and connection string [PRD_SDM_ETL].]"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms