Hi all,
I am currently studying Oracle DB and App deployments as part of my on-site education and have got a bit confused with the following scenario. (I promise I have researched this but have not found a solution yet)
Aim:
I have a database server with a database deployed (server A) and I have an app server (server B) with the client installed trying to connect to it via a 3rd party app installation wizard but it failed with 'can't connect to database'. I can't get any more info from that log - so not overly useful. I've proven the deployment E2E with everything on the one server only before.
Checks:
I can from server B - SQLPLUS user/pw@tnsname successfully connect to server A.
The servers can ping each other and resolve each other's hostnames.
Potential Issue:
A more experienced colleague is advising - SQLPLUS user/pw should connect to server A. So from what I can see without a TNSNAME - you need the ORACLE_SID set to the DB name. This does not work it gives ORA12545 or ORA12560. I'm just reading that maybe TWO_TASK could help here? But will try that tomorrow. I'm not totally sold that because I can't connect this way it is the reason the app wizard can't connect to my DB. The app wizard asks for all of the DB details (which I've confirmed are correct via sqlplus/sqldeveloper) such as host, port, db name, username, pw. Perhaps without knowing the app code it is too hard to help me(?).
Interested to hear your advice on how I could look into this further or options to consider. Many thanks.