Configuring Oracle Apex on 11gR2

Might ask why you would want to run Apex?  Well Apex is a very power sql driven application module that allows even the noob to advanced programmer the ability to code and create useful pages/applications.  I personally don’t have any experience with Apex from a programming standpoint and decided to at least install it to […]

ORA-12518: TNS:listener could not hand off client connection

Ever experience “TNS:listener could not hand off client connection”? I have, just recently when creating a vm with multiple databases and setting up OEM 12c. oracle@test:> sqlplus / as sysdba SQL*Plus: Release 11.2.0.2.0 – Production on Sun Aug 26 09:21:56 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12518: TNS:listener could not hand off client […]

resync catalog from db_unique_name all — fails ***UPDATE

Previously I talked about ‘RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;’ (LINK) and the issues we have faced.  As promised here is some followup. Oracle had asked us to perform a few steps. The first was to test 2 new net service names in the tnsnames.ora file on both the primary and the standby database.  Here is […]

Continuous Physical Data Block Corruption Issues

Wanted to update the world on what’s going on with my current work related issues. Of course names and other propriety details will be withheld, but here we go.*** Oh and in case you are wondering, this is a complex system setup. Exadata at that. 8 node primary with a Data Guard and Physical Standby […]

Recovering from Physical Database Block Corruption

We were performing an incremental backup of our production database when  it failed due to physical block corruption.  This is an 8 node exadata system with an 8 node physical standby and dataguard.  To correct the database physical block corruption we performed the following steps.  Hope this is helpful for others who have experience this […]

Oracle Exadata Database Machine – Part 1 high level general administration

Exadata – General Administration For general administration of Exadata you must be proficient with Oracle RAC and its general concepts. Since Exadata X2 series Hardware utilizes 11gR2 (11.2.0.2) I also recommend to read up on RAC. You can click here to access the 11gR2 documentation http://www.oracle.com/pls/db112/portal.portal_db?selected=16&frame=#oracle_real_application_clusters In this blog post I’ll be showing some basic […]

RMAN – ALLOCATE CHANNEL FOR MAINTENANCE (RMAN-01009)

Performing maintenance using RMAN is part of any dba’s admin duties.  Issuing the commands in RMAN manually is not as common as it used to be.  Most dba’s have scripts that perform the normal RMAN tasks.  Because of this automation dba’s tend to forget the actual commands or structure of the commands. This tutorial is […]

Difference between DDL and DML

DDL statements (Data Definition Language) are used to define the structure of a table or database as well as the schema of the database. DML statements (Data Manipulation Language) are used to manage the data of the objects within a schema, table or database. Below are some examples of DDL and DML statements: DDL CREATE […]

How to get sql_id and sql_text for a concurrent request

A colleague asked for a quick video and text example of how to get sql_id and sql_text for a concurrent program that is running. The text is below: col action format a20 col module form a30 select sid,sql_id,action,module from v$session where action like ‘%Conc%’; select sql_text from v$sqlarea where sql_id=’SQL_ID’; I hope this is helpful. […]