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> […]
oracle
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 […]
How to pass a value from shell script to GoldenGate replicat for mapping to target table column
The value must be assigned to an environment variable and the replicat must be started from the OS command line and not within GGSCI. Example: Start the replicat via the command line as part of the script and not calling GGSCI inside the script. If GGSCI is called to start replicat it will not recognize […]
Oracle GoldenGate: How to start Extract & Replicat using Shell Script
For simple commands, you can “pipe” the output of one command to GGSCI’s input; for example: $ echo “start EAIOU” | ggsci will issue the “start EIAOU” command to GGSCI. GGSI’s messages will appear on the terminal. For more than one command, you can either use the above with an OBEY command, or redirect the […]
Oracle Multitenant: How to Create CDB and PDB
Creating a CDB The steps required to create a new CDB, using either DBCA or SQL*Plus, are the same. The first step, as for any database, non-CDB or CDB, consists of configuring an instance with an init.ora parameter file and then starting the instance. The second step is the creation of the CDB using the […]