Your database deployment is up and running

This deployment comes preconfigured with Oracle REST Data Services, Oracle Application Express and, of course, an Oracle Database

SQL Developer
Help

SQL Developer Web

SQL Developer Web simplifies development and management of your Oracle Database in the convenience of your web browser. SQL Developer Web provides a worksheet for running queries and scripts, a DBA page for managing your database, a digramming tool for generating relational diagrams, and a Real-Time SQL Monitoring interface.

For a complete IDE and data modeling experience, you can also use the desktop family of SQL Developer solutions. Download here

Getting Started

Provide the Oracle Database REST enabled schema you wish to use for authentication in the ‘Schema’ field within the SQL Developer section and click ‘Go’. Afterwards, you will be prompted for the database credentials corresponding to the REST enabled schema you entered in the field.

For your convenience, the PDBADMIN database account within the first PDB provisioned in all container databases has been REST Enabled for use with SQL Developer Web. Non-container databases do not have a database account enabled for use with SQL Developer Web, nevertheless, you can follow the instructions below in order to enable or create a database account for use with SQL Developer Web either within a PDB or directly in the database/root container.

Enabling a schema for SQL Developer Web

Steps ( As the root user )
  1. Create a file that will contain the schema password.
    • touch /home/oracle/password.txt
  2. Modify the password file permissions.
    • chmod 600 /home/oracle/password.txt
  3. Open the file with a text editor and insert the schema password. The file should contain a single line with the password without any white spaces.
    • vim /home/oracle/password.txt
  4. Execute ORDS Assistant to enable the schema using the password file that was created previously.
    • /var/opt/oracle/ocde/assistants/ords/ords -ords_action="enable_schema_for_sdw" -ords_sdw_schema="<SCHEMA_NAME>" -ords_sdw_schema_password="<PATH_TO_FILE_CONTAINING_PASSWORD>" -ords_sdw_schema_enable_dba="<TRUE/FALSE>"
  5. Once the above command has finished, the output will contain the schema name that should be used in order to access SQL Developer Web.
Steps ( As the oracle user )
  1. Connect to sqlplus as SYSDBA
    • sqlplus / as sysdba
  2. Connect to the provisioned PDB
    • ALTER SESSION SET CONTAINER = "<PROVISIONED_PDB_NAME>";
  3. Reset PDBADMIN user password
    • ALTER USER PDBADMIN IDENTIFIED BY "<NEW_PASSWORD>";
Steps ( As the root user )
  1. Create a file that will contain the schema password.
    • touch /home/oracle/password.txt
  2. Modify the password file permissions.
    • chmod 600 /home/oracle/password.txt
  3. Open the file with a text editor and insert the schema password. The file should contain a single line with the password without any white spaces.
    • vim /home/oracle/password.txt
  4. Execute ORDS Assistant to enable the schema using the password file that was created previously.
    • /var/opt/oracle/ocde/assistants/ords/ords -ords_action="enable_schema_for_sdw" -ords_sdw_schema="<SCHEMA_NAME>" -ords_sdw_schema_password="<PATH_TO_FILE_CONTAINING_PASSWORD>" -ords_sdw_schema_enable_dba="<TRUE/FALSE>"
  5. Once the above command has finished, the output will contain the schema name that should be used in order to access SQL Developer Web.
Steps ( As the root user )
  1. Create a file that will contain the schema password.
    • touch /home/oracle/password.txt
  2. Modify the password file permissions.
    • chmod 600 /home/oracle/password.txt
  3. Open the file with a text editor and insert the schema password. The file should contain a single line with the password without any white spaces.
    • vim /home/oracle/password.txt
  4. Execute ORDS Assistant to enable the schema using the password file that was created previously.
    • /var/opt/oracle/ocde/assistants/ords/ords -ords_action="enable_schema_for_sdw" -ords_sdw_schema="<SCHEMA_NAME>" -ords_sdw_schema_password="<PATH_TO_FILE_CONTAINING_PASSWORD>" -ords_sdw_schema_container="<PDB_NAME>" -ords_sdw_schema_enable_dba="<TRUE/FALSE>"
  5. Once the above command has finished, the output will contain the schema name that should be used in order to access SQL Developer Web.
For more information click here