Versions Compared

Key

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

...

Property Name

Property Code

Required

Description

Oracle Database User

FDORA_USER

Yes

The username that will be used to connect to the target Oracle Database.

Oracle Database Password

FDORA_PASSWORD

Yes

The password for Oracle Database User.

SQLPlus Path

FDSQLPLUS_PATH

No

Provide the sqlplus path (Required if sqlplus is not on PATH environment).

( Ex: /u01/install/APPS/apps/tech_st/10.1.2/bin/sqlplus)

SQLPlus Source Script

FDSQLPLUS_ENVIRONMENT_SCRIPT

No

Source Script with full path.

(Ex: /u01/install/APPS/apps/apps_st/appl/oracle_config.env)

Oracle SID

FDSQLPLUS_ORACLE_SID

No

Provide the Oracle SID (optional if it is already set in the source script).

...

This operation will randomly execute on one of the endpoints identified during selection.

Special Considerations

login.sql

The script that you provided in the input FDSQLPLUS_INP_LOGIN_SQL_FILE will be created as the login.sql file in the current working directory. The login.sql script file in SQLPlus is executed automatically whenever you start SQLPlus. It can be used to set up your SQL*Plus environment, including setting formatting options, environment variables, and other session settings.below

Below the is the example script . we can customize based on requirement

...