Colleagues PLSQL can normal visit test database of the computer, my computer to access the test database in the following situations:
Through powershell can remote link test environment database and query properly
Through PLSQL (11) can link test database, SQL, the query has been is being initialized, then PLSQL showed no response
Tip: when The test database by sqldeveloper link status: failure - test fails: IO error: The Network Adapter could not establish The connection


What conditions will lead to appear this kind of circumstance? Now want to use PLSQL query test database, how to deal with?

The local database version: oracle11g, test database version: oracle 11 g
Test environment database: monitor is started

CodePudding user response:

Make sure your server can connect, and even on any operation without any caton, then give the output of the command below:
LSNRCTL status
The vmstat 2 10

CodePudding user response:

reference 1st floor minsic78 response:

make sure your server can connect, and even on any operation without any caton, then give the output of the command below:
LSNRCTL status
The vmstat 2 10

Not careful, when I didn't speak, on the ground floor,

CodePudding user response:

The last time this two days has been no overtime
The vmstat output 2 10 below

CodePudding user response:

reference Eagle__sky reply: 3/f

it has been two days work overtime last time no
The vmstat output 2 10 below

before I haven't the topic carefully, because the reply of the first floor,,,

But since the open pit, or let me efforts:

Look at the building Lord server LSNRCTL status of output, and give you use PLSQL tnsnames definition when connect to the database,

CodePudding user response:

Tnsping service name 10 to see what results