Скачать или смотреть How to Register Pluggable Database (PDB) with a New Listener in Oracle 19c

Learn how to effectively register a pluggable database (PDB) with a new listener in Oracle 19c running on CentOS 7. This step-by-step guide simplifies the process and ensures proper database management.
---
This video is based on the question https://stackoverflow.com/q/63458885/ asked by the user 'K.D.Gayan' ( https://stackoverflow.com/u/11384676/ ) and on the answer https://stackoverflow.com/a/63459252/ provided by the user 'Barbaros Özhan' ( https://stackoverflow.com/u/5841306/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to Register Pluggable Database(PDB) with new created LISTENER

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Register Pluggable Database (PDB) with a New Listener in Oracle 19c

If you've recently set up an Oracle 19c database on CentOS 7 and created a Pluggable Database (PDB) within a Container Database (CDB), you might be wondering how to effectively register your PDB with the newly created listener on port 1522. Worry not! This guide will walk you through the necessary steps to accomplish this task, ensuring your PDB is recognized by Oracle's Listener for optimal database communication.

Understanding Oracle Listener and PDB

Before we dive into the solution, let’s clarify a couple of key concepts:

Oracle Listener: This is a server-side component that manages incoming client connection requests. For each database instance, including PDBs, you typically have a listener defined in the listener.ora configuration file.

Pluggable Database (PDB): A PDB is a portable collection of schemas, schema objects, and non-schema objects that appears to an Oracle Net client as a non-CDB. PDBs are contained within CDBs and offer more flexibility in managing databases.

Steps to Register PDB with the Listener

Here we will outline the step-by-step instructions to register your PDB named PDB with the Listener running on port 1522.

1. Connect to the Database

First, you need to ensure you are connected to an idle instance of your Oracle database. This can be done using SQL*Plus as follows:

[[See Video to Reveal this Text or Code Snippet]]

2. Startup the Instance

Once connected, you need to start up the database instance:

[[See Video to Reveal this Text or Code Snippet]]

3. Switch to the Pluggable Database

Next, change your session context to the PDB you want to register:

[[See Video to Reveal this Text or Code Snippet]]

You should see a confirmation message that the session has been altered.

4. Open the Pluggable Database

Now we need to open the Pluggable Database:

[[See Video to Reveal this Text or Code Snippet]]

5. Set the Local Listener

To ensure the listener recognizes your PDB, we will set the local_listener parameter to point to your listener configuration. Enter the following command:

[[See Video to Reveal this Text or Code Snippet]]

This command alters the system configuration to inform the Oracle Database of the listener's address.

6. Immediate Service Registration

Next, issue the command to register the PDB service with the listener immediately:

[[See Video to Reveal this Text or Code Snippet]]

This command notifies Oracle to update the listener service registrations.

7. Restart the Pluggable Database

To finalize the registration process, restart the PDB with the following commands:

[[See Video to Reveal this Text or Code Snippet]]

This ensures all your changes are appropriately reflected.

8. Start the Listener

If your listener isn’t already running, start the listener using:

[[See Video to Reveal this Text or Code Snippet]]

9. Check Listener Status

Finally, verify that your listener has registered the PDB correctly by checking the listener status:

[[See Video to Reveal this Text or Code Snippet]]

You should see your PDB listed among the services provided by the listener.

Conclusion

Registering a Pluggable Database (PDB) with a new listener can be accomplished in a few straightforward steps. By following the guide above, you ensure that your PDB is correctly recognized by your Oracle database listener, enabling seamless communication when connecting to your databases. Feel free to revisit any of the steps above whenever needed, and enjoy the flexibility that Oracle PDBs offer for your database management tasks!