Monthly Archives: October 2015

Exadata X4-2 1/8 Eighth Rack / Data Compression Methods and Testing


Advertisements

ORA-27475: Errors With Scheduler Job In Invalid State


A job is hanging in RUNNING status. – Other scheduler jobs are running normally – When attempt to stop the job you get: SQL> BEGIN 2 SYS.DBMS_SCHEDULER.DROP_JOB 3 (job_name => ‘OC_BPS.”send_bps_notifications1″‘); 4 END; 5 BEGIN * ERROR at line 1: ORA-27478: job “OC_BPS.send_bps_notifications1” is running ORA-06512: at “SYS.DBMS_ISCHED”, line 213 ORA-06512: at “SYS.DBMS_SCHEDULER”, line 657 ORA-06512: […]

List of Infiniband Switch commands in Exadata / Monitoring Commands


#ibstatus – To check the status of IB switch root@bakuexa1dbadm01:~# ibstatus Infiniband device ‘mlx4_0’ port 1 status: default gid: fe80:0000:0000:0000:0010:e000:0147:da39 state: 4: PORT_ACTIVE phys state: 5: LINK_UP sm lid: 0x1 base lid: 0x5 rate: 40 Gb/sec (4X) link_layer: IB Infiniband device ‘mlx4_0’ port 2 status: default gid: fe80:0000:0000:0000:0010:e000:0147:da3a state: 4: PORT_ACTIVE phys state: 5: LINK_UP […]

How to fix broken database jobs


SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs JOB SCHEMA_USER B WHAT ———- —————————— – —————————————- 47 ANAR Y send_bps_notifications1; 1 rows selected. SQL> exec dbms_job.broken(47,FALSE); PL/SQL procedure successfully completed. SQL>connect ANAR/password SQL>select JOB,SCHEMA_USER,BROKEN,WHAT from dba_jobs JOB SCHEMA_USER B WHAT ———- —————————— – —————————————- 1 ANAR N send_bps_notifications1;