ORA Error Codes

ORA-00059: maximum number of DB_FILES exceeded

Get the db_files parameter value from the following SQL or using pfile.
select value from v$parameter where name = ‘db_files’;
Get the count of the datafiles created
select count(*) from v$datafile;

When exceeding the db_files parameter ORA-00059 error given.
Increasing the value of the db_files parameter will resolve the problem.


ORA-01102: cannot mount database in EXCLUSIVE mode 

First check smon using the command ps -eaf | grep smon Then shutdown database... shutdown immediate Then logout of SQL and again grep for smon... Kill that particular process using kill -9 <PID> Then login to SQL and type startup The database should surely startup now. Error connecting to database EBSTEST: ORA-10 Unable To View The Concurrent Request Output In A Browser [ID 1121304.1] Applies to: Oracle Application Object Library - Version: 12.1.1 and later   [Release: 12.1 and later ] Information in this document applies to any platform. Symptoms Trying to view the output of any concurrent request gives the following error: Error connecting to database EBSTEST: ORA-10 Cause Need to set the variable GWYUID in the apps.conf file Solution To resolve the issue: 1. Set the variable GWYUID in the apps.conf file to APPLSYSPUB/<password>,  the variable,"s_gwyuid_user", should be set in the context file 2. Run AutoConfig 3. Retest for the issue ORA-01654: unable to extend index string.string by string in tablespace string Cause:     Failed to allocate an extent of the required number of blocks for an index segment in the tablespace indicated. Action:     Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.