Month: March 2009

Error ORA-20446 creating an export job

While trying to do an export in my Oracle 11g test database today I received the following errors, ———————————— ORA-20446: The owner of the job is not registered ORA-06512: at “SYSMAN.MGMT_JOBS”, line 168 ORA-06512: at “SYSMAN.MGMT_JOBS”, line 86 ORA-06512: at line 1 ———————————— It turns out that this is a bug in 11g, and while […]

Database upgrade

It looked like I was going to have to upgrade one of our DEV databases from 10.2.0.1 to 10.2.0.4 today. I was a bit nervous about doing that so I tried it on one of my test databases first. It didn’t seem to work. Now it also seems that the issue we were having with […]

Connect is a role not a privilege

I was checking our database security policy at work today when I came across something that confused me for a little while. It said that you should not grant the CONNECT role to non-DBA users. My first thought was ‘hang on, if I don’t give users the CONNECT role, they won’t be able to connect […]

Next Page »