Oracle Error 2391
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this sessions_per_user limit oracle site About Us Learn more about Stack Overflow the company Business Learn more
Sessions_per_user Oracle 11g
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x
Exceeded Simultaneous Sessions_per_user Limit Oracle Error
Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle Error (exceeded simultaneous SESSIONS_PER_USER limit) up vote 2 down vote favorite 1 I have a .Net application with Oracle database. I received the below error while trying to run a report in my application. Request anyone to check and advice if there is a fix for this problem. Also note that I have spoken to my DBA and he says that there is something in the .Net code that is not ending the sessions. The error message is : ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit Let me know if you need any more info .net oracle share|improve this question asked Jan 28 '14 at 15:33 user3245152 112 You should close/dispose your sessions somewhere. –L.B Jan 28 '14 at 15:34 Don't you use connection pools? –Maheswaran Ravisankar Jan 28 '14 at 15:59 2 First check that the limit makes sense. Find the limit with statements like these: select username, profile from dba_users;, select * from dba_profiles where resource_name = 'SESSIONS_PER_USER';. Look at select username, status, v$session.* from v$session; to see where your sessions are coming from. For example: are other people using the account, are some of the sessions "SNIPED" or "KILLED" (these sessions don't always go away quickly), or is anybody using parallelism (in some environments a single user can easily consume hundreds of sessions.) –Jon Heller Jan 29 '14 at 1:20 @OracleUser If you're doing a traditional client-server application, where would you use a connection pool? Each client executable would simply make a direct connection to the database. –ab
production, but I got the Oracle Error: ORA-2391: exceeded simultaneous SESSIONS_PER_USER limit Can I have suitable remedy for this error? View 5 Replies Similar Messages: TNS-00510 / Internal Limit Restriction Exceeded Application Express :: ORA-56720 - I/O Data Limit Exceeded - Call Aborted Backup & Recovery :: ORA-19809 / Limit Exceeded For Recovery Files Maximum Number Of Processes (1100) Exceeded ORA 0100 - Maximum Open Cursors Exceeded? SQL & PL/SQL :: ORA-00020 Maximum Number Of Processes 150 Exceeded ORA-01450 - Maximum Key Length (3118) Exceeded RMAN Error Maximum Number Of 128 Rows Exceeded Server Administration :: ORA-00020 / Maximum Number Of Processes (400) Exceeded Server Administration :: ORA-01000 http://stackoverflow.com/questions/21409899/oracle-error-exceeded-simultaneous-sessions-per-user-limit Maximum Open Cursors Exceeded Server Administration :: ORA-00059 / Maximum Number Of DB_FILES Exceeded Client Tools :: ORA-01000 / Maximum Open Cursors Exceeded RAC/ASM Clusterware Installation :: OUI - Netca Exceeded Number Of Arguments Passed To Stdin SQL & PL/SQL :: ORA-01000 Maximum Open Cursors Exceeded Frequently While Running Application In Java 30 Character Limit? SQL & PL/SQL :: DBA Profile - Limit Value? Limit On A CLOB Server Administration :: http://oracledba.bigresource.com/SQL-PL-SQL-ORA-2391-exceeded-simultaneous-SESSIONS_PER_USER-limit-ZjQ8akZz9.html ORA-28031 Maximum Of 148 Roles Enabled Roles Exceeded UTL_TCP Connection Limit? How To Set Time Limit For A Procedure SQL & PL/SQL :: Wm_concat Limit On Rows? PL/SQL :: ORA-06532 / Subscript Outside Of Limit Possible To Limit Sessions In These Views How To Limit The Table Size SQL & PL/SQL :: Limit Of Number Of Sub Programs In A Package Security :: Limit Sessions Per User In RAC Windows :: Clarification On Oracle XE 4Gb Limit Forms :: Selection Limit On Block? SQL & PL/SQL :: Range Output And Limit Records ADVERTISEMENT TNS-00510 / Internal Limit Restriction Exceeded Aug 23, 2011 TNS-12540: TNS:internal limit restriction exceededTNS-12560: TNS:protocol adapter errorTNS-00510: Internal limit restriction exceededDEC OSF/1 AXP Error: 28: No space left on device View 4 Replies View Related Application Express :: ORA-56720 - I/O Data Limit Exceeded - Call Aborted Sep 16, 2012 I have a workspace on [URL] I tried to copy an application. It gives meGET_STMT error. ORA-56720: I/O data limit exceeded - call aborted:281:0ORA-56720: I/O data limit exceeded - call aborted View 3 Replies View Related Backup & Recovery :: ORA-19809 / Limit Exceeded For Recovery Files Mar 22, 2012 while opening my database i got this error i already increase my db_recovery_file_dest_size but still i got this errorE:oracleproduct10.2.0db_1BIN>SET ORACLE_SID=LIVEDBE:oracleproduct10.2
and other http://www.oracle.com/pls/db92/db92.error_search?prefill=ORA- troubleshooting information in these books. List of Message Types ORA-00000 to ORA-00899 ORA-00900 to ORA-01499 ORA-01500 to ORA-02099 ORA-02100 to ORA-04099 ORA-04100 to ORA-07499 ORA-07500 to ORA-09857 ORA-09858 to ORA-12299 ORA-12300 to ORA-12399 ORA-12400 to ORA-12699 ORA-12700 to ORA-19399 ORA-19400 to ORA-24279 ORA-24280 to ORA-29249 oracle error ORA-29250 to ORA-32799 ORA-32800 to ORA-32999 ORA-33000 to ORA-65535 BFILE-Related Messages (LFI) DBNEWID Messages (NID) DBVERIFY Messages (DBV) Export Messages (EXP) External Naming Messages (NNF) External Tables Messages (KUP) Import Messages (IMP) interMedia Audio Messages (AUD) interMedia Image Messages (IMG) interMedia Video Messages (VID) Network sessions_per_user limit oracle Security Messages (NZE) Object Type Translator Initialization Messages (O2I) Object Type Translator Type File Messages (O2F) Object Type Translator Unparser Messages (O2U) Oracle Names Client Messages (NNC) Oracle Names Control Utility Messages (NNL) Oracle Names Server Messages (NNO) Oracle Names Server Network Presentation Layer Messages (NPL) Oracle Net Messages (TNS) Oracle OLAP Catalog Metadata Messages (AMD) Oracle Text Messages (DRG) Oracle Trace Collection Services Messages (EPC) Parameter Messages (LCD) Parameter Messages (LRM) PCF FIPS Messages (PCF) PL/SQL and FIPS Messages (PLS) Pro*C/C++ Messages (PCC) Pro*COBOL Messages (PCB) Recovery Manager Messages (RMAN) Remote Operation Messages (NCR) Simple Network Management Protocol Messages (NMP) SQL Runtime Messages (SQL) SQL*Module Messages (MOD) Summary Advisor, Explain Rewrite, and Explain Materialized View Messages (QSM) XML Parser Messages (LPX) XML Schema Processor Messages (LSX) Copyright © 2016, Oracle. All rights reserved.