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 […]
Category: Oracle
What’s the difference between Larry Ellison and god?
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 […]
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 […]
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 […]
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 […]
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. […]
Another lecture “Basics of database technology” in German
Tomorrow at 10 a.m. I’ll give a lecture about the “Basics of database technology” in German language for 9th-formers of Augustinus Grammar School in Weiden. See the handout and the presentation here. Regards Usn […]
Oracle 10gR2 Clusterware on Novell/SuSE SLES10 on multipath devices
Hi RAC-DBAs, installing the Oracle Clusterware CRS 10.2 on SLES10 with its multipath devices can be tricky. Background: The tool formatting the OCR disks, clsfmt.bin, is buggy concerning multipath / device mapper devices and you will see root.sh fail and clsfmt spit out errors like: clsfmt: Failure trying to resize OCR file from … bytes […]
Lecture “Highly available Communications Server” (Oracle Database) at DOAG conference 2007
Hi, I’ll give a lecture about high availability with Oracle RAC and Dataguard at DOAG Conference 2007 (annual conference of the German Oracle User’s Group). The talk will be in German. (“Ein hochverfügbarer Kommunikationsserver mit RAC, ASM, redundant shared media und DataGuard”) When? Thursday, November 22nd 2007 1300hrs Where? CCN CongressCenter Nürnberg Ost Messezentrum D-90471 […]
Scheduler hangs in Oracle Database 10g
Hi, sometimes the 10g scheduler refuses to start jobs any more. I do not know why at the moment, but as a workaround you can just kill -9 the “coordinator job queue (CJQ0)” process from OS level. The process will be named like “ora_cjq0_SID” in a RAC. PMON does a restart of the coordinator after […]