Posted by Mir Sayeed Hassan on August 10th, 2023
Error occur while dropping tablespace as ORA-23515: materialized views and/or their indices exist in the tablespace
Drop the tablespace
SQL> drop tablespace MGMT_TABLESPACE including contents and datafiles;
drop tablespace MGMT_TABLESPACE including contents and datafiles
*
ERROR at line 1:
ORA-23515: materialized views and/or...
Read more..
Posted in DBA Administration | Comments Off on Error occur while dropping tablespace as ORA-23515: materialized views and/or their indices exist in the tablespace
Posted by Mir Sayeed Hassan on July 19th, 2023
Apply the latest DB RU Patch_19.19 (35042068) on 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
---------------- ----------------- --------------------
oemswdb 19.0.0.0.0 READ WRITE
Posted in DB Patch | Comments Off on Apply the latest DB RU Patch_19.19 (35042068) on Oracle Database 19C
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
