The value of learning about lots of different topics really comes to the fore when you spot a connection, however tenuous, between things that on the surface have no bearing on each other at all.Continue reading “Old Books, Russian Hip-Hop, and Database Imports”
Why Install Oracle 21c on OL8 via RPM?
Far too often in home lab situations, where there’s some interesting idea to be explored, efforts get derailed as a result of sinking too much time into the environment setup particularly when something like Oracle Database is involved. Maybe the the initial idea is to play with data migration or to investigate some new feature or just to brush up on skills, but whatever the scenario there’s a need for an environment and then, just like that, a week has passed and you’re just about ready having hunted down all the obscure errors and issues thrown up as the setup has progressed, when you get distracted by something else as the idea you wanted to work on has been crushed by the weight of getting things ready.Continue reading “Why Install Oracle 21c on OL8 via RPM?”
Dynamics AX 2009 Oracle to SQL Server Migration
Dynamics AX no longer supports the Oracle database and so pre-AX 2012 applications still on Oracle need to be migrated to SQL Server before they can be upgraded. Here’s how to overcome the risk and fear associated with Dynamics AX Data Migration. Continue reading “Dynamics AX 2009 Oracle to SQL Server Migration”
SQL Developer – IO Error: Got minus one from a read call
The IO Error: Got minus one from a read call error is caused by the SQLNET.ora file on the database server being configured to only allow connections from certain computers on the network (as identified by their IP addresses). Continue reading “SQL Developer – IO Error: Got minus one from a read call”
Oracle GoldenGate Proof of Concept
Oracle very kindly offered to run through a Proof of Concept installation of their GoldenGate replication product with us, and seeing as how we’re not prone to looking gift horses in their mouths, we’ve accepted!
Playing with Oracle Enterprise Manager
Quiet Friday’s are a nice treat but something too often squandered. This past Friday I found myself left to my own devices as the rest of the DBA team were working from another location. This left me free to get a few things about running our environment straight in my own mind with the most notable being was how to use CommVault for database backup and recovery beyond simply copying RMAN output to tape.Continue reading “Playing with Oracle Enterprise Manager”
Securing RMAN Scripts
The programmatic nature of Oracle’s Recovery Manager tool provides great flexibility but also creates a common problem of insecure scripts being left running on production servers allowing anyone to read critical password details with ease. Continue reading “Securing RMAN Scripts”