Michael A. Georgiou
マイケル

Technical articles for oracle database

Search This Blog

Thursday, June 2, 2011

Clean Oracle's Report Server Jobs Queue

Valid for Oracle Application server 10.2

Stop Report Server
Rename the dat file present in $ORACLE_HOME/reports/server directory and restart the server again

Αναρτήθηκε από Michael Georgiou στις 11:06 AM

Newer Post Older Post Home

Popular Posts

Configure RMAN to use all RAC nodes (Parallel backups)

Consider a two-node rac with 1 cpu per node. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 2; CONFIGURE CHANN...
Flashback table is not working with Materialized views

create table t ( id number); alter table t enable row movement; insert into t values (1); insert into t values (1); insert into t valu...
Tablespace Encryption

Transparent Data Encryption (TDE) and the use of a component known as the Oracle Wallet. Oracle 10.2.4 + CREATE TABLESPACE encrypted_ts DATA...
How to call c shared library (.so) from PLSQL

The example uses Oracle Linux 5 32bits , Oracle 11gR2 EE Call C csum int csum(int a, int b) { return (a+b); } gcc -c -fPIC csum.c...
Running OS Commands and Scripts from PL/SQL Using java on Unix

This article is coming from : http://www.dba-oracle.com/job_scheduling/commands_scripts_plsql.htm Some extra tips are added in order to run ...
ORACLE RAC KSH SCRIPT

#!/bin/ksh ############################# # Put program variable here # db1=orcl db2=RMAN ############################### while [ : ] ; do wh...
Start and Stop RAC Listeners

lsnrctl stop listene r affect only the connected node On two nodes RAC cluster use the following commands to stop and start RAC's listen...
How to use reference cursor in java

<%@ page contentType="text/html;charset=windows-1252"%> <%@ page import= "java.sql.*" %> <%@ page import=...
Check if database is up ( ksh script)

#!/bin/ksh if ps -aef | grep pmon | grep rdev > /dev/null ; then print "Database is Up." else print "Database is dow...
Transportable tablespace and Cross-Platform Tablespace Conversion

From Oracle 10g Win64 to Oracle 12c AIX64 create user test identified by test; grant connect,resource to test; create tablespace test d...

National Bank Of Greece

Blog Archive

► 2015 (3)
- ► August (1)
- ► May (1)
- ► January (1)

► 2012 (11)
- ► December (1)
- ► November (1)
- ► June (3)
- ► May (2)
- ► April (1)
- ► January (3)

▼ 2011 (59)
- ► December (6)
- ► November (9)
- ► October (2)
- ► September (4)
- ► August (10)
- ► July (4)
- ▼ June (5)
- ► May (4)
- ► April (6)
- ► March (6)
- ► February (1)
- ► January (2)

► 2010 (2)
- ► December (1)
- ► January (1)

► 2009 (22)
- ► December (1)
- ► November (8)
- ► October (1)
- ► June (3)
- ► May (2)
- ► March (3)
- ► January (4)

► 2008 (6)
- ► November (2)
- ► June (4)

► 2007 (19)
- ► December (1)
- ► October (2)
- ► September (1)
- ► August (2)
- ► June (1)
- ► May (1)
- ► April (11)

Michael A. Georgiou

Michael Georgiou: Nicosia, Cyprus; Michael Georgiou currently works at the National Bank of Greece (Cyprus Branch) as an Oracle Database and Oracle Application Server Administrator. He earned an M.Sc. degree in Computer Science from the University of Cyprus (2011) and Bsc degree in Computer Science from Cyprus College (2004). He is Oracle Certified Professional (OCP) and Red-Hat Certified Engineer (RHCE). He has 8 Years of experience with Oracle Database and Oracle Applications Servers Administration and Instruction. He works on large government projects such as the Police Computerization System, Cyprus Social Insurance, Ministry of Labor and others. Mr Michael specializes in application analysis and development (PL/SQL,Java,C,C++). In the past he has worked for NetU Consultant ltd (2004-2007). email:askmichaelgeorgiou@gmail.com

View my complete profile

RAC-logo

Total Pageviews

Travel theme. Powered by Blogger.