When trying to do an extraction with the Delivery Manager Tool (DMT) to an Oracle database, the error ORA-12516 is encountered as in the following log message:
2016-08-25 11:49:45.838 INFO Unable to establish a connection to: jdbc:oracle:thin:@//<host>:<port>/<service> => Listener refused the connection with the following error: ORA-12516, TNS:listener could not find available handler with matching protocol stack
Release | Yes/No |
|---|---|
| 8.2.x |  |
| 8.1.x | |
| 8.0.x | |
| 7.3.x | |
RDBMS | Yes/No |
|---|---|
| Oracle Server | N/A |
| Microsoft SQL Server | N/A |
| CSS2 | N/A |
Below is the step-by-step scenario leading to the problem:
- Try to extract with the DMT tool code from an Oracle database.
The impact of the problem on the analysis or the dashboard is: No code extracted so no data to analyze and present on the dashboard.
The problem occurs with Oracle databases with SCAN (Single Client Access Name) feature when trying to access them with the DMT.
To fix the problem, proceed as follows:
Do a manual extraction using the standalone Extractor from the command line using the following JDBC connection information (include (LOAD_BALANCE=on)) to create a *.castextraction file
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<Host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<service>)))
- Then use DMT to create a package using the CAST DB extractor extraction results (the *.castextraction file)
This was encountered in a Siebel environment and Siebel command line in this case for the manual extraction using the standalone Extractor looked like this:
"<java_path>\java.exe" -Xmx1500M -cp <Path to Siebel>\SIEBEL\02_Analysis\01_SourceExtraction\Utils\CASTDBExtractor.jar;<Path to Siebel>\SIEBEL\02_Analys\ojdbc6.jar com.castsoftware.extractor.cli.DatabaseExtractor -vendor Siebel -platform 8.1 -driver oracle.jdbc.OracleDriver -url "jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<service>)))" -user "<user>" -password "password" -parameters "SCHEMA=SIEBEL;idProject=Project;repositoryID=3-I8O7-1" -l "<path to Siebel>\SIEBEL\02_Analysis\01_SourceExtraction\Log\ExtractorLog_Project.log" -v -target "<Path to Siebel>\SIEBEL\02_Analysis\01_SourceExtraction\01_Results\SiebelExtract_Project" -config "<Path to Siebel>\SIEBEL\02_Analysis\01_SourceExtraction\Utils\CASTSiebel_orcl.config" -format text -zip -multithreaded
