Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Not all the questions on this page are directly related to Canvas deployment, e.g. questions on Oracle database. Some of these questions were asked by participants during the Canvas training sessions. We have answered those here for the larger benefit of the Canvas Developer community.

 How to connect to Oracle database through command prompt?
  1. At command prompt, type sqlplus and press ENTER.
  2. Enter the DBA User ID and press ENTER.
  3. Enter the DBA User Password and press ENTER.

    Connecting to Oracle Database

    If the credentials are correct the connection to Oracle database will be successful.
 How to find out the Oracle System ID (SID)?

  1. After successfully connecting to the Oracle database at the command prompt as suggested in previous question, enter the following command:

    show parameter service_name
  2. In the result, the VALUE column displays the Oracle SID.

    Finding Oracle SID
 What to update in the ‘config.txt’ file for deploying Canvas?

The ‘config.txt’ file contains the configuration details to connect to the database and execute the schema scripts of Canvas Technology framework. It is essential that you provide the correct DBA user ID and password in the ‘config.txt’ file to connect to the Oracle database. The Canvas schema scripts are executed on the connected database.

Updating config.txt file


 Why is the Canvas schema script running thrice when executing the ‘run.bat’ file?

It is because, by default the ‘run.bat’ file executes the schema scripts of CT ModelHouse, Expert Studio, and Wizard Studio. However, you can specify which scripts to be executed in the APP_LIST parameter in the 'config.txt' file by removing the unwanted schemas:

APP_LIST=ctmodelhouse, ctstudio/Expert, ctstudio/Wizard

# Here, ctmodelhouse is the schema for the sample application, ModelHouse, that is packaged with Canvas Framework.
# ctstudio/Expert is the schema for Canvas Expert Studio (Canvas Studio).
# ctstudio/Wizard is the schema for Canvas Wizard Studio.
 How to connect to the schemas of CT ModelHouse, Expert Studio, and Wizard Studio in SQL Developer?
  1. Open Oracle SQL Developer.
  2. In the Connections tab on the left-hand side, right-click Connections and select New Connection.

    Creating new connection in SQL Developer

  3. In the New / Select Database Connection dialog box, enter the Connection Name. For example, to connect to Model schema, enter MODEL. (This value must be similar to the name of schema given in the ‘config.txt’ file)

    New Database Connection dialog box

  4. Enter the schema username and password in the Username and Password fields respectively. For example, for Model schema, enter MODEL / MODEL (These values must be similar to the values given in the ‘config.txt’ file)
  5. Ensure the correct Hostname, Port, and SID are given in the respective fields.
  6. Click Test. If the credentials are correct the connection to the schema will be successful.
  7. Click Connect.
  8. After schema connection is established, check if you are able to view the schemas contents.


    Viewing schema details in SQL Developer
  • No labels