What Is Privilege Analysis in Oracle Database
What is privilege analysis? - Privilege Analysis captures the privileges used by database users, including database …
Oracle
How to Convert a General Purpose ACFS Filesystem to CRS Managed on Release 11.2./12.1
It is not uncommon for customers to configure an ACFS filesystem as an ACFS mount registry-based general-purpose …
ORA-28007: The Password Cannot Be Reused
The Problem You attempt to alter a user’s password to a previously used one and get the following error when …
Oracle Database - Reading an Export File Using Import Without Physically Importing Data
The purpose of this post is to briefly describe how to list objects in an export file without physically importing the …
"/Etc/Init.d/Oracleasm Is Deprecated in Favor of Userspace Tool /Usr/Sbin/Oracleasm" - Error While Restarting Oracleasm Service
The Problem We had Upgraded oracleasm tools and system to latest. Restarting the oracleasm service triggers below …
How to Start and Shutdown CRS, OHAS, ASM, RDBMS & ACFS Services on Oracle RAC Cluster 11.2 & 12.1
The post provides in detail the steps to shutdown/startup The CRS, OHAS, ASM & RDBMS Services on a RAC Cluster 11.
Oracle Database - How to Unset DB_FILE_MULTIBLOCK_READ_COUNT to Default Value
Question: DB_FILE_MULTIBLOCK_READ_COUNT is set to 16 in the spfile. How to unset the parameter as it keeps reverting …
Understanding the Oracle Resource Profile Parameters PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME
This post talks about the change of behavior for the PASSWORD_REUSE_MAX and PASSWORD_REUSE_TIME resource profile …
How to Check Oracle Database Accounts Without Profiles That Have a Default Password
This post explains about how to check database accounts without profiles have default password. When a profile is …
How to Move Tables Between Tablespaces Using Traditional Oracle Export/Import (EXP/IMP)
This post discusses three ways you can move tables from one tablespace to another tablespace using traditional …
Understanding ACCOUNT_STATUS Column in DBA_USERS View
This post explains the meaning of the ACCOUNT_STATUS column of the DBA_USERS view. The DBA_USERS.ACCOUNT_STATUS can have …