About

Martin Klier

usn-it.de

memlock config for Debian Lenny

Hi, today I tried to start Oracle XE with parameters “pre_paged_sga=true” and “lock_sga=true” on my Debian Lenny toybox. But Lenny has had a rather strict and really sticky value for the user’s maximum amount of pinned memory (ulimit -l) value: 32 (kb). First attempt, change /etc/security/limits.conf: oracle – memlock 1073741824 Result: Nothing, “ulimit -l” as […]

read more

Oracle DML Parallel Execution Don’ts

Have you ever waited on a parallelized statement? Parallel execution is said to be fast, efficient, system-exhausting. Far from that! There’s a 10.2.0.4 x86_64 system with 16 cores and over 600MB/s write-IO ability, one statement running, one CPU burning, one developer waiting. For days. Finally, at the end of the week, the admin is involved. […]

read more

Nerd compliments.

If anybody ever considers joining irc.freenode.net #oracle (what I’d recommend for all Oracle interested folks), be prepared for being treated like that: <nayyares> it worked !!! <usn> wait some time, it might crash, or restart all cluster services to see if there is a boot bug <nayyares> ok, i am monitoring usn <Rudemeister> Im also […]

read more

TEMP tablespace too small

Today I got a mail from my grid control: “Tablespace TEMP1 is 97% full”, acting for one of the single instance servers. No problem, you may think, this might happen. It’s an OLAP database, so I wasn’t afraid of big numbers as well. But as you can see, using all this huge temp tablespace for […]

read more

Cleanly removing an agent or host target from Oracle Grid Control 10.2.0.4

Removing a host/agent in Oracle’s Grid Control can be unnerving: There are enough dependencies between the agent, the (cluster-)database, the listener, the host and so to make your deleting action an endless sequence if you are following them. But GC really becomes stubborn if the agent we are about to remove is unavailable: due to […]

read more

Grid Control startup fails, installUser=%s_userName%

Oracle seems to have an uncommon sense of humor. Executing gcstartup after patching the grid control server to 10.2.0.4 (Linux x86) fails with: /bin/su: user %s_userName% does not exist I am not surprised, since this is windows’ environment variable notation, and unknown to my Linux shells. Solution: In the head of /opt/oracle/grid/oms10g/install/unix/scripts/omsstup replace installUser=%s_userName% with  the username […]

read more

Oracle expdp utility i18n – strange

Export> kill_job Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): yes Möchten Sie diesen Job wirklich stoppen ([yes]/no): YES Möchten Sie diesen Job wirklich […]

read more

Effectice load balancing for a (web?) service in RAC 10gR2

Hi, had to review service creation with DBMS_SERVICE package for a good-feeling load balancing in Oracle RAC 10gR2 several times – now I have to write it down for myself. 🙂 I needed it for a web service using shared server today, but the generic syntax is useful for all other purposes as well. Basic […]

read more

ORA-00600 [kgeade_is_0]

Have a look at this nice one (alert log), seen in 10gR2 (10.2.0.4 64bit on Linux): ORA-00600: Interner Fehlercode, Argumente: [kgeade_is_0], [], [], [], [], [], [], [] And from the trace file: Current SQL statement for this session: select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and […]

read more