The operating system is Windows 7 (64) also has appeared win2012, oracle11g,
With client PC pl/SQL dev tools to connect to the database, no problem, run the statement is no problem, but if no longer operating, and after 2-3 hours to run again, pl tools will be stuck for a while, and then an error ora - 12152 error, must make a new link, to run again,

Before the server is a Windows 2003 system, whether oracle 9 I or 11 g won't appear this kind of error, trouble to know the great spirit guide instruction, thank you.

CodePudding user response:

With q, thank you, xp system, connecting oracle in the long run will quote this error, can not find a solution. O solve

CodePudding user response:

reference 1st floor Andy114459807 response:

q, thank you, xp system, connecting oracle in the long run will quote this error, can not find a solution. O solve

This is not a bug, just automatic release resources database, you can view the SELECT * FROM DBA_PROFILES; How long don't operate automatically disconnect query connection,

CodePudding user response:

The firewall off a try?

CodePudding user response:

Database may set up a connection timeout:
1, profile, such as 2 #, to query dba_profiles can check;
2, sqlnet. Ora file may set the timeout
Are more likely to be a database, the firewall Settings timeout,