Step 1: Before applying Patch 24848928
********************************************************************************
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 4 02:30:24 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-29263: HTTP protocol error
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Step 2: Applying Patch 24848928
********************************************************************************
[oracle@soa-training ~]$ pwd
/home/oracle
[oracle@soa-training ~]$ cd /u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ ls -ltr
total 164
-rw-r--r--. 1 oracle oinstall 2576 May 6 2009 opatch.pl
-rw-r--r--. 1 oracle oinstall 23695 Aug 2 2010 emdpatch.pl
-rwx--x---. 1 oracle oinstall 9352 Mar 31 2011 opatchdiag.bat
-rwx--x---. 1 oracle oinstall 10056 Mar 31 2011 opatchdiag
-rwx--x---. 1 oracle oinstall 569 Aug 12 2012 datapatch.bat
-rwx--x---. 1 oracle oinstall 537 Aug 12 2012 datapatch
-rwx--x---. 1 oracle oinstall 20009 Dec 29 2013 opatch.bat
-rwx--x---. 1 oracle oinstall 24478 Jan 26 2014 opatchauto
-rwx--x---. 1 oracle oinstall 33889 Mar 26 2014 opatch
drwxr-xr-x. 5 oracle oinstall 4096 Jul 9 2015 ocm
drwxr-xr-x. 4 oracle oinstall 4096 Jul 9 2015 opatchprereqs
drwxr-xr-x. 2 oracle oinstall 4096 Jul 9 2015 jlib
drwxr-xr-x. 2 oracle oinstall 4096 Jul 9 2015 docs
drwxr-xr-x. 3 oracle oinstall 4096 Jul 9 2015 oplan
-rw-r--r--. 1 oracle oinstall 49 Jul 9 2015 opatch.ini
[oracle@soa-training OPatch]$ ./opatch version
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-44-30AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-44-30AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ cd /home/oracle/Downloads
[oracle@soa-training Downloads]$ ls -ltr
total 3372
-rw-r--r--. 1 oracle oinstall 3450285 Apr 4 02:28 p24848928_121020_Linux-x86-64.zip
[oracle@soa-training Downloads]$ unzip p24848928_121020_Linux-x86-64.zip
Archive: p24848928_121020_Linux-x86-64.zip
creating: 24848928/
creating: 24848928/etc/
creating: 24848928/etc/config/
inflating: 24848928/etc/config/actions.xml
inflating: 24848928/etc/config/inventory.xml
creating: 24848928/files/
creating: 24848928/files/lib/
inflating: 24848928/files/lib/libnnz12.so
creating: 24848928/files/lib/libnnz12.a/
inflating: 24848928/files/lib/libnnz12.a/nzos.o
creating: 24848928/files/lib/libnnzst12.a/
inflating: 24848928/files/lib/libnnzst12.a/ext_nzos.o
inflating: 24848928/README.txt
[oracle@soa-training Downloads]$ ls -ltr
total 3376
drwxrwxr-x. 4 oracle oinstall 4096 Dec 21 2016 24848928
-rw-r--r--. 1 oracle oinstall 3450285 Apr 4 02:28 p24848928_121020_Linux-x86-64.zip
[oracle@soa-training Downloads]$ cd 24848920
bash: cd: 24848920: No such file or directory
[oracle@soa-training Downloads]$ cd 24848928
[oracle@soa-training 24848928]$ pwd
/home/oracle/Downloads/24848928
[oracle@soa-training 24848928]$ ls -ltr
total 16
-rw-rw-r--. 1 oracle oinstall 5932 Dec 21 2016 README.txt
drwxrwxr-x. 3 oracle oinstall 4096 Dec 21 2016 files
drwxrwxr-x. 3 oracle oinstall 4096 Dec 21 2016 etc
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch version ./
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch version
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-50-23AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-50-23AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch apply
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/24848928_Apr_04_2019_02_52_36/apply2019-04-04_02-52-35AM_1.log
Applying interim patch '24848928' to OH '/u01/app/oracle/product/12.1.0/dbhome_2'
Verifying environment and performing prerequisite checks...
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_2')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Verifying the update...
Patch 24848928 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/24848928_Apr_04_2019_02_52_36/apply2019-04-04_02-52-35AM_1.log
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-53-30AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-53-30AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 24848928 : applied on Thu Apr 04 02:53:10 PDT 2019
Unique Patch ID: 20856904
Created on 21 Dec 2016, 06:02:18 hrs PST8PDT
Bugs fixed:
24848928
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training 24848928]$
Step 3: After applying Patch 24848928
********************************************************************************
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 4 03:01:51 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1207961720 bytes
Database Buffers 922746880 bytes
Redo Buffers 13848576 bytes
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> startup mount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1207961720 bytes
Database Buffers 922746880 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> select * from DBA_REGISTRY_SQLPATCH;
select * from DBA_REGISTRY_SQLPATCH
*
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views only
SQL> alter database open;
Database altered.
SQL> select * from DBA_REGISTRY_SQLPATCH;
no rows selected
SQL> SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
UTL_HTTP.REQUEST('HTTPS://WS.PEARSONVUE.COM/CXFWS2/SERVICES/PING',NULL,'FILE:/U0
--------------------------------------------------------------------------------
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soapen
v="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><soap:Fault><soap:Code>
<soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:la
ng="en">Fault occurred while processing.</soap:Text></soap:Reason></soap:Fault><
/soap:Body></soap:Envelope>
********************************************************************************
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 4 02:30:24 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL
*
ERROR at line 1:
ORA-29273: HTTP request failed
ORA-29263: HTTP protocol error
ORA-06512: at "SYS.UTL_HTTP", line 1491
ORA-06512: at line 1
SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
Step 2: Applying Patch 24848928
********************************************************************************
[oracle@soa-training ~]$ pwd
/home/oracle
[oracle@soa-training ~]$ cd /u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ ls -ltr
total 164
-rw-r--r--. 1 oracle oinstall 2576 May 6 2009 opatch.pl
-rw-r--r--. 1 oracle oinstall 23695 Aug 2 2010 emdpatch.pl
-rwx--x---. 1 oracle oinstall 9352 Mar 31 2011 opatchdiag.bat
-rwx--x---. 1 oracle oinstall 10056 Mar 31 2011 opatchdiag
-rwx--x---. 1 oracle oinstall 569 Aug 12 2012 datapatch.bat
-rwx--x---. 1 oracle oinstall 537 Aug 12 2012 datapatch
-rwx--x---. 1 oracle oinstall 20009 Dec 29 2013 opatch.bat
-rwx--x---. 1 oracle oinstall 24478 Jan 26 2014 opatchauto
-rwx--x---. 1 oracle oinstall 33889 Mar 26 2014 opatch
drwxr-xr-x. 5 oracle oinstall 4096 Jul 9 2015 ocm
drwxr-xr-x. 4 oracle oinstall 4096 Jul 9 2015 opatchprereqs
drwxr-xr-x. 2 oracle oinstall 4096 Jul 9 2015 jlib
drwxr-xr-x. 2 oracle oinstall 4096 Jul 9 2015 docs
drwxr-xr-x. 3 oracle oinstall 4096 Jul 9 2015 oplan
-rw-r--r--. 1 oracle oinstall 49 Jul 9 2015 opatch.ini
[oracle@soa-training OPatch]$ ./opatch version
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-44-30AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-44-30AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training OPatch]$ pwd
/u01/app/oracle/product/12.1.0/dbhome_2/OPatch
[oracle@soa-training OPatch]$ cd /home/oracle/Downloads
[oracle@soa-training Downloads]$ ls -ltr
total 3372
-rw-r--r--. 1 oracle oinstall 3450285 Apr 4 02:28 p24848928_121020_Linux-x86-64.zip
[oracle@soa-training Downloads]$ unzip p24848928_121020_Linux-x86-64.zip
Archive: p24848928_121020_Linux-x86-64.zip
creating: 24848928/
creating: 24848928/etc/
creating: 24848928/etc/config/
inflating: 24848928/etc/config/actions.xml
inflating: 24848928/etc/config/inventory.xml
creating: 24848928/files/
creating: 24848928/files/lib/
inflating: 24848928/files/lib/libnnz12.so
creating: 24848928/files/lib/libnnz12.a/
inflating: 24848928/files/lib/libnnz12.a/nzos.o
creating: 24848928/files/lib/libnnzst12.a/
inflating: 24848928/files/lib/libnnzst12.a/ext_nzos.o
inflating: 24848928/README.txt
[oracle@soa-training Downloads]$ ls -ltr
total 3376
drwxrwxr-x. 4 oracle oinstall 4096 Dec 21 2016 24848928
-rw-r--r--. 1 oracle oinstall 3450285 Apr 4 02:28 p24848928_121020_Linux-x86-64.zip
[oracle@soa-training Downloads]$ cd 24848920
bash: cd: 24848920: No such file or directory
[oracle@soa-training Downloads]$ cd 24848928
[oracle@soa-training 24848928]$ pwd
/home/oracle/Downloads/24848928
[oracle@soa-training 24848928]$ ls -ltr
total 16
-rw-rw-r--. 1 oracle oinstall 5932 Dec 21 2016 README.txt
drwxrwxr-x. 3 oracle oinstall 4096 Dec 21 2016 files
drwxrwxr-x. 3 oracle oinstall 4096 Dec 21 2016 etc
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch version ./
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch version
OPatch Version: 12.1.0.1.3
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-50-23AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-50-23AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch apply
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/24848928_Apr_04_2019_02_52_36/apply2019-04-04_02-52-35AM_1.log
Applying interim patch '24848928' to OH '/u01/app/oracle/product/12.1.0/dbhome_2'
Verifying environment and performing prerequisite checks...
All checks passed.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.1.0/dbhome_2')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.ldap.rsf, 12.1.0.2.0...
Patching component oracle.ldap.rsf.ic, 12.1.0.2.0...
Patching component oracle.rdbms, 12.1.0.2.0...
Verifying the update...
Patch 24848928 successfully applied
Log file location: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/24848928_Apr_04_2019_02_52_36/apply2019-04-04_02-52-35AM_1.log
OPatch succeeded.
[oracle@soa-training 24848928]$ /u01/app/oracle/product/12.1.0/dbhome_2/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.3
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/dbhome_2
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/dbhome_2/oraInst.loc
OPatch version : 12.1.0.1.3
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/opatch2019-04-04_02-53-30AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatch/lsinv/lsinventory2019-04-04_02-53-30AM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 24848928 : applied on Thu Apr 04 02:53:10 PDT 2019
Unique Patch ID: 20856904
Created on 21 Dec 2016, 06:02:18 hrs PST8PDT
Bugs fixed:
24848928
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@soa-training 24848928]$
Step 3: After applying Patch 24848928
********************************************************************************
SQL*Plus: Release 12.1.0.2.0 Production on Thu Apr 4 03:01:51 2019
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1207961720 bytes
Database Buffers 922746880 bytes
Redo Buffers 13848576 bytes
SQL> select status from v$instance;
STATUS
------------
STARTED
SQL> startup mount
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2926472 bytes
Variable Size 1207961720 bytes
Database Buffers 922746880 bytes
Redo Buffers 13848576 bytes
Database mounted.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> select * from DBA_REGISTRY_SQLPATCH;
select * from DBA_REGISTRY_SQLPATCH
*
ERROR at line 1:
ORA-01219: database or pluggable database not open: queries allowed on fixed
tables or views only
SQL> alter database open;
Database altered.
SQL> select * from DBA_REGISTRY_SQLPATCH;
no rows selected
SQL> SELECT UTL_HTTP.request('https://ws.pearsonvue.com/cxfws2/services/Ping',NULL,'file:/u01/app/oracle/product/12.1.0/dbhome_2/owm/wallet_53','xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') FROM DUAL;
UTL_HTTP.REQUEST('HTTPS://WS.PEARSONVUE.COM/CXFWS2/SERVICES/PING',NULL,'FILE:/U0
--------------------------------------------------------------------------------
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:soapen
v="http://schemas.xmlsoap.org/soap/envelope/"><soap:Body><soap:Fault><soap:Code>
<soap:Value>soap:Receiver</soap:Value></soap:Code><soap:Reason><soap:Text xml:la
ng="en">Fault occurred while processing.</soap:Text></soap:Reason></soap:Fault><
/soap:Body></soap:Envelope>
No comments:
Post a Comment