Error message" Undefined status code -12514 for DBMS facility" seen into IC status log.

Error message" Undefined status code -12514 for DBMS facility" seen into IC status log.

book

Article ID: KB0092377

calendar_today

Updated On:

Products Versions
TIBCO BusinessWorks Collaborator -
Not Applicable -

Description

Description:

Description:
------------------
The  "Undefined status code -xxxx" noramlly represents the error code returned from the database. If the Oracle database is being used then it translates to ORA-12154 error "Could not resolve service name??" which is caused due to the following reasons.
Symptoms:
Error message" Undefined status code -12514 for DBMS facility" seen into IC status log.


Cause:
1). The tnsnames.ora file was not found at the specified location.
2). The database name is not mentioned in the tnsnames.ora file.
3). The tnsnames.ora has a syntax error.

Any error in a TNSNAMES.ORA file makes it unusable.

Issue/Introduction

Error message" Undefined status code -12514 for DBMS facility" seen into IC status log.

Resolution

Resolution:
-----------------
1) The tnsnames.ora file was not found.

Verify that a TNSNAMES.ORA file exists. The tnsnames.ora can be found in one of 3 locations.

a). Oracle first checks to see if TNS_ADMIN is set and looks in the directory the environment variable is pointing to.
b).  /etc
c). $ORACLE_HOME/network/admin.

If your system has multiple instances of Oracle homes and multiple tnsnames.ora files, make sure the entries are made into the right tnsnames.ora file.

2). The database name is not in the tnsnames.ora file.

Check to see that the database service name exists in one of the TNSNAMES.ORA files and add it if necessary.

3). The tnsnames.ora has a syntax error.

Make sure there are no syntax errors in the file. Look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable.
If possible, regenerate the configuration files using the Oracle Network Manager.