Everyone a great god, recently encountered a strange question, PL/SQL links can be normal after remote ORCLE execute queries, but after a few minutes after use, such as disconnection, and to link it to ORA - 12541 TNS listener, I ping the database server address, and be able to link, have been around the great god, and this problem to share experience ~ thank you very much

CodePudding user response:

What middle through the router, firewall will turn off for a long time without connection
This is a normal phenomenon
Can modify the network equipment Settings, such as the specific IP, a specific port set longer timeout this
Or you set the time to access the database in the application of the mechanism of
If it is a pl/SQL, you can open a window to make it regularly to execute a query

CodePudding user response:

Waiting for a few minutes is not operating, or has been using

CodePudding user response:

reference 1/f, CKC response:

middle through the routers, firewalls, or something will turn off for a long time without connection
This is a normal phenomenon
Can modify the network equipment Settings, such as the specific IP, a specific port set longer timeout this
Or you set the time to access the database in the application of the mechanism of
If it is a pl/SQL, you can open a window to make it regularly performs a query

Now appeared before link data ping this server's IP, or it shall be reported to the TNS without listening, written code timing task to push data to the library is also difficult to push in the past, I've struggled with ping the IP is working properly, the database is too proud jiao the

CodePudding user response:

refer to the second floor baidu_36457652 response:

waited several minutes is not operating, or has been using

No operation, after what has happened is that link the database to ping the IP of the server, or it shall be reported to the TNS without listening, ping an can normal links,

CodePudding user response:

reference 4 floor u012592436 response:

Quote: refer to the second floor baidu_36457652 response:

Waiting for a few minutes is not operating, or has been using

No operation, after what has happened is that link the database to ping the IP of the server, or it shall be reported to the TNS without listening, ping an can normal links,

Did see the sqlnet. At the end of ora sqlnet. EXPIRE_TIME=5 this limitation, feel there firewall Settings
Feeling is the middle

CodePudding user response:

Encountered such a problem, is an office there is something wrong with the wireless router, administrator changed a new one with respect to OK, the specific reason, no down analysis,

CodePudding user response:

Network is stable, configuration issues,

CodePudding user response:

Firewall Settings no longer connection problem!

CodePudding user response:

Hardware problems, from the software is unable to solve,