Using the Demos PDB

The Demos PDB (pluggable database) contains demos that highlight some of the more popular features of Oracle Database 12c. You can have this PDB included when you create a Database Cloud Service database deployment hosting an Oracle Database 12c single-instance database or Oracle Data Guard configuration.

Some of these popular features include JSON in the database, XMLDB, APEX development, the In-Memory option and Data Mining. There is also a web page installed for you that provides access to labs and tutorials to be used with this PDB.

To install the Demos PDB, simply check the Include "Demos" PDB option on the Details page of the Create Instance wizard when creating a database deployment.

Note:

DEMOS PDB is only available for Oracle Database 12c Release 1 database deployments.

Accessing the Labs and Tutorials

You can access the web page to the Demos PDB’s labs and tutorials by directing your browser to the URL https://node-ip-address/jet/home.html. In this URL node-ip-address is the public IP address of the deployment’s compute node; it is listed on the deployment’s Oracle Database Cloud Service Overview page. To display this page, see Viewing Detailed Information for a Database Deployment.

If access to web pages is blocked on the deployment, you need to enable access to HTTPS port 443 before you can view this page. For instructions, see Enabling Access to a Compute Node Port.

Adding the Demos PDB to an Existing Database Deployment

Note:

DEMOS PDB is only available for Oracle Database 12c Release 1 database deployments.

If you didn’t install the Demos PDB during the creation of your database deployment, you can add it later by following these steps:

  1. Connect to the deployment’s compute node as the oracle user.

    For detailed instructions, see Connecting to a Compute Node Through Secure Shell (SSH).

  2. Download the script to create and enable the Demos PDB:

    $ wget https://storage.us2.oraclecloud.com/v1/dbcsswlibp-usoracle29538/pdb_demo/demo.pl
  3. Set the file permissions on the script to make it executable:

    $ chmod a+x demo.pl
  4. Execute the patching script:

    $ ./demo.pl
  5. Disconnect from the compute node:

    $ exit