Thursday, March 30, 2017

Where to Tune to your weblogic server

First, find out your weblogic JAVA_HOME.

1. cd $DOMAIN_HOME/bin/

2. grep JAVA_HOME setDomainEnv.sh

you can see the JAVA_HOME.


3. cd $JAVA_HOME/jre/lib/security/

4. Take backup of java.security cp -i java.security java.security_org

grep securerandom  java.security

you can see the securerandom.source=file:/dev/random

change to securerandom.source=file:/dev/./urandom.

save the file and start the weblogic server, you can see the different.


Wednesday, March 22, 2017

TIU 12.2

Running the Technology Inventory Utility

The Technology Inventory Utility generates a consolidated report that summarizes the version levels of all installed technology stack components.
Set your Oracle E-Business Suite environment, then run one of the following commands:

On UNIX:

Application tier:
perl $FND_TOP/patch/115/bin/TXKScript.pl 
-script=$FND_TOP/patch/115/bin/txkInventory.pl 
-txktop=$APPLTMP  
-contextfile=$CONTEXT_FILE 
-appspass=apps 
-outfile=$APPLTMP/Report_Inventory.html
Database tier:
perl $ORACLE_HOME/appsutil/bin/TXKScript.pl 
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl 
-txktop=$ORACLE_HOME/appsutil/temp 
-contextfile=$CONTEXT_FILE 
-appspass=apps 
-outfile=$ORACLE_HOME/appsutil/temp/Report_Inventory.html

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!

Friday, March 3, 2017

oerr ora 19809

To got a hit with oerr ora 19809 so I checked 
oerr ora 19809
19809, 00000, "limit exceeded for recovery files"
//*Cause: The limit for recovery files specified by the
//        DB_RECOVERY_FILE_DEST_SIZE was exceeded.
// *Action: There are five possible solutions:
//          1) Take frequent backup of recovery area using RMAN.
//          2) Consider changing RMAN retention policy.
//          3) Consider changing RMAN archived log deletion policy.
//          4) Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
//          5) Delete files from recovery area using RMAN.


I checked my v$recovery_file_dest;

select space_limit/1024/1024/1024 GB,space_used/1024/1024/1024 GB from v$recovery_file_dest;

Then added more GB to it.


ALTER SYSTEM DB_RECOVERY_FILE_DEST_SIZE = 300G scope=both;