Versions Compared

Version Old Version 9 New Version 10
Changes made by

Ravikumar Babu CTOO

Ravikumar Babu CTOO

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleWhy 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:

Code Block
languagebash
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.



Expand
titleHow to export a schema from Oracle 12c?

To export a schema from Oracle 12c database, perform the following:

  1. Connect to the Oracle 12c database and check the existing directories using the following SQL command:

    Code Block
    languagesql
    select * from all_directories;


  2. Export the required schema using the following SQL command:

    Code Block
    languagesql
    expdp dumpfile=<DumpFilename>.dmp logfile=<LogFilename>.log directory=<DirectoryName> schemas=<SCHEMA_NAME>;

--Example:
expdp dumpfile=CMS.dmp logfile=CMS.log directory=LOG_FILE_DIR schemas=CMS;


  3. Use the following syntax when prompted for user name:

    Code Block
    languagesql
    sys/<Password>@<Servicename>as sysdba

--Example:
sys/Password@pdborcl as sysdba



Expand
titleHow 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

...