Category: Blog

 When the weblogic console is not being to launched and you have to enable and disable domain configuration lock from the back end, how will…

set markup html onspool info.htmselect * from dba_objects where object_name=’STATTAB_RES’;spool offset markup html off

While rebuilding an index, if you are facing ORA-08104 error, then you need to clean it using dbms_repair Problem: SQL> alter index sapr3.”ZJDADEMAND~0″ rebuild online;…

Problem:- RMAN-03009: failure of allocate command on ORA_AUX_SBT_TAPE_1 channel at 10/19/2018 23:10:08 ORA-19554: error allocating device, device type: SBT_TAPE, device name: ORA-27209: syntax error in…

Issue:- Error In the adop log :-               [UNEXPECTED]Error occurred while executing – — —- —               [UNEXPECTED]Error while runSyncFS sub-routine is called Explanation:- it…

Error:- You are trying to access a page that is no longer active. – The referring page may have come from a previous session. Please…

Issue:- Below Oracle Homes are already registered in the inventory: /EBS_Data2/oracle/TEST/fs2/FMW_Home/Oracle_EBS-app1 /EBS_Data2/oracle/TEST/fs2/FMW_Home/webtier /EBS_Data2/oracle/TEST/fs2/FMW_Home/oracle_common Exiting Cloning… Ensure that the above Oracle Homes are unregistered from the…

Source Environment Details:  ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db  CRS_HOME=/home/oracle/oracle/product/10.2.0/crs  Oracle Database Version  SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – Prod PL/SQL…

To achieve this you need to create a small package and run a query which I wrote below: Step 1:  Create Package Specification CREATE OR…

After applying patch set 7 on existing oracle (9.2.0.5) to upgrade to 9.2.0.8. The “Ora-32700 error occurred in DIAG Group Service “ occurred at the…