creating local repository yum install linux

Follow the below procedure

[root@ebs-app-xx-xx u01]# yum repolist

[root@ebs-app-xx-xx u01]# yum list installed | grep createrepo

createrepo.noarch                         0.9.9-28.el7             @anaconda/7.5

[root@ebs-app-xx-xx u01]# createrepo /u01/Packages/

 

[root@ebs-app-xx-xx u01]# cd /etc/yum.repos.d

[root@ebs-app-xx-xx yum.repos.d]# ls -tlr

total 4

-rw-r–r–. 1 root root 358 Nov  4 22:55 redhat.repo

Now, create custom repository

[root@ebs-app-xx-xx yum.repos.d]# cat custom.repo

[customrepo]

name=Custom Repository

baseurl=file:///u01/Packages/

enabled=1

gpgcheck=0

 

you can check how (more...)

Remove this file if there is no X server

Try to start VNC, you may get the below error

 

[root@fusiondev ~]# vncserver

Warning: fusiondev.xxxxx.com:1 is taken because of /tmp/.X1-lock
Remove this file if there is no X server fusiondev.xxxx.com:1

New ‘fusiondev.xxxxx.com:2 (root)’ desktop is fusiondev.xxxxx.com:2

Starting applications specified in /root/.vnc/xstartup
Log file is /root/.vnc/fusiondev.xxxxx.com:2.log

 

Solution :

[root@fusiondev tmp]# rm -rf /tmp/.X1-lock

[root@fusiondev tmp]# rm -rf /tmp/.X11-unix/X1

(more...)

REST API Record Type Example

Goal :

Multi data insert into table of EBS 12.1 or 12.2 Enviornment

Follow the procedure :

Steps 1:

Create a package using with record type

 

CREATE OR REPLACE PACKAGE APPS.xxace_ap_restapi
AS
/* $Header: xxace_ap_restapi$ */
/*#
* This custom PL/SQL package can be used to load AP Invoices from restapi test.
* @rep:scope public
* @rep:product AP
* @rep:displayname AP Invoice Interface for restapi test
* @rep:category BUSINESS_ENTITY XXAPTEST_INT
*/
(more...)

Master Note for Handling Oracle Database Corruption Issues

Very useful document

 

Master Note for Handling Oracle Database Corruption Issues (Doc ID 1088018.1)

Enable SOA Log for EBS 12.1 and 12.2

EBS 12.1

$INST_TOP/ora/10.1.3/j2ee/oafm/config/oc4j.properties

Add the lines

SOA_ENABLE_STANDALONE_LOGGING=TRUE

 

Bounce the adoafmctl.sh

and then log file will generate $INST_TOP/soa/SOALog.log

 

EBS 12.2 :

How to Generate File ISGLog.log for SOAP Services in Release 12.2.X? (Doc ID 2008707.1)

Please be note, you need to see the logfile when the transaction are incoming to server

/u01/EBSLEBUAT/fs2/FMW_Home/user_projects/domains/EBS_domain_LEBDEV/servers/oafm_server1/logs

 

 

Database Security Assessment Tool

The Oracle Database Security Assessment Tool (DBSAT) analyzes database configurations, users, their entitlements, security policies and identifies where sensitive data resides to uncover security risks and improve the security posture of Oracle Databases within your organization.

You can use DBSAT report findings to:

  • Fix immediate short-term risks
  • Implement a comprehensive security strategy
  • Support your regulatory compliance program
  • Promote security best practices

Download

Oracle Database Security Assessment Tool (DBSAT) (Doc ID 2138254.1)

Installation and test

(more...)

ORACLE E-BUSINESS SUITE 12.2.8 RELEASE UPDATE

Oracle is pleased to announce the availability of Oracle E-Business Suite 2018 innovations, which include Oracle E-Business Suite 12.2.8 and other 2018 updates delivered prior to 12.2.8

Refer  :

http://www.oracle.com/us/products/applications/ebs-2018-innovations-5119373.pdf

https://community.oracle.com/thread/4176619

http://learn.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=904&get_params=cloudId:243,objectId:22957

 

ons port connection refused

When I try to open forms, I am getting the below issue

 

FRM-92102: A network error has occurred.
The Forms Client has attempted to reestablish its connection to the Server 1 time(s) without success.
Please check the network connection and try again later.

Details…
Java Exception:
java.io.FileNotFoundException: http://ebsuat.xxx.xx:8005/foms/x

 

So I checked the logfile in opmn.log, it shows

” [ons-connect] Connection e5e,ebsuat.xxxx.xxx,6265 connect (Connection refused) ‘

[appluat@ebsuat (more...)

libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4′

When we try to rebuild the forms or reports, you may get the below issues

“[appluat@ebsuat lib]$ make -f ins_reports.mk install
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so; \
rm -f /u01/EBSUAT/apps/tech_st/10.1.2/lib//librw.so
rm -f rwsutil.o rwspid.o ; \
/usr/bin/ar x /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.a rwsutil.o rwspid.o ; \
(LD_OPTIONS=”-z muldefs”; \
/usr/bin/gcc -m32 -o /u01/EBSUAT/apps/tech_st/10.1.2/lib//librwu.so -shared -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/ -L/u01/EBSUAT/apps/tech_st/10.1.2/lib/stubs/ rwsutil.o rwspid. (more...)

OUI to the latest version on EBS 12.1.3

you must required to upgrade OUI to latest version on EBS Version while Deploying JRE native for Windows Client, Here If you need to execute runInstaller like below

 

./runInstaller -ignoreSysPrereqs -invPtrLoc /u01/EBSUAT/apps/tech_st/10.1.2/oraInst.loc