How can I detach domain name from PDB Service?
I am in the process of upgrading our Ebiz 12.1.3 to 19c (v8). Upgrade went smoothly and I was able to bring up both 19c database and Application services normally. At the end, I had to bounce the database after modifying the init parameters . When the database back online, I was unable to connect our PDB database using 'sqlplus system/xxxxx@psmp' which is returning error:
ERROR:
ORA-12521: TNS:listener does not currently know of instance requested in connect descriptor
Observation:
I have a Pluggable Database (PDB) with a simple service name (psmp). When the service name is registered with our listener, our domain name is automatically appended to our service name. This is what causing the error.