The Oracle Pluggable Database Self-Service Provisioning application provides an interface to Oracle Database 12c Multitenant option and allows for the provisioning of Pluggable Databases (PDBs). You can perform PDB operations including create, clone, open/close, plug/unplug, and drop. Additionally, you can grant others access to the application, giving them rights to create and manage their own PDBs within the quota limits you set.
Note:
This section does not apply to service instances that use Oracle Real Application Clusters. Such instances do not currently include the Oracle Pluggable Database Self-Service Provisioning application.
Note:
Before you begin using the Pluggable Database Self-Service Provisioning application, you need to configure its email properties. See Configuring Email for the Pluggable Database Self-Service Provisioning Application.
Topics
• Accessing the Pluggable Database Self-Service Provisioning Application
• Configuring Email for the Pluggable Database Self-Service Provisioning Application
• Setting the Password for a New User Using the Oracle Pluggable Database Self-Service Provisioning Application
Accessing the Pluggable Database Self-Service Provisioning Application
How you access the Pluggable Database Self-Service Provisioning application depends on whether the HTTP port (80) has been unblocked. When an Oracle Database Cloud - Database as a Service instance is first created, the HTTP port is blocked to ensure network security. For information about unblocking a port, see Enabling Access to a Compute Node Port.
• When the HTTP port is unblocked:
1. Open the Oracle Database Cloud Service console.
For detailed instructions, see Accessing the Oracle Database Cloud Service Console.
2. From the menu for the service instance, select Open PDB Provisioning Console.
The Oracle Pluggable Database Self-Service Provisioning login page is displayed.
3. Enter admin as the user name and the password specified when the instance
was created as the password, and then click Login.
This option is also available from the menu on the Oracle Database Cloud Service Instance Overview page.
Alternatively, you can access the Oracle Pluggable Database Self-Service
Provisioning login page by directing your browser to the URL http://node-ip-
address/apex/f?p=PDBSS, where node-ip-address is the public IP address
of the compute node hosting the application. • When the HTTP port is blocked:
When the HTTP port on the instance is blocked, you must create an SSH tunnel to port 80 on the compute node hosting the application. For information about creating an SSH tunnel, see Creating an SSH Tunnel to a Compute Node Port. After the SSH tunnel is created, you can access the Pluggable Database Self-Service Provisioning application by directing your browser to the URL http://
localhost/apex/f?p=PDBSS.
After the Oracle Pluggable Database Self-Service Provisioning login page is displayed, enter admin as the user name, enter the password specified when the service instance was created, and then click Login.
Configuring Email for the Pluggable Database Self-Service Provisioning Application
The Pluggable Database Self-Service Provisioning application sends email messages to users of the application on occasion, such as when requesting an account. However, as a security measure, Oracle Cloud prohibits outgoing email from service instances. Thus, these email messages are blocked when using the application on an Oracle Database Cloud - Database as a Service instance.
Despite the fact that outgoing email messages are blocked, you must set the
application’s sender of email to a valid email address in order for the application to work correctly. To do so, you set the application’s sender to an email address that is local the service instance:
1. Log into the Pluggable Database Self-Service Provisioning application.
For instructions, see Accessing the Pluggable Database Self-Service Provisioning Application.
2. Click the Administration link.
The Self-Service Administration page displays.
3. Locate and click the Self-Service System Configuration item.
The Self-Service System Configuration page displays.
4. Locate the row labeled Emails From and click the edit icon in the row.
The Update Self-Service System Setting page displays, providing a box where you can enter a value for the Emails From setting.
5. In the box, enter the local email address of the oracle user: [email protected]
where instance is the name of the service instance and domain is the name of
the service domain.
6. Click Save Changes.
Your change is saved and the Self-Service System Configuration page displays, showing the changed value.
Setting the Password for a New User
As a security measure, Oracle Cloud prohibits outgoing email from service instances. As a result, the email messages providing new PDBSS users with their usernames and temporary passwords are blocked. You, as the PDBSS administrator, must therefore set an initial password for new users and email them their account login information. You must perform this task whether you create the user manually or approve a user’s request for an account.
When to perform this procedure
You must perform this task:
• After you have approved a request for access to the PDBSS application. • After you have manually added a user to the PDBSS application.
Procedure
1. Log in to the Oracle Application Express administration console on the Oracle
Database Cloud - Database as a Service instance.
For detailed instructions, see Accessing the Oracle Application Express Administration Console.
Note:
If your service instance is running Oracle Database 12c Release 1, make sure you log into the administration console for the CDB.
2. On the home page, click Manage Workspaces. Using the Oracle Pluggable Database Self-Service Provisioning Application
The Manage Workspaces page displays.
3. In the Workspace Actions group, click Manage Developers and Users.
The Manage Developers and Users page displays.
4. In the table of users, locate the row for new PDBSS user.
The user’s name will have the form of an email address and a workspace value of ORACLE_PDB_SELF_SERVICE.
5. Edit the new PDBSS user’s information by clicking the Pencil icon in the new
user’s row.
The Create / Edit User page displays.
6. Edit the new PDBSS user’s information as follows:
• In the Account Privileges section, set Default Schema to C##PDBMGR. • In the Password section, enter an initial password for the user in the Password
box and then reenter that password in the Confirm Password box
• In the Password section, set Require Change of Password on First Use to Yes. • In the Password section, make sure the Expire Password box is not selected.
7. Click Apply Changes.
Your changes are saved and the Manage Developer and Users page is displayed with a message indicating that the user was updated.
8. Log out of the Oracle Application Express administration console.
9. Send a message to the new PDBSS user, providing the following information:
• A link to the PDBSS application on the Database as a Service instance. • Their user name
• Their initial password, with a note indicating that they will be required to change their password when they login the first time. (As a security measure, you may want to send the password separately.)