Oracle EBS BI XML reports arabic font show question marks

Solution:

 1. Run the System Administrator request "Generate concurrent processing environment information”.

2. Note the value of AF_JRE_TOP.

3. Copy all of the font files (*.ttf) from $FND_TOP/resource to:

For Release 11i   $AF_JRE_TOP/jre/lib/fonts

For Release 12  $AF_JRE_TOP/lib/fonts

(On the concurrent manager node) . These files are:
ADUO.ttf ALBANWTT.ttf ADUOB.ttf ALBANYWT.ttf ADUOJ.ttf ADUOJB.ttf ADUOK.ttf ADUOKB.ttf ADUOSC.ttf ADUOSCB.ttf ADUOTC.ttf ADUOTCB.ttf ALBANWTJ.ttf ALBANWTK.ttf ALBANWTS.ttf

4. To test the output using "Preview", then copy them to $OA_JRE_TOP/jre/lib/fonts on the web node.

Linux: Find and replace string in file command sed

Replace /log/oraasmaudit.log with  @@10.19.22.21:514 

Note the \ used to skip /

 sed -i 's/\/var\/log\/oraasmaudit.log/@@10.19.22.21:514/g' /etc/rsyslog.conf

create database service using dbms_service

 exec dbms_service.stop_service(service_name=>'hypstg');

exec dbms_service.delete_service('hypstg');

exec dbms_service.create_service(service_name=>'hypstg', network_name=>'hypstg');

exec dbms_service.start_service('hypstg');

alter system set service_names='hypstg' scope=both;

alter system register;

EBS Unable to connect JDeveloper with Oracle EBS Database 19c pdb

 Make sure below entries added to listener.ora file:

 

USE_SID_AS_SERVICE_LISTENER = ON

USE_SID_AS_SERVICE_<DCBNAME> = ON

Netbackup RMAN backup restore

cd $ORACLE_HOME/lib

ln -s /usr/openv/netbackup/bin/libobk.so64 ./libobk.so

 RUN 

{

startup force mount;

set until time="to_date('18012023 10:00:00','ddmmyyyy hh24:mi:ss')";

ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch02 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch03 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch04 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

ALLOCATE CHANNEL ch05 TYPE 'SBT_TAPE' PARMS  'ENV=(NB_ORA_CLIENT=xxxxqlvstss01.xxxxtest.ae,NB_ORA_SSERV=xxxxQWVSB001.xxxx.ae)';

restore database;

recover database;

RELEASE CHANNEL ch00;

RELEASE CHANNEL ch01;

RELEASE CHANNEL ch02;

RELEASE CHANNEL ch03;

RELEASE CHANNEL ch04;

RELEASE CHANNEL ch05;

alter database open resetlogs;

}

Apps URL redirecting to https after cloning (ssl_terminator)

Cloned SSL instance to non-SSL instance:

 After  investigation I found that changing all https to http doesn't disable SSL but also need to modify ssl_terminator value in context value as below.

<sslterminator oa_var="s_enable_sslterminator"/>

to

<sslterminator oa_var="s_enable_sslterminator">#</sslterminator>

This disables SSL configuration. The I executed autoconfig and bounced services and finally I could launch ebs applications from Browser.

EBS r12.2 ORA-1017: Invalid username/password: login denied in forms 19c database

1. In 19c database service_name parameter should be set to container name

Connect to the CDB and run the following commands:

alter System set SERVICE_NAMES='<CDBNAME>' SCOPE=BOTH;
alter system register;

Note :- Need to wait ensuring the ebs_<PDB_NAME> and <PDB_NAME>_ebs_patch running automatically

2. Verify that the PDB database is registered with the listener

Connect to PDB and check value of local_listener parameter. It should be not be set at PDB level and should be same as CDB value.

3. PDB should have at a minimum of these services in 12.1 and 12.2.

select name from v$active_services;

12.2:

ebs_<PDB NAME>
<PDB NAME>
<PDB_NAME>_ebs_patch

4. Listener should be started using CDB environment file

cd $ORACLE_HOME

CDB_HOSTNAME.env

lsnrcrt stop CDBNAME

lsnrctl start CDBNAME

5. Verify status of listner using below mentioned command :

$ lsnrctl status 

R