I am configuring a server in CentOS 7 to connect to an Oracle database within the same network. IP ORACLE = 192.167.10.100 IP SERVER = 192.167.15.123
I have installed the Instant Client Package: Basic, SDK and SQL * Plus. Link Download .
Then set the environment variables:
ORACLE_HOME = / usr / lib / oracle / 12.2 / client64
PATH = $ PATH: $ ORACLE_HOME / bin
LD_LIBRARY_PATH = $ ORACLE_HOME / lib
TNS_ADMIN = $ ORACLE_HOME / network / admin
When entering with SQL * Plus using the implicit connection string: With the format.
sqlplus username / password @ host: port / sid
sqlplus testuser/[email protected]:1521/testdb
I get the error: ORA-12170: TNS: Connect timeout occurred
I have been able to connect with the same credentials from a Windows PC with Oracle SQL Developer but from CentOS I get an error:
Someone to help me find the solution, please.