Upgrading Linux - rhn-client-tools and oraclelinux-release conflict - /etc/pki/rpm-gpg/RPM-GPG-KEY etc

this is because both packages are trying to do the same thing with regard to the key.

Solution

:

Update oraclelinux

[root@CSLFEB16R2 ~]# yum upgrade oraclelinux-release
Setting up Upgrade Process
Resolving Dependencies
--> Running transaction check
---> Package oraclelinux-release.x86_64 6:6Server-4.0.4 will be updated
---> Package oraclelinux-release.x86_64 6:6Server-7.0.6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================
 Package                              Arch                    Version                          Repository                   Size
=================================================================================================================================
Updating:
 oraclelinux-release                  x86_64                  6:6Server-7.0.6                  ol6_latest                   23 k

Transaction Summary
=================================================================================================================================
Upgrade       1 Package(s)

Total download size: 23 k
Is this ok [y/N]: y
Downloading Packages:
oraclelinux-release-6Server-7.0.6.x86_64.rpm                                                              |  23 kB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
Warning: RPMDB altered outside of yum.
** Found 4 pre-existing rpmdb problem(s), 'yum check' output follows:
glibc-headers-2.12-1.107.el6_4.4.x86_64 has missing requires of kernel-headers
glibc-headers-2.12-1.107.el6_4.4.x86_64 has missing requires of kernel-headers >= ('0', '2.2.1', None)
oracle-rdbms-server-11gR2-preinstall-1.0-7.el6.x86_64 has missing requires of kernel-uek
oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64 has missing requires of kernel-uek
  Updating   : 6:oraclelinux-release-6Server-7.0.6.x86_64                                                                    1/2
  Cleanup    : 6:oraclelinux-release-6Server-4.0.4.x86_64                                                                    2/2
  Verifying  : 6:oraclelinux-release-6Server-7.0.6.x86_64                                                                    1/2
  Verifying  : 6:oraclelinux-release-6Server-4.0.4.x86_64                                                                    2/2

Updated:
  oraclelinux-release.x86_64 6:6Server-7.0.6

Complete!
[root@CSLFEB16R2 ~]# yum -y install rhn-client-tools
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package rhn-client-tools.noarch 0:1.0.0.1-4.0.1.el6 will be updated
---> Package rhn-client-tools.noarch 0:1.0.0.1-32.0.4.el6 will be an update
--> Processing Dependency: rhnlib >= 2.5.22-13 for package: rhn-client-tools-1.0.0.1-32.0.4.el6.noarch
--> Running transaction check
---> Package rhnlib.noarch 0:2.5.22-12.0.2.el6 will be updated
---> Package rhnlib.noarch 0:2.5.22-15.0.2.el6 will be an update
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================================================
 Package                           Arch                    Version                             Repository                   Size
=================================================================================================================================
Updating:
 rhn-client-tools                  noarch                  1.0.0.1-32.0.4.el6                  ol6_latest                  503 k
Updating for dependencies:
 rhnlib                            noarch                  2.5.22-15.0.2.el6                   ol6_latest                   67 k

Transaction Summary
=================================================================================================================================
Upgrade       2 Package(s)

Total size: 571 k
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : rhnlib-2.5.22-15.0.2.el6.noarch                                                                               1/4
  Updating   : rhn-client-tools-1.0.0.1-32.0.4.el6.noarch                                                                    2/4
warning: /etc/yum.repos.d/public-yum-ol6.repo created as /etc/yum.repos.d/public-yum-ol6.repo.rpmnew
  Cleanup    : rhn-client-tools-1.0.0.1-4.0.1.el6.noarch                                                                     3/4
  Cleanup    : rhnlib-2.5.22-12.0.2.el6.noarch                                                                               4/4
  Verifying  : rhnlib-2.5.22-15.0.2.el6.noarch                                                                               1/4
  Verifying  : rhn-client-tools-1.0.0.1-32.0.4.el6.noarch                                                                    2/4
  Verifying  : rhnlib-2.5.22-12.0.2.el6.noarch                                                                               3/4
  Verifying  : rhn-client-tools-1.0.0.1-4.0.1.el6.noarch                                                                     4/4

Updated:
  rhn-client-tools.noarch 0:1.0.0.1-32.0.4.el6

Dependency Updated:
  rhnlib.noarch 0:2.5.22-15.0.2.el6

Complete!
[root@CSLFEB16R2 ~]#

Displaying Wallet Contents with ORAPKI

With most versions of ORAPKI It is difficult to display full certificate details.

The easiest way I have found of doing this is to export the Cert to a file and then use ORAPKI cert display.

Converting Oracle Wallet to SSO

If you have ewallet.p12 and want to convert to CWALLET.SSO

/u02/app/Oracle/webtier/oracle_common/bin/orapki wallet create -wallet $PWD -auto_login -pwd WALLETPASS

Oracle PKI Tool : Version 11.1.1.7.0
Copyright (c) 2004, 2013, Oracle and/or its affiliates. All rights reserved.


Use ORAPKI to gen it.  No parameters are required, it will automatically name it CWALLET.SSO


rw------- 1 uatwls oinstall 13792 Dec 22 16:10 ewallet.p12
-rw------- 1 uatwls oinstall 13869 Dec 22 16:21 cwallet.sso

Weblogic : Sneaky ways to find a logfile or socket/ports

On Linux can be hard to find what files a process has open

Get the PID of the process you want and substitute

For Logfile
Try

ls -lrt /proc//fd|grep -v \\.jar|grep -v socket|grep -v \\.DAT|grep -v Embedded

For Ports/Sockets

 lsof -P|grep |grep IPv

this is all sockets.   To find those actually acting as endpoints

 lsof -P|grep |grep IPv|grep LISTEN

Setting up Hugepages for Oracle

use scripts etc to  calculate the right number of pages - or take an estimated guess.

SHOW SGA will give you the current SGA size you need.

I wanted 8G reserved for DB pages

Usual hugepage size is 2M -  you can see this from one of the entries in  /proc

 grep Hugepagesize /proc/meminfo
Hugepagesize:       2048 kB

OK so for 8G reserved 8g/2M = 4096 

add that number to /etc/sysctl.conf

vm.nr_hugepages = 4096

and reboot 

once the instances come up have a look at the Alert Log 

(this is 12.1.0.2 ) 

*********************************************************************

Thu Nov 26 10:08:41 2015

Dump of system resources acquired for SHARED GLOBAL AREA (SGA)

Thu Nov 26 10:08:41 2015

 Per process system memlock (soft) limit = 128G

Thu Nov 26 10:08:41 2015

 Expected per process system memlock (soft) limit to lock

 SHARED GLOBAL AREA (SGA) into memory: 1922M

Thu Nov 26 10:08:41 2015

 Available system pagesizes:

  4K, 2048K

Thu Nov 26 10:08:41 2015

 Supported system pagesize(s):

Thu Nov 26 10:08:41 2015

  PAGESIZE  AVAILABLE_PAGES  EXPECTED_PAGES  ALLOCATED_PAGES  ERROR(s)

Thu Nov 26 10:08:41 2015

        4K       Configured               3               3        NONE

Thu Nov 26 10:08:41 2015

     2048K             4096             961             961        NONE

Thu Nov 26 10:08:41 2015

**********************************************************************

we can see the SGA being allocated into the hugepages 

Running Oracle ETCC for Middle Tier

As per previous post log on to the Middle Tier, download the patch.

Source the run environment and run MTCC.sh
If the environment is correctly sourced you don't need the path to the context file but you DO need the apps password


[oracle@ebsapp4 ETCC]$ ./checkMTpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |             Oracle E-Business Suite Release 12.2              |
 |           Middle Tier Technology Codelevel Checker            |
 +===============================================================+

Using context file from currently set applications environment:
/u02/oracle/VIS/fs2/inst/apps/VIS_ebsapp4/appl/admin/VIS_ebsapp4.xml

Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.21.
Wed Nov 18 05:53:00 EST 2015
Log file for this session: /tmp/ETCC/checkMTpatch_3079.log

Bugfix XML file version: 120.0.12020000.20
This file will be used as the reference for identifying missing bugfixes.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user:
Database connection successful.
The installed AD.C.6 codelevel does not support storing the results in the datab

==================================================================
Oracle Forms and Reports
==================================================================
Now examining product Oracle Forms and Reports.

Oracle Home = /u02/oracle/VIS/fs2/EBSapps/10.1.2.
Product version = 10.1.2.3.0.
Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.
  Missing Bugfix: 17353142
  Missing Bugfix: 20643256
  Missing Bugfix: 16041055
  Missing Bugfix: 16910762
  Missing Bugfix: 20270659
  Missing Bugfix: 17372642
  Missing Bugfix: 17566694
  Missing Bugfix: 20240480
  Missing Bugfix: 19304738
The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.
All required bugfixes are present for RSF within Forms.

==================================================================
Oracle Fusion Middleware (FMW) - Web Tier
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/webtier.
Product Version = 11.1.1.6.0

------------------------------------------------------------------
[WARNING]
Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.6.0 is no longer
recommended for use with Oracle E-Business Suite Release 12.2.
Details of required bugfixes and patches are no longer
maintained for this version, so ETCC output may be out of date
and inapplicable.

For information on recommended versions, refer to My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".
------------------------------------------------------------------

Checking required bugfixes for FMW - Web Tier 11.1.1.6.0.
All required bugfixes are present for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.
All required bugfixes are present for RSF within FMW Web tier.

==================================================================
Oracle Fusion Middleware (FMW) - oracle_common
==================================================================
Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/oracle_common.
Product Version = 11.1.1.6.0

------------------------------------------------------------------
[WARNING]
Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.6.0 is no longer
recommended for use with Oracle E-Business Suite Release 12.2.
Details of required bugfixes and patches are no longer
maintained for this version, so ETCC output may be out of date
and inapplicable.

For information on recommended versions, refer to My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".
------------------------------------------------------------------

Checking required bugfixes for FMW - oracle common 11.1.1.6.0.
  Missing Bugfix: 14803792
The above list shows missing bugfixes for FMW - oracle common.

==================================================================
Oracle WebLogic Server (WLS)
==================================================================
Now examining product Oracle WebLogic Server.

Oracle Home = /u02/oracle/VIS/fs2/FMW_Home/wlserver_10.3.
Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.
All required patches are present for Oracle WebLogic Server (WLS).

==================================================================

One or more products have bugfixes missing.
Apply the missing bugfixes and rerun this script.

See Doc ID 1594274.1 for the patches that provide the bugfixes.
The footnotes for patches also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.
Wed Nov 18 05:54:32 EST 2015

==================================================================
[oracle@ebsapp4 ETCC]$

Running Oracle ETCC for E-Business Suite - DB Tier

This is for EBS 12.2

Download ETCC from Metalink 17537119

Unzip into its own directory onto the database server

If you have no idea how to run it you will need the path to the context file. 

If you are not experienced you need to know how to find it. 

If you have the environment set then just do 


[oracle@ebsvdbr4 ETCC]$ export |grep -i CONTEXT_FILE

declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"

now we can run ETCC Database checker

[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh                                                                                                                                                    
 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28
Enter the full path to the DB Context file :^C
[oracle@ebsvdbr4 ETCC]$ export |grep -i CON
declare -x CONTEXT_FILE="/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml"
declare -x CONTEXT_NAME="VIS_ebsvdbr4"
declare -x HISTCONTROL="ignoredups"
[oracle@ebsvdbr4 ETCC]$ ./checkDBpatch.sh

 +===============================================================+
 |    Copyright (c) 2005, 2015 Oracle and/or its affiliates.     |
 |                     All rights reserved.                      |
 |    Database EBS Technology Codelevel Checker (DB-ETCC)        |
 +===============================================================+

Starting Database EBS Technology Codelevel Checker, Version 120.28

*** Here paste in the path to the Context File **** 


Enter the full path to the DB Context file :/u02/oracle/VIS/11.2.0/appsutil/VIS_                                                                                                             ebsvdbr4.xml

Using database context file:
/u02/oracle/VIS/11.2.0/appsutil/VIS_ebsvdbr4.xml

Bugfix XML file version: 120.0.12020000.27
This file will be used as the reference for identifying missing bugfixes.

Identifying database release.
Setting database release to 11.2.0.3.

================================================================================                                                                                                             ===

[WARNING]

Oracle Database 11.2.0.3 is no longer recommended  for use with Oracle
E-Business Suite Release 12.2. Details of bugfixes and patches
are no longer maintained for this version, so ETCC output may be out of date and
inapplicable.

For recommended database versions, refer to  My Oracle Support Knowledge
Document 1594274.1, "Oracle E-Business Suite Release 12.2: Consolidated List
of Patches and Technology Bug Fixes".

================================================================================                                                                                                             ===

Database connection successful.

Table to store DB-ETCC results already exists in the database.

Started prerequisite patch testing : Wed Nov 18 05:29:57 EST 2015

Log file for this session : ./checkDBpatch_43824.log

Obtained list of bugfixes to be applied and the list to be rolled back.
Now checking Database ORACLE_HOME.

The opatch utility is at the required version.

Found patch records in the inventory.

All the required one-off bugfixes are present in Database ORACLE_HOME.

Stored Technology Codelevel Checker results in the database successfully.

Finished prerequisite patch testing : Wed Nov 18 05:30:06 EST 2015


=========================================================

Yes I know 11.2.0.3 is not supported.  I am upgrading to 12.1.0.2 but before I do that I need to put all the interop patches needed on.  Here I am just showing how to run ETCC