This post explains how you can check which options or features are used in the database. This is particularly useful for licensing purposes or when you want to de-install a certain option. This can be achieved through the DBA_FEATURE_USAGE_STATISTICS view. This view will list the feature usage on a per patchset basis. So the combination […]
oracle
ASM disk addition/deletion hung with no rebalancing
The Problem 1. Several disks have been added to an existing diskgroup in RAC environment and sqlplus session initiating adding operation does not return the control which have to be disconnected manually. 2. Rebalance is not occuring from v$asm_operation: SQL> select * from gv$asm_operation; no rows selected 3. “disk validation pending” message in other nodes […]
How to Verify if Oracle Active Data Guard is Enabled
Question: How to identify if Active Data Guard (ADG) is enabled on a Standby database? The concept of an Active Data Guard, also known as Real-Time Query, is when it allows read-only access on the Physical standby node at the same time as applying archived transactions from the Primary node. For that to happen, the […]
WebLogic Server Domain: How To Disable the HTTP methods other than GET and POST (such as PUT, DELETE, etc.)
The objective is to disable the HTTP methods other than GET and POST (such as PUT, DELETE etc.) in a WebLogic Server domain. We can restrict the access to HTTP methods such as PUT or DELETE using security constraints in the <application_name>/WEB-INF/web.xml: <security-constraint> <display-name>Constraint-0</display-name> <web-resource-collection> <web-resource-name>mytest</web-resource-name> <description>Test</description> <url-pattern>/*</url-pattern> <http-method>PUT</http-method> <http-method>DELETE</http-method> </web-resource-collection> <auth-constraint> <role-name>NONE</role-name> </auth-constraint> <user-data-constraint> […]
How to Change the Default Home Page of Oracle HTTP Server
By default when the URL http://[OHS_HostName]:[OHS_Port] is accessed, a default welcome page is displayed. In certain scenarios, there will be a need to change this default welcome page to a custom one. This post provides steps to change this default home page of OHS to any custom page. This can be achieved by modifying the […]
How To Disable the Oracle WebLogic Server Default Welcome Page
Below page is displayed when going to the default location on the admin server port http://host:[PORT]/ and says “Welcome to Oracle Fusion Middleware 11g”. (where http://host:[PORT]/console or http://host:[PORT]/em is working and you do not want to allow users to backspace to the doc root location) Note the port [PORT] is really only used for /em […]
Oracle WebLogic Server: How to Disable the UDDI and UDDI Explorer Functionality
This post describes how to disable UDDI and UDDI Explorer functionality in WebLogic Server. You may not be using this feature and be looking to disable non-required applications. 1. From WL_HOME/server/lib, delete uddi.*, specifically: uddi.properties uddi.war uddiexplorer.war You can also move the files somewhere else if you want to keep the copies (recommended). However, be […]
ORA-65208: Lockdown profile P1 does not exist
The Problem The following error is generated when creating a lockdown profile in application container of a PDB database. ORA-65208: Lockdown profile P1 does not exist. The Solution When pdb_lockdown parameter is set in an application container using a CDB common user(e.g SYS), we look up lockdown profile defined in the CDB ROOT. In this […]
How to Offline a PDB Datafile in NOARCHIVELOG mode CDB which is not Open in Read Write
For the purposes of this post, the following environment is used as an example to describe the procedure: Container Database Name: CDB1 Pluggable Database Names: PDB1 Datafile Name: /tmp/STATSPACK.dbf If you try to attempt to offline a datafile, it results in error when the database is running in NOARCHIVELOG mode and is not open in […]
What are the implications of rebuilding indexes in Oracle Database
This post will try to outline the implications of rebuilding indexes. It will help customers to decide if index rebuild is required or not and if index coalesce is better. There have been many discussions about whether rebuilding indexes is useful or not. Generally speaking, the need to rebuild b-tree indexes is very rare, basically […]