Copyright (c) 1982, 2013, Oracle.? All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @check
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 11.2.0.4 .
INFO: Database RDBMS DST version is DSTv4 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv14 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
INFO: Note that the upg_tzv_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
SQL> SQL>
SQL> !
vi [oracle@ora11 ~]$ vi app.sql
[oracle@ora11 ~]$ exit
exit
SQL> @app.sql
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: The database RDBMS DST version will be updated to DSTv14 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
ERROR:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 35 Serial number: 49
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ora11 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.4.0 Production on Fri Dec 12 12:25:34 2014
Copyright (c) 1982, 2013, Oracle.? All rights reserved.
Connected to an idle instance.
SQL> startup pfile='/home/oracle/bak/pfile.ora';
ORACLE instance started.
Total System Global Area? 597098496 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2255552 bytes
Variable Size? ? ? ? ? ? 226493760 bytes
Database Buffers? ? ? ? ? 364904448 bytes
Redo Buffers? ? ? ? ? ? ? ? 3444736 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile='/home/oracle/bak/pfile.ora';
File created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area? 597098496 bytes
Fixed Size? ? ? ? ? ? ? ? ? 2255552 bytes
Variable Size? ? ? ? ? ? 226493760 bytes
Database Buffers? ? ? ? ? 364904448 bytes
Redo Buffers? ? ? ? ? ? ? ? 3444736 bytes
Database mounted.
Database opened.
SQL> @app.sql
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: The database RDBMS DST version will be updated to DSTv14 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area? 59709