Database Administration (MOSC)

MOSC Banner

ORA-12154 on newly created PDB when trying to connect with admin

edited Jan 25, 2017 7:34AM in Database Administration (MOSC) 3 commentsAnswered ✓

I newly created a PDB using dbca interactively.

I created pdb_admin3/password and when trying to connect with SQLPLUS I'm getting
ORA-12154

I can connect to another PDB flawlessly using its pdb_admin/password@pdborcl for example.
But typing

sqlplus pdb_admin3/<weakpassword>@pdborcl3  (I must confess that I ignored the warning about creating a password not conforming to the complexity rules)

I'm getting this ORA-12154.

I also did an

ALTER PLUGGABLE DATABASE ALL OPEN

to no avail.

--

Christoph

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center