Michael Berndt's Page - Oracle Community

Oracle Community

The social network for Oracle people

Michael Berndt 30 Erlangen, Germany: Share

Blog Posts (4)
Discussions
Events
Groups (1)
Featured Photos
Photo Albums
Featured Videos

Michael Berndt's Groups

Database Admins

133 members

View All

Latest Activity

Michael Berndt's profile changed Apr 18

Michael Berndt commented on the blog post ksvcreate: Process(m000) creation failed; kkjcre1p: unable to spawn jobq slave process Apr 18

Michael Berndt added the blog post '"Oh.. i accidently deleted some rows .."'Feb 5

Michael Berndt added the blog post 'ksvcreate: Process(m000) creation failed: Research'Feb 4

Michael Berndt joined the group Database AdminsFeb 4

Michael Berndt added the blog post 'ksvcreate: Process(m000) creation failed; kkjcre1p: unable to spawn jobq slave process'Feb 4

Michael Berndt commented on the blog post First msg Feb 1

Michael Berndt's profile changed Feb 1

Profile Information

About Me:: Just a DBA from Germany. Member #39. Wohoo!

Michael Berndt's Blog

"Oh.. i accidently deleted some rows .."

I like phone calls like this.

Some rows deleted.. ok. We are on 10g, we have a big undo-tablespace.

"How much time has gone since this accident?"

I hope for "less than one hour".

"Uh.. it was on last friday."

WTH.
I check with flashback query and come back around 18 hours.

Narv. This guy deleted 30 rows in a table with 400 rows. The whole database has 150G and there is no way to put it down for recovery - neither the tablespace where thi… Continue

Posted on February 5th, 2008 at 1:43am — 2 Comments

ksvcreate: Process(m000) creation failed: Research

First description of the problem

So well. I had some talk with some dba-collegues and a member of the unix-team today. Until now, we have no clue where our problem comes from - we are just on the way to suspect, that our oracle installer software has been corrupted - nearly the same configuration runs otherwhere without any problems.

Until now we are not able to reproduce the flaw, but… Continue

Posted on February 4th, 2008 at 1:14pm —

ksvcreate: Process(m000) creation failed; kkjcre1p: unable to spawn jobq slave process

This hurts.

2 month ago we moved from solaris 9 on a single Primepower 2500 to Solaris 10 on some Sun V490. We decided to make use of the concept of the zones: just like virtual machines running on these V490 boxes.

Each zone has at least one database owner, some exclusive storage in the SAN and access to the veritas cluster filesystem, where the oracle-binaries are.
Every single database-owner on every zone on every box uses the same ORACLE_HOME (in fact we have to HOMES f… Continue

Posted on February 4th, 2008 at 1:17am — 4 Comments

Export/Import issues due NLS_LANG

I even prepared for an outstanding migration from 9i to 10gR2. Because we also change the platform from windows to solaris 10, i have to go the old way: export/import

So i created the new database on solaris and startet an rows=n import.

After that a comparison of the objects gives me a little surprise: Although all packages have been imported i cannot find all package bodies.
Nevertheless i am able to create these package bodies as the schema-owner without any error.…
Continue

Posted on February 1st, 2008 at 6:58am —