Posts by Admin User
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 MoreOracle 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 MoreOracle 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 MoreBest 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 MorePros 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 MoreUsing 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 MoreOracle 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 MoreSpotting 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 MoreFast, Reliable, Cheap – You can have all three!
I used to be a fan of the saying ‘Fast, Reliable, Cheap – pick 2, you can’t have them all!’ but now I think differently and believe that you can have all three. The thing is that each attribute is a relative measure, what is cheap to one person may be expensive to another.…
Read MoreOracle Database 12c, 18c and 19c product versions and should I upgrade
As many would know in the Oracle circles, there has been a ‘new’ database version available this year. Don’t get me wrong, 18c is a new version but not a major release but a new approach to the software releases. 18c is equivalent to 12.2.0.2 and 19c will be the terminal release 12.2.0.3. As with…
Read More