Updating spfile

Rated 3.98/5 based on 802 customer reviews

I'm able to add file to the list in UI (in browser) without problems. My user (with Windows identity) has Full Control permissions on Web Application.

Today when i was creating a STANDBY database 11GR2 , i got ORA-16179.

I prepared the system by setting pga_aggregate_target to 128M, sga_target to 512M, and memory_target = 1648M.

NOTE: Throughout these examples, I’ve removed the irrelevant results from “show parameter target”. I was not able to find any notes on Metalink regarding the issue.

I just did another test where I “primed the pump” so to speak. It allowed me to grow the db_cache_size at that point.

And apparently, this one here appeared: So even though the error message is a bit rough (at least in my release drop) the parameter does what we want.I got a help request from a client who was running Oracle 11.1.0.6 64-bit.Their memory_target parameter was set to 5G, with sga_target and all pool parameters set to 0. However, Oracle would not allocate more than 64MB RAM to the Buffer Cache. Pre-upgrade steps in the source database for database upgradation to 12c from 11.2.0.3 1the and script from the 12.1.0.1.0 $ORACLE_HOME/rdbms/admin location to the source database /tmp directory -rw-r--r-- 1 oracle oinstall 5231 Jun 19 -rw-r--r-- 1 oracle oinstall 381893 Jun 19 [[email protected] tmp]$ echo $ORACLE_SID dupdb [[email protected] tmp]$ sqlplus / as sysdba @SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 19 2014 Copyright (c) 1982, 2011, Oracle. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Loading Pre-Upgrade Package... ************************************************************ ************************************************************ ====[[email protected] tmp]$ sqlplus / as sysdba @SQL*Plus: Release 11.2.0.3.0 Production on Thu Jun 19 2014 Copyright (c) 1982, 2011, Oracle. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Loading Pre-Upgrade Package... ************************************************************ ************************************************************ ==== exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options [[email protected] tmp]$ more /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/Oracle Database Pre-Upgrade Information Tool Script Version: 12.1.0.1.0 Build: 006 ********************************************************************** Database Name: DUPDB Version: 11.2.0.3.0 Compatible: 11.2.0.0.0 Blocksize: 8192 Platform: Linux x86 64-bit Timezone file: V14 ********************************************************************** [Renamed Parameters] [No Renamed Parameters in use] ********************************************************************** ********************************************************************** [Obsolete/Deprecated Parameters] [No Obsolete or Desupported Parameters in use] ********************************************************************** [Component List] ********************************************************************** -- EXAMPLE tablespace is adequate for the upgrade. ************************************************************ Results of the checks are located at: /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/Pre-Upgrade Fixup Script (run in source database environment): /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/preupgrade_Post-Upgrade Fixup Script (run shortly after upgrade): /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/postupgrade_************************************************************ Fixup scripts must be reviewed prior to being executed. ************************************************************ Results of the checks are located at: /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/Pre-Upgrade Fixup Script (run in source database environment): /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/preupgrade_Post-Upgrade Fixup Script (run shortly after upgrade): /u01/app/orcl/oracle/cfgtoollogs/DUPDB/preupgrade/postupgrade_************************************************************ Fixup scripts must be reviewed prior to being executed.

Leave a Reply