Wednesday, March 22, 2017

Where to change your wallet file in location in R12.2

cd $IAS_ORACLE_HOME it will take you fs1/FMW_Home/webtier/

Then  cd instances/EBS_web_$SID_OHS1/config/EBS_WEB_SID

view the ssl.conf

SSLWallet File :/../../../fs_ne/inst/$SID_sever/certes/Apache/


under this directory you should have the ewallet.p12 and ewallet.sso



Wednesday, March 15, 2017

how to find your ip address on your linux server

ifconfig | sed -En 's/127.0.0.1//;s/.*inet (addr:)?(([0-9]*\.){3}[0-9]*).*/\2/p'

How to check Java path in windows

for %j in (java.exe) do @echo.   %~$PATH:j

FIPS 140-2 Settings and verification

How to check what client version is connecting you DB

set linesize 180
set pagesize 600
col sid format 99999
col client_info format a45
col network_service_banner format a85
col CLIENT_VERSION format a10
col CLIENT_DRIVER format a10

break on sid skip 1 on client_info on client_version on CLIENT_DRIVER

select sid,
 (select username||'/'||machine||'/'||osuser  from v$session s where s.sid = i.sid) client_info,
CLIENT_VERSION,
CLIENT_DRIVER,
NETWORK_SERVICE_BANNER
from v$session_connect_info i;


break on sid skip 0

Monday, March 13, 2017

How to Synchronize FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2

How to Synchronize FND_NODES, ADOP_VALID_NODES, and FND_OAM_CONTEXT_FILES in 12.2 When ADOP Phase=Prepare Fails with Error 'not able to detect any valid application tier nodes in ADOP_VALID_NODES table. ' (Doc ID 2064223.1)

R12.2.5 addition



3.2 New adop monitoring and validation features

CategoryDescriptionParameters
New featuresProgress of an online patching cycle can be followed by running the new Online Patching Monitoring utility (adopmon). This utility can be used to follow the overall progress of a patching cycle, as well as identifying the various individual adop actions being taken.

$ adopmon

Before you start a new patching cycle by running the prepare phase, you can optionally check your system's readiness by running adop with the 'validate' option. If you do this while a patching cycle is in progress, validation will take place for the cutover phase.
$ adop -validate

Wednesday, March 8, 2017

VM Install on Linux 7

yum VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
No such command: VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm. Please use /bin/yum --help
[root@prince Downloads]# yum install VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm
Loaded plugins: langpacks, ulninfo
Examining VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm: VirtualBox-5.1-5.1.14_112924_el7-1.x86_64
Marking VirtualBox-5.1-5.1.14_112924_el7-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package VirtualBox-5.1.x86_64 0:5.1.14_112924_el7-1 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

============================================================================================================================================
 Package                    Arch               Version                         Repository                                              Size
============================================================================================================================================
Installing:
 VirtualBox-5.1             x86_64             5.1.14_112924_el7-1             /VirtualBox-5.1-5.1.14_112924_el7-1.x86_64             167 M

Transaction Summary
============================================================================================================================================
Install  1 Package

Total size: 167 M
Installed size: 167 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : VirtualBox-5.1-5.1.14_112924_el7-1.x86_64                                                                                1/1

Creating group 'vboxusers'. VM users must be member of that group!

  Verifying  : VirtualBox-5.1-5.1.14_112924_el7-1.x86_64                                                                                1/1

Installed:
  VirtualBox-5.1.x86_64 0:5.1.14_112924_el7-1                                                                                              

Complete!