Failover Primary database is down Log into the Data Guard Broker on standby node and check the configuration (dgmgrl sys/<password>) Issue the failover command. Modify the listener.ora file on the new primary node to allow it to listen for connections from the old primary. To prevent Grid Infrastructure from starting the database in the wrong … More Data Guard Broker Failover
Whenever you migrate a database it’s a good idea to move those SQL profiles that have forced the optimizer to a more efficient execution plan. I found that this wasn’t as easy as I had expected, so I thought I would share the results of my research. In my case I’mm migrating from 10.2.0.5 to … More Moving Oracle SQL Profiles
This is a 2 node 11gR2 RAC cluster database. When attempting to configure an ODBC connection to Oracle I encountered an issue with the scan listener and the client firewall. It seems even though I was able to obtain a successful tnsping to the database: However, trying to connect via ODBC produced the following error: … More TNS Scan Issue with Client Firewall
Most folks don’t realize that the database file size limits are operating system dependent. Limited by maximum operating system file size typically 222 or 4M blocks. The block size / datafile size limitations are: Max datafile size for SMALL FILE NORMAL TABLESPACE would be: Database Block Size Maximum Datafile File Size 2k 4194303 * 2k … More Database File Size Limits
When you login into SQL*Plus there are two configuration files that are executed. These files allow you an opportunity to customize your SQL*Plus environment and are named glogin.sql and login.sql. They are invoked when SQL*Plus starts or when the CONNECT command is used. –glogin.sql file is normally located in the $ORACLE_HOME/sqlplus/admin directory. I believe the … More Customizing SQL*Plus with login.sql or glogin.sql
Ever had the need to pass an OS level parameter to an Oracle SQL script? I have and after some work I was able to make it to happen. The scenario here is to gather the total amount of diskspace in the ASM diskgroups and then load it into a database. The biggest challenge is … More Passing OS Shell Parameters to Oracle SQL Scripts
Well, I’ve been an Oracle DBA for well over 7 years and have been working with Oracle for 15+ years. Just the other day I ran across an article which noted that you can actually use more than one alias in each tnsnames.ora entry! I know I should have known this before, however there is … More tnsnames.ora alias entries
Most folks that know me know that I actually have a really decent job with great benefits, so why reach out to the private sector and consider working there. Well the politics are really bad here and our shop is moving to Microsoft one application at a time. I’d like to continue to keep my … More Why am I doing this?