Oct 19, 2012
ORA-39001:ORA-39000:ORA-39142
12.2K

ORA-39001:ORA-39000:ORA-39142

Error ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 3.1 in dump file “/bds/app/oracle/product/cedb/10.2.0/admin/cdprod/dpdump/tables236351_01.dmp” Solution Import 11g data dump into 10g You can use Oracle data dump to export data dump from 11g server, and import into 10g using the data Pump parameter called Version....
Oct 12, 2012
ORA-39082: Object type PACKAGE_BODY or VIEW
2.4K

ORA-39082: Object type PACKAGE_BODY or VIEW

ORA-39082: Object type PACKAGE_BODY ORA-39082: Object type VIEW ORA-39082 generally occur during the import . The error message states that the object in the SQL statement following this error was created with compilation errors. impdp system/xxxx schemas=DMTRC ┬ádumpfile=DMTRC.DMP logfile=DMTRC.log Import: Release 10.2.0.1.0 – Production on Wednesday, 30 November, 2011 14:40:06...
Oct 11, 2012
Solution of ORA-00376: ORA-01110:
814

Solution of ORA-00376: ORA-01110:

Error Description: ———————– Whenever I try to access a objects it fails with errors. The error message stack follows: ORA-00376: file 9 cannot be read at this time ORA-01110: data file 9: ‘/oradata2/test_tbs02.dbf’ Possible Causes and Solutions: —————————————- A.Tablespace or Datafile Offline: —————————————– As you see the error return with...
Oct 11, 2012
DBVERIFY Datafile Corruption
865

DBVERIFY Datafile Corruption

DBVERIFY Datafile Corruption The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on datafiles whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check...
Oct 04, 2012
ORA-00823: Specified value of sga_target greater than sga_max_size
1.7K

ORA-00823: Specified value of sga_target greater than sga_max_size

ORA-00823: Specified value of sga_target greater than sga_max_size Solution: Shutdown the database and change the value in pfile (sga_target = 3G) Otherwise change the value of sga_max_size
Oct 02, 2012
Find ATG Rollup Patch Level in R12
1.7K

Find ATG Rollup Patch Level in R12

How to Find ATG Rollup Patch Level in R12?? Please use below query to query for ATG rollup Patch level in Oracle Applications. connect to apps schema “sqlplus apps/apps” column BUG format a8; column PATCH format a60; set linesize 100; set pagesize 200; select b.bug_number BUG, b.LAST_UPDATE_DATE LDATE, decode(bug_number, 4440000,...
Oct 02, 2012
ATG patch level oracle apps 11i
1.5K

ATG patch level oracle apps 11i

How to find the atg patch level in oracle apps 11i ? Use below query to query for ATG patch level: Connect to apps schema “sqlplus apps/apps” SELECT (bug_number), decode((bug_number), ‘3438354’,’ATG_PF.H’, ‘4017300’,’ATG_PF.H RUP 1′, ‘4125550’,’ATG_PF.H RUP 2′, ‘4334965’,’ATG_PF.H RUP 3′, ‘4676589’,’ATG_PF.H RUP 4′, ‘5473858’,’ATG_PF.H RUP 5′, ‘5903765’,’ATG_PF.H RUP 6′, ‘6241631’,’ATG_PF.H...