How to resolve GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Issue:

Downloading Packages:
warning: rpmts_HdrFromFdno: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

GPG key retrieval failed: [Errno 14] Could not open/read file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle


Solution:

Run below one to get RPM-GPG-KEY-oracle file.

wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Now you should able to run yum without any issues.

Yum not installaing rpms in Cent OS

Issue:

[root@test u03]# yum install oracle-rdbms-server-12c*
Loaded plugins: fastestmirror, refresh-packagekit, security
Setting up Install Process
Loading mirror speeds from cached hostfile
 * base: mirror.fibergrid.in
 * centosplus: mirror.fibergrid.in
 * contrib: mirror.fibergrid.in
 * extras: mirror.fibergrid.in
 * updates: mirror.fibergrid.in
No package oracle-rdbms-server-12c* available.
Error: Nothing to do

[root@test etc]# cd yum.repos.d
[root@test yum.repos.d]# ls
CentOS-Base.repo  CentOS-Base.repo.rpmnew  CentOS-Debuginfo.repo  CentOS-fasttrack.repo  CentOS-Media.repo  CentOS-Vault.repo

Solution:

Run below one to get public-yum-ol6.repo file.

[root@test yum.repos.d]# wget http://public-yum.oracle.com/public-yum-ol6.repo
--2016-12-06 06:01:55--  http://public-yum.oracle.com/public-yum-ol6.repo
Resolving public-yum.oracle.com... , 
Connecting to public-yum.oracle.com||:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 7301 (7.1K) [text/plain]
Saving to: âpublic-yum-ol6.repoâ

100%[==============================================================================================================================>] 7,301       --.-K/s   in 0s

2016-12-06 06:01:59 (15.8 MB/s) - âpublic-yum-ol6.repoâ

Now yum install run successfully

yum install oracle-rdbms-server-12c*

====================================================================
 Package             Arch    Version      Repository    Size
====================================================================
Installing:
 oracle-rdbms-server-12cR1-preinstall                    
                    x86_64  1.0-14.el6    ol6_latest    17 k
Installing for dependencies:
 cloog-ppl      x86_64  0.15.7-1.2.el6   base           93 k
 compat-libcap1 x86_64  1.10-1           base           17 k
 compat-libstdc++-33                                     
                x86_64  3.2.3-69.el6     base           183 k
 cpp            x86_64  4.4.7-17.el6     base           3.7 M
 gcc            x86_64  4.4.7-17.el6     base           10 M
 gcc-c++        x86_64  4.4.7-17.el6     base           4.7 M
 ksh            x86_64  20120801-33.el6  base           761 k
 libaio-devel   x86_64  0.3.107-10.el6   base           13 k
 libstdc++-develx86_64  4.4.7-17.el6     base           1.6 M

Transaction Summary
====================================================================
Install      14 Package(s)

Total size: 54 M
Installed size: 164 M
Is this ok [y/N]: y

Oracle Fusion Middleware 12c (12.2.1.2.0) Certification Matrix

1. What is the certified JDK that can be installed for SOA 12.2.1.2.0?

A: Oracle JDK 1.8.0_101+

2. What is the certified/Supported Platforms(Linux,Solaris and Windows) that can be installed for SOA 12.2.1.2.0?

Linux :

Oracle Linux 6.6+&7, Red Hat Enterprise Linux 6.6+&7 and SUSE Linux 11,12

Solaris:

Oracle Solaris on SPARC (64-bit) 11u2+, Oracle Solaris on x86-64 (64-bit) 11u2+

Microsoft Windows x64 (64-bit):

2012 Service Pack


Refer below Certification Matrix for Oracle Fusion Middleware 12c (12.2.1.) ( xls) at URL:

http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-122120-certmatrix-3254735.xlsx

OBIEE 12c(OBIEE 12.2.1.2.0) Installation on Linux 6.8 64-bit Step by Step

Platform Details:
Red Hat Enterprise Linux Server release 6.8 (Santiago)
Linux em12c.oracle.com 2.6.39-400.286.3.el6uek.x86_64 #1 SMP Fri Oct 21 15:33:03 PDT 2016 x86_64 x86_64 x86_64 GNU/Linux

Database:  
Oracle Database 12c(12.1.0.2.0)

Application:
OBIEE 12c(12.2.1.2.0)

Platform support:

Oracle Linux 6.7,Redhat 6,7 and Suse 11 and 12.

1) Download the required Oracle Business Intelligence 12c files

2)  Pre-requisite Configurations

a. Creation of the installer user

[root@oe12c ~]# useradd oraobi -g dba

[root@oe12c ~]# passwd oraobi

Changing password for user oraobi.

New UNIX password: oraobi

BAD PASSWORD: it is WAY too short

Retype new UNIX password: oraobi

passwd: all authentication tokens updated successfully.

6.2.2.2 - Creation of the Middleware Home directory

b. Creation of the Middleware Home directory 

mkdir -p /u01/MiddlewareHome

chown -R oraobi:dba /u01/MiddlewareHome

chmod -R 775 /u01/MiddlewareHome

c. Install below Prerequisite packages

compat-libcap1-1.10

compat-libstdc++-33-3.2.3-x86_64

libgcc-4.8.2-x86_64

libstdc++-4.8.2-x86_64 

libstdc++-devel-4.8.2-x86_64

sysstat-10.1.5

gcc-4.8.2

gcc-c++-4.8.2

make-3.82

glibc-2.17-x86_64

glibc-devel-2.17-x86_64

libaio-0.3.109-x86_64

d. Set the File Handle Limit parameter

oraobi                 soft    nofile  4096

oraobi                 hard    nofile  65536

3) Install JDK

[root@oe12c OBIA12C]# rpm -ivh jdk-8u112-linux-x64.rpm
Preparing...                ########################################### [100%]
   1:jdk1.8.0_112           ########################################### [100%]
Unpacking JAR files...
        tools.jar...
        plugin.jar...
        javaws.jar...
        deploy.jar...
        rt.jar...
        jsse.jar...
        charsets.jar...
        localedata.jar...
[root@oe12c OBIA12C]# java -version
java version "1.8.0_112"
Java(TM) SE Runtime Environment (build 1.8.0_112-b15)
Java HotSpot(TM) 64-Bit Server VM (build 25.112-b15, mixed mode)
[root@oe12c OBIA12C]# which java
/usr/bin/java

4) Oracle Database 12c(12.1.0.2.0) Installation on Linux 6.8

For Database installation , follow below link 

http://oracleapplicationsdba4u.blogspot.in/2016/11/oracle-database-12c121020-installation.html

5) Install Fusion Middleware Infrastructure

Run below command to install

[oracle@oe12c OBIA12C]$ java -jar fmw_12.2.1.2.0_infrastructure.jar

Click Next

Click Next

Change the path where install and click Next

Click Next

Unncheck  and Click Next

Click Yes

Click Install

Click Next

Click Finish

6) Install OBIEE 12c Software

[oracle@oe12c OBIA12C]$ ./bi_platform-12.2.1.2.0_linux64

Click Next

Click Next

Change path and Click Next

Click Next

Click Next

Click Install

Click Next

Click Finish

7) Domain Creation and Configure RCU

./config.sh

Click Next

Click Next

Change domain name what you want and Click Next

Provide Schema prefix to repository creation and give database details , Click Next
Connect String like <hostname or ip>:db port:Servicename

Click Next

Click Configure

Click Finish.

When we run config.sh , it will run rcu automatically and created repository in database. Otherwise run rcu first then run cinfig.sh.

RCU:

cd /u01/MiddlewareHome/Oracle_Home/oracle_common/bin

Run 


./rcu

Click Next

Click Next

Provide database details and Click Next

Click Next

Select existing schema and click component and Click Next

Provide schema password and Click Next

Click Ok and Next

Click Next

Click Next

Click Next

Click Create

Click Close.

8) Post installation verification

Below URLs will display after configuration.

WebLogic Console:
http://<host>:9500/console

Fusion Middleware Control:
http://<host>:9500/em

Visual Analyzer:
http://<host>:9502/va

BI Publisher:
http://<host>:9502/xmlpserver

BI Analytics:

http://<host>:9502/analytics

WebLogic Console:

Fusion Middleware Control:

Visual Analyzer:

BI Publisher:

BI Analytics:

9) How to Start/Stop/Status

cd /u01/MiddlewareHome/Oracle_Home/user_projects/domains/bi/bitools/bin

[oraobi@em12c bin]$ ls

admintool.sh                   biserverxmlgen.sh              diagnostic_dump.sh          isstopped.sh       nqudmlgen.sh            startESSCMD.sh
biserverapplyverticalrules.sh  clone_bi_machine.sh            equalizerpds.sh             migration-tool.sh  obieerpdmigrateutil.sh  startMAXL.sh
biserverextender.sh            comparerpd.sh                  export_service_instance.sh  nqcmd.sh           obieerpdpwdchg.sh       start.sh
biservergentypexml.sh          create_bi_service_instance.sh  externalizestrings.sh       nqgenoldverrpd.sh  patchrpd.sh             status.sh
biservermetadatadictgen.sh     datamodel.sh                   extractprojects.sh          nqsecudmlgen.sh    prunerpd.sh             stop.sh
biserverxmlcli.sh              delete_bi_machine.sh           generate_css_secrets.sh     nqudmlcli.sh       runcat.sh               sync_midtier_db.sh
biserverxmlexec.sh             delete_bi_service_instance.sh  import_bar.sh               nqudmlexec.sh      ssl.sh                  validaterpd.sh

For starting applications run 

[oraobi@em12c bin]$./start.sh

For checking applications status run

[oraobi@em12c bin]$./status.sh

For stoping applications run 

[oraobi@em12c bin]$./stop.sh