Having tenant metadata in Oracle configured using a TNS name specified in tnsnames.ora, you cannot login into the Mobile App getting "Invalid User" error.
Having data in Oracle configured using a TNS name specified in tnsnames.ora, you get error while trying to load the Mobile App assigned to you.
On the server side you can check the event viewer and you will find an error related to a .NET application. In the details you will find an oracle error like:
ORA-12154: TNS:could not resolve the connect identifier specified
That errors is related to the Oracle .NET managed driver that is not capabile or reading the settings in the Windows registry. Please refer to:
You have to manually edit the web.config file of the Mobile endpoint within:
[M.App Enterprise installation folder]\Mobile
You have to add the following within the <configuration> section:
<configSections> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89b483f429c47342"/> </configSections>
<oracle.manageddataaccess.client> <version number="*"> <settings> <setting name="TNS_ADMIN" value="C:\oracle\product\18.0.0\client_1\network\admin" /> </settings> </version> </oracle.manageddataaccess.client>