Linux Oracle Database Connection Test Script

Database connection testing scripts are out there, but not all of them provide a one stop way to test more than 1 node of the RAC at the same time.  Sure you can do simple tests using “tnsping”, “nc -z” or even “telnet” to confirm the listener is up.  Actually testing a login is a […]

You (oracle) are not allowed to use this program (crontab)

Here is the message being faced on our x3-8 Exadata (Note that this can happen on any linux system): [root@ex01db01 etc]# su – oracle [oracle@ex01db01 ~]$ crontab -l You (oracle) are not allowed to use this program (crontab) See crontab(1) for more information Some MOS note that describe NON-ROOT users having difficulty using crontab: Non […]

2013 Great Lakes Oracle Conference

Join the Northeast Ohio Oracle Users Group and the Ohio Oracle Users Group at their newly formed Great Lakes Oracle Conference (GLOC). The event has been re–branded as the Great Lakes Oracle Conference to attract participants from all over the Great Lakes region, not just Ohio. We anticipate this to be the largest Oracle user conference in […]

RMAN-20001: target database not found in recovery catalog

Trying to register my Oracle database and receiving error message rman-06004 and rman-20001 Here is my error: $–> rman Recovery Manager: Release 11.2.0.3.0 – Production on Tue Nov 13 10:13:14 2012 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. RMAN–> connect rcvcat catusr/——@orclcat connected to recovery catalog database RMAN–> connect target dbusr/——-@orcl […]

Difference between data pump EXPDP/IMPDP and legacy EXP/IMP

Lets start with the basics. Legacy EXPORT/IMPORT (exp/imp) What is now known as legacy export/import (exp/imp) was introduced in Oracle 7.1  and were called ‘conventional path exports’.  This meant that the ‘conventional path export used “SELECT * FROM OWNER.TABLE” to extract the data and push through various buffers and finally to the export file on […]

Logical vs Physical Standby

So, what’s the difference between a logical and a physical standby database? First, lets get to know what each standby database type is. Physical standby –  Database structure is the same as the source database. –  Archived logs are shipped to the standby from the source. –  Archived log are applied to the physical standby. […]

Changing SGA_MAX_SIZE and SGA_TARGET

After encountering numerous errors in regards to ORA-04031 we opened an SR and confirmed our suspicion.  We needed to increase the size of our sga.  After further review we decided to keep the values of SGA_MAX_SIZE and SGA_TARGET the same. Here are the steps we followed (very cautious and backup of everything done before we […]

Configuring Oracle Apex on 11gR2

Might ask why you would want to run Apex?  Well Apex is a very power sql driven application module that allows even the noob to advanced programmer the ability to code and create useful pages/applications.  I personally don’t have any experience with Apex from a programming standpoint and decided to at least install it to […]

Delete archivelog all

I am working with a new client and disk space is somewhat lacking.  Performing some large imports wreaks havoc on their filesystem.  So it is a small data warehouse which we have chosen to keep in archivelog mode so we can perform hotbackups.  But because of the fast generation of archivelogs, running out of diskspace […]