Quote Originally Posted by davey23uk View Post
hmm yes default 10g doesnt allow other users to access it - there is a fix on metalink for it

look for chperm (i think) in the install directory and look at running then
I have been thinking about this. I think the chperm comes with 10.2.0.3 patch whereas we are sitting on 10.2.0.1.

If i patch the oracle i take it this should not affect the database in any way. I don't have to upgrade the database as such, just bring down the database, patch the oracle and bring database back up?
Is that right?