#!/bin/bash ############################################################################### # File Name : tablespace_free_space.sh # Author : Vimal Raju # Date : 27/11/2014 # Description : Tablespace size check # ###############################################################################…
Read MoreIssue: We had a request to refresh FND_TOP alone. We stopped the application process and refreshed the FND_TOP from production. As expected forms were not opened up so we have…
Read MoreFind the below commands to rebuild Index, Partitioned Index, LOB Index, IOT (Index Organized Table), To rebuild the index: set pagesize 1000 SELECT ‘ALTER INDEX ‘ || OWNER ||’.’||index_name ||’…
Read MoreWhile exporting we got the following error, UDE-31623: operation generated ORACLE error 31623ORA-31623: a job is not attached to this session via the specified handleORA-06512: at “SYS.DBMS_DATAPUMP”, line 3326ORA-06512: at…
Read MoreWe got the following error while starting up the database, SYS> startup mount pfile=initabc.oraORA-32006: PARALLEL_SERVER initialization parameter has been deprecatedORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status:…
Read MoreIf your are getting the below error while starting the 12c OEM agent, java.lang.OutOfMemoryError: unable to create new native thread Then check for the below logfiles of 12c OEM agent,…
Read MoreThe Below script will List the Oracle Application users with the specified age limit select papf.employee_number,papf.full_name, papf.date_of_birth from per_all_people_f papf,fnd_user fu where papf.person_id=fu.employee_id and substr(papf.date_of_birth,8) <= 56 –year (2014-58=56) –Here…
Read MoreHow to Find E-Business Suite Patches & E-Business Suite Technology Stack Patches
Read MoreIf you are getting the below error in OID while using ldap, then it means the super user is locked. [oracle@xyz bin]$ ./ldapsearch -h xyz.oracle.com -p 389 -D cn=orcladmin -w…
Read MoreOracle Database 12c introduces the new Parallel Upgrade Utility, catctl.pl. This utility replaces the catupgrd.sql script that was used in earlier releases. Although you can still use the catupgrd.sql script,…
Read More