ERRORS & SOLUTION in ORACLE APPS

We face many errors in oracle application in day to day activity. I am sharing some of them as may be this will help you to save time.


ERROR 1
ORA-00020: maximum number of processes (200) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.

 Reason :-- we are exceeded from the defined range of the sessions. So please find the below solution for this problem.


Solution :--  It is very common error that we face day to day. For this please  Increase the processes & Session in  DB
e.g. alter system set processes=XXX scope=spfile;
     alter system set sessions=XXX scope=spfile;
And bounce the Database properly.


ERROR 2

frm-92050 failed to connect to the server hostname:hostname:9000


Solution :--

Have a look at the following notes (especially the troubleshooting note):

Note: 252113.1 - Login Issue Failed To Connect To The Server Frm-92050 After Specfic Number Of Connections
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=252113.1

Note: 299187.1 - FRM-92050 Errors on Linux Oracle Applications 11i installs
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=299187.1

Note: 365529.1 - Troubleshooting FRM-92XXX Errors in Oracle Applications
https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=365529.1

ERROR #

ISSUE :- ORA-01555 : snapshot too : old

Cause :-  Running big transection

Solution :- For this error just follow the following steps:-

1)     First check the size of UNDOTBS1 tablespace. Increase the size if it is  full .

2)     Check the undo_retention parameter. This is dynamic parameter and you can change it whenever you want. So  I found that this parameter is set to 900 i.e. in seconds. So I have increased this values to 2700.