Home > database >  Oracle12C connection issue
Oracle12C connection issue

Time:09-18

The ultimate goal is to apply to TCPS connected to oracle12c, (local and virtual machine installed oracle12c as experimental, the inside of the virtual machine database as a server)
Problem is in the process of installation, follow steps will listen on port configuration for 2484 online, do not specify a user can connect to the database when the service and port, specify the host port instead of listening is not open, but check the listening state when the display is normal, just one more port 5500 started, when checking their port found 2484 port is not in use, want to ask about the causes of this problem, and whether can amend the configured 2484 port to port 5500,,,

CodePudding user response:

You didn't match well, hair configuration and have a look

CodePudding user response:

Mark, I oracle12C local Linux virtual machine, virtual machine OK, however, the native Windows always connected, with bosses around ~ ~ ~

CodePudding user response:

refer to the second floor non-breaking response:
Mark, my local oracle12C Linux virtual machine, virtual machine OK, but not native Windows always connected, with bosses around ~ ~ ~

LSNRCTL status the status of the LISTENER to see listen
Then
Windows CMD
First tnsping usr/PWD @ IP: port/service_name
Up sqlplus usr/PWD @ IP: port/service_name

CodePudding user response:

references to learning turn reply: 3/f
Quote: refer to the second floor non-breaking response:

Mark, I oracle12C local Linux virtual machine, virtual machine OK, but not native Windows always connected, with bosses around ~ ~ ~

LSNRCTL status the status of the LISTENER to see listen
Then
Windows CMD
First tnsping usr/PWD @ IP: port/service_name
Up sqlplus usr/PWD @ IP: port/service_name

Thank you, after checking found TNS is normal, the listener is normal,
The final solution, if can arrive up sqlplus on Linux, and connection can be used, so, please click the following:
1: close the Linux firewall
Check the firewall status: service iptables status
Close the firewall: service iptables stop
Cancel the firewall from rev: when the phone is switched on the chkconfig iptabels off
2: replace 12 c client, on oracle's website, download the corresponding client, replace the connection tools oci file, restart the connection tools can,
  • Related