Problem:
After creating an spfile on an 11g instance (11.1.0.7) on R12.1.3 on Windows 2008, it does not automatically appear when the ‘show parameter spfile’ command is issued in SQL*Plus.
Solution:
When the database is started via the Windows Services panel, it seems that the pfile is used by default, even though the spfile may have been created. Stop and start the database via SQL*Plus to see the spfile.
Problem:
How do I enable archivelog in an Oracle9i database?
Solution:
After logging into the running Oracle9i instance as the SYS user (sqlplus “/ as sysdba”), check the log_archive parameters:
show parameter log_archive
Set the archive log destination directory (note that these commands assume that the database uses the spfile):
alter system set log_archive_start=TRUE scope=spfile; alter system set log_archive_dest_1='location=/u01/archive/ORCL/' scope=spfile; alter system set log_archive_format='arch_%t_%s.arc' scope=spfile;
Then shutdown and mount the database, and enable archivelog:
shutdown immediate; startup mount; archive log start; alter database archivelog; alter database open;
Reference:
http://www.oracle-base.com/articles/9i/ArchivelogModeOnRAC9i.php
[amazon asin=0071496610&template=iframe image&chan=default] [amazon asin=1849687307&template=iframe image&chan=default] [amazon asin=0071598758&template=iframe image&chan=default]
Problem:
EBS instance running out of processes. Need to increase the database PROCESSES initialization parameter.
Solution:
Change the PROCESSES init parameter in the pfile or scope=spfile. Then restart the database (using addbctl.sh, not using the database stop immediate/startup command as shown below).
SQL> @ utlu102i.sql
Oracle Database 10.2 Upgrade Information Utility 08-30-2007 18:57:10
.
**********************************************************************
Database:
**********************************************************************
–> name: PROD
–> version: 9.2.0.8.0
–> compatible: 9.2.0
–> blocksize: 8192
.
**********************************************************************
Logfiles: [make adjustments in the current environment]
**********************************************************************
–> The existing log files are adequate. No changes are required.
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
–> SYSTEM tablespace is adequate for the upgrade.
…. minimum required size: 7139 MB
–> CTXD tablespace is adequate for the upgrade.
…. minimum required size: 17 MB
–> APPLSYSD tablespace is adequate for the upgrade.
…. minimum required size: 18597 MB
–> CCTD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> ARD tablespace is adequate for the upgrade.
…. minimum required size: 268 MB
–> OKCD tablespace is adequate for the upgrade.
…. minimum required size: 33 MB
–> AMVD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> XNPD tablespace is adequate for the upgrade.
…. minimum required size: 9 MB
–> XDPD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> IEOD tablespace is adequate for the upgrade.
…. minimum required size: 4 MB
–> IBUD tablespace is adequate for the upgrade.
…. minimum required size: 1 MB
–> IEMD tablespace is adequate for the upgrade.
…. minimum required size: 8 MB
–> JTFD tablespace is adequate for the upgrade.
…. minimum required size: 63 MB
–> ASOD tablespace is adequate for the upgrade.
…. minimum required size: 7 MB
–> TEMP tablespace is adequate for the upgrade.
…. minimum required size: 58 MB
–> APPS_UNDOTS1 tablespace is adequate for the upgrade.
…. minimum required size: 286 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
WARNING: –> “streams_pool_size” is not currently defined and needs a value of
at least 50331648
WARNING: –> “session_max_open_files” needs to be increased to at least 20
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
— No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 10.2 init.ora or spfile]
**********************************************************************
–> “optimizer_max_permutations”
–> “row_locking”
–> “undo_suppress_errors”
–> “log_archive_start”
–> “max_enabled_roles”
–> “enqueue_resources”
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
–> Oracle Catalog Views [upgrade] VALID
–> Oracle Packages and Types [upgrade] VALID
–> JServer JAVA Virtual Machine [upgrade] VALID
…The ‘JServer JAVA Virtual Machine’ JAccelerator (NCOMP)
…is required to be installed from the 10g Companion CD.
–> Oracle XDK for Java [upgrade] VALID
–> Oracle Java Packages [upgrade] VALID
–> Oracle Text [upgrade] VALID
–> Oracle XML Database [install]
–> Real Application Clusters [upgrade] INVALID
–> Oracle interMedia [upgrade] VALID
…The ‘Oracle interMedia Image Accelerator’ is
…required to be installed from the 10g Companion CD.
–> Spatial [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: –> Passwords exist in some database links.
…. Passwords will be encrypted during the upgrade.
…. Downgrade of database links with passwords is not supported.
WARNING: –> Deprecated CONNECT role granted to some user/roles.
…. CONNECT role after upgrade has only CREATE SESSION privilege.
WARNING: –> Database contains stale optimizer statistics.
…. Refer to the 10g Upgrade Guide for instructions to update
…. statistics prior to upgrading the database.
…. Component Schemas with stale statistics:
…. SYS
…. CTXSYS
…. ORDSYS
…. MDSYS
WARNING: –> Database contains INVALID objects prior to upgrade.
…. USER APPS has 4 INVALID objects.
…. USER DISCOVERER has 1 INVALID objects.
…. USER PERFSTAT has 1 INVALID objects.
…. USER SPOTLIGHT has 2 INVALID objects.
…. USER SYS has 5 INVALID objects.
…. USER VTAS_I3_ORCL has 40 INVALID objects.
.
**********************************************************************
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 10.2 environment]
**********************************************************************
–> New “SYSAUX” tablespace
…. minimum required size for database upgrade: 500 MB
.
PL/SQL procedure successfully completed.
SQL>
SQL>
SQL> spool off
Recent Comments