Oracle mix

Just before the new year, I found this site...

https://mix.oracle.com/

We all know Linkedin or Plaxo. Now Oracle has it's own network site (beta..)
Check it out and login using your Oracle sso account (otn account)

Oracle EBS R12 Applications DBA Beta Exam

Today I received an email from Oracle in which they announced the Oracle EBS R12 Applications DBA Beta Exam. This exam is open to register and this beta period runs from January 03 – April 04, 2008
The exam is called :
Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238]
This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified Professional certification.

I am not sure if I am going to participate in this beta exam....

Enterprise Manager

We had a problem using OEM 10g. During the day a database proces (ora_j001) was consuming 100% cpu. Because of this OEM coud not be reached, oms down. Looking for a solution, I ran into the job_queue_processes database parameter. This parameter was set to 10 in our database. I searched the net and could only find out that the value of this parameter should be > 0, if you want to use OEM. Prefered value is 10 (our original value...), but it looks like a value of 10 leads to the 100 % cpu problem.
I changed the job_queue_processes parameter to 2, also changed the aq_tm_processes parameter to 1. The OEM database seems to be more stable, but I don't know if everthing still works in OEM....
Has anyone got any experience with this ??

Colors in vi

So after turning off the colors in the 'ls' command on linux, I also had to deal with the colors using vi...
When reading a logfile for example, the file is presented in 5 or 6 different colors..
To turn off these colors edit the following file (as root)...

/usr/share/vim/vim60/macros/vimrc

In this file you will see the following lines:

" Switch syntax highlighting on, when the terminal has colors
" Also switch on highlighting the last used search pattern.
if &t_Co > 2 has("gui_running")
syntax on
set hlsearch
endif

You can disable coloring by placing " in front of these lines..

" Switch syntax highlighting on, when the terminal has colors
" Also switch on highlighting the last used search pattern.
"if &t_Co > 2 has("gui_running")
" syntax on
" set hlsearch
"endif

Now all colors are gone, and I believe reading is much easier ....

Colors in linux terminal

This week I started my new job with Smartapps. The first thing I usually do is check out the excisting EBS environments. I also did the same starting here...When starting a putty session on one of the EBS nodes, I noticed the different colors when using the ' ls' or 'll' commando. I find it very annoying, so I decided with my new colleagues to remove this.
I found this was caused by the use of aliasses.

alias cp='cp -i'
alias l.='ls -d .[a-zA-Z]* --color=tty'
alias ll='ls -l --color=tty'
alias ls='ls --color=tty'
alias mv='mv -i'
alias rm='rm -i'
alias vi='vim'

So, all I had to do was unalias the ' ls' and the 'll' commando (and make a new alias for ' ll' )

Upgrade R12

a few months ago, I had an EBS R12 poll on my blog. The question was if anyone already upgrade their EBS environemnt from 11i to R12. The results of the poll showed me that nobody had upgraded or was going to...
For those who are planning to upgrade their 11i environment, Steven Chan has writen an article abouot this on his blog.
Check it out !! http://blogs.oracle.com/schan/2007/11/29#a2268