Query to find Actual Processes and Target Processes and Status of Concurrent Manager

Query To Check Concurrent Managers Status 

How to check Concurrent Manager Status 

 In oracle apps dba job below query will be helpful to work for oracle concurrent manager.

By using this query you can find status of concurrent manager, Actual Processes and Target Processes etc.

So, as oracle apps dba you can use below query. 

 

SELECT fcqv.user_concurrent_queue_name "Concurrent Manager",
         fcq.TARGET_NODE "Node",
         fcq.running_processes "ACTUAL Processes",
         fcq.max_processes "TARGET Processes",
         DECODE (fcqv.control_code,
                 'D', 'Deactivating',
                    'E', 'Deactivated',
                         'N', 'Node unavai',
                              'A', 'Activating',
                                  'X', 'Terminated',
                                      'T', 'Terminating',
                                            'V', 'Verifying',
                                     'O', 'Suspending',
                              'P', 'Suspended',
                     'Q', 'Resuming',
                 'R', 'Restarting')
            status
    FROM apps.fnd_concurrent_queues fcq, apps.fnd_concurrent_queues_vl fcqv
   WHERE fcq.concurrent_queue_id = fcqv.concurrent_queue_id
         AND fcq.running_processes = fcq.max_processes
ORDER BY fcq.max_processes DESC;

 

  You can find me on Fiverr & LinkedIn

Oracle Application TOP

How to find Application TOP

To find oracle application top you can use below Query...

Query:

SELECT variable_name,
  VALUE
   FROM fnd_env_context
  WHERE variable_name LIKE 'AP\_TOP' ESCAPE '\'
 AND concurrent_process_id =
  (SELECT MAX(concurrent_process_id) FROM fnd_env_context
  )
 ORDER BY 1;

 

Please not that you can find more important info from this "fnd_env_context" table that i have used above. 

So, I request you to check this table in details. 

If you are oracle apps dba then it will be helpful for you.

 

 You can find me on Fiverr & LinkedIn

How to know oracle database instance status | Oracle Database instance is running or not | Instance name | Instance status

This post will help you to know the status of oracle database instance. So you can find the database instance is running or not. 


After completing this post study you will get the answer of below questions.

• How to know oracle database instance status?
• Oracle Database instance is running or not
• How to find Instance name?

Run this below query:

SQL> select instance_name, STATUS, DATABASE_STATUS, TO_CHAR(startup_time, 'DD-MON-YY HH:MM:SS AM') startedate from v$instance;

Output will be like this:

INSTANCE_NAME     STATUS       DATABASE_STATUS      STARTDATE
---------------- ------------ ----------------- -----------------------------------------------------
NEW                              OPEN          ACTIVE                    24-JAN-19 10:01:15 AM


 






Note: you can use this query to get individual output.
For-example:



Run below query to know the instance name only. 

SQL> select instance_name from v$instance; 

output:            INSTANCE_NAME
                        ----------------
                         NEW

 if you have any question then feel free to comments. 

 

You can find me on Fiverr & LinkedIn

how to check cpu info in linux | cpu info in Linux | Check CPU info in Linux

This post will help you to check your cpu info in Linux. 

Use this below command and you will get all info of your cpu in linux.

$ cat /proc/cpuinfo

I'm showing to you whats happening in my system when I run it. 
Note: My system configuration is core i5 with 8GB RAM. 
====================
[appsdba@reyaz ~]$ cat /proc/cpuinfo
processor    : 0
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 0
cpu cores    : 6
apicid        : 0
initial apicid    : 0
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

processor    : 1
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 1
cpu cores    : 6
apicid        : 2
initial apicid    : 2
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

processor    : 2
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 2
cpu cores    : 6
apicid        : 4
initial apicid    : 4
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

processor    : 3
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 3
cpu cores    : 6
apicid        : 6
initial apicid    : 6
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

processor    : 4
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 4
cpu cores    : 6
apicid        : 8
initial apicid    : 8
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

processor    : 5
vendor_id    : GenuineIntel
cpu family    : 6
model        : 158
model name    : Intel(R) Core(TM) i5-8400 CPU @ 2.80GHz
stepping    : 10
microcode    : 0x96
cpu MHz        : 2801.000
cache size    : 9216 KB
physical id    : 0
siblings    : 6
core id        : 5
cpu cores    : 6
apicid        : 10
initial apicid    : 10
fpu        : yes
fpu_exception    : yes
cpuid level    : 22
wp        : yes
flags        : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc aperfmperf eagerfpu pni pclmulqdq dtes64 monitor ds_cpl vmx est tm2 ssse3 fma cx16 xtpr pdcm pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand lahf_lm abm 3dnowprefetch ida arat epb xsaveopt pln pts dtherm tpr_shadow vnmi flexpriority ept vpid fsgsbase tsc_adjust bmi1 avx2 smep bmi2 erms invpcid rdseed adx smap
bogomips    : 5609.70
clflush size    : 64
cache_alignment    : 64
address sizes    : 39 bits physical, 48 bits virtual
power management:

[appsdba@reyaz ~]$  
====================== 

 

You can find me on Fiverr & LinkedIn

How to recover a root password in linux RHEL 7 | How to reset a root password in Linux | Forget root password in RHEL 7

How to recover a root password
How to reset a root password
Forget root password




In this post we will learn how to recover a root password in RHEL 7 system. If you forgot your root password then this post will help you to recover or reset the root password. Please follow all steps as shown as below. Hope it will work for you. 


Note: Here in this post I have added all the things that I tested in my system. It worked for me when I forgot my root password. 

 
Step:01
=========
Press e on your keyboard when booting starting


Step:02
========
Use your arrow keys to move to the Linux16 line



Step:03
=======
Using your del key or your backspace key, remove rhgb quiet and replace with the following:

rd.break enforcing=0

Step:04
=======
Press Ctrl-x to start.



Step:05
=======
Remount the hard drive with read-write access:

# mount –o remount,rw /sysroot

 
Step:06
=======
Run chroot to access the system:

# chroot /sysroot

 
Step:07
=======
You can now change the root password:

# passwd

 
Step:08
=======
Type the new root password twice when prompted. If you are successful, you should see a message that reads "all authentication tokens updated successfully."

 
Type exit twice to reboot the system.

 

Step:09
=======
Log in as root and restore the SELinux label to the /etc/shadow file.

# restorecon -v /etc/shadow

Turn SELinux back to enforcing mode:

# setenforce 1


Done.

 

You can find me on Fiverr & LinkedIn

How to configure IP address in Linux | How to add an IP address in Linux | How to change IP address in Linux

How to configure IP address in Linux 
How to add an IP address in Linux 
How to change IP address in Linux





To configure an IP address or to change an IP address or to add an IP address please follow below details. 

In this post I'm showing command and images according to my system. 


Steps: 
[root@reyaz ~]# ifconfig

[root@reyaz ~]# vi /etc/sysconfig/network-scripts/p8p1
Edit as below

TYPE=Ethernet
BOOTPROTO=none
IPADDR0=192.168.20.234
PREFIX0=22
GATEWAY0=192.168.20.1
DNS1=8.8.8.8
DEFROUTE=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=no
IPV6_AUTOCONF=yes
IPV6_DEFROUTE=yes
IPV6_PEERDNS=yes
IPV6_PEERROUTES=yes
IPV6_FAILURE_FATAL=no
NAME="p8p11"
UUID=43ff9b45-9de4-4e2e-ae09-254d6bb3e060
ONBOOT=yes

save and exit

[root@reyaz ~]# systemctl restart network 

Done



At first check your ether name by using the Linux command "ifconfig"

Then open the file where all info is stored for your network (ether)
 [root@reyaz ~]# vi /etc/sysconfig/network-scripts/p8p1

Then edit "NAME" line and "IPADDR" line according to my steps and image

After that save and exit. 

Now restart your system Network.

Check again by command   "ifconfig"

Done.
  

 

You can find me on Fiverr & LinkedIn