Skip to main content

Posts

Showing posts from December, 2024

Steps on creating a new PDB service

Steps on creating a new PDB service Setting up a new service in a Pluggable Database (PDB) in Oracle involves creating the service in the PDB and configuring the client to connect to it.  Steps: 1. Login to container Database and Change to pdb container; sqlplus '/as sysdba' alter session set container=pdb1; 2. Create service for current pdb using name and new network service name. Syntax: BEGIN    DBMS_SERVICE.CREATE_SERVICE(       service_name => 'MY_PDB_SERVICE',       network_name => 'MY_PDB_SERVICE'    ); END; / exec dbms_service.create_service('pdb1','pdb1'); 3. Start the new service. exec dbms_service.start_service('pdb1'); alter system register; 4. Check the listener services and try to make a new connection to the newly created services.  lsnrctl services  SELECT NAME FROM V$ACTIVE_SERVICES; 5. Save the state for PDB. Need to save the state for pluggable for the new pdb service. Otherwise, you need to manual...