Prerequisites installation BI Publisher 11.1.1.9.0

Prerequisites

Operating system cerification:

See the matrix certificate http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls

Oracle-7, redhat-7, redhat-6, oracle-6, oracle-5, enterprise-5.4, enterprise-4, enterprise-5, redhat-5.4, redhat-4,redhat-5,SuSE-10,SuSE-11

Recommended operating system packages

o   binutils-2.20.51.0.2

o   compat-libcap1-1.10

o   compat-libstdc++-33-3.2.3-x86_64

o   libstdc++-33-3.2.3-69.el6-x86_64

o   libgcc-4.4.4-x86_64

o   libstdc++-4.4.4-x86_64

o   libstdc++-devel-4.4.4-x86_64

o   sysstat-9.0.4

o   gcc-4.4.4

o   gcc-c++-4.4.4

o   make-3.81

o   glibc-2.12-x86_64

o   glibc-devel-2.12-x86_64

o   libaio-0.3.107-x86_64

o   libaio-devel-0.3.107-x86_64

Kernel Parameters

VERSION= 2.6.32

Hardnofiles=4096

Softnofiles=4096

Recommended glibc version

Expected result: ATLEAST=2.12

Physical memory

Expected result: 1024MB

LD_ASSUME_KERNEL environment variable

Expected result: LD_ASSUME_KERNEL environment variable should not be set in the environment

Ensure your hostname added in /etc/hosts:

[rms@vcr-broadcast2 ~]$ hostname vcr-broadcast2 [rms@vcr-broadcast2 ~]$ cat /etc/hosts 127.0.0.1   localhost localhost.localdomain localhost4  vcr-broadcast2 ::1         localhost localhost.localdomain localhost6      vcr-broadcast2 10.124.249.12           vcr-broadcast2

Ensure vncserver installed in your server.

If you haven’t installed the software yet, you can see https://www.howtoforge.com/vnc-server-installation-centos-6.5 for CentOS 6.5

Or http://tecadmin.net/setup-vnc-server-on-centos-redhat-and-fedora/

Or https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/System_Administrators_Guide/ch-TigerVNC.html

[rms@vcr-broadcast2 ~]$ vncserver xauth:  timeout in locking authority file /u01/rms/.Xauthority New 'vcr-broadcast2:4 (rms)' desktop is vcr-broadcast2:4 Starting applications specified in /u01/rms/.vnc/xstartup Log file is /u01/rms/.vnc/vcr-broadcast2:4.log

Ensure you have root privilege OS to run some scripts.

Give us root account to install BI Publisher. 

error in invoking target 'ntcontab.o' of makefile

[rms@abcxyz ~]$ rpm -qa | grep gcc
gcc-4.4.7-3.el6.x86_64
libgcc-4.4.7-3.el6.x86_64
libgcc-4.4.7-3.el6.i686
gcc-c++-4.4.7-3.el6.x86_64

[rms@abcxyz ~]$ yum remove gcc-4.4.7-3.el6.x86_64
[rms@abcxyz ~]$ yum remove libgcc-4.4.7-3.el6.x86_64
[rms@abcxyz ~]$ yum remove libgcc-4.4.7-3.el6.i686
[rms@abcxyz ~]$ yum remove gcc-c++-4.4.7-3.el6.x86_64
[rms@abcxyz ~]$ yum install gcc-c++

[rms@abcxyz ~]$ yum install libgcc

How to fix error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such file or directory

[root@vcr-broadcast2 tmp]# rpm -q libgc
rpm: error while loading shared libraries: libgcc_s.so.1: cannot open shared object file: No such file or directory
[root@vcr-broadcast2 tmp]#
[root@vcr-broadcast2 tmp]# export LD_LIBRARY_PATH=${prefix}/lib:$LD_LIBRARY_PATH

RPM to install packets for Redhat using option --nodeps

Install Packet
[root@vcr-broadcast2 setup]# rpm -ivh glibc-headers-2.21.90-18.fc24.i686.rpm 
error: Failed dependencies:
glibc = 2.21.90-18.fc24 is needed by glibc-headers-2.21.90-18.fc24.i686
kernel-headers is needed by glibc-headers-2.21.90-18.fc24.i686
kernel-headers >= 2.2.1 is needed by glibc-headers-2.21.90-18.fc24.i686
[root@vcr-broadcast2 setup]# rpm -ivh --nodeps glibc-headers-2.21.90-18.fc24.i686.rpm 
Preparing...                ########################################### [100%]
   1:glibc-headers          ########################################### [100%]
Uninstall packet.
[root@vcr-broadcast2 setup]# rpm -ev libstdc++-devel-5.1.1-4.fc23.i686
error: Failed dependencies:
libstdc++-devel = 4.4.4-13.el6 is needed by (installed) gcc-c++-4.4.4-13.el6.x86_64
[root@vcr-broadcast2 setup]# rpm -ev --nodeps libstdc++-devel-5.1.1-4.fc23.i686
[root@vcr-broadcast2 setup]#

See version of Red hat or Centos

[oracle@ptudvtg149 PT8.54]$ cat /etc/redhat-release 
Red Hat Enterprise Linux Server release 6.5 (Santiago)

Startup and Shutdown service Enterprise Manager Cloud 12c

[oracle@PTUD ~]$ cat .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
# Oracle Settings
export TMP=/tmp

export ORACLE_HOSTNAME=PTUD
export ORACLE_UNQNAME=ptud
export ORACLE_BASE=/u01/app/oracle
export ORACLE_SID=ptud
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_OMS=$ORACLE_BASE/em/oms
export ORACLE_OMS_AGENT=$ORACLE_BASE/em_agent/core/12.1.0.4.0
PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

alias cdob='cd $ORACLE_BASE'
alias cdoh='cd $ORACLE_HOME'
alias tns='cd $ORACLE_HOME/network/admin'
alias envo='env | grep ORACLE'

alias cdo='cd $ORACLE_OMS'
alias cdoa='cd $ORACLE_OMS_AGENT'
umask 022

envo


Start Enterprise Manager Cloud Control:

$ORACLE_HOME/bin/dbstart $ORACLE_HOME

$OMS_HOME/bin/emctl start oms

$AGENT_HOME/bin/emctl start agent

Shutdown Enterprise Manager Cloud Control:

$OMS_HOME/bin/emctl stop oms -all

$AGENT_HOME/bin/emctl stop agent

$ORACLE_HOME/bin/dbshut $ORACLE_HOME

Fixing Login Application Designer PeopleSoft Invalid username and password

Solution 1:
Login using SQL*Plus as user SYSADM, password: SYSADM
[oracle@ptud fmw]$ sqlplus sysadm/SYSADM@FIN92DMO

SQL*Plus: Release 12.1.0.1.0 Production on Mon Jul 20 10:41:46 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Last Successful login time: Mon Jul 20 2015 10:29:00 +07:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> update PSACCESSPRFL set ACCESSID='VP1', ACCESSPSWD='VP1', ENCRYPTED=0
where SYMBOLICID='SYSADM1';
SQL> commit;

Solution 2:
Running with Data Mover.
Open file PS_HOME/scripts/resetpswd.dms

Example Running Data Mover PeopleSoft

PeopleSoft Financials and Supply Chain Management  (FSCM 9.2) Directory:

FSCM_HOME=/home/oracle/peoplesoft/PT9.2
export $FSCM_HOME

Syntax of Data Mover Scripts:

Usage: psdmtx [-CT DB2|DB2ODBC|DB2UNIX|INFORMIX|MICROSFT|ORACLE|SYBASE]
[-CS server name]
[-CD database name]
[-CO user id]
[-CP user pswd]
[-CI connect id]
[-CW connect id pswd]
[-I  process instance]
[-FP filename]
 or
psdmtx [parmfile]

Example:
[oracle@ptud1 PT8.54]$ $PS_HOME/bin/psdmtx -CT ORACLE -CS ptudvtg149 -CD FIN92DMO -CO SYSADM -CP SYSADM -CI people -CW people -FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms

PeopleTools 8.54 - Data Mover
Copyright (c) 2015 PeopleSoft, Inc.
All Rights Reserved

Started:  Tue Jul 14 17:09:40 2015
Data Mover Release: 8.54
Database: FIN92DMO (ENG)
Input file: /home/oracle/peoplesoft/PT9.2/data/epzhsa.db (ENG

-CT ORACLE : The type of database to connect to.
-CS ptudvtg149 : Server name
-CD FIN92DMO :  database name
-CO SYSADM : user id
-CP SYSADM : user id password
-CI people : connect id
-CW people : connect id password
-FP /home/oracle/peoplesoft/PT9.2/scripts/fin92dmoora.dms  The filename for the Data Mover import script (DMS) to run. < $FSCM_HOME/scripts/ora.dms>

Scripts see Memory Static every 5 seconds

[oracle@ptud1 PT8.54]$ more tho.sh
while true
do
free
echo "-----VTG-----------" $(date) "-----------------"
sleep 5
done
[oracle@ptud1 PT8.54]$ sh tho.sh
             total       used       free     shared    buffers     cached
Mem:       8062556    7894200     168356          0     104628    3922636
-/+ buffers/cache:    3866936    4195620
Swap:      8191992      48316    8143676
-----VTG----------- Tue Jul 14 16:58:48 ICT 2015 -----------------
             total       used       free     shared    buffers     cached
Mem:       8062556    7894588     167968          0     104636    3922636
-/+ buffers/cache:    3867316    4195240
Swap:      8191992      48316    8143676
-----VTG----------- Tue Jul 14 16:58:53 ICT 2015 -----------------
             total       used       free     shared    buffers     cached
Mem:       8062556    7894960     167596          0     104640    3922636
-/+ buffers/cache:    3867684    4194872
Swap:      8191992      48316    8143676
-----VTG----------- Tue Jul 14 16:58:58 ICT 2015 -----------------

Simply Example of grep on linux

Do you want to find content of file on directory on linux?
I'd like to give you a simply command to do that.
Syntax:
grep -ril {content what you want to search} {path of the directory}
Example:

[oracle@ptud1 unix]$ grep -ril "grant select" .

./psroles.sql

./psroles.log

./connect.sql

./connect.log

./pdb/psroles2.sql

./pdb/connect.sql

[oracle@ptud1 unix]$