Demo of Oracle Database 10g on Windows
Datafile location.
SQL> select name from v$controlfile;
NAME
D:\ORACLE\ORADATA\IPMSPROD\CONTROL01.CTL
D:\ORACLE\ORADATA\IPMSPROD\CONTROL02.CTL
D:\ORACLE\ORADATA\IPMSPROD\CONTROL03.CTL
SQL> select name from v$datafile;
NAME
D:\ORACLE\ORADATA\IPMSPROD\SYSTEM01.DBF
D:\ORACLE\ORADATA\IPMSPROD\UNDOTBS01.DBF
D:\ORACLE\ORADATA\IPMSPROD\SYSAUX01.DBF
D:\ORACLE\ORADATA\IPMSPROD\USERS01.DBF
D:\ORACLE\ORADATA\IPMSPROD\IPMSPROD01.DBF
D:\ORACLE\ORADATA\IPMSPROD\ITCSSPROD01.DBF
D:\ORACLE\ORADATA\IPMSPROD\IPS30_BACKUP01.DBF
D:\ORACLE\ORADATA\IPMSPROD\CWMLITE01.DBF
D:\ORACLE\ORADATA\IPMSPROD\DRSYS01.DBF
D:\ORACLE\ORADATA\IPMSPROD\EXAMPLE01.DBF
D:\ORACLE\ORADATA\IPMSPROD\INDX01.DBF
D:\ORACLE\ORADATA\IPMSPROD\ODM01.DBF
D:\ORACLE\ORADATA\IPMSPROD\TOOLS01.DBF
D:\ORACLE\ORADATA\IPMSPROD\XDB01.DBF
D:\ORACLE\ORADATA\IPMSPROD\IPMSPROD02.DBF
D:\ORACLE\ORADATA\IPMSPROD\IPMSPROD03.DBF
已选择16行。
SQL> select name from v$tempfile;
NAME
D:\ORACLE\ORADATA\IPMSPROD\TEMP01.DBF
SQL> select member from v$logfile;
MEMBER
D:\ORACLE\ORADATA\IPMSPROD\REDO03.LOG
D:\ORACLE\ORADATA\IPMSPROD\REDO02.LOG
D:\ORACLE\ORADATA\IPMSPROD\REDO01.LOG
D:\ORACLE\ORADATA\IPMSPROD\REDO01_2.LOG
D:\ORACLE\ORADATA\IPMSPROD\REDO02_2.LOG
D:\ORACLE\ORADATA\IPMSPROD\REDO03_2.LOG
已选择6行。
|
Patch p9243179_10204_Win32.
D:\oracle\product\10.2.0\db_1\OPatch>set ORACLE_HOME=D:\oracle\product\10.2.0\db_1
D:\p9243179_10204_Win32\p9243179_10204_Win32\9243179>D:\oracle\product\10.2.0\db_1\OPatch\opatch version
Invoking OPatch 10.2.0.4.2
OPatch Version: 10.2.0.4.2
OPatch succeeded.
D:\p9243179_10204_Win32\p9243179_10204_Win32\9243179>D:\oracle\product\10.2.0\db_1\OPatch\opatch apply
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : D:\oracle\product\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : D:\oracle\product\10.2.0\db_1\oui
Log file location : D:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2024-05-14_00-05-45AM.log
ApplySession applying interim patch '9243179' to OH 'D:\oracle\product\10.2.0\db_1'
Running prerequisite checks...
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'D:\oracle\product\10.2.0\db_1')
Is the local system ready for patching? [y|n]y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '9243179' for restore. This might take a while...
Backing up files affected by the patch '9243179' for rollback. This might take a while...
Patching component oracle.rdbms, 10.2.0.4.0...
Copying file to "D:\oracle\product\10.2.0\db_1\bin\oracle.exe"
Copying file to "D:\oracle\product\10.2.0\db_1\rdbms\admin\oracle.sym"
ApplySession adding interim patch '9243179' to inventory
Verifying the update...
Inventory check OK: Patch ID 9243179 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9243179 are present in Oracle Home.
The local system has been patched and can be restarted.
OPatch succeeded.
D:\p9243179_10204_Win32\p9243179_10204_Win32\9243179>D:\oracle\product\10.2.0\db_1\OPatch\opatch lsinv
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : D:\oracle\product\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : D:\oracle\product\10.2.0\db_1\oui
Log file location : D:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2024-05-14_00-17-59AM.log
Lsinventory Output file location : D:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\lsinv\lsinventory2024-05-14_00-17-59AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 9243179 : applied on Tue May 14 00:11:54 PDT 2024
Created on 31 Dec 2009, 02:51:43 hrs PST8PDT
Bugs fixed:
9243179
--------------------------------------------------------------------------------
OPatch succeeded.
|
Create a new instance.
oradim -NEW -SID IPMSPROD -STARTMODE auto -PFILE D:\oracle\product\10.2.0\db_1\database\INITipmsprod.ORA -SYSPWD oracle
|
