Home / Repstance User Guide / DATABASE CONFIGURATION COMMANDS / Prepare Target Database / Oracle as Target

Oracle as Target

These parameters are used by prepare, validate and remove with database=target dbtype=oracle (see Prepare Target Database, Validate Database and Remove Repstance Objects from Database). The login that is given in user needs the privileges that are described in Database Privileges.

Parameters

Parameter	Description
database	target. Required.
dbtype	oracle. Required.
generatesql	1 makes prepare return the SQL script and change nothing. The default is 0: prepare creates the objects. validate does not use the parameter, and remove removes the objects whatever its value.
connectiontype	How Repstance reaches Oracle: ezconnect uses server, port and servicename, tns uses tnsname. Required.
tnsname	The net service name. Required with connectiontype=tns; server, port and servicename are then not used.
server	The host name or the IP address of the Oracle server. Required with connectiontype=ezconnect.
port	The port of the Oracle listener, usually 1521. Required with connectiontype=ezconnect.
servicename	The service name or the SID of the database. Required with connectiontype=ezconnect.
user	The login that Repstance connects with. Required.
password	The password of the login. With connectiontype=tns it can be left out when the connection uses an Oracle wallet.

A database name is not needed: the objects are created in the user REPI.

Examples

Return the script instead of running it. The command connects to the database to find the name of the user REPI (C##REPI or REPI):

repcli prepare database=target dbtype=oracle connectiontype=ezconnect server=ora-tgt.example.com port=1521 servicename=ORA1 user=repuser password=Passw0rd123 generatesql=1

The connection through a TNS alias:

repcli validate database=target dbtype=oracle connectiontype=tns tnsname=ORA1 user=repuser password=Passw0rd123

A required parameter that is missing:

repcli prepare database=target dbtype=oracle
[Failed]: Missed connectiontype parameter
  connectiontype         How to reach Oracle: tns uses tnsname; ezconnect uses server, port and servicename.
                         [tns | ezconnect; required]

Web UI

The form “Database Settings” of an Apply Process for Oracle has the list “Connection Type” (EZCONNECT or TNS) and, for EZCONNECT, the fields “Server”, “Port” and “Service Name/SID”, and “Username” and “Password”. With the connection type TNS the field “TNS Name” takes the place of the three. The buttons that prepare the database are shown in Prepare Target Database:

Prepare Target Database

SQL Server as Target

On this page

Parameters

Examples

Web UI