About

Martin Klier

usn-it.de

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

Disabling (or enabling) general job execution in Oracle 10g

Hi, disabling and enabling job execution in Oracle DB has two ways: If you are using dbms_jobs, it’s handy to set job_queue_processes to zero to disable the execution of jobs, and set it to a value >0 (maybe 100) to enable. If you are using dbms_scheduler, this parameter does not work for you. You will […]

read more

Find out your character set in Oracle DB

Hi, since ‘show parameter’ does not tell you your database charset, use this statement to see how your characters are stored: select * from nls_database_parameters where parameter=’NLS_CHARACTERSET’; Regards Usn […]

read more