Identify the Oracle SID

You can set the Oracle SID by using the Oracle SET SSID command. You can issue this command in the FOCPROF profile. Alternatively, if the SID is at most four characters, you can specify it in your CLIST or JCL.

Reference: Identifying the Oracle SID in FOCPROF

ENGINE SQLORA SET SID sid

where:

sid: Is the Oracle Subsystem ID.

This should be set before setting the USER or CONNECTION parameters and can be placed in the FOCPROF member.

Reference: Identifying the Oracle SID in Your CLIST or Batch JCL

If the sid is at most four characters, you can specify it in either your CLIST or JCL, instead of in FOCPROF, using the following DD allocation:

//ORA@sid DD DUMMY

where:

sid: Is the Oracle Subsystem ID.

In your CLIST, you also need to add the following allocation:

ALLOC F(ORA$LIB)  DA('ORACLE.V10203.MESG') SHR REUSE

Where ORACLE.V10203.MESG is your installation Oracle MESG library.

The TSO session also needs to have the following data sets available to it in the STEPLIB allocation, either explicitly or implicitly, using the naming conventions at your site:

ORACLE.V10203.CMDLOAD
ORACLE.V10203.MESG

If you are running in batch, the STEPLIB allocation in the JCL should have the following as part of the concatenation:

//         DD DSN=ORACLE.V10203.CMDLOAD,DISP=SHR       
//         DD DSN=ORACLE.V10203.MESG,DISP=SHR

The job also needs the ORA$LIB allocation:

//ORA$LIB  DD DSN=ORACLE.V10203.MESG,DISP=SHR