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
This deployment comes preconfigured with Oracle REST Data Services, Oracle Application Express and, of course, an Oracle Database
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
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.
touch /home/oracle/password.txt
chmod 600 /home/oracle/password.txt
vim /home/oracle/password.txt
/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>"
sqlplus / as sysdba
ALTER SESSION SET CONTAINER = "<PROVISIONED_PDB_NAME>";
ALTER USER PDBADMIN IDENTIFIED BY "<NEW_PASSWORD>";
touch /home/oracle/password.txt
chmod 600 /home/oracle/password.txt
vim /home/oracle/password.txt
/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>"