AskDba.org Weblog

Writing About Our Experiences With Oracle Databases

buy zithromax online; buy lexapro online

Friday May 18th 2012

Latest Topics

Using current_scn for RMAN incremental ? Think again..

I am bloging about experience we had using rman incremental backup for syncing standby database. We had a standby [Read More]

Poll on Sql Plan Management

Dominic is conducting poll on SPM and Sql Profiles usage on his website. Link can be found here I have been using SPM [Read More]

Oracle Direct connector for HDFS

Some time back oracle had announced Oracle Big Data appliance. Along with this Oracle released Big Data Connectors to [Read More]

ORA-7445 core dump [kokscold()+849] from EM 12c

The first problem reported by my EM 12c is an ORA-7445 error. After checking the alert log following is the exact [Read More]

Copying Oracle Scheduler jobs with Arguments

Oracle provides dbms_scheduler.copy_job function to copy oracle scheduler jobs which works great. But problem is that [Read More]

Archive for April, 2009

SRVCTL fails to start RAC resources:CRS-0215

20 Apr, 2009 | Author: Saurabh Sood | 1 Comment »

After upgrading RAC database to 10204 and applying CRS bundle patch-1 for 10204 crs home, srvctl command fails to startup resources on rac nodes. While starting up RAC resources using SRVCTL following error occurs in CRSD.log file: $ srvctl start instance -d rac -i rac2 [Read More]

ORA-1078 ORA-1565 Errors while starting database with SPFILE on ASM

14 Apr, 2009 | Author: Amit | 2 Comments »

I was getting following error’s while starting a database using spfile on ASM. Actually this was a cloned RAC environment. SQL> create SPFILE='+ASM_GROUP/PORTALDB/spfileportaldb.ora' from pfile; File created. SQL> shut immediate; ORA-01109: database [Read More]

Grid Control Fails to Start

13 Apr, 2009 | Author: Saurabh Sood | 2 Comments »

The link for Grid Control was not Working and it failed to show the login page. In this situation checked the following things: 1. The repository database was up and running 2. The listener was up. 3. OMS server was down. Tried to stratup the OMS server using opmnctl [Read More]

Connections to DataBase Hang Including “/ as sysdba”

07 Apr, 2009 | Author: Saurabh Sood | 2 Comments »

Recently I faced one issue where all the connection to database hung and it was also not possible to login to database using “/ as sysdba”. To get access of sqlplus I used the following syntax: $ sqlplus -prelim / as sysdba With “prelim” option we [Read More]