Oracle Database backup using AWS Volume Snapshots

September 5th, 2016 | Posted in AWS, Blog | No Comments

I just published a new article about Oracle Database backup using AWS Volume Snapshots on Dell toad world website. Check it out here; http://www.toadworld.com/platforms/oracle/w/wiki/11671.oracle-database-backup-using-aws-volume-snapshots

Hope you enjoy it !
Cheers
Wissem



AWS concepts and commands for Oracle DBAs: Part I: AWS Resource usage and price monitoring

September 5th, 2016 | Posted in AWS, Blog | No Comments

I just published a new article about AWS Resource usage and price monitoring on Dell toad world website. Check it out here;
http://www.toadworld.com/platforms/oracle/w/wiki/11670.aws-concepts-and-commands-for-oracle-dbas-part-i-aws-resource-usage-and-price-monitoring

Hope you enjoy it !

Cheers

Wissem



Build a real world recommendation system using Apache Spark within an Oracle Big Data Management System

August 1st, 2016 | Posted in 12c, Apache Spark, Big Data, Blog, Exadata, hadoop | No Comments

I just published a new article called “Build a real world recommendation system using Apache Spark within an Oracle Big Data Management System” on Dell toad world website. Check it out here;

hhttp://www.toadworld.com/platforms/oracle/w/wiki/11651.build-a-real-world-recommendation-system-using-apache-spark-within-an-oracle-big-data-management-system#

Hope you enjoy it !

Cheers

Wissem



Oracle Big Data SQL

August 1st, 2016 | Posted in Apache Spark, Big Data, Blog, Exadata, hadoop, Oracle Big Data Appliance (BDA). | No Comments
Tags:

I just published a new article about Oracle Big Data SQL on Dell toad world website. Check it out here;

http://www.toadworld.com/platforms/oracle/w/wiki/11653.oracle-big-data-sql

Hope you enjoy  it !

Cheers

Wissem



OEM12c: information publisher reports & the ORA-00942: table or view does not exist Error

July 4th, 2016 | Posted in 12c, Blog, enterprise manager | No Comments


One colleague asked me to help on troubleshooting the ORA-00942: table or view does not exist Error when she wants to add a report on Oracle Enterprise Manager 12c (OEM 12c).

(more…)



Fix the ORA-27300 Status 11, ORA-27301 and ORA-27302 Errors!

December 15th, 2015 | Posted in Blog | No Comments


Some users reported slowness issue in one Oracle production database. we have the Oracle 11.2.0.3 Enterprise edition production server (under an oracle Linux 6 OS ).

(more…)



E-Business Suite queries using USERENV legacy function

July 20th, 2015 | Posted in 11gR2, Blog | No Comments


A colleague reported me an issue she is having when running an E-Business Suite query from her SQL Developer client. The query returns no rows when it does on the Oracle server itself.
This is a much known issue, a miss configuration on the client side when the queries are using USERENV conditions for example: USERENV (‘LANG’)
(more…)



PRCN-2065 : Port(s) 1521 are not available on the nodes given

June 22nd, 2015 | Posted in 11gR2, Blog | No Comments


When configuring the listener for Oracle grid infrastructure 11gR2; we get the following error;

vmcavora1test(+ASM):/home/oracle>srvctl add listener
PRCN-2061 : Failed to add listener ora.LISTENER.lsnr
PRCN-2065 : Port(s) 1521 are not available on the nodes given
PRCN-2067 : Port 1521 is not available across node(s) "vmcavora1test"
vmcavora1test(+ASM):/home/oracle>

(more…)



Optimize OBIEE queries – My Approach

June 4th, 2015 | Posted in 11gR2, Blog | No Comments


Oracle Business Intelligence Enterprise Edition (OBIEE):
This is a business intelligence and analytics Oracle product that delivers dashboards, ad hoc queries, mobile analytic, notifications and alerts, enterprise and financial reporting.

The performance issue:

Some users start complaining about performance issues when they run dashboards used by Global HR users for Headcount verification.

These specific Headcount verification dashboards are executing queries hundreds of times per minutes and the goal is to spend very little time executing a given query—the queries should be small and fast. So the goal here is not increase the parse time (increase dynamic sampling will give the optimizer more time to hard parse the query). First thought, SQL Profiles makes more sense in this situation.
(more…)



Oracle Enterprise Manager Cloud control agents unreachables

February 19th, 2015 | Posted in Blog, enterprise manager | No Comments


1- The problem:
Today, we discovered some of the OEM agents are unreachable as a consequence all jobs scheduled were skipped / having problems.
This is an Oracle Enterprise Manager Cloud control version 12.1.0.4.0.
(more…)



Retrieve OS information using SQL

February 16th, 2015 | Posted in 11gR2, Blog | No Comments

I have been asked today to check a database performance issue of an Oracle 11.2.0.3.
The vendor doesn’t want to give me a Linux access and only provided me a temporary database access as a sysdba.
No problem, I can check the content of alert log file as a part of the troubleshoot querying sys.x$dbgalertext fixed table.
(more…)



ORA-00600 ; Number of Diskgroups in ASM 12c with Pre-12c databases.

January 5th, 2015 | Posted in 12c, Blog | 1 Comment


Last week, we migrated Oracle ASM to 12c (12.1.0.2). The goal of the migration is to be able to use ASM 12c new features specially, the number of diskgroups which as increased from 63 to 511. Another important improvement is to be able to allocate more than 2TB for a disk, this will allow us to use a reduced number of disks for multi-terabyte databases. You can check more details here
(more…)



Oracle EBS R12: Function ncrorou returned error code 3010. The Applications File Server process may have exited abnormally.

October 28th, 2014 | Posted in Blog, EBSR12 | No Comments


One user reported to me the following error ;

An error occurred while attempting to receive the output arguments of the remote procedure. Function ncrorou returned error code 3010. The Applications File Server process may have exited abnormally. Please contact your system administrator.

(more…)



12c Standalone Grid Infrastructure: CLSRSC-350: Cannot configure two CRS instances on the same cluster

October 14th, 2014 | Posted in 12c, Blog | No Comments


During 12cR1 Standalone Grid Infrastructure installation, I got the following message when running the root.sh script;
(more…)



RMAN-03009: ORA-19502: ORA-27072: File I/O error

October 6th, 2014 | Posted in 11gR2, Blog, RMAN | No Comments


We got the following error when backing up an 11.2.0.3 database to an external disk.

(more…)



ORA-19870 ORA-19573 During Physical Standby Rollforward

August 20th, 2014 | Posted in 11gR2, Blog | No Comments

I got the following error during Physical Standby database (11.2.0.3) Roll forward operation using incremental backup to synchronize with the primary database.
(more…)



E-Business suite : Secure APPS using Oracle VPD

August 19th, 2014 | Posted in 11gR2, Blog | No Comments

During a database check of one production environment , I found several DB users (not part of our DBA Team) having select access to ALL EBS R12 APPS schema tables.

Those users need to access to FND_* Tables for audit purposes. The issue : those users can see all encrypted application passwords from FND_USER table and thus can guess APPS password and gain more access on the application. The Oracle E-Business suite ‘APPS’ user is the most powerful application user who can see every
table in the database and run every EBS API, start/stop application, etc …
(more…)



Suspending MMON slave action kewfmadsa_ for 82800 seconds

August 4th, 2014 | Posted in 11gR2, AWR, Blog | No Comments

Problem:
In one of production environment 11.2.0.3 Oracle Enterprise Edition database, We just realized the AWR collection are stopped since the 24-JUL-14 (Date of the post 31-07-2014) ; DBA_HIST_* Tables not updated and all records older than 8 days are deleted (DBA_HIST_SNAPSHOT, DBA_HIST_SQLSTAT etc …)

After investigation, I saw those messages in the alert log files;
(more…)



ORA-17619: max number of processes using I/O slaves in a instance reached

August 4th, 2014 | Posted in 11gR2, Blog, RMAN | No Comments


Problem:
In order to Remove backup load & reduce storage on primary database, our Full Tape RMAN Backups are offloaded to the Physical Standby Database. But we recently, have the following error during RMAN backups;

(more…)



Troubleshoot: ORA-26040: Data block was loaded using the NOLOGGING option

July 26th, 2014 | Posted in 11gR2, block corruption, Blog | 1 Comment


We recently created a copy clone snapshot disk copy from a physical standby database. The database version is 11.2.0.3.
This is a new database for a new Oracle EBS environment R12.
When we run the adgrants standard script we faced the following error; “ORA-26040: Data block was loaded using the NOLOGGING option”

(more…)



Kyle Hailey: http://www.oraclerealworld.com/

June 4th, 2014 | Posted in 11gR2, 12c, ACE, Blog | No Comments


If you haven’t already noticed ; Kyle Hailey is writing excellent articles about Oracle Performance Tuning / Database Thin Cloning and much more …
Hurry up , subscribe and receive notifications when he add new articles (http://www.oraclerealworld.com/). His blog is a great resource and I learn many things from him. Ah, don’t forget to Follow him on Twitter too ; @kylehhailey

Thanks Kyle.



Troubleshoot lock issue

May 27th, 2014 | Posted in 11gR2, Blog | No Comments


One colleague asked me to check why an insert statement hangs in production environment.
The procedure inserts a record into a table using a database link; insert into a table in “prod” database.
(more…)



How do I prevent a specific SQL_ID to run in the database ?

May 14th, 2014 | Posted in 11gR2, 12c, Blog | No Comments


One colleague asked me to prevent a given SQL_ID to run in the database because the query run multiple times without a where condition and fetch thousands of millions
of rows in a development environment. Unfortunately, developers may take some time until they fix it in application code.
Database version is 11.2.0.3.
(more…)



Oracle 12c & Hadoop for better Data Management and Processing

March 25th, 2014 | Posted in 12c, Blog, hadoop | No Comments

Dear Friends,
I am happy and proud to announce that my article Oracle 12c & Hadoop for better Data Management and Processing is now published on Oracle Technology Network official website in Spanish:
(more…)



Oracle Flex ASM – Español (Article in Spanish)

November 22nd, 2013 | Posted in 12c, Blog | No Comments

1. Introducción:

La tecnología de almacenamiento ASM (Automatic Storage Management) llevo a cabo su aparición en la versión 10g de bases de datos Oracle y desde entonces, ASM no paro de evolucionar en las siguientes versiones de bases de datos.
ASM ofrece una facilidad en manejo de volumen y una mejora en temas de escalabilidad, alta disponibilidad y rendimiento.
La nueva versión de Oracle 12c sigue esa línea introduciendo nuevas capacidades en ASM. La mejora más significativa de ASM de Oracle 12c es la opción Flex ASM.

En el siguiente articulo (Adjunto en PDF), voy a explicar cómo funciona Oracle Flex ASM en la versión 12c de Oracle, como habilitar la opción y verificar su instalación por línea de comando.

Espero que os ayuda un poco en entender Oracle Flex ASM en a versión 12c de Oracle.

Oracle Flex ASM – 12CR1
Saludos
Wissem



Oracle 12c: Recover tables using RMAN

July 23rd, 2013 | Posted in 12c, Blog | 2 Comments

Dear Friends,
I am happy and proud to announce that the articles written by myself Oracle ACE Mr Wissem EL KHlifi and My friend ACE Director Mr Joel Perez are now published on Oracle Technology Network official website in Spanish:
The 4 articles are about the new possibility in Oracle Database 12c to recover a table using RMAN.
(more…)



Oracle 12c: Managing Resources

July 20th, 2013 | Posted in 12c, Blog | 1 Comment


1. Introduction:

Oracle database 12c comes with several Resource management enhancements to handle resources within CDBs and PDBs. In this article we will focus on the use of Resource Manager in a CDB environment.
(more…)



Oracle 12c: Transport tablespaces across platforms

July 15th, 2013 | Posted in 12c, Blog | 2 Comments


1- Introduction:

Transportable Tablespaces helps to copy one or more tablespaces from one Oracle Database to another.
Starting with Oracle Database version 11g, transport tablespaces can be used to migrate database from one platform to another.
This includes transporting tablespaces acrosse platforms with differemt endian formats.

Oracle database 12c Realease 1 comes with the possibility to use backupsets and image copies to transport data between platforms.
(more…)



Oracle 12c: [INS-20802] Oracle Services For Microsoft Transaction Server failed.

July 14th, 2013 | Posted in 12c, Blog | 2 Comments


During an Oracle 12c release 1 installation on Windows, I had the following error;

[INS-20802] Oracle Services For Microsoft Transaction Server failed.

(more…)



Oracle 12c: What’s New in Oracle Data Guard 12cR1?

July 12th, 2013 | Posted in 12c, Blog, Dataguard | 1 Comment


Introduction:

The following article describes the new features and enhancements that were added in Oracle Data Guard 12c Release 1.

(more…)



Polls

which oracle topic interests you most?

View Results

Loading ... Loading ...


Oracle Class Tweets


Recent Posts


Recent Comments

  • T Robinson: In regard to the comment “In our case, RMAN didn’t found anything corrupted.” Please notice...
  • iftikhar: if we backup in multiple backupsets and will be command for restoring for more than one backupsets ,
  • Abey: Very helpful article.Thanks a lot. Can we follow this on oracle DG enabled deployment also?
  • Mauricio Daher: Need help configuring SBT for cloud backups. Does not seem to work for 12c. Thanks! RMAN>...
  • Leszek K: *.db_create_file_dest=’+ DATA’ create database command – why do you use full datafile...
  • Prabhakar Kumar: Thanks buddy!!! It really helps to DBAs who are novice to 12c ASM feature.
  • Wubeshet: I am getting the ORA-07445 This morning on the trace file. The following is the symptom of the problem. It...
  • Lakshmi N: Hi Thanks for the post. Just curious, is there a way to restore to a point wher my db is in no archive...
  • Shivakkumar P: This is really very good article. Iam learning Oracle 12c I used this to replicate testing from...
  • Uday: Hi Wissem, Once we apply the level 1 incremental backup to datafile copy it is no longed required. My question...
  • avnish: Can I set up active duplicate database in 11g standard edition (11.2.0.1)
  • Jaya V: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • Jaya: hi, am having rman backup. i need to restore on it, from test instance. But the test instance name not same...
  • wissem: SQL Developer 4.0
  • oracleman consulting: great info thanks for sharing
  • Mike: Very nice article!! Thanks for sharing!!
  • yathish: I really appreciate if you can send me, if you have tutorial for 11g (11.2.0.1) RAC & ASM (prefer to be...
  • Farrukh Kamal: Fahad, I’m interesting in pursuing remote employment with Pythian. What tips would you suggest...
  • pavankumar: for the error it need to set env correctly http://orcl11gdba.blogspot.in/ 2014/08/asmcmd-08102-no-con...
  • wissem: Post result off; crsctl check has crsctl check crs

Oracle-Class Forums Latest Activity