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 […]

MySQL Daemon – Timeout, unable to stop failed

Trying to stop that instance of MySQL? Getting this message: [root@mwlab01-mysql01~]# service mysqld stop Timeout error occurred trying to stop MySQL Daemon. Stopping mysqld: [Failed] Try adjusting your start/stop timeout values in your /etc/init.d/mysqld script OLD default values: STARTTIMEOUT=120 STOPTIMEOUT=60 NEW values: STARTTIMEOUT=240 STOPTIMEOUT=240 Now lets try stopping the MySQL instance again: [root@mwlab01-mysql01~]# service mysqld […]

Configure Exadata storage cell to receive email notifications

As an Exadata DBA and sysadmin this is one of those important, most crucial configurations you can make for monitoring your storage cells.  Sure the Exadata plugin for EM12C provides alot of information and similar alerting, I have never put all my eggs in one basket.  Setting up SMTP alerting on the storage cells is […]

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 […]