Skip to main content

Listener refused the connection due to NetExcepti​on

I was testing some piece of code for calculation of new date on the basis of a given pattern and the specified date.
I wrote a method to automate the test cases to generates those patterns and calculate the new date for each date of the specified date of the range of years.
Since there were around 1 million pattern test cases are possible, so I want to insert this data in database for any future reference.
After creating a pattern I was inserting data of the pattern and the calculation date along with the calculated date.
It was working fine.

I was prepare to hit the start button now, after testing different patterns individually.
I hit the run button and it started its executions, but in the middle, I got this error.

java.sql.SQLException: Listener refused the connection with the following error:ORA-12516, TNS:listener could not find available handler with matching protocol stack       at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)      at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)      at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)      at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)      at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)      at java.sql.DriverManager.getConnection(DriverManager.java:620)      at java.sql.DriverManager.getConnection(DriverManager.java:200)      at com.ofss.fc.infra.jdbc.FCRJConnection.openConnection(FCRJConnection.java:292)      at com.ofss.fc.infra.jdbc.FCRJConnection.getConnection(FCRJConnection.java:241)      at com.ofss.fc.junit.domain.dda.entity.account.facility.instruction.RecurrencePatternAutomation.runQuery(RecurrencePatternAutomation.java:392)      at com.ofss.fc.junit.domain.dda.entity.account.facility.instruction.RecurrencePatternAutomation.createRecurrencePattern(RecurrencePatternAutomation.java:149)      at com.ofss.fc.junit.domain.dda.entity.account.facility.instruction.RecurrencePatternAutomation.main(RecurrencePatternAutomation.java:83)Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:ORA-12516, TNS:listener could not find available handler with matching protocol stack       at oracle.net.ns.NSProtocol.connect(NSProtocol.java:386)      at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)      at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)      ... 11 more


I am not sure about this error, why I got this. I looked database also, since looking at the trace, it seems that the database connection is not available.
But database was up, so it looks strange to me.

Is it possible that, I am firing so many insert queries in such a small interval, that it denied the insert statements.
If anyone faced such an error, please reply back.
Labels:

Comments

Post a Comment

Popular posts from this blog

B*Tree Reverse index

B*Tree Reverse index is one of the index types that is supported by oracle. It more or less behaves like b*tree unique & non-unique index but only difference is the way it constructs the tree. In this index, index value is stored in the reverse direction when compared to the values in the actual data table. This index is used in order to distribute the index data evenly across all the leaf index nodes if table data is skewed very high. Like b*tree index, this index doesn’t understand NULL. This B*Tree Reverse index can be created on a single column or more than one column. More than one B*Tree Reverse index can be created for the same data table. HOW TO VERIFY: How to verify whether the created index is reverse index or not? Fire this query, select index_type from user_indexes where index_name = 'DEPT_ID_INDX' ð   This query would return “ NORMAL/REV ” (it means it is B*Tree index but of “Reverse” type) LITTLE-KNOWN FACTS TO BE REMEMBERED: ·          If this B*Tree Reve
Post a Comment
Read more

Nested Loop Outer Join

Before we go into this topic in detail, first we will understand what outer join is meant by. For an example, take 2 tables which have to be joined, say “Parent” table & “Child” table [I have taken these table names, only to discuss this topic in an easy way]. If Child table is outer joined with Parent table, then you can say, the matching records from both these tables will be retrieved and then the records which are available only in Parent table will also be retrieved though the corresponding matching records are not available in Child table. This is called outer join. [in natural or equi-join, only the matching records from both the tables will be retrieved.] To perform this outer join, 3 different join techniques have been provided by oracle. ·          Nested loop outer join ·          Hash outer join ·          Sort merge outer join In this, we will discuss about nested loop outer join. To perform this nested loop outer join, Oracle follows these steps (assume, child ta
Post a Comment
Read more

Index Fast Full Scan

Index Fast Full Scan is one of the index access methods supported by Oracle. Index Fast Full Scan is otherwise called as Fast Full Index Scan also. Index Fast Full Scan can be imposed by Oracle Optimizer only in the certain scenario. The scenario where this index would be invoked is, Whenever the Oracle SQL optimizer detects that the query is serviceable without touching table rows, Oracle invokes this fast full index scan and quickly reads every block of the index without touching the table itself provided that query doesn’t contain any ORDER BY clause. The definition for this scan is more or less similar to the index full scan but the only difference is that former  will be invoked when ORDER BY clause is not mentioned in the query. It differs from the index full scan in another way where output won’t be in the sorted order since ORDER BY clause is not mentioned. If Oracle detects the query is serviceable without touching the table rows, it means, all the columns mentioned in th
Post a Comment
Read more