foalabs

Configuring Office365 cloud server for Notification Mailer Inbound and Outbound The Office365 cloud server SMTP and IMAP services can be used for Workflow Notification Mailer Outbound and Inbound configuration. This blog explains the SMTP/IMAP server configuration, SSL certificate installation in Concurrent Tier and configuring Office365 IMAP and SMTP servers for Workflow Notification Mailer Inbound and Outbound. 1. Configure Mailer Outbound/Inbound with Office365 servers Mailer Outbound and Inbound can be configured with Office365 SMTP and IMAP servers using below configuration details. SMTP server   Server smtp.office365.com Port 587 Protocol TLS(startTLS) User Name User name on Office365 server along  with email address Password Password for the account used above IMAP server  Server outlook.office365.com Port 993 Protocol SSL User Name User name on Office365 server along with email address Password Password for the account used above 2. Apply the W...

Positional Parameters in Shell Script Positional Parameters   are used to pass the information to the shell directly with command line argument or indirectly using set and command substitution. It can be assigned from shell argument and it is denoted by $N, where N is the single digit and referred as parameter N. if N is double digit use braces ${N}. Command Line Argument for positional Parameters You can pass many arguments in command line. For Example we run a script script.sh with 10 argument a to j $ ./script.sh a b c d e f g h i j Now the detail of output we get from positional parameters $0  is the name of script          ./script.sh $1  is the first parameter passed.         a $2  is second parameter passed.         b ${10}  is the 10 parameter passed, use bracket for double digit         j if no bracket is used i.e.  $10  then the output is      ...

Explaining the IT Process with which DBA/Apps DBA Work in Real Time If you like please follow and comment

SQL Query  to retrieve the name and location of the latest Notification Mailer log file in EBS Query: SELECT logfile_name  FROM fnd_concurrent_processes    WHERE process_status_code = 'A'  AND concurrent_queue_id in  (SELECT concurrent_queue_id from fnd_concurrent_queues  WHERE concurrent_queue_name in ( 'WFMLRSVC')); If you like please follow and comment

How to set JVM arguments in WebLogic 12c Steps to set Custom arguments to set in Weblogic JVM In the Domain Structure pane, expand the Servers node. Click the name of the server that you want to configure. In the right pane, click Server Start. Select Lock & Edit. In the Arguments text box, provide the JVM options. After inserting your options, click Save. Restart the server so that the new settings are used. If you like please follow and comment

How to find  SOA 12c version  We use the command line script  soaversion.sh located under $ORACLE_HOME/soa/bin $ ./soaversion.sh ************************************************************** INFO: Detected a WebLogic Installation. ************************************************************** Oracle SOA Suite Version Information: ------------------------------------- Product Version : 12.2.1.0.0-151013.0700.0085 Label Version   : PCBPEL_12.2.1.0.0_GENERIC_151013.0700.0085 Compile JDK     : 1.8.0_40-ea Java Home       : /d01/oracle/middleware/jdk1.8.0_77 Runtime JDK Version java version "1.8.0_77" Java(TM) SE Runtime Environment (build 1.8.0_77-b03) Java HotSpot(TM) 64-Bit Server VM (build 25.77-b03, mixed mode) If you like please follow and comment

Important Printing related Commands in AIX TERMS: print job                A print job is a unit of work to be run on a printer. The system assigns a unique job number to it. queue                    It is where a print job is directed. (It is a stanza in the /etc/qconfig file.) queue device              The stanza in the /etc/qconfig. It specifies the /dev file (printer device) that should be used. qdaemon                   It runs in the background and controls the queues. print spooler             A spooler does not normally know what type of job it is queuing. It provides spooling function for any type of jobs. printer backend           It is a collection of programs called by the spooler's qdaemon command to manage a print job.        It re...

How to Enable/Disable JSSE in Weblogic Server in 11g/12c JSSE Advantages SHA-2 signed certificates are supported in the JSSE SSL implementation provided in WebLogic Server. The JSSE-based implementation supports TLS V1.0, TLS V1.1, and TLS V1.2. Also to enable support for the TLS V1.1 and TLS V1.2 protocols, WebLogic Server must be running with JDK 7. Note Latest Version JDK 1.6 also supports these TLS version How to enable JSSE in Weblogic Server (1) Login to Weblogic Console (2) Click on Lock and Edit (3) Navigate to Environment > Servers and select the server where you want to change it (4) Now go to the SSL tab and then go to the advanced section and click on JSSE enabled (5) Save the changes and release the configuration (6) You can restart the Managed server and it will start using JSSE An alternative way to enable JSSE You can also enable JSSE by settings these parameters in JAVA_OPTIONS.   -Dweblogic.ssl.JSSEEnabled=true   -Dweblogic.security.SSL.enableJSS...

Shell script to Backup/Maintain and Purge Log Files in Linux In this post, I am going to share a script to the daily backup log file and keep old ones for 7 days and then purge them. You can change based on requirements. Script: #!/bin/bash ############################################################## #Script to Manage, Backup and Purge Log Files #Author          Version                  Date #======== ========= ========== #Himanshu 1.0 9-SEP-2021 ############################################################### v_date=`date +%F` cd /u01/oracle/appldev/10.1.2/webcache/logs cp -p access_log  access_log_${v_date} cat /dev/null > access_log cp -p event_log  event_log_${v_date} cat /dev/null > event_log find /u01/oracle/appldev/10.1.2/webcache/logs -type f -name "access_log_*" -mtime +7 -exec rm {} \; find /u01/oracle/appldev/10.1.2/webcache/logs -type f -name "event_log_*" -mtime +7 -exec...

Import Certificate in Oracle OPSS Keystore Service(KSS) OPSS Keystore Service provides an alternate mechanism to manage keys and certificates for message security. The OPSS Keystore Service makes using certificates and keys easier by providing central management and storage of keys and certificates for all servers in a domain. You use the OPSS Keystore Service to create and maintain keystores of type KSS. In SOA 12c, OPSS is configured to use the database instead of the file system by default. Now every time an Expanded, Compact or Integrated Domain is created, the following settings will be seen in the Keystore tab. The above KSS (Key Store Service) nomenclature indicates that the Keystore is being handled within OPSS rather than the standard Java Keytool. So in order to import a certificate, you have to: 1. Download the certificate which has the entire chain. 2. Log in to Fusion Middleware Control (EM). 3. From the navigation pane, locate the domain i.e "SOA Domain" 4. Na...

How to see users Contained in Group Name in Linux If we want to find users contained in group named ‘dba’: # lid -g dba Note:  This will need root privilege or sudo access to execute. If you like please follow and comment

How to Download the SSL Certificate from a Weburl on Linux Many times we come across SSL websites that had certificates. We might need to deploy certificates in our wallets, Keystore, etc. We can directly download those certificates from the URL on Linux server. Let's says we want to download amazon.in cert use below command $ true | openssl s_client -connect amazon.in:443 2>/dev/null | openssl x509 [himanshu@oel7server tmp]$ true | openssl s_client -connect amazon.in:443 2>/dev/null | openssl x509 -----BEGIN CERTIFICATE----- MIIGlzCCBX+gAwIBAgIQCAQS8j7FlS+HLCsnKEkPGzANBgkqhkiG9w0BAQsFADBG MQswCQYDVQQGEwJVUzEPMA0GA1UEChMGQW1hem9uMRUwEwYDVQQLEwxTZXJ2ZXIg Q0EgMUIxDzANBgNVBAMTBkFtYXpvbjAeFw0yMTA3MTkwMDAwMDBaFw0yMjA3MTMy MzU5NTlaMBsxGTAXBgNVBAMMECouY3kucGVnLmEyei5jb20wggEiMA0GCSqGSIb3 DQEBAQUAA4IBDwAwggEKAoIBAQDKrYzNvrrL8Ik7C7mi6lfEtfSnIqzvuMUrGajD QG/pUVkvF0EdZAMW+uwt9Sy19HalO2UWYZu8Y/uYtWa4TCV2+kSFZ1PVjMnojSf3 ugWmMLV71nc8ZJ1YHZopLMeFeVcTOHn386wXDKNcevrfAEtAx1c2+9Xhl+snrIP/ eHa...