I am trying to make the connection in the database, between a notebook (client) and a desktop (server).
I fixed the server IP.
Set the TNSNAMES.ORA to make the connection.
through the client I can perform a ping on the server.
However when attempting to connect the server the ORA-12514 error is displayed.
TNSNAMES.ORA information is like this:
EQUILIBRIUN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EQUILIBRIUN)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = Usuario-PC)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
)
)
Services are all in the air, both on the server, and the client.
Once informing the IP directly on tnsnames.ORA did not see the need to change sqlnet.ora.
Any help they can provide, will be very welcome.
Thank you for your attention.