Exadata General (MOSC)

MOSC Banner

Howto solv: SCAN Listener is not working on PDB, which was restored from Windows

edited Mar 7, 2023 11:41AM in Exadata General (MOSC) 1 commentAnswered ✓

A non-RAC CDB contains a PDB , which is running on Windows x64. A cold rman backup was taked. It was successfully restored as single instance on Exadata. After opening the PDB doesn't register any Service - but the CDB does.

alter pluggable database all open; Pluggable database altered. The PDB is available and queries can be run. A register didn' help:

SQL> alter session set container=PDB1; Session altered.

SQL> alter system register;

SQL> alter pluggable database PDB1 close immediate;

SQL> alter pluggable database PDB1 open;

I unplugged the PDB und plugged in to another CDB2. Same result. But the SCAN listens to the CDB and also on any brand new created PDB, which means an empty one.

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