EBS R12.2 Retrieve weblogic password

 cd $EBS_DOMAIN_HOME/bin

. ./setDomainEnv.sh

java weblogic.WLST

from weblogic.security.internal import BootProperties

BootProperties.load("/u01/app/EBS/fs1/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/security/boot.properties", false)

prop = BootProperties.getBootProperties()

print "username: " + prop.getOneClient()

print "password: " + prop.getTwoClient()

Linux root filesystem is full

 To check where is the space consumed:

sudo du -smx /* | sort -n

Oracle EBS ACL error ORA-24247: network access denied by access control list (ACL)

To solve this issue run below as a sys user

 begin

DBMS_NETWORK_ACL_ADMIN.DROP_ACL('/sys/acls/OracleEBS.xml');

commit;

end;

 /

begin

DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('/sys/acls/OracleEBS.xml','ACL description', 'APPS', TRUE, 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/OracleEBS.xml','APPS', TRUE, 'resolve');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE('/sys/acls/OracleEBS.xml','APPS', TRUE, 'connect');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL('/sys/acls/OracleEBS.xml','*');

commit;

END;

 /

Configure Oracle Public Yum repository in Linux servers like redhat

 cd /etc/yum.repos.d

[root@pft-ebsdb1 yum.repos.d]#  wget http://public-yum.oracle.com/public-yum-el7.repo

Create and import cetificate to oracle database wallet

 orapki wallet create -wallet '/u01/app/oracle/product/19.0.0/dbhome_1/wallet'

orapki wallet add -wallet '/u01/app/oracle/product/19.0.0/dbhome_1/wallet' -trusted_cert -cert '/tmp/WHATSAPP.cer'

orapki wallet display -wallet '/u01/app/oracle/product/19.0.0/dbhome_1/wallet'

1. Create wallet

Syntax: orapki wallet create -wallet <wallet_location>

$orapki wallet create -wallet ‘/home/oracle/admin/WALLETS’

Enter password:

Enter password again:

2. copy/ftp the user trusted certificate to database server temp location

/tmp/testwallet_ssl.cer

3. To add a trusted certificate to an Oracle wallet:

Syntax:  orapki wallet add -wallet <wallet_location> -trusted_cert -cert <certificate_location>

$orapki wallet add -wallet ‘/home/oracle/admin/WALLETS’ -trusted_cert -cert ‘/tmp/testwallet_ssl.cer’

4. To view an Oracle wallet:

Syntax:  orapki wallet display -wallet <wallet_location>

$orapki wallet display -wallet ‘/home/oracle/product/WALLETS/oracle’

Delete files older than n number of days

 

find /u01/app/oracle/admin/sehacdb/adump/ -name '*.aud'  -mtime +7 -delete

Mount share folder between Linux and Windows

mount -t cifs -o vers=2.0,rw,nounix,iocharset=utf8,file_mode=0777,dir_mode=0777,domain=companydomain,username=windowsUsername,password=windowsPassword //IPADDRESS_WINDOWS/sharedfolder /LINUXFOLDER

Recover WebLogic Password in EBS R12.2

cd $EBS_DOMAIN_HOME/bin

. ./setDomainEnv.sh

echo $EBS_DOMAIN_HOME    ----------  Note you have to replace below path with your instance path

java weblogic.WLST

from weblogic.security.internal import BootProperties

BootProperties.load("/u01/app/EBS/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/AdminServer/security/boot.properties", false)

prop = BootProperties.getBootProperties()

print "username: " + prop.getOneClient()

print "password: " + prop.getTwoClient()