Gen Linux CSE cse_config error "ORA-12547: TNS: lost contact"

Products

• Gen

Issue/Introduction

While configuring the CSE on Linux targeting Oracle running the cse_config script from the cse/bin folder, encountering the error:

ORA-12547: TNS: lost contact

Can connect to the database using sqlplus with same userid/password from outside the configuration session.   

The Oracle database is local to the CSE server.

 

Environment

Gen 8.6 Linux CSE

Cause

For a local database if the DB name specified during cse_config is local the cse_config should connect to it via the Oracle bequeath (local) protocol.
It seems there must be some problem using this protocol.

Resolution

The following will force the cse_config to use the Oracle TNS Listener to connect to the database.
When prompted for 'Database Name' continue to enter '<database_name>' but when prompted for 'Database User' enter as follows:
Encyclopedia Database User (30 chars): username@<service_name>
(typically the service_name is the same as the database_name but not always)

Note:  Also use the same syntax for the 'Coordination Database User' when prompted.

Additional Information

Reference the error message ORA-12547: TNS: lost contact within the Oracle Support Link:  

Oracle Support Link for report error