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

Drop Corrupted Undo Tablespace with active Rollback Segments

1, Make sure the database was last cleanly shut down. sqlplus /nolog SQL>connect sys/change@crm as sysdba SQL> shutdown immediate 2, m...
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...
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...
Connect to a remote database using the TWO_TASK enviroment

Some programs , for example COBOL , access the database in the same machine using the enviroment variable ORACLE_SID. What happen if the COB...
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...
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...
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...
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...
Recreate dbconsole on RAC Database 10.2

export ORACLE_SID=orclinst1 -- drop repository if exist emca -deconfig dbcontrol db -repos drop ---reconfigure again emca -config dbcontrol ...

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.