Enable remote connection to oracle database 12c

Navigation
0

I have a database on a server and locally the connection is correct with sqldeveloper but if I try to access from another ip it stays loading and the connection drops by timeout, I understand that I must enable the remote connection but I can not find documentation that serve me and I do not know how to enable this connection and be able to access the database from another part, I appreciate the help in advance.

    
asked by Juan Jose Perdomo Forero 28.08.2018 в 00:01
source

1 answer

1

  • Try to perform a ping from the local machine to the remote machine. This to corroborate that you are in the same network. This test in both directions.

  • If you succeed from step 1 check the firewall of the remote machine! If it's linux , it discards iptables . If Windows discards the firewall from sour cherries ... sorry Windows .

  • Verify that the listener is running perfectly on the remote server.
  • In the tnsname.ora of the local server create the service of the remote server and try via console to apply tnsping (name of the service)

    • Try that and comment to see what happens

    Greetings

        
    answered by 25.09.2018 в 02:04
    When executing a remote command by ssh the variable is cropped Determine if a number of two digits belongs to the fibonacci series