Oracle problem in PLSQL connect the HYPER

Hello, everyone, today again in the HYPER - V installed Oracle, host virtual machines are WIN10, now can host the virtual machine via remote desktop connection, Telnet test, an open port 1521, why use PLSQL connection, has been in is on state, is always not on,
Yesterday host and virtual machine is through the external network connections, PLSQL connection is no problem, then today for internal network connection, and then I put the tnsname. Ora the relevant IP also changed, even not, study the whole day, please pass by master save me!!!!!!!!

CodePudding user response:

This is likely to be the cause of the network,
1. Ping server id
2. Ping database connection string
Give it a try!

CodePudding user response:

Hello, server id can ping, ping database connection string, however, I didn't understand what meaning,

CodePudding user response:

What do you mean by external and internal network?
Ping of the database connection string a server_name tnsping configuration

CodePudding user response:

The

reference 3 floor jdsnhan response:

what do you mean by external and internal network?
Ping of the database connection string means tnsping configuration server_name

WIN10 connect the HYPER - V virtual machine, there are three types of virtual switches, respectively is external, internal, dedicated, I said external networks refer to those I set is external virtual switch type,
This my own habits, didn't pay attention to,

CodePudding user response:

In front of a few let ping, tnsping, have what results?

CodePudding user response:

reference 5 floor minsic78 reply:

front several ping, tnsping, have what results?

Tnsping seems to have to install on the client (the host) Oracle can pass, I don't have to install Oracle client, so prompt tnsping not internal or external command, but on the server (virtual machine) can be pass,
In addition, in both on the server and the client, is able to ping, no problem,

CodePudding user response:

refer to 6th floor qq_19832477 response:

Quote: refer to the fifth floor minsic78 reply:

In front of a few let ping, tnsping, have what results?

Tnsping seems to have to install on the client (the host) Oracle can pass, I don't have to install Oracle client, so prompt tnsping not internal or external command, but on the server (virtual machine) can be pass,
In addition, in both on the server and the client, is able to ping, no problem,

That's because you're the client installed gimped instant client, so there is no tnsping, that's the trouble, let me guess: open your virtual writers fire wall?

CodePudding user response:

Find another under surveillance, log files, look at your remote connections, listening ever detected your remote connections,

CodePudding user response:

refer to the eighth floor minsic78 response:

in addition, to find the listening log files, look at your remote connections, listening ever detected your remote connections,

Firewall is turned off,
When the remote connection, I was in the listening log file inside, I find that a log:

Type='UNKNOWN' level='16' host_id='NORM'
Host_addr='fe80: : 189 a: e814:4766:12' 794 f % & gt;
23-11 chain? 2017 10:12:27 * (CONNECT_DATA=https://bbs.csdn.net/topics/(=DEDICATED SERVER) (SERVICE_NAME=former) (CID=(PROGRAM=E:/software/E/OracleClient/plsqldev. Exe) (HOST=ZHOU) (USER=ZHOU))) * (ADDRESS=(TCP) PROTOCOL=(HOST=169.254.248.215%12) (64088) PORT=) * establish * wouldn * 0

E: \ software \ \ E OracleClient \ plsqldev exe is my client PLSQL, ZHOU is my client computer name, ZHOU is a user name, behind the HOST is the client's IP,
This should be detected my remote connection?

CodePudding user response:

references 9 f qq_19832477 response:

Quote: refer to the eighth floor minsic78 response:

Find another under surveillance, log files, look at your remote connections, listening ever detected your remote connections,

Firewall is turned off,
When the remote connection, I was in the listening log file inside, I find that a log:

Type='UNKNOWN' level='16' host_id='NORM'
Host_addr='fe80: : 189 a: e814:4766:12' 794 f % & gt;
23-11 chain? 2017 10:12:27 * (CONNECT_DATA=https://bbs.csdn.net/topics/(=DEDICATED SERVER) (SERVICE_NAME=former) (CID=(PROGRAM=E:/software/E/OracleClient/plsqldev. Exe) (HOST=ZHOU) (USER=ZHOU))) * (ADDRESS=(TCP) PROTOCOL=(HOST=169.254.248.215%12) (64088) PORT=) * establish * wouldn * 0

E: \ software \ \ E OracleClient \ plsqldev exe is my client PLSQL, ZHOU is my client computer name, ZHOU is a user name, behind the HOST is the client's IP,
This should be detected my remote connection?

Is not detected, and the connection is established, then the waiting is in the database, often appear this kind of circumstance is because a lot of short connection to connect storm out of the question, or password wrong connection constantly retry out, but this should not be in both cases you? When stuck on the database server to check the v $session if there is any program field for PLSQL (concrete may be other values, such as PLSQL developer, etc.) that the event (v $session of another field), then do further diagnosis,

CodePudding user response:

references to the tenth floor minsic78 response:

Quote: references 9 f qq_19832477 response:

Quote: refer to the eighth floor minsic78 response:

Find another under surveillance, log files, look at your remote connections, listening ever detected your remote connections,

Firewall is turned off,
When the remote connection, I was in the listening log file inside, I find that a log:

Type='UNKNOWN' level='16' host_id='NORM'
Host_addr='fe80: : 189 a: e814:4766:12' 794 f % & gt;
23-11 chain? 2017 10:12:27 * (CONNECT_DATA=https://bbs.csdn.net/topics/(=DEDICATED SERVER) (SERVICE_NAME=former) (CID=(PROGRAM=E:/software/E/OracleClient/plsqldev. Exe) (HOST=ZHOU) (USER=ZHOU))) * (ADDRESS=(TCP) PROTOCOL=(HOST=169.254.248.215%12) (64088) PORT=) * establish * wouldn * 0

E: \ software \ \ E OracleClient \ plsqldev exe is my client PLSQL, ZHOU is my client computer name, ZHOU is a user name, behind the HOST is the client's IP,
This should be detected my remote connection? nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull