Hello everyone,
I just setup 12c on my Oracle Linux box and I'm able to connect locally to the database as wished. Now what would be the first step in order to connect to my database externally from another computer on the network. For example, if the Database server is 10.0.0.150 and I want to connect from 10.0.0.151 how can I make this happen? If needed here are some references:
-bash-4.2$ cat listener.ora
# listener.ora Network Configuration File: /ora01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oranode1.dba.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
-bash-4.2$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /ora01/app/oracle/product/12.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ANTHONYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oranode1.dba.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = anthonydb)
)
)
-bash-4.2$ cat /etc/hosts
127.0.0.1 oranode1 oranode1.dba.com localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.0.0.150 oranode1.dba.com oranode1
Let me know if you need any information. I currently, am not able to connect to my database using IP and port (10.0.0.150, 1521) from my pc 10.0.0.151. Thank you all for your help, in advance.