DbSchema for Oracle Database

DbSchema is a powerful database management and design tool for Oracle. It offers features such as visual schema design, team collaboration with GIT, schema deployment and HTML schema documentation.

How to Connect to Oracle Database

1. Access the Connection Dialog

   Choose "Connect to the database" or "New Model Connected to the Database" will let you select your database and open the Connection Dialog.

   DbSchema automatically downloads the JDBC driver to connect to your database.

2. Configure the Connection

In the Connection Dialog window, select the JDBC URL you want to connect with. If your database is running in the cloud, choose Edit Manually and insert the JDBC URL from the cloud console.

Enter the host name, the authentication details, select your database as described in the Connection Dialog page.

3. Troubleshoot Firewall Issues
If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.

1. Connect to Oracle Cloud Autonomous Database
2. Connect to a provisioned Oracle Server
3. Use Kerberos Authentication
4. Guided Oracle Installation

Connect to Oracle Cloud Autonomous Database

In the Oracle Cloud Console create an autonomous database. Click the 'Database Connection' tab, and download and unzip the wallet to a local folder, for example C:/Temp/OracleWallet. The download will ask to create a wallet password. Use for example 'dbschemasecret'.

Open and edit the DbSchema.vmoptions file, located in the DbSchema installation folder. Add the following parameters, pointing to the downloaded wallet files and the password created when downloading the wallet:

-Djavax.net.ssl.trustStore=C:/Temp/OracleWallet/truststore.jks
-Djavax.net.ssl.trustStorePassword=dbschemasecret
-Djavax.net.ssl.trustStoreType=SSO
-Djavax.net.ssl.keyStore=C:/Temp/OracleWallet/keystore.jks
-Djavax.net.ssl.keyStoreType=SSO
-Djavax.net.ssl.keyStorePassword=dbschemasecret
-Doracle.net.authentication_services=(TCPS)

Copy the connection string to a text editor, and add 'jdbc:oracle:thin:@' in front. The JDBC URL will be something like:

jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1522)(host=adb.eu-frankfurt-1.oraclecloud.com))(connect_data=(service_name=g158801ea2b709a_dbschema_medium.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))

Start or restart DbSchema, and connect to the Oracle database. In the Connection Dialog choose 'Edit Manually' in the JDBC URL combo, and copy the JDBC URL.

The database user is ADMIN with the password you entered when creating the Autonomous Database.

Connect to an Provisioned Server

The connection dialog is explained here.

You can connect to Oracle using the users 'sys', '/ as sysdba' or any database user. The default Oracle port is 1521.

From the Method & Driver combo you can choose between different connection methods.

In the Database SID field enter the Oracle SystemId, namely the Oracle instance. Default Oracle SID is ORCL. This identifies the database in case more instances of Oracle are running at one time. You can execute show parameter instance_name in SQLPLUS and see the SID as the last keyword is the list.

Connect to Oracle using Kerberos Authentication

This require setting in the Connection Dialog Settings pane the Properties field to:
oracle.net.authentication_services=( KERBEROS5 );oracle.net.kerberos5_mutual_authentication=true

Please also edit the file DbSchema.vmoptions ( look in the same folder as DbSchema executable or in DbSchema.app/Contents/vmoptions.txt ) and add this oracle.net.kerberos5_cc_name=path_to_credential

Guided Oracle Installation

Download Oracle 10g from: http://www.oracle.com/technetwork/database/express-edition/downloads/102xewinsoft-090667.html

Start the installation process...Select Next...Accept the license agreement...Select the destination folder:

Type in your password:

Install...