6 Replies Latest reply on Mar 28, 2018 11:57 PM by thatJeffSmith-Oracle

    PDBs not showing up in SQL Developer

    6String

      Hello, x86-64, SLES 11, Oracle 12.1.0.2

       

      Just added a CDB with 3 PDBs and the PDBs are not showing up in SQL Developers DBA Editor.

       

      1) I created the connection to the CDB in SQL Developer and confirmed it was working.

      2) I connected to the CDB.

      3) I clicked "View/DBA" in SQL Developer to open the DBA editor.

      4) I right-clicked "Connections" and selected "Add new connection" and added the CDB connection.

      5) "Container Database" folder is present when I expanded the CDB connection, but it has no PDBs in it.

       

      This rookie has no clue how to get the PDBs to show up.  Any assistance you have is greatly appreciated.

       

      FYI the PDBs are open READ WRITE via "show pdbs" command.

       

      Thank you for taking the time to reply.

      6~

        • 1. Re: PDBs not showing up in SQL Developer
          thatJeffSmith-Oracle

          Are you looking in the right place?

           

          plugs.png

           

          This is the code we run to populate that node of the tree

           

          SELECT

              name,

              'PDB' AS type,

              con_id

            FROM

              gv$pdbs

          WHERE

              name != 'PDB$SEED'

                 AND application_root   = 'NO'

                 AND application_pdb    = 'NO'

          UNION ALL

          SELECT

              name,

              'APPROOT' AS type,

              con_id

            FROM

              gv$pdbs

          WHERE

              name != 'PDB$SEED'

                 AND application_root   = 'YES'

           

          pdb2.png

          • 2. Re: PDBs not showing up in SQL Developer
            6String

            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.

            • 3. Re: PDBs not showing up in SQL Developer

              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

              • 4. Re: PDBs not showing up in SQL Developer
                thatJeffSmith-Oracle

                >> see you're SQL but that provides the PDBs that should appear in the Container Database folder, right?

                Correct.

                 

                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.

                • 5. Re: PDBs not showing up in SQL Developer
                  6String

                  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 12.1.0.2 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.

                   

                  • 6. Re: PDBs not showing up in SQL Developer
                    thatJeffSmith-Oracle

                    View > Log...Statements panel. Then you can see the query we run for 12.1 vs 12.2