JAMS runs Oracle batch Jobs through the use of SQLPlus. SQLPlus is the equivalent to SQLCMD.exe in Microsoft SQL Server. JAMS has the ability to handle native Oracle commands on both UNIX-based and Windows-based Oracle.
JAMS supports running jobs on Oracle database versions:
Oracle9i Database Release 1: (patchset as of December 2003)
Oracle9i Database Release 2: (patchset as of April 2007)
Oracle Database 10g Release 1: (patchset as of February 2006)
Oracle Database 10g Release 2: (patchset as of April 2010)
Oracle Database 11g Release 1: (patchset as of September 2008)
Oracle Database 11g Release 2: (patchset as of September 2011)
For UNIX-based Oracle installations, JAMS can execute native Oracle commands through the normal UNIX shell.
For Example:
$ . oraenv
ORACLE_SID = [orcl] ? orcl
$ sqlplus daniels/tiger
For Windows-based Oracle installation, JAMS can handle SQLPlus language by simply calling SQLPlus.exe within a normal Windows Command Procedure Execution Method.
For example:
Sqlplus.exe daniels/tiger@orcl
The best way to secure SQLPlus is to use external authentication. To do that, your init.ora needs to contain these lines:
remote_os_authent = true
os_authent_prefix = OPS$
Then, the SQLPlus command line would be something like:
plus33w.exe / thesqlfile.sql
Then, if you are logged on as user JOE, Oracle will look for a database user OPS$JOE.
Add Your Comments