Unable To Apply Table Extends On Oracle Server DB. Getting Errors : ORA-12560: TNS:protocol adapter error (Doc ID 1475690.1)

Last updated on JUNE 06, 2017

Applies to:

Siebel Database Extension - Version 8.0.0.1 [20408] and later
Information in this document applies to any platform.
**Checked for relevance on 05-Jan-2016**
Reviewed on 07JUN2017.

Symptoms

On : 8.0.0.13 SIA [20448] version, Configuration - Dev Env


Unable to apply table extends on Oracle server DB. getting errors

ERROR
-----------------------
1. could not connect to datasource for Event API

2. 08001 (12560): [DataDirect][ODBC Oracle driver][Oracle]ORA-12560: TNS:protocol adapter error


STEPS
-----------------------

1. Installed Siebel version 8.0.0.13.
2. After some configuration changes, user extended S_CONTACT and S_ORDER_ITEM tables and tried to apply the changes to Server database using the table owner SIEBEL.
3. Following errors is shown >

-could not connect to datasource for Event API
-08001 (12560): [DataDirect][ODBC Oracle driver][Oracle]ORA-12560: TNS:protocol adapter error

4. User has successfully applied table extend on Siebel 8.0.0.8 and after applying the 8.0.0.13 patch this is the first time we tried to extend and apply the table changes.

Error Message:could not connect to datasource for Event API08001 (12560): [DataDirect][ODBC Oracle driver][Oracle]ORA-12560: TNS:protocol adapter error

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