[oracle@ODIGettingStarted ~]$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Apr 7 01:20:15 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Enter password:
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> SELECT UTL_HTTP.request('https://wsctt.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/11.2.0/orcl/owm/wallet_51','xxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
SELECT UTL_HTTP.request('https://wsctt.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/11.2.0/orcl/owm/wallet_51','xxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29259: end-of-input reached
ORA-06512: at line 1
SQL> SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/11.2.0/orcl/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/11.2.0/orcl/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1720
ORA-29259: end-of-input reached
ORA-06512: at line 1
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@ODIGettingStarted ~]$
[oracle@ODIGettingStarted ~]$ cd $ORACLE_HOME
[oracle@ODIGettingStarted orcl]$ cd OPatch
[oracle@ODIGettingStarted OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.20
OPatch succeeded.
[oracle@ODIGettingStarted OPatch]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-APR-2019 01:24:16
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ODIGettingStarted)(PORT=1521)))
The command completed successfully
[oracle@ODIGettingStarted OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_11-22-37AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/lsinv/lsinventory2019-04-07_11-22-37AM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: localhost
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ODIGettingStarted OPatch]$
[oracle@ODIGettingStarted OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -ph /home/oracle/Downloads/27338049
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-25-30AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[oracle@ODIGettingStarted OPatch]$ ./opatch prereq CheckActiveFilesAndExecutables -ph /home/oracle/Downloads/27338049
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-26-01AM_1.log
Invoking prereq "checkactivefilesandexecutables"
Prereq "checkActiveFilesAndExecutables" for patch 17478514 passed.
Prereq "checkActiveFilesAndExecutables" for patch 18031668 passed.
Prereq "checkActiveFilesAndExecutables" for patch 18522509 passed.
Prereq "checkActiveFilesAndExecutables" for patch 19121551 passed.
Prereq "checkActiveFilesAndExecutables" for patch 19769489 passed.
Prereq "checkActiveFilesAndExecutables" for patch 20299013 passed.
Prereq "checkActiveFilesAndExecutables" for patch 20760982 passed.
Prereq "checkActiveFilesAndExecutables" for patch 21352635 passed.
Prereq "checkActiveFilesAndExecutables" for patch 21948347 passed.
Prereq "checkActiveFilesAndExecutables" for patch 22502456 passed.
Prereq "checkActiveFilesAndExecutables" for patch 23054359 passed.
Prereq "checkActiveFilesAndExecutables" for patch 24006111 passed.
Prereq "checkActiveFilesAndExecutables" for patch 24732075 passed.
Prereq "checkActiveFilesAndExecutables" for patch 25869727 passed.
Prereq "checkActiveFilesAndExecutables" for patch 26609445 passed.
Prereq "checkActiveFilesAndExecutables" for patch 26392168 passed.
Prereq "checkActiveFilesAndExecutables" for patch 26925576 passed.
Prereq "checkActiveFilesAndExecutables" for patch 27338049 passed.
OPatch succeeded.
[oracle@ODIGettingStarted OPatch]$ ./opatch apply /home/oracle/Downloads/27338049
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-27-09AM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-27-26AM_1.log
Verifying environment and performing prerequisite checks...
UtilSession failed:
To run in silent mode, OPatch requires a response file for Oracle Configuration Manager (OCM).
Please run "/tmp/oracle-home-1554614843190109/OPatch/ocm/bin/emocmrsp" to generate an OCM response file. The generated response file
can be reused on different platforms and in multiple OPatch silent installs.
To regenerate an OCM response file, Please rerun "/tmp/oracle-home-1554614843190109/OPatch/ocm/bin/emocmrsp".
Log file location: /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-27-26AM_1.log
OPatch failed with error code 73
[oracle@ODIGettingStarted OPatch]$ cleat
bash: cleat: command not found
[oracle@ODIGettingStarted OPatch]$ clear screen
[oracle@ODIGettingStarted OPatch]$ ./opatch apply /home/oracle/Downloads/27338049
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-35-11AM_1.log
Verifying environment and performing prerequisite checks...
--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...
Oracle Interim Patch Installer version 11.2.0.3.20
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/orcl
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/orcl/oraInst.loc
OPatch version : 11.2.0.3.20
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/orcl/cfgtoollogs/opatch/opatch2019-04-07_01-35-25AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111 24732075 25869727 26609445 26392168 26925576 27338049
Do you want to proceed? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/11.2.0/orcl')
Is the local system ready for patching? [y|n]
Y (auto-answered by -silent)
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/orcl'
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
---------------------
---------------
------------------
------------------------------
No comments:
Post a Comment