Posts
Oracle iAS upgrade to 11g/12c – the WebLogic license trap
When upgrading to 11g/12c in Oracle iAS applications, the infrastructure will now include WebLogic Server. It is easy to mistakenly think that the existing licenses can be ported across with no change – wrong, well partially….. The default WebLogic Server installation will require an additional Standard, Enterprise or WebLogic Suite license which you can purchase…
How to diagnose a ORA-00600 Error
The ORA-00600 error is an internal error generated in the Oracle Database software that is not captured by another error trap. Oracle provide special tools to assist in the diagnosis: The current preference is to upload the relevant trace file and alert log to the standalone ORA-00600 troubleshooting tool. See My Oracle Support document 153788.1 for more information on…
Oracle Database RMAN Recovering Block Corruption
RMAN Recovering Block Corruption Block corruption sounds a bad thing – and it is. But it is also easy to recover from using RMAN. Here we will simulate a block corruption and repair the corruption using RMAN: 1. Create a table in tablespace users create table testtab tablespace users as select * from tab; select…
How to change HTTP port in Oracle FMW 11g
Changing the HTTP port in Oracle FMW 11g The Oracle FMW OHS defaults to port 8888. But this may be changed to a custom port (to port 80 for example in order to keep the url simple). The actual port change is in the Oracle FMW Administrators Guide for Oracle HTTP Server, however this does not seem…
Oracle Web Tier 11g Compatibility View Pop Up
Oracle Web Tier Compatibility View Pop Up After installing Oracle 11g Web Tier products with ADF either seperately or as part of a larger packaged product, the following pop up message may appear in the browser when trying to connect to a web application. “The current compatibility setting is not supported.Disable Compatibility View before running…
Oracle dbms_registry problems
Sometimes, especially after a clone or an upgrade you may find that some packages within Oracle Database do not work as you would expect. For example, creating the repository for enterprise manager may result in the following failure: BEGIN dbms_registry.valid(‘EM’); END; ……. PLS-00302 Component ‘VALID’ must be declared Also if you run utlrp.sql, you may…
Oracle database read only user
Creating a read only user in Oracle Database There are many ways of achieving a read only user, here is a simple method using synonyms that creates a script to give RO_USER access to the RW_USER tables and views: –As a dba user, create the read only user CREATE USER RO_USER identified by password; GRANT…
Best Practice or Smoke and Mirrors?
Best Practice is defining your Best Practice Most IT professionals will have their own idea of best practice and some vendors even provide tools to check for their flavour of best practice. Often however best practices are not quantified or measurable and as such are in the eye of the beholder. Worst still is that best…
Pros and cons of cloud computing
You are most likely to be already using cloud There are very few businesses not using cloud computing to some extent, in fact the 2018 IDG Cloud Computing Study revealed that this represents the model for 77% of enterprises. There are incredible advantages of using cloud solutions and there are plenty of other options that…
Using Oracle Database LoadJava
LoadJava Oracle provides the LoadJava tool to create schema objects from Java source, class, data files or SQLJ files. The LoadJava tool is located in the bin directory under $ORACLE_HOME. CREATE PROCEDURE and CREATE TABLE privileges are required to load into your schema. CREATE ANY PROCEDURE and CREATE ANY TABLE privileges are required to load into…