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.
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.
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.
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.
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.
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
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...