After Vertical Scale Out, the New Instance Cannot Connect to the Database and Log Shows Error: [nQSError: 17014] Could not connect to Oracle database. [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connection (Doc ID 1638056.1)

Last updated on AUGUST 21, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.131017 and later
Information in this document applies to any platform.

Symptoms

After vertically scaling the BI Server the second instance does not start.  These kind of messages are seen on the nqserver.log:

[YYYY-MM-DDTHH:MI:SS.000-05:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00iK^lavJpn07yKLqUXBiY0001qG00001H,0] [tid: 1cec]  [nQSError: 17014] Could not connect to Oracle database. [[
[nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach.]]

 

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