Tuesday 31 January 2023

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;



Friday 20 January 2023

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;

}


Sunday 8 January 2023

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.

Number of Visitors