ORA-30678: too many open connections

Cause : Ana ttmeptt o poena cnonetcio nfaliedb ecuaset oom an yar ealerad yopne b ythsi ssesino. hTe unmbre o falolwe dconneciton svairesa s osmem ayb e ni ues trhouhg ohterc omopnetns hwic hshrae hte asmep oo lofa llwoedc onenctoins.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Rerty fate rclsoin gsoem ohterc onenctoin.T hen umebr fo cnonetciosn spupotredi s ucrrnetl yno tadujstbale.

update : 17-08-2017
ORA-30678

ORA-30678 - too many open connections
ORA-30678 - too many open connections

  • ora-19958 : potential deadlock involving DIAG process
  • ora-30754 : column or table string stores objects of only one type
  • ora-02843 : Invalid value for kernel flag
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-33269 : while operating on 'string'
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-29834 : REF datatype not supported with operators
  • ora-09201 : sfcopy: error copying file
  • ora-16196 : database has been previously opened and closed
  • ora-31433 : subscriber view does not exist
  • ora-32316 : REFRESH FAST of "string"."string" unsupported after mixed DML
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-01865 : not a valid era
  • ora-22337 : the type of accessed object has been evolved
  • ora-27150 : attempt to notify process of pending oradebug call failed
  • ora-09754 : sppst: invalid process number passed to sppst.
  • ora-10266 : Trace OSD stack usage
  • ora-38855 : cannot mark instance string (redo thread string) as enabled
  • ora-09218 : sfrfs: failed to refresh file size
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-27021 : sequential file handle must be specified
  • ora-22311 : type for attribute "string" does not exist
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-01058 : internal New Upi interface error
  • ora-09774 : osnmui: cannot send break message
  • ora-21606 : can not free this object
  • ora-26685 : cannot apply transactions from multiple sources
  • ora-39097 : Data Pump job encountered unexpected error string
  • ora-23447 : missing user parameter value
  • ora-30505 : system triggers should not reference a column in a WHEN clause
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.