Posts Tagged ‘dba immam’

« Older Entries

ORA-00059: Maximum Number Of DB_FILES Exceeded

December 8th, 2025, posted in Oracle Queries
Share

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error.

SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf' size 20G;
alter tablespace DATA add datafile '/u01/data/data15.dbf' size 20G
*
ERROR at line 1:
ORA-00059: maximum number of DB_FILES exceeded

 SOLUTION :

Check for DB_FILES value :

SQL> sho parameter db_files;
 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer    500

Check Value for Total number of datafiles in Database :

 SQL> select count(*) from dba_data_files;
COUNT(*)
----------
        496

Set the db_files parameter to a new high-value :

SQL> alter system set db_files = 1000 scope = spfile;
System altered.

Restart your database :

SQL>shutdown immediate;
SQL>startup
SQL> sho parameter db_files;
 NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_files                             integer            1000
SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf' size 20G;

Issue resolved !!

Share
read more no comments

Oracle Database 23AI Session Related Scripts.

December 1st, 2025, posted in Oracle Queries
Share

Columns Name Details

sid – session identifier
serial# – session serial number
osuser – operating system client user name
machine – operating system machine name
program – operating system program name
module – name of the currently executing module as set by calling the DBMS_APPLICATION_INFO.SET_MODULE procedure

——————————

select * from v$session;

——————————

select SID,SERIAL#,USERNAME,STATUS,SCHEMANAME,OSUSER,MACHINE from v$session where USERNAME=’SYSTEM’;

—————

select SID,SERIAL#,USERNAME,STATUS,SCHEMANAME,OSUSER,MACHINE from v$session where STATUS=’ACTIVE’;

———————

select sid,serial#,osuser,machine,program,module from v$session ;

———————–

Note : Sometimes need to find session details. 
You can change the last line to search for sessions that are running specific queries. 
Replace ALTER TABLE%SHRINK% with another command that you want to search.

SELECT SES.SID,SES.SERIAL# SER#,SES.PROCESS OS_ID,SES.STATUS,SQL.SQL_FULLTEXT
FROM 
   V$SESSION SES,V$SQL SQL,V$PROCESS PRC
WHERE
   SES.SQL_ID=SQL.SQL_ID AND SES.SQL_HASH_VALUE=SQL.HASH_VALUE AND SES.PADDR=PRC.ADDR AND UPPER(SQL.SQL_FULLTEXT) LIKE UPPER(‘ALTER TABLE%SHRINK%’);

   ————————–

How to find sql text and session information history during a week.

select a.SAMPLE_TIME, a.SQL_OPNAME, a.SQL_EXEC_START, a.program, a.client_id, b.SQL_TEXT
from DBA_HIST_ACTIVE_SESS_HISTORY a, dba_hist_sqltext b –v$sqltext b
where a.SQL_ID = b.SQL_ID order by a.SQL_EXEC_START asc;

Share
read more no comments

Oracle EBS R12.1.1 File Locations

November 16th, 2025, posted in Oracle EBS Application
Share

Autoconfig log file :

Apps:

$INST_TOP/apps/$CONTEXT_NAME/admin/log/$MMDDHHMM/adconfig.log.

Database:

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME//adconfig.log $ORACLE_HOME/appsutil/log/$CONTEXT_NAME//NetServiceHandler.log

Startup/Shutdown Log files:

$INST_TOP/logs/appl/admin/log

Apache, OC4J and OPMN:

$LOG_HOME/ora/10.1.3/Apache $LOG_HOME/ora/10.1.3/j2ee $LOG_HOME/ora/10.1.3/opmn

Patch log:

$APPL_TOP/admin/$SID/log/

Concurrent log:

$INST_TOP/apps/$CONTEXT_NAME/logs/appl/conc/log

Clone log :
Preclone log files in source instance 

Apps:

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ (StageAppsTier_MMDDHHMM.log) 

Database:

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/(StageDBTier_MMDDHHMM.log) 

Clone log files in target instance :

Apps :

$INST_TOP/apps/$CONTEXT_NAME/admin/log/ApplyAppsTier_.log 

Database:

$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/ApplyDBTier_.log

Alert Log File:

$ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log

APPL_TOP

[applmgr@gayatri10 ~]$ cd /oracle/PROD/apps/apps_st/appl

INST_TOP

[applmgr@gayatri10 ~]$ cd /oracle/PROD/inst/apps/context_name

COMMAN_TOP

[applmgr@gayatri10 ~]$ cd /oracle/PROD/apps/apps_st/comn

JAVA_TOP  

[applmgr@gayatri10 ~]$ cd /oracle/PROD/apps/apps_st/comn/java

Database_top  

[applmgr@gayatri10 ~]$ cd /oracle/PROD/db/tech_st/10.2.0/appsutil/scripts/PROD_gayatri10/ 

  
Context file:-(.xml)

[applmgr@gayatri10 ~]$ cd /oracle/PROD/inst/apps/PROD_gayatri10/appl/admin

Defaults file location:-(.txt)

[applmgr@gayatri10 ~]$ cd  /oracle/PROD/apps/app_st/appl/admin/PROD/adalldefault.txt
[applmgr@gayatri10 ~]$ cd APPL_TOP/admin/<SID>  


Autoconfig log file :

[applmgr@gayatri10 ~]$ cd /oracle/PROD/inst/apps/PROD_gayatri10/appl/admin/log

Share
read more no comments

IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG)

September 8th, 2025, posted in Oracle EBS Application
Share

IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG)
=================================================

#woesOfDBA, #WoesOfDba, #woesOfDBA, #WoesOfDba, woes of dba, Woes Of Dba, immam dba,dba immam, #immam_dba, #immamDba, #dbaimmam, #dba_immam, IAP-CANNOT READ FIELD,

Issue : One of the concurrent request got failed due to below error on 
R12 Clone instance.

Error :- IAP-CANNOT READ FIELD (FIELDNAME=PARAMETER.CONFIG) 

Application Version  :- 12.1.2
Database version : 11.2.0.3.0

Issue cause : 

The ‘APPLFSTT’ parameter didn’t setup to TWO_TASK name in the  MT node 
LISTENER.ora.

MT node listener.ora :-
APPLFSTT=DXXX2I_FO;DXXX2I_BALANCE;DXXX2I,

Solution :-

1. Change the parameter value for ‘APPLFSTT’ in the APPS LISTENER.ora file 
to show TWO_TASK (SID name) value.
Changes :  APPLFSTT=DXXX2I;DXXX2I_FO;DXXX2I_BALANCE;
2. Bounce your middle Tier.
3. Retest the issue. 


Refer Metalink Doc id :Concurrent Processing - Error AP-CANNOT
READ FIELD (FIELDNAME=PARAMETER.CONFIG) When Viewing the 
Concurrent Request Output [ID 466410.1]
Share
read more no comments

ORA-01194: file 1 needs more recovery to be consistent

September 2nd, 2025, posted in Oracle EBS Application, Oracle Queries
Share

ERROR :

SQL> startup
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: ‘/u01/app/oracle/oradata/denemedb/system01.dbf’

SOLUTION :

SQL> show parameter undo

NAME |TYPE |VALUE
— —| — — — | — — — — — —
undo_management |string |AUTO

SQL> alter system set undo_management=manual scope=spfile;

SQL> ALTER SYSTEM SET “_allow_resetlogs_corruption”= TRUE SCOPE = SPFILE;

SQL> ALTER DATABASE OPEN RESETLOGS;

SQL> alter system set undo_management=AUTO scope=spfile;

SQL> shutdown immediate

SQL> startup
Share
read more no comments
« Older Entries