About

Martin Klier

usn-it.de

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

New theme

Hi, decided to look for a new theme. After testing GenkiTheme, Mimetastic and Munch, I ended up with TechnoPlain 1.1 Hope it looks okay for you. Regards Usn […]

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

Talk “Hope is not a strategy” at Vocational School Wiesau

Hi, there will be a talk about IT High Availability for rising IT professionals at Vocational IT School Wiesau on Monday, 10th of March 2008. The topic: “Hope is not a startegy” – IT high availability in theory and practical experience See paper and slides here. Regards Martin EDIT: There has been a nice press […]

read more

Oracle Database with SGA of or larger than 16GB

Hi, using large SGA’s requires 64bit Oracle RDBMS, of course. But furthermore, some OS settings are to be done. SUSE walks it’s own lane, quite as usual, so I will provide two ways for doing without ORA-27102. […]

read more

New homepage for our Linux User Group Mitterteich

Hi friends, the Linux User Group Mitterteich has a new webpage and a new URI (http://www.linux-mitterteich.de). The old URI (http://www.lug-mitterteich.de.vu) will be redirected from today on. Well, the page isn’t perfect at the moment – but finally we started working on it: The free template (made by Ramin Hossaini) used at the moment will be […]

read more

Blog moved and updated

Hi, this blog has been moved to our new Debian root server – much more of my own taste than olde funpic has been. And, at least, free of advertising cheap flights or packet shipping companies by popup and/or floating-in banners. Touching the blog software anyway, the update being due since two weeks was done: […]

read more