Reference: |
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.
ENGINE SQLORA SET SID sid
where:
Is the Oracle Subsystem ID.
This should be set before setting the USER or CONNECTION parameters and can be placed in the FOCPROF member.
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:
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
Information Builders |