4.1.3.2 Examples

To set up database schema for an on-prem Oracle database server:

Use either a shell continuation character after -connStr or keep the connection descriptor on the same line. For example:

./TSAMDBSchemaSetup.sh -connStr "hostname:1521/orclpdb1" -user tsamuser1

To set up database schema for an Oracle Autonomous Database in Oracle Cloud, with partitioning enabled:

./TSAMDBSchemaSetup.sh -connStr 
"(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=adb.oraclecloud.com))(connect_data=(service_name=tsam22c.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))" -user tsamuser1 -enablePartition

To set up database schema for an Oracle Autonomous Database in Oracle Cloud, with AI feature enabled:

  ./TSAMDBSchemaSetup.sh -connStr "(description=(retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=adb.oraclecloud.com))(connect_data=(service_name=tsam22c.adb.oraclecloud.com))(security=(ssl_server_dn_match=yes)))" -user tsamuser1 -enableAI -aiUser tsamuser2

Note:

If the TSAMDBSchemaSetup.sh script fails, it's recommended to rerun TSAMDBUserProvision.sh with the -dropUser parameter to redo the database user provision from scratch.