Today, one of my blog reader asked how we can add new agent software to Oracle Cloud Control. He says he installed Cloud Control on a Linux server and now he wants to deploy cloud control agents to Solaris Servers. Adding new agents can be done by self update feature of Cloud Control. Click “setup”, and then extensibility and click to Self Update:Read More
In a project, I asked to create a database link between Oracle to MySQL. I thought that I can use Oracle’s Heterogeneous Services. Oracle Database is running on Sparc Server (Solaris 10), so I downloaded the free ODBC packages from unixODBC project. They already provide a binary package for Solaris but it says it will remove any non pkgmgr content in “/usr/local/bin” directory. So I decided to download the source codes and build it manually. Although it sounds like a scientific operation, you just need to run 3 commands to build and install the package in normal conditions but oh unfortunately it took a lot of time to fix “library” dependencies problem and adding MySQL support to unixODBC.
Here are the commands to build unixODBC:
I attended to Oracle Extreme Performance Tour event in Istanbul, yesterday. It was a marketing event so I can’t say it was attractive for a tech-guy like me. On the other hand, I meet friends from Oracle, found some social networking opportunities and examined Oracle Database Appliance. So it was over my expectations.
Oracle Turkey chooses great places to host their events but this one is really amazing. The event was held at the Ciragan Palace. It’s a former Ottoman palace, now a five-star hotel. I just wanted to share some photos of this beautiful place:Read More
I attended Real World Performance Tour, yesterday. TROUG (Turkish Oracle User Group) organized the event under the sponsorship of the Oracle Turkey. Although it was snowing, there were about 100 attendees. Well known Oracle experts Tom Kyte, Andrew Holdsworth and Graham Wood presented a 6 hour seminar in a conversational format.
Some of the topics:
- Database connections
- SQL statement parsing
- Set based operations rather than row by row processing
- Proper use of indexes
- Understanding JOINs
In my previous blog, I tried to explain why the fundamental Oracle flaw is dangerous. On the other hand, in my tests I couldn’t find a way to pass a higher SCN to a target DB to crash it. Since then, I’m trying to verify that this flaw can be can exploited. Here’s a short video of one of my tests:Read More