Versions Compared

Old Version 5

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Amy Smith

Saved on

Key

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

...

As a Datical DB user, you can use the Kerberos authentication with Oracle 12, Oracle 18, and Oracle 19 without having to present passwords or certificates to it.

...

To use the project_creator, perform the following steps:

  1. Ensure that the Datical DB CLI directory is in your path. Otherwise, specify the full path to the CLI tool – hammer.

  2. Select a sample input file for Oracle named ProjectNameOracle.dbdefs.tsv.txt that is delivered with the Datical DB installation. It is located in the following directory:

Code Block
<DaticalDB-Installation-Directory>/repl/scripts/examples

ProjectNameOracle.dbdefs.tsv.txt field names and their description

Field Headers (case-sensitive)

Description

name

The name for the dbDef. It is used as an alias for the connection.

DbDefClass

Inline Credentials: OracleDbDef
Run-Time Supplied Credentials: DelayedCredentialOracleDbDef

hostname

The hostname/IP of the target database server.

port

The port number for JDBC connections to the target database server.

username

The database user name to use for the connection.

sid

The name of the Oracle SID to which you want to connect.

serviceName

The name of the Oracle Service to which you want to connect.

useWallet

The name of the Oracle Wallet to connect to the Oracle database through an SSL connection. See Using Oracle Wallet for SSL Connections to Oracle Databases.

tnsName

The directory that contains configuration files for Oracle Wallet.

defaultSchemaName

The name of the schema/catalog you want to manage.

contexts

A comma-separated list of contexts to associate with the new dbDef.

labels

A comma-separated list of labels to associate with the new dbDef.

storageOptions

A TRUE or FALSE value that determines if Datical collects Storage Options.

dbDefType

The value that is set to standard for a managed database and to dmcdb for a Deployment Monitoring Console database.

Info

If you specify a dmcdb in your project, project_creator.groovy will attempt to register the project with the dmcdb.

scriptExecutionTimeout

The value that limits the time to wait for a script to execute in seconds. The default value is 0, which means there is no limit.

kerberos

A TRUE or FALSE value that determines if Datical uses the Kerberos authentication. Set to true if you want to use the Kerberos authentication to connect.

3. Next, run the script on your Windows system:

...