My Oracle Support Banner

ORA-12154 Error While Connecting To PDB On OCI DB Using Sqlplus (Doc ID 2536578.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Database Cloud Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Symptoms

1. Trying to connect from Sqlplus fails as below:

$ sqlplus <user>/<password>@<tns service>

SQL*Plus: Release 12.2.0.1.0 Production on Fri Apr 26 15:40:32 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


2. Services related to corresponding PDB is registered with teh listener.

3. TNSPING is successful.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.