Error: =========== We came across below ORA error during import of Schema ORA-39083: Object type TYPE:”FMSDEV”.”SAMPLE_TYPE_TABLE” failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE…
Read MoreWe have to check the below details before reorganize the table TABLE DETAILS SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES/1024/1024/1024 FROM DBA_SEGMENTS WHERE SEGMENT_NAME IN (‘WF_ITEM_ACTIVITY_STATUSES_H’); OWNER …
Read MoreSQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreFRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. We…
Read MoreERROR: ORA-12547: TNS :lost contact when try to connect to Oracle There could be many reasons for the above error, but one of the common issue is due to incorrect…
Read MoreA snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. The snapshot controlfile must be on a location shared…
Read MoreApplies to: Oracle E-Business Suite Technology Stack – Version 11.5.10.0 to 11.5.10.0 [Release 11.5] Information in this document applies to any platform. Checked for relevance on 25-SEP-2013 Goal How to…
Read MoreWe are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read MoreApplies to: Oracle Applications Manager – Version 12.2.4 and later Information in this document applies to any platform. Symptoms E-Business Suite 12.2 Applications Manager, Rapidclone related issues Cloning the applications…
Read More