Oracle Apps DBAs - When Database is up, listener is up. listener.ora and tnsnames.ora both are configured properly, still client is not being able to make a connection to the database. What may be the possible issues ?
– Firewall blocking db port between client and server
– Authentication restricted in sqlnet.ora (Client allowed from only selected machines)