foalabs

Azure Learning|Subscriptions, Management Groups,Resources Session 5 if you like please follow and comment.

Azure Learning |Cloud Computing Features|CAPex and OPex|Session 4 if you like please follow and comment

Query to find Users Logins in EBS For user sessions since auditing was enabled, run the "Signon Audit Users" concurrent request.   The following query should help in finding out previous login times if  the profile "Sign-On:Audit Level" was not enabled. 1. Log into sqlplus as the apps user. 2. Perform the following select: select to_char(creation_date,'DD-MON-YY HH:MI:SS'), disabled_flag from icx_sessions where user_id=(select user_id from fnd_user where user_name = 'SYSADMIN'); /   Notes: 1. The disabled_flag = N means the session is still active. 2. The sessions shown are from the time the icx_sessions table was last purged. 3. This query gives all the login times, not just logins that happened prior to enabling sign-on audit. Add a date filter to the where clause if you only want sessions prior to the date when sign-on audit was enabled If you like please follow and comment

How to Run Linux Commands or Shell Scripts in Background When we run a command in the terminal, it will be executed on the same terminal and we have to wait or open a new session to continue our work.  This is called running the command in the foreground or foreground process.  A background process is a process/command that is started from a terminal and runs in the background, without interaction from the user. Run a Linux Command in the Background To run a command in the background, add the ampersand symbol (&) at the end of the command: command & The shell job ID (surrounded with brackets) and process ID will be printed on the terminal: [1] 3507 You can have multiple processes running in the background at the same time. The background process will continue to write messages to the terminal from which we invoked the command. To suppress the stdout and stderr messages use the following syntax: command > /dev/null 2>&1 &  >/dev/null 2>&1 me...

How to check Heap Usage in Weblogic and Change Heap Memory Checking Heap Usage: Sign on to the Weblogic Administration Console by entering the following URL in a browser:   http://funoracle.lab:7001/console. Expand your WebLogic domain then expand Servers. Click the server you intend to monitor. Select the Monitoring tab, and the Performance sub-tab. Increasing Heap Memory As a good practice to start an Admin server with a lower JVM heap size than your other managed servers because the Admin server doesn’t require many resources. The size is set in the setDomainEnv.sh file for Linux or setDomainEnv.cmd for Windows, which is in the $DOMAIN_HOME/bin directory. Steps(Same for Admin and Managed Servers) 1. Shutdown Admin and Managed servers 2. Take a backup of setDomainEnv.sh or setDomainEnv.cmd file in case something goes wrong, you can revert the changes. 3. Open setDomainEnv file that is under the  $DOMAIN_HOME/bin directory. 4. Copy and paste the below lines in the setDom...

Azure Learning|Cloud Models| Session 3 if you like please follow and comment.

Azure Learning|Cloud Computing|Session 2 if you like please follow and comment

Azure Learning | Session1 If you like please follow and comment

Importing the Jar Signing Certificate for Oracle E-Business Suite R12 Important Definitions: adkeystore.bak - a backup copy of your previous adkeystore.dat Keystore taken before the new one is created. JavaVersionFile - The Java version used in the compilation (The JDK version on your server) adsign.txt - Used to pass arguments to the JRI during file signing. The first value within this file is your alias. adkeystore.dat - the Keystore file that is used to sign jar files on the server. Steps 1: Generate Keypair and Certificate Signing Request Note:  The alias and key size parameters are optional Valid options for the -keysize parameter are 2048, 3072 or 4096 If you do not include the -keysize parameter it will use the default 2048 bit key size. If you do not include the alias parameter it will be created using the environments $CONTEXT_NAME by default. If you wish to change the alias from the current value this must be done before running this command to create the new adkeystor...

Alert Log:Warning: VKTM detected a time drift, Time drifts can result in unexpected behavior such as time-outs. Error: The below message keeps repeating in Alert-log. Warning: VKTM detected a time drift. Time drifts can result in unexpected behavior such as time-outs. Please check the trace file for more details. SOLUTION: This problem is due to the Bug  – “TIME DRIFT DETECTED” APPEARS INTERMITTENTLY IN ALERT LOG” To fix the issue download and apply patch 11837095 as available for your release/platform or enable event 10795 at level 2. alter system set event=”10795 trace name context forever, level 2″ scope=spfile Then bounce the instance (shutdown then startup) for the event to be applied. Note: This warning can be ignored since it is harmless. If you like please follow and comment

Install and Enable Telnet Service in RHEL/Centos/OEL Install telnet service yum install telnet-server Managing Telnet Service Once telnet-server is installed we can start the telnet service with the following command. systemctl start telnet.socket To verify the status using the following command systemctl status telnet.socket To enable telnet  service after reboot well use the following command systemctl enable telnet.socket If you like please follow and comment

How to make flash work on IE or Edge with IE Compatibility With flash been ended from 1-Jan-2021, many applications using flash have stopped working the way they were built (like OEM, OBIEE, etc). The option you have to upgrade.  This method will give a workaround in IE or Edge in IE compatibility mode without upgrading. 1. Verify you have installed flash.ocx on your desktop. Typically, flash.ocx file is located in C:\Windows\System32\Macromed\Flash or C:\Windows\SysWOW64\Macromed\Flash according to your laptop OS system. 2. Edit mms.cfg from the location as a System Administrator In the case of the 64bit system, it might have mms.cfg under C:\Windows\SysWOW64\Macromed\Flash 3. Add below options into mms.cfg file. Note: AllowListUrlPattern list is an example. The URLs need to be replaced to your hosts those have Flash pages. SilentAutoUpdateEnable=0 AutoUpdateDisable=1 EOLUninstallDisable=1 EnableAllowList=1 AllowListUrlPattern=http://www.google.com/ AllowListUrlPattern=http://goo...

Shell Script Symbol Commands | Or Various Braces used in Shell Scripting If you like please follow and comment

How to call Autoinvoice Import Program (Program short name is RAXTRX) using FND_REQUEST.SUBMIT_REQUEST API Auto invoice Import Program takes the following parameters : argv[0]  program name argv[1]  parallel module name  [MAIN|PU?] argv[2]  running mode  [V|T|P] argv[3]  batch source id argv[4]  batch source name argv[5]  default date argv[6]  concatenated transaction flexfield attribute value argv[7]  transaction type id argv[8]  low bill to customer number argv[9]  high bill to customer number argv[10]  low bill to customer name argv[11] high bill to customer name argv[12] low gl date argv[13] high gl date argv[14] low ship date argv[15] high ship date argv[16] low transaction number argv[17] high transaction number argv[18] low sales order argv[19] high sales order argv[20] low invoice date argv[21] high invoice date argv[22] low ship to customer number argv[23] high ship to customer number argv[24] low ship to customer...

How To Rename Global Name for a Pluggable Database- PDB 1. Set container to PDB named TEST alter session set container=TEST; 2. Shut down and open it in restricted mode. shutdown immediate; startup open restrict; 3. Now rename the PDB alter pluggable database TEST rename global_name to fundb; 4. Validate Now show con_name; show pdbs; 5. shutdown and start in normal mode. shutdown immediate; startup; 6. Verify select name,open_mode from v$pdbs; If you like please follow and comment

How I Create SQL Baseline to fix query with an Execution Plan              I am sharing on creating SQL baseline and force query to use better execution plan (plan hash value).  I was doing today so thought to share this scenario where the query which was running fine till yesterday now suddenly running long in my EBS instance. So very important  I check the plan for a particular sqlid.  Note my DB version in 11.2.0.4 Query to check the multiple hash plans for sql id. select SQL_ID , PLAN_HASH_VALUE , sum(EXECUTIONS_DELTA) EXECUTIONS , sum(ROWS_PROCESSED_DELTA) CROWS , trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS , trunc(sum(ELAPSED_TIME_DELTA)/1000000/60)  ELA_MINS from DBA_HIST_SQLSTAT where SQL_ID in ( '6hxw283cyw0ub') --repalce sqlid with your sqlid group by SQL_ID , PLAN_HASH_VALUE order by SQL_ID, CPU_MINS I find out the best execution plan (Plan_hash_value) and force the query to use that plan. Below are the steps I did to ...