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

EBS R12.2 Java Code signing certificate

 EBS R12.2 Java Code sigining certificate 

get the certficate alias from below file, it will be the first word in the file:

cat $NE_BASE/EBSapps/appl/ad/admin/adsign.txt

Mostly its the $CONTEXT_NAME

mv $NE_BASE/EBSapps/appl/ad/admin/adkeystore.dat $NE_BASE/EBSapps/appl/ad/admin/adkeystore.dat_old

keytool -keystore $NE_BASE/EBSapps/appl/ad/admin/adkeystore.dat -genkey -validity 6000 -keypass puneet -dname "CN=EBSDB_apps, OU=IT, O=Tahaluf, L=Abudhabi, ST=Abudhabi, C=AE" -alias EBSDB_apps -keyalg RSA -keysize 2048 -storepass puneet

keytool -export -alias EBSDB_apps -keystore adkeystore.dat  -rfc -file EBSDB_apps.crt -storepass puneet

Stop the application

Run ADADMIN, and select the following from the AD Administration Main Menu:

Choose Generate Applications Files menu

From this menu choose Generate product JAR files

Enter yes when prompted with: Do you wish to force regeneration of all jar files? [No] ? yes

Then

Reload JAR files to database 

Start the application

In client machine run Configure Java

Security tab > Manage certificate > Certificate Type > Signer ca  > Import certificate