Archive

Archive for July, 2013

Oracle: Non ASM to ASM migration

July 30, 2013 Leave a comment

Advertisements
Categories: Oracle

ORA-04031: when restoring spfile using rman

July 12, 2013 Leave a comment

When trying to restore the spfile from rman  you might encounter the following error


rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jul 12 11:09:28 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)<
RMAN> startup force nomount
starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/12/2013 11:09:40
RMAN-04014: startup failed: ORA-04031: unable to allocate 70464 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","KTI-UNDO")
RMAN> exit

RMAN will use certain default values. Sometimes, these default values may not be sufficient (depending on your version/os).

This is a well known behavior.
set this environment variable to a higher value.
export ORA_RMAN_SGA_TARGET= xxxxxxx

Categories: Oracle

No diagnostic or tuning pack , dont get robbed by Oracle

July 9, 2013 Leave a comment

To Track what features are being used in a database you can run the following sql

SELECT output FROM TABLE( DBMS_FEATURE_USAGE_REPORT.DISPLAY_TEXT);

Categories: Uncategorized