Are you looking in the right place?
This is the code we run to populate that node of the tree
'PDB' AS type,
name != 'PDB$SEED'
AND application_root = 'NO'
AND application_pdb = 'NO'
'APPROOT' AS type,
name != 'PDB$SEED'
AND application_root = 'YES'
Yes that's where I'm looking. My folder is empty. I see you're SQL but that provides the PDBs that should appear in the Container Database folder, right?
I'm also having problems setting up a connection in SQL Developer directly to the PDB. My PDBs are open READ WRITE. I'm new to multitenant.
Does the listener.ora need an entry for every pdb?
If you could point me in the right direction I would really appreciate it.
Thank you for taking time to reply.
I'm also having problems setting up a connection in SQL Developer directly to the PDB.
Ok - but haven't SHOWN US anything at all about how you are trying to make the connection.
1. use a basic connection
2. use SERVICE_NAME and not SID
3. make sure the PDB is registered with the listener
If you need more help than that then SHOW US:
1. WHAT you do
2. HOW you do it
3. WHAT results you get
>> see you're SQL but that provides the PDBs that should appear in the Container Database folder, right?
So connect to your container database, and run that SQL. Do you get anything back? Any errors? if you get nothing or errors, that explains why you don't see your PDBs.
Ok rp048 I see we're talking in two threads. Thanks for your time. My @#$%^& browser won't PASTE for some reason. Ugh.
thatJeffSmith-Oracle, I'm on 18.104.22.168 so my gv$pdbs doesn't contain application_pdb column but I can show you this:
select name, open_mode, restricted from v$pdbs;
(pasting isn't working so I'll streamline)
NAME OPEN_MODE RESTRICTED
PDB$SEED READ ONLY NO
PDBTOUGGSB2 READ WRITE NO
PDBTOUGGSB3 READ WRITE NO
PDBTOUGGSB1 READ WRITE NO
I don't think entries are required in listener.ora. And I'm doing BASIC connection in SQL Dev so tnsnames isn't a factor.
Thanks very much for your time.
View > Log...Statements panel. Then you can see the query we run for 12.1 vs 12.2