Posted by Mir Sayeed Hassan on 7th May 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 4th May 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 1st May 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 1st May 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
