How to Modify an Oracle Database Windows Service?
How we can change some parameters for one database winodws service. Background: I have a database called PROD with version 19.3, running on Windows. Its service looks like: This…
Read MoreOPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 “Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714” on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will…
Read MoreORA-29283: invalid file operation: path traverses a symlink [29433]
DB : Oracle 19.5 OS : RHEL 7 Expdp is failing due to the below error in my 19c database Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42…
Read MoreChange DB Alert Log metric on 13C:
Oracle Enterprise Manager database plugin version 12.1.0.4, there is a new metric “DB Alert Log” available. This metric replaces the existing “Alert Log” metric. The benefit of the new plugin…
Read MoreResolve ORA-01111, ORA-01110, ORA-01157
Mailn reasons for a file being created as UNNAMED or MISSING in the standby database, including insufficient disk space on standby site (or) Improper parameter settings related to file management.…
Read MoreEM 13.2: opatch lsinventory Command Fails With Error “RawInventory gets a null Vector of one-off entries
1. Error Message:- I faced with that error message while I was trying to apply 13.2.0.0.0 patch [oracle@TESTOEM]$export ORACLE_HOME=/u01/app/oracle/product/agent13c/agent_13.2.0.0.0 [oracle@TESTOEM]$export PATH=$PATH:/u01/app/oracle/product/agent13c/agent_13.2.0.0.0/OPatch/ [oracle@TESTOEM]$ opatch lsinventory Oracle Interim Patch Installer version…
Read MoreConvert Oracle 12c database from Non-ASM to ASM (standalone)
Now from 12c database you can move/relocate datafiles ONLINE menaing users can still able to access the database and objects while the move/relocate is in process, prior to 12c it…
Read MoreORA-02020: Too Many Database Links In Use
PROBLEM: While querying against a database link, got below error. select sysdate from dual@DBLINK * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION:…
Read MoreORA-29283: invalid file operation: path traverses a symlink [29433]
DB : Oracle 19.5 OS : RHEL 7 Expdp is failing due to the below error in my 19c database Export: Release 19.0.0.0.0 – Production on Thu Apr 30 06:06:42…
Read MoreUC: Time Drift Detected
Issue:- alert found into the alert logfile. Warning: VKTM detected a forward time drift. Time drifts can result in unexpected behavior such as time-outs. Please see the VKTM trace file…
Read More