ORA-22303 ORA-00604 OR…

Alertlog:

 

ORA-00018: maximum number of sessions exceeded
Fri Nov 08 07:36:00 2013
Process q000 died, see its trace file
Fri Nov 08 07:36:11 2013
Errors in file/oracle_ebs/prod/db/tech_st/11.1.0/admin/PROD_ebs/diag/rdbms/prod/PROD/trace/PROD_q000_4533.trc:
ORA-00018: maximum number of sessions exceeded
Fri Nov 08 07:36:12 2013
Process q000 died, see its trace file
Fri Nov 08 07:36:22 2013
Errors in file/oracle_ebs/prod/db/tech_st/11.1.0/admin/PROD_ebs/diag/rdbms/prod/PROD/trace/PROD_q000_4577.trc:
ORA-22303: type "SYS"."AQ$_HISTORY" not found
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
Fri Nov 08 07:36:22 2013
Errors in file/oracle_ebs/prod/db/tech_st/11.1.0/admin/PROD_ebs/diag/rdbms/prod/PROD/trace/PROD_q001_4579.trc:
ORA-22303: type "SYS"."AQ$_HISTORY" not found
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
Fri Nov 08 07:36:22 2013

 

 

Tracefile:

 

*** 2013-11-08 07:27:53.998
*** CLIENT ID:() 2013-11-08 07:27:53.998
*** SERVICE NAME:() 2013-11-08 07:27:53.998
*** MODULE NAME:() 2013-11-08 07:27:53.998
*** ACTION NAME:() 2013-11-08 07:27:53.998
 
KSV 18 error in slave process

*** 2013-11-08 07:27:53.998
ORA-00018: maximum number of sessions exceeded
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00018: maximum number of sessionsexceeded

 

 

 

 

 

 

 

 

 

 

 

 

 

ORA-22303 ORA-00604 ORA-00018 ORA-00447 Opirip: Uncaught Error 447(文档 ID 1098521.1)

转到底部

---

修改时间:2013-3-2类型:PROBLEM

In thisDocument
  Symptoms
  Cause
  Solution
  References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.7- Release: 10.2 to 11.1
Information in this document applies to any platform.
***Checked for relevance on 20-Dec-2011***

Symptoms

The following errors are reported in the alert log and tracefile:

ORA-22303: type "SYS"."AQ$_HISTORY"not found
ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process

Cause

The errors were discussed in unpublished Bug 5959280, marked as aduplicate of unpublished Bug 5377190 which has been closed as 'Nota Bug'.

Solution

The ORA-22303 error is misleading.
The real issue is the ORA-00018: maximum number ofsessions exceeded' error which is documented in
Note 419130.1 - ORA-00018: Maximum Number Of SessionsExceeded

References

NOTE:419130.1- Ora-00018: Maximum Number Of Sessions Exceeded