Posted by Mir Sayeed Hassan on July 19th, 2023
Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch
Check the status of the OMS
[oracle@oemdb ~]$ cd /u01/OEM13.5C/middleware/bin/
[oracle@oemdb bin]$ ./emctl status oms
Oracle Enterprise Manager Cloud Control 13c Release 5
Copyright (c) 1996, 2021 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle...
Read more..
Posted in Patching | Comments Off on Apply the Latest OMSPatcher on OEM Server before apply the Main DBRU Patch
Posted by Mir Sayeed Hassan on May 7th, 2023
Apply the DBRU Patch_19.18 for Oracle Database 19C Grid Infrastructure on Standalone server
Check the status of Database
[oracle@stagdb2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 1 16:53:37 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise...
Read more..
Posted in Patching | Comments Off on How to apply the DBRU Patch_19.18 for Oracle Database 19C Grid Infrastructure on Standalone server
Posted by Mir Sayeed Hassan on May 4th, 2023
How to login the user schema without knowing the password in Oracle Database 19c
Note:
– This scenario is to login to the user without knowing the password & perform some test operation purpose only.
– You can change/re-set the user password with new password but inconvenience to the end user.
– Therefore the Oracle...
Read more..
Posted in DBA Administration | Comments Off on How to login the user schema without knowing the password in Oracle Database
Posted by Mir Sayeed Hassan on May 1st, 2023
Apply the Latest DB RU Patch_19.18 (34765931) on Oracle Database 19C
Check the status of Database
[oracle@db-stag ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 1 16:53:37 2023
Version 19.17.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release...
Read more..
Posted in Patching | Comments Off on Apply the Latest DB RU Patch_19.18 (34765931) on Oracle Database 19C
Posted by Mir Sayeed Hassan on May 1st, 2023
Apply the Latest OPatch (12.2.0.1.37) for Oracle Database 19C
Check the status of Database
SQL> select instance_name, version, open_mode from V$database, v$instance;
INSTANCE_NAME VERSION OPEN_MODE
---------------- ----------------- --------------------
PEPSTAGE 19.0.0.0.0 READ WRITE
Check the last updated OPatch
[oracle@stagdb...
Read more..
Posted in Patching | Comments Off on Apply the Latest OPatch (12.2.0.1.37) for Oracle Database 19c
Posted by Mir Sayeed Hassan on April 29th, 2023
Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly ASMCA needs Oracle Grid Infrastructure to configure ASM in Single Instance ASM Database
Brief:
– First of all the Grid Infrastructure is install with standalone server only option
– Due to this the error occur while adding an ASM Disk into the Oracle Grid Infrastructure using...
Read more..
Posted in ASM | Comments Off on Error occur while detecting ASM as Oracle Grid infrastructure is not configured properly in Oracle Database
