Skip to main content

Posts

Showing posts from November, 2021

Unknown publisher error while Opening forms in Oracle Apps

Unknown publisher error while Opening forms in Oracle Apps Download the jar signing certificate and copy to client on Windows. Import that certificate to Java certificates on client system Signer CA (Signer Certificate Authority) :  A Certificate Authority is also recognised with its certificate.  Again in a MS Windows based client machine, these certificates are listed under : Control Panel --> Java --> Security --> Manage Certificates --> Signer CA If you like please follow and comment

Automatically Generate a self signed Certificate and load in adkeystore.dat using Shell Script

Automatically Generate a self signed Certificate and load in adkeystore.dat using Shell Script If we want to generate self signed certificate we can do manually. I have tried to do the same via a script and tested for Oracle Apps jar signing. Before running the script please make necessary changes as per your need. Script: [applmgr@funebs122 admin]$ cat gen_self_sign.sh   #!/bin/bash # # CN = Common Name # OU = Organization Unit # O  = Organization # C  = Country code # # Certificate settings: # These are used to generate the initial signing certificate # Change them to suite your organisation # DN_CN="funoracleapps" DN_OU="IT Lab" DN_O=Noida DN_C=India # # Give your keystore file KEYSTORE=$APPL_TOP/admin/adkeystore.dat # # If KEYSTORE already exists, old KEYSTORE_PASSWORD for the keystore file must # be correctly given here. If KEYSTORE does not already exist, any password # given here will be taken for the new KEYSTORE file to be created. # # *** Remove the text a...

Understanding backup and Restore in AIX

Understanding backup and Restore in AIX Important Points: a. rootvg backup can be taken thru mksysb command. Most people refer it as mksysb backup. b. This type of backup on a tape is bootable. Hence its been widely used to restore the system incase of system crash. c. Mksysb backup contains 4 images i. BOS Boot Image - Kernel Device Drivers ii. mkinsttape image - ./image.data, ./tapeblksz, ./bosinst.data and few other commands iii. dummy .toc - Nothing but a dummy table of contents file iv. rootvg data - This is where the actual data resides Files used by mksysb: /image.data : Contains information about the image installed during the BOS installation process. This includes the sizes, names, mount points of LVs and file systems in the rootvg [Actually nothing but the rootvg structure]. It can be created using mkszfile command. /var/adm/ras/bosinst.data : It allows you to customize the OS installtion. Modified mostly to use the mksysb image to install new servers. Few Commands : To gene...

Shell Script to take Input of 5 Numbers from User and Sum the Even Numbers

Shell Script to take Input of 5 Numbers from User and Sum the Even Numbers Script: #!/bin/bash echo "Enter 5 numbers separated by space" read a b c d e x=0 for i in $a $b $c $d $e do if [ $((i % 2)) -eq 0 ] then x=$(( $x + $i )) fi done echo " Sum of even numbers is : $x" If you like please follow and comment

sqlldr cannot start because oranfsodm12.dll is missing

sqlldr cannot start because oranfsodm12.dll is missing I have recently installed Oracle Database Client (12.1.0.2.0)(winx64) with Administration installation, But when I am trying to execute sqlldr.exe then I am getting the below error : This is a known bug Solutions: =========== To avoid the issue in the first place, explicitly select "Oracle NET" component during install After the fact, you can  a) do another custom install into the same home, and select "Oracle NET" or b) copying ORACLSCE12.DLL from an existing install into OH\bin also resolves the issue. or c) cd ORACLE_CLIENT_HOME\bin copying oraodm12.dll and renaming it to oranfsodm12.dll  If you like please follow and comment

Installing Oracle 12c Client on Windows

Installing Oracle 12c Client on Windows Download the Respective Client from Oracle. Right Click on Setup of exe and run as administrator Select ‘Administrator’ at the first step of the installation. Click Next Select ‘Use Windows Built-in Account’ at this step. Select ‘Oracle Base’ & ‘ Oracle Home’ location Validating Verify summary before install Click Install Installation is done.  Please add tnsnames.ora with respective entries if required. Please also set the Oracle home/bin in the PATH variable on the System. If you like please follow and comment