foalabs

How to Copy Table stats from one database to another database If we want to migrate the stats from One database to other database, we can follow below steps. 1) Create a stat table in the source database. The statistics table is created in APPS schema. connect as APPS exec dbms_stats.create_stat_table(ownname => 'APPS', stattab => 'STAT_TAB'); select * from tab where TNAME='STAT_TAB'; TNAME TABTYPE CLUSTERID ------------------------------ ------- ---------- STAT_TAB TABLE 2) Export the table statistics. exec dbms_stats.export_table_stats(ownname=>'INV',tabname=>'MTL_SYSTEM_ITEMS_TL',statown=>'APPS',stattab=>'STAT_TAB',cascade=>TRUE); 3) Then take export backup of table STAT_TAB from schema APPS. COPY the dump file to target server. I did on shared path. RESTORE_DIR /oracle/stage/RESTORE_DIR  cat > exp_stat.ctl userid=APPS/apps  directory=DATA_PUMP_DIR  tables=STAT_TAB  dumpfile=exp_stat.dmp  LOGFILE=exp_s...

ERROR : Timed out( 100000 ): Interrupted Exception Oracle Apps EBS 12.2 When starting Application Server 10g services with EBusiness Suite Release 12, if the server is heavily loaded you may sometimes receive a timeout message from one or more startup scripts called by adstrtal.sh Forms Oacore Oafm Solution: Change below entry in file and Start. Before:- [applmgr@funebs122 scripts]$ grep "start timeout" /u01/applmgr/PROD/fs2/EBSapps/10.1.2/opmn/conf/opmn.xml <start timeout=”600″/> <start timeout=”600″ retry=”2″/> <restart timeout=”720″ retry=”2″/> After:- [applmgr@funebs122 conf]$ grep "start timeout" /u01/applmgr/PROD/fs2/EBSapps/10.1.2/opmn/conf/opmn.xml <start timeout=”1800″/> <start timeout=”1800″ retry=”2″/> <restart timeout=”720″ retry=”2″/> If you like please follow and comment

Query to find the session locking an object in Oracle Database Query: select    c.owner,    c.object_name,    c.object_type,    b.sid,    b.serial#,    b.status,    b.osuser,    b.machine from     v$locked_object a ,    v$session b,    dba_objects c where    b.sid = a.session_id    and     a.object_id = c.object_id    and c.object_name='OE_ORDER_HEADERS_ALL' If you like please follow and comment

Launching an Oracle Apps Forms in Linux Mint  In this post I am going to share how to open Oracle EBS forms in Linux Mint. Note:   The EBS should be JWS enabled to make it work. 1) Remove any other version installed. sudo apt remove openjdk -11 -jdk-headless sudo apt remove jdk -11.0 .9 #(installed this manually in a distant past apparently) sudo apt remove openjdk -8 -jre-headless 2) Install  Open JDK 8 sudo apt install openjdk-8-jre sudo apt install openjdk-8-jre-headless 3) Verify Version himanshu@himanshu-LIFEBOOK-A555:~/Downloads$ java -version openjdk version "1.8.0_312" OpenJDK Runtime Environment (build 1.8.0_312-8u312-b07-0ubuntu1~20.04-b07) OpenJDK 64-Bit Server VM (build 25.312-b07, mixed mode) 4) Install package for JAVA Web Start(javaws) sudo apt install icedtea* himanshu@himanshu-LIFEBOOK-A555:/usr/lib/jvm/java-8-openjdk-amd64$ javaws --version selected jre: /usr/lib/jvm/java-8-openjdk-amd64 icedtea-web 1.8 (1.8) 5) If you see below error then ...

Make  Bootable Windows 7 USB on Linux OS using Command Line Plugin the USB Drive Most modern Linux distributions should automount the USB drive. If not, you can see what device ID is assigned to the USB drive by running df -h or mount or lsblk. Additionally, syslog can be monitored to find the device ID. On Fedora, CentOS, or RHEL, run sudo tail -f /var/log/messages. On Ubuntu or Debian, run sudo tail -f /var/log/syslog. Once you figure out the USB drive’s device ID, be sure to unmount it before continuing: sudo umount /dev/sdX Partition the USB Drive Disclaimer:  The following steps will  erase  everything on your USB drive. I am not, nor is anyone else, responsible for any potential data loss. Either parted or fdisk can be used to partition the USB drive. Use the command you are more familiar with. Changes made using parted  cannot  be reverted because they are executed in real time to the device...

Errors while applying 12.2.11 RUP Patch (31856789) in Oracle E-Business Suite 12.2 $adop phase=apply apply_mode=downtime patches=31856789 abandon=no restart=yes Enter the APPS password: Enter the SYSTEM password: Enter the WLSADMIN password: Validating credentials. Initializing.     Run Edition context  : /orapps122/FUAT/fs1/inst/apps/PHASE1_***test/appl/admin/PHASE1_acetest.xml     Patch edition context: /orapps122/FUAT/fs2/inst/apps/PHASE1_***test/appl/admin/PHASE1_acetest.xml *******FATAL ERROR******* PROGRAM : (/orapps122/FUAT/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl) TIME    : Thu Aug  6 10:34:36 2020 FUNCTION: ADOP::GlobalVars::_GetMandatoryArgs [ Level 1 ] ERRORMSG: Cannot identify any valid application tier nodes in           ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes. [STATEMENT] Please run adopscanlog utility, using the command "adopscanlog -latest=yes" to get the list of the log files ...

LFTP Fatal error: Host key verification failed error My Concurent programs which pull ftp data started failing when trying to connect to a server using the sftp protocol with LFTP, you receive the error "Fatal error: Host key verification failed". IP: 10.10.10.1 or  Hostname : ftp.funebs122.lab $ lftp sftp://user@10.10.10.1:22 Password:  lftp user@10.10.10.1:~> ls ls: Fatal error: Host key verification failed The cause of the problem is the missing RSA key fingerprint in the list of known hosts. To fix it, it's enough to try to connect to the SFTP server using the ssh command: $ ssh -p 22 user@10.10.10.1 @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @    WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!     @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that a host key has j...

Enabling SSH2 Protocol # grep Protocol /etc/ssh/sshd_config #Protocol 2,1 Uncomment  and make below changes   # grep Protocol /etc/ssh/sshd_config Protocol 2 Restart SSHD services: service sshd restart   SSH Protocol Test: Before: nmap -sV -p22 hostname Test connection via putty ssh  protocol 1 After: moving to SSH PROTOCOL 2 Now when we test from putty ssh1 protocol If you like please follow and comment

Important Queries related to SOA-INFRA Query to fetch and tabulate the number of instances in various states SELECT (CASE WHEN STATE=1 THEN 'OPEN AND RUNNING' WHEN STATE=2 THEN 'OPEN AND SUSPENDED' WHEN STATE=3 THEN 'OPEN AND FAULTED' WHEN STATE=4 THEN 'CLOSED AND PENDING' WHEN STATE=5 THEN 'CLOSED AND COMPLETED' WHEN STATE=6 THEN 'CLOSED AND FAUTED' WHEN STATE=7 THEN 'CLOSED AND CANCELLED' WHEN STATE=8 THEN 'CLOSED AND ABORTED' WHEN STATE=9 THEN 'CLOSED AND STALE' WHEN STATE=10 THEN 'NON-RECOVERABLE' ELSE STATE || '' END) AS STATE,COMPOSITE_NAME, COUNT(*) AS NUM_OF_CUBE_INST FROM SOA_SOAINFRA.CUBE_INSTANCE GROUP BY STATE,COMPOSITE_NAME ORDER BY 3 DESC; Query to find the count of the instances of particular Composites created on particular time    SELECT     * FROM     (         SELECT             COUNT(composite_name) count,             composite_name       ...

Composite Instance States in SOA-INFRA Find composite instances in various states in the  CUBE_INSTANCE  table. The table below shows the various State Value for composite instances in the CUBE_INSTANCE table of the  SOA_INFRA  schema in the  dehydration store . STATE VALUE STATE STATE MEANING 0 INITIATED State value for an instance that has just been created. The instance will only have this value as its state after it has been created by the process domain. 1 OPEN AND RUNNING State value for an instance that has been created and has active activities executing. The instance is not in an exception or error condition. 2 OPEN AND SUSPENDED State value for an instance that is unavailable. Performers of any of the activities that belong to this instance cannot take any action until the instance has returned to the running state. 3 OPEN AND FAULTED State value for an instance that has an activity that has thrown an exception. When an activity throws an exception, th...