Oracle. How to set up a remote connection?

Question

Oracle

There is a remote machine - Windows 2012 Server.
It seems that I set everything up, wrote something in the registry ... All the connection works on it. But I can't connect to mine.
Tried both sqlplus and sqldeveloper .
listener.ora
SID_LIST_LISTENER . In section SID_DESC
(global_dbname = real ip)
....
LISTENER . In the DESCRIPTION section , I added all kinds of addresses: localhost, ip address, computer name . And one field was initially with protocol = ipc, key = extproc1521
---- listener.ora end ----
On connection (after some waiting) timeout -ORA-12170: TNS:Connect timeout occurred
How to set up a remote connection, do I need to create a user with special privileges for this?
PS The command sqlplus usr/[email protected]/sid works on it, where instead of ip both real ip and localhost
But there is another Windows 2008 Server machine where it works only with localhost.

Answer 1

Decided!!!
It was the firewall.
After resolving, another error appeared - ora-12638 ,
after googling, did the following: commented out the line
And yes, as Vapaamies said , set the value to GLOBAL_DBNAME too, which was in SID_NAME

Answer 2

Well, if it works locally, then the problem is most likely in the network.
tracert to a remote machine what does it say?

Answer 3

first, check the availability of the oracle server port from your PC from CMD
telnet IP_or_server_name 1521
if as a result you get an error that there is no access, THEN you need to solve the problem with network availability,
if everything is OK, write we will continue to look
at the listener.ora example on the server

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = d:\app\drno\product\12.1.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:d:\app\drno\product\12.1.0\dbhome_1\bin\oraclr12.dll")
    )
  )

  
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.41)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )	
  )

and
tnsnames.ora on the client

ORACLE_SERVER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.41)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mycrm)
    )
  )

Answer 4

The GLOBAL_DBNAME parameter must be set to the simple or domain name of the database instance , not the IP. IP is written in the HOST parameter. Don't forget to restart the service after setting it up.