Few days ago I received a call from customer about problem with their EM console and messages about file system full. They run DB 220.127.116.11 on OEL 5.7 and had only binaries installation at that file system and the database itself was using ASM. I quickly logged on to find out the file system was really full and after looking around I figure out that all the free space was eaten by alert and trace diagnostic directories. The trace directory was full of 10MB files and the alertlog file was quick growing with following messages:
I was doing some installation at customer site when they asked if there anything specific to run GI 11.2 on HP-UX as this was their first interaction with 11g. Of course I replied that there is nothing specific, just to make sure the ownership of the raw disk is correct and had a correct ASM discovery string. They said that this is all done as it’s written in the documentation, but disks could not be discovered. This made me curious and asked them to log me in the system so I could have a look.
The system was running (more...)
It’s less than a day, tomorrow starts the Bulgarian Oracle User Group (BGOUG) conference. I’ve been looking for so long for this conference as I missed OOW this year. The conference will took place at Hisarya (near Plovdiv) for three days where there are session only at Friday and Saturday. We are proud that the conference will host seven Oracle ACE Directors and two Oracle ACEs.
I’m looking forward to meet and have a chat with these great people, of course with a lot of friends and have a nice and relaxing weekend.
This is the link to the conference (more...)
In case you need to run PHP with Oracle support this is how to do it with Oracle Enterprise Linux 5.x. I assume that Apache and PHP are already installed.
First you need to download the source of latest version of oci8 driver, here. Also you need to download and install the latest version of Oracle Instant Client Packages – Basic and SDK, here.
The next step is to install both packages on the system:
rpm -ivh oracle-instantclient11.2-basic-18.104.22.168.0-1.x86_64.rpm
rpm -ivh oracle-instantclient11.2-devel-22.214.171.124.0-1.x86_64.rpm
After installing the (more...)
It’s not necessary to work on a big project to use SVN. Keeping your design into SVN repository is very useful and good practice. By doing so you could easily see what changes you’ve made to the design and in case of accident you could restore any older version and correct the problem.
After you successfully setup Subversion (here) it’s time to start integrating tools with SVN. Integration of Oracle SQL Data Modeler is really easy and it’s done in few simple steps:
1. Integrated Oracle SQL Data Modeler with SVN:
Start Oracle SQL Data Modeler
Go to (more...)