I am looking for information about accessing data present in ORACLE from IBM Mainframe applications (Z/OS). The data is lying on Oracle which is on a separate server and the IBM Mainframe system, by using COBOL programs need to access the data from Oracle.
I heard that by using 'Oracle Access Manager for CICS' we can access Oracle data directly from IBM mainframe applications (using COBOL program). If yes, then are there any limitations/considerations on the Oracle version we are using ? I heard that the gateway 'Oracle Access Manager for CICS/IMS' is only supported in older versions of Oracle(i.e. 10g) but not in 11g or 12c ? Is Oracle still supporting 'Oracle Access Manager for CICS/IMS' ? Has anyone done this or do you have suggestions? 
Thanks in advance for your help.
Sai

All of that sounds unfortunately correct.  Oracle "sunsetted" further development on z/OS at version 10.2.  Apparently they do support that still, and I imagine you can still use the 10.2 client (including Oracle Access Manager) on z/OS to connect to a higher level server off z/OS, but I can't say for sure.

At our shop we used to be a VSE shop, where Oracle hasn't been supported since the 80s.  We used IBM Infosphere Federation Server in between DB2 for z/OS and Oracle to facilitate our Oracle access.  It works well enough, but it's not ideal.  We continued with this "paradigm" when we migrated to z/OS.

You are the only shop I've ever heard ask about this (other than us).  "Apparently" everyone else who is/was using Oracle Server on z/OS has either migrated to DB2 on z/OS or they are just staying with the back level z/OS Oracle.  Or something else, but I've never heard the something else other than what we are doing.

If you have any pull at all with Oracle I'd love to see them support client-side Oracle on z/OS, even without server-side.

Here's something I just discovered: Oracle Database Provider for DRDA.  Still requires DB2 on z/OS, but could be an alternative to using IBM Federation Server as the "middle tier"/"translation layer".  I don't know anything other than what I read at http://www.oracle.com/technetwork/database/gateways/db-provider-drda-2005417.html and the reference manual.