Oracle Connection String in asp.net c#

Question

Please help..... I'm using c# asp.net and oracle database, And here is my connection string static string strConnection = "Data Source=test;User ID=testing;Password=test123"; public OracleConnection DbConn = new OracleConnection(strConnection); DbConn.Open(); then i got this error: ORA-00018.Maximum number of sessions exceed , i did anything from own idea but it doesn't work. thank you.

Manas Mohapatra · Answer

As per your error, it is using all the sessions in Oracle DB Server. There is no session available for next call so you are getting error. You need to increase session values Oracle DN Server. Please go through below article: http://nimishgarg.blogspot.in/2011/11/ora-00018-maximum-number-of-sessions.html If doesn't resolve your problem please details here.

mudar dastam · Answer

yes i did. and i checked all the connection string it is properly opened and properly closed. i think this is from asp.net side problem.

Manas Mohapatra · Answer

1. Did you go through the link I provided. 2. Please make sure that you are closing the connection. Ask your administrator to increase sessions in Oracle database.

mudar dastam · Answer

regarding the database i don't have an authorized to modify or do something else, but the session parameter it is already increased by the oracle administrator. it was 5 session parameter limits now it's 10 session parameter limits. but still the same error. by the way thanks for help.

Oracle Connection String in asp.net c#

Answers (4)