DBA Arena

1. Check database and application availability
2. Check status of cluster services
3. Monitor space availability in all tablespaces
4. Check for errors in Database Alert log files and take appropriate action
5. Check Concurrent Managers
6. Check /tmp for space constraints
7. Check invalid objects and compile if required
8. ASM Grid Space Check
9. Database and Application Mount points check
10. Verify Backups
11. Verify Gather Schema Statistics and Purge Concurrent Request and/or Manager Data Concurrent Requests are scheduled and are completing successfully

Read more...

Objective:

The objective is to migrate the EBS instance from a server running Linux 5 to a new server running Linux 7.

Environment Details:

EBS R12.1.3, Database 11.2.0.4
Mount points: Database: /ddb02, Application: /dap01

Create Users and Groups on the new server.

[root@ebs01 ~]# groupadd dba

[root@ebs01 ~]# groupadd oinstall

[root@ebs01 ~]# groupadd oper

[root@ebs01 ~]# groupadd asmdba

[root@ebs01 ~]# groupadd asmoper

[root@ebs01 ~]# useradd -g dba -G oinstall,oper,asmdba,asmoper -m oradev

[root@ebs01 ~]# useradd -g dba -G oinstall,oper -m appldev

[root@ebs01 ~]# groups oradev

oradev : dba oinstall oper asmdba asmoper

[root@ebs01 ~]# groups appldev

appldev : dba oinstall oper

Read more...

Error :

While starting the application services, Apache services do not start.

Error in the log file:
/dap01/appldev/EBSDEV/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb-4.3.so: cannot open shared object file: No such file or directory

Cause:

This is caused by having an older Oracle HTTP Server installed on a newer Operating System. For the OPatch issue, Perl is expecting to find the /usr/lib/libdb-3.3.so library, but it is missing.
The following command locates a higher version of the library (for example, /usr/lib/libdb-4.1.so)

/libdb ls -al /usr/lib *.so
 
Note that the error can be a newer library, depending which is found and used from the operating system. (e.g., libdb-4.2.so, libdb-4.3.so, libdb-4.4.so, etc).

The correct libdb filename to use should depend on output of ldd httpd, for example:


cd $ORACLE_HOME/Apache/Apache/bin
ldd httpd | grep libdb
libdb.so.2 => /usr/lib/libdb.so.2 (0x00868000)


•In this case, libdb.so.2 is expected
•In this case, having libdb-3.3.so will not help

Read more...

ORACLE error 20100 in FDPSTP
FDPSTP failed due to ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.
Directory &FILE_DIR is invalid, contact your system administrator.

Check that the directory is a valid directory with wri06-APR-2016 14:48:29

The concurrent program was unable to write to the specified temporary file because the virtual path assigned to the APPLPTMP environment variable is not referenced in the UTL_FILE_DIR
Read more...

Error:

Unable to generate forwarding URL. Exception: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

ORA-00257: archiver error. Connect internal only, until freed

Solution:

Check Flash Recovery Area usage:

SELECT
ROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,
ROUND((A.SPACE_USED / 1024 / 1024 / 1024), 2) AS FLASH_USED_IN_GB,
ROUND((A.SPACE_RECLAIMABLE / 1024 / 1024 / 1024), 2) AS FLASH_RECLAIMABLE_GB,
SUM(B.PERCENT_SPACE_USED) AS PERCENT_OF_SPACE_USED
FROM
V$RECOVERY_FILE_DEST A,
V$FLASH_RECOVERY_AREA_USAGE B
GROUP BY
SPACE_LIMIT,
SPACE_USED ,
SPACE_RECLAIMABLE;
Read more...