I'm trying to understand how I can install Apex and connect to a database using entries on my TNSNAMES.ORA file
( Oracle 11g2r Apex 4.2)
Can I do this if I use the embedded PL/SQL gateway?
Is there some documentation that talks about this? I'm not finding anything
the question may be simple, but it still doesn't make sense. As Hari alluded to, coming to an understanding of the Apex architecture should answer your questions.
This is because TNS connections allow connections to a database by a client. In the case of Apex, it is a 3 tier architecture meaning the connection to the database is handled by an application server, and not the user client, which is a browser. This means that any TNS configuration happens between the application server, typically Oracle's HTTP server or the Apex Listener, and the database. In the case of the embedded PL/SQL gateway (EPG) no TNS configuration is necessary as the EPG is embedded in the database.
I hope this helps you understand why your question didn't make sense.