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…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...

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…

Read More...

Oracle 19c database on LiveSQL

Oracle database 19c Oracle database 19c is currently available at LiveSQL.oracle.com and on premise Exadata. LiveSQL is a free online platform that can assist with development and training. Other on premise releases are expected in the next few months of Q2CY19. 19c is the long term support release of 12cR2 with extended support until Mar 2026….

Read More...

Spotting scam phone calls

Scam Calls Just like scam emails and scam post, there are some very unscrupulous people out there that will call you and claim to be something that they are not such as the Tax Office, an energy supplier, phone company, a bank or the police. They will pressure you to get your personal or bank details…

Read More...

Discover Your Opportunities

Data Solutions | Application Development | Automation

GET STARTED TODAY