Using OPS$ user mechanism from SAP/Windows connecting to Oracle/AIX
Hi, I have an SAP Central Instance located on a Windows 2003 server that connects to an Oracle 10.2 database on AIX.
All is working fine with work processes doing direct logon as "Connect sapr3/sap<sid>". However, I would like to use the OPS$ mechanism for connection instead.
I reviewed Note 400241 and created and tested an OPS$sidadm user. However, I am wondering if the work processes are trying to connect via the SAPServiceSID user and that is why my OPS$ authentication is not working.
Can someone tell me what user my Windows work processes are using to connect to the Oracle database on AIX? My AIX system only supports usernames up to 8 characters. If the work processes are running under SAPServiceSID (which is what my SAP service is running under), then is it even possible to use the OPS$ mechanism given the 8 character username limitation?
Thanks much for your help!! --Julie
You don't need to create the user at AIX level, you only need to create the user and db objects within oracle.