Skip to main content

Posts

Warning Message When Creating A Keystore

  Warning Message When Creating A Keystore When we try to list the contents of the keystore, using the below command, keytool -list -v -keystore adkeystore.dat Enter keystore password: Keystore type: JKS Keystore provider: SUN Your keystore contains 1 entry Alias name: prod_apps002 Creation date: Jan 26, 2012 Entry type: PrivateKeyEntry Certificate chain length: 1 Certificate[1]: Owner: CN=PROD_apps002, OU=apps, O=apps002, C=US Issuer: CN=PROD_apps002, OU=apps, O=apps002, C=US Serial number: 4f208085 Valid from: Thu Jan 26 01:21:57 AST 2012 until: Tue Jan 16 01:21:57 AST 2052 Certificate fingerprints:          MD5:  XX: XX XX XX          SHA1:  XX: XX XX XX          SHA256:  XX: XX XX XX Signature algorithm name: SHA1withDSA Subject Public Key Algorithm: 1024-bit DSA key Version: 3 ******************************************* ******************************************* Warning: The JKS keystore...

How to install Apache using Ansible

How to install Apache using Ansible Use the powerful ansible tool to install Apache on your local machine or you can install on any remote server as well. 1. Install Ansible Modules [root@dev02 ~]# yum install ansible* Oracle Linux 8 EPEL Packages for Development (x86_64)                                                                                                             1.5 kB/s | 2.5 kB     00:01 Oracle Linux 8 Gluster Appstream (x86_64)                                                                        ...

How to Setup OCI CLI on Linux

How to Setup OCI CLI on Linux This blog shows how to setup OCI CLI on Linux [root@dev02 ~]# oci setup config     This command provides a walkthrough of creating a valid CLI config file.     The following links explain where to find the information required by this     script:     User API Signing Key, OCID and Tenancy OCID:         https://docs.cloud.oracle.com/Content/API/Concepts/apisigningkey.htm#Other     Region:         https://docs.cloud.oracle.com/Content/General/Concepts/regions.htm     General config documentation:         https://docs.cloud.oracle.com/Content/API/Concepts/sdkconfig.htm Enter a location for your config [/root/.oci/config]: Enter a user OCID: ocid1.user.oc1..adfdaaaaq54tehkijdffd2gpshbfgfsfgfgfgfp98dfdfdfdfjwrolhmq7bq Enter a tenancy OCID: ocid1.tenancy.oc1..aaaaaaaaefb4u5ccdfdfsdfd87d89000901adfdfb2cgqfte2dosmdd5o2q ...

How to Install OCI CLI on Linux

How to Install OCI CLI on Linux To install the OCL CLI on Linux Open a terminal. To run the installer script, run the following command. [root@dev02 ~]# bash -c "$(curl -L https://raw.githubusercontent.com/oracle/oci-cli/master/scripts/install/install.sh)"   % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current                                  Dload  Upload   Total   Spent    Left  Speed 100 14867  100 14867    0     0   8588      0  0:00:01  0:00:01 --:--:--  8583     ******************************************************************************     You have started the OCI CLI Installer in interactive mode. If you do not wish     to run this in interact...
How to create Yum respository in RHEL 7 This blog shows the various steps needed to create a Yum repository in RHEL 7 1. Mount the ISO CD to your server 2. Navigate to the Packages directory under the ISO CD [root@dev1 RHEL-7.3 Server.x86_64]# pwd /run/media/root/RHEL-7.3 Server.x86_64 [root@dev1 RHEL-7.3 Server.x86_64]# ls -ltr total 894 -r--r--r--.  1 root root  18092 Mar  6  2012 GPL -r--r--r--.  1 root root   8266 Apr  4  2014 EULA -r--r--r--.  1 root root   3211 Sep 27  2016 RPM-GPG-KEY-redhat-release -r--r--r--.  1 root root   3375 Sep 27  2016 RPM-GPG-KEY-redhat-beta -r--r--r--.  1 root root    114 Oct 19  2016 media.repo -r--r--r--.  1 root root   1568 Oct 19  2016 TRANS.TBL dr-xr-xr-x.  2 root root   4096 Oct 19  2016 repodata dr-xr-xr-x. 24 root root   6144 Oct 19  2016 release-notes dr-xr-xr-x....

How to Gather Table Statistics in Oracle E-Business Suite

How to Gather Table Statistics in Oracle E-Business Suite To gather Table level statistics in Oracle E-Business Suite, we can use the FND_STATS package. exec fnd_stats.GATHER_TABLE_STATS( OWNNAME => 'INV', TABNAME=> 'MTL_ONHAND_QUANTITIES_DETAIL', PERCENT => 40, DEGREE => 4 ); where , the parameter are as below: OWNNAME --> Schema owning the table TABNAME  --> Name of the Table to be analyzed PERCENT --> % of the data to be analyzed DEGREE --> Degree of parallelism.  --- 

Create Listener in Silent Mode

Create Listener in Silent Mode To create a listener in silent mode, please follow the below steps: $ netca -silent -responseFile /u01/app/oracle/product/12.1.0.2/db_1/assistants/netca/netca.rsp Parsing command line arguments:     Parameter "silent" = true     Parameter "responsefile" = /u01/app/oracle/product/12.1.0.2/db_1/assistants/netca/netca.rsp Done parsing command line arguments. Oracle Net Services Configuration: Profile configuration complete. Oracle Net Listener Startup:     Running Listener Control:       /u01/app/oracle/product/12.1.0.2/db_1/bin/lsnrctl start LISTENER     Listener Control complete.     Listener started successfully. Listener configuration complete. Oracle Net Services configuration successful. The exit code is 0

Create Database in Silent Mode

Create Database in Silent Mode After the Oracle Home is relinked, we have to create the Database using dbca However there are some issues with the Graphics Display or there is no graphics terminal available. In this case, we plan to create the database using silent mode. 1. Set up the Environment variables. ORACLE_HOME PATH mkdir -p /u01/app/oracle/oradata 2. Use DBCA to create the database dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName ORCLDEV.channels.com.sa -sid ORCLDEV -sysPassword sys -systemPassword oracle123 -emConfiguration NONE -datafileDestination /u01/app/oracle/oradata -storageType FS -characterSet AL32UTF8 Copying database files 1% complete 3% complete 37% complete Creating and starting Oracle instance 40% complete 45% complete 50% complete 55% complete 56% complete 60% complete 62% complete Completing Database Creation 66% complete 70% complete 73% complete 85% complete 96% complete 100% complete Look at the ...

Converting RAC Home Binaries to Non RAC

To turn off RAC $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk rac_off rm -f /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxp12.so cp /u01/app/oracle/product/12.1.0.2/db_1/lib//libskgxpg.so /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxp12.so rm -f /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxn2.so cp /u01/app/oracle/product/12.1.0.2/db_1/lib//libskgxns.so \       /u01/app/oracle/product/12.1.0.2/db_1/lib/libskgxn2.so /usr/bin/ar d /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/libknlopt.a kcsm.o /usr/bin/ar cr /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/libknlopt.a /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/ksnkcs.o # Relink Oracle $ make -f  ins_rdbms.mk  ioracle chmod 755 /u01/app/oracle/product/12.1.0.2/db_1/bin  - Linking Oracle rm -f /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/oracle /u01/app/oracle/product/12.1.0.2/db_1/bin/orald  -o /u01/app/oracle/product/12.1.0.2/db_1/rdbms/lib/oracle -m64 -z...

Patch 26834480: adgrants.sql execution gives WARNINGS

Patch 26834480: adgrants.sql execution gives WARNINGS For the patch 26834480, we have to run the adgrants.sql , after comparing the highest version of this file present in $APPL_TOP/admin and the patch directory.  The highest version of adgrants.sql has to be copied to database home  $ORACLE_HOME/appsutil/admin directory The script will give the necessary grants and permissions and in the end, it will show warnings. SQL> @adgrants.sql apps Connected. . . . . ........... ......... The following ERRORS and WARNINGS have been encountered during this adgrants session: TIME_STAMP           SESSION_ID LOG_MODULE                                 LOG_LEVEL -------------------- ---------- ------------------------------------------ ---------- LOG_MESSAGE -----------------------------------------------------------------------------------------...

How to check OCR keys using OCRDUMP on RAC 12c

How to check OCR keys using OCRDUMP on RAC 12c To check the OCR keys values using ocrdump utility, please run below command: /u01/app/12.1.0/grid/bin/ocrdump.bin -stdout -keyname SYSTEM.version.hostnames [SYSTEM.version.hostnames] UNDEF : SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node1] ORATEXT : 12.1.0.2.0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node1.patchlevel] UB4 (10) : 0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME : root, GROUP_NAME : root} [SYSTEM.version.hostnames.rac_node2] ORATEXT : 12.1.0.2.0 SECURITY : {USER_PERMISSION : PROCR_ALL_ACCESS, GROUP_PERMISSION : PROCR_READ, OTHER_PERMISSION : PROCR_READ, USER_NAME :...

Health Check Script

Oracle Database Health Check Script Run this script has sysdba user or any user having DBA Role Change the spool file patch to correct directory. In this example it is set to  /export/home/oraprod/ $ cat Health_Check_Script.sql set pagesize 1100 SET MARKUP HTML ON SPOOL ON spool /export/home/oraprod/health_check_new.html set feedback off set linesize 200; set pages 50 set lines 1000 set pages 70 set heading on PROMPT================================================================ prompt PROMPT PROMPT Daily_Monitoring Checkup Report prompt ================================================================================================================================================= PROMPT REPORT DATE select to_char(sysdate,'DD-MON-YYYY:HH:MI:SS') "Report Run Date" from dual; prompt DATABASE NAME PROMPT ============== select instance_name,host_name,version,status from gv$instance ,v$database a; PROMPT DATABASE INFO PROMPT =============...