ADEEB ORACLE DBA,RAC & APPS DBA Blog

Thursday, October 24, 2019

alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger

R12.2 Adcfgclone.pl Configuring Run File System Error: Failed to enable EBS_LOGON trigger

Issue

Enter the APPS password : Enter the APPS password : Error while executing /u01/oracle/erpdev/fs2/EBSapps/comn/clone/bin/alter_ebs_logon_trigger.sql

alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger

update context_file

context value == s_update_scan -====> TRUE(For Rac Only)

Run autoconfig

[oraprod@pansoft ERPDEV_pansoft]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:24:32 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter user sys identified by welcome1;

User altered.

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:29:21 201

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter service;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

service_names string ERPDEV, ebs_patch,ERPDEV_ebs_p

atch

SQL> alter system set service_names='ERPDEV','ebs_patch' scope=both;

System altered.

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraprod@pansoft ERPDEV_pansoft]$ lsnrctl reload ERPDEV

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-JUL-2019 16:30:33

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=panosft.dba.com)(PORT=1541)))

The command completed successfully

[oraprod@pansoft ERPDEV_pansoft]$ lsnrctl status ERPDEV

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 31-JUL-2019 16:30:35

Copyright (c) 1991, 2014, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=panosft.dba.com)(PORT=1541)))

STATUS of the LISTENER

------------------------

Alias ERPDEV

Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production

Start Date 31-JUL-2019 16:21:10

Uptime 0 days 0 hr. 9 min. 24 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/ERPDEV_pansoft/listener.ora

Listener Log File /u01/app/oracle/product/12.1.0/dbhome_1/admin/ERPDEV_pansoft/diag/tnslsnr/pansoft/erpdev/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=panosft.dba.com)(PORT=1541)))

Services Summary...

Service "ERPDEV" has 2 instance(s).

Instance "ERPDEV", status UNKNOWN, has 1 handler(s) for this service...

Instance "ERPDEV", status READY, has 1 handler(s) for this service...

Service "ebs_patch" has 1 instance(s).

Instance "ERPDEV", status READY, has 1 handler(s) for this service...

The command completed successfully

[oraprod@pansoft ERPDEV_pansoft]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Wed Jul 31 16:30:37 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Connected to:

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> show parameter local_;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

_local_communication_costing_enabled boolean TRUE

local_listener string ERPDEV_LOCAL

SQL>

SQL>

SQL>

SQL>

SQL>

SQL> exit

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oraprod@pansoft ERPDEV_pansoft]$

[oraprod@pansoft ERPDEV_pansoft]$

[oraprod@pansoft ERPDEV_pansoft]$ exit

logout

[root@pansoft ERPDEV_pansoft]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \

> compat-libcap1 \

> compat-libstdc++-33 \

> elfutils-libelf \

> elfutils-libelf-devel \

> gcc \

> gcc-c++ \

> glibc \

> glibc-common \

> glibc-devel \

> glibc-headers \

> ksh \

> libaio \

> libaio-devel \

> libgcc \

> libstdc++ \

> libstdc++-devel \

> make \

> libXext \

> libXtst \

> libX11 \

> libXau \

> libxcb \

> libXi \

> libXp \

> libaio \

> sysstat \

> unixODBC \

> unixODBC-devel \

> openmotif21 \

> xorg-x11-utils \

> libXrender \

> perl \

> gdbm \

> libgomp \

> redhat-lsb \

> util-linux \

> sysstat \

> xorg-x11-libs-compat \

> perl-File-CheckTree

binutils-2.27-34.base.el7(x86_64)

compat-libcap1-1.10-7.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(i686)

elfutils-libelf-0.172-2.el7(x86_64)

package elfutils-libelf-devel is not installed

gcc-4.8.5-36.el7_6.2(x86_64)

gcc-c++-4.8.5-36.el7_6.2(x86_64)

glibc-2.17-260.el7_6.5(x86_64)

glibc-2.17-260.el7_6.5(i686)

glibc-common-2.17-260.el7_6.5(x86_64)

glibc-devel-2.17-260.el7_6.5(x86_64)

glibc-devel-2.17-260.el7_6.5(i686)

glibc-headers-2.17-260.el7_6.5(x86_64)

ksh-20120801-139.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

package libaio-devel is not installed

libgcc-4.8.5-36.el7_6.2(x86_64)

libgcc-4.8.5-36.el7_6.2(i686)

libstdc++-4.8.5-36.el7_6.2(x86_64)

libstdc++-4.8.5-36.el7_6.2(i686)

libstdc++-devel-4.8.5-36.el7_6.2(x86_64)

libstdc++-devel-4.8.5-36.el7_6.2(i686)

make-3.82-23.el7(x86_64)

libXext-1.3.3-3.el7(i686)

libXext-1.3.3-3.el7(x86_64)

libXtst-1.2.3-1.el7(x86_64)

libXtst-1.2.3-1.el7(i686)

libX11-1.6.5-2.el7(x86_64)

libX11-1.6.5-2.el7(i686)

libXau-1.0.8-2.1.el7(x86_64)

libXau-1.0.8-2.1.el7(i686)

libxcb-1.13-1.el7(x86_64)

libxcb-1.13-1.el7(i686)

libXi-1.7.9-1.el7(x86_64)

libXi-1.7.9-1.el7(i686)

libXp-1.0.2-2.1.el7(i686)

libXp-1.0.2-2.1.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

sysstat-10.1.5-4.el7(x86_64)

package unixODBC is not installed

package unixODBC-devel is not installed

openmotif21-2.1.30-11.el7(i686)

xorg-x11-utils-7.5-23.el7(x86_64)

libXrender-0.9.10-1.el7(x86_64)

libXrender-0.9.10-1.el7(i686)

perl-5.16.3-294.el7_6(x86_64)

gdbm-1.10-8.el7(x86_64)

gdbm-1.10-8.el7(i686)

libgomp-4.8.5-36.el7_6.2(x86_64)

redhat-lsb-4.1-27.0.1.el7(x86_64)

util-linux-2.23.2-59.el7_6.1(x86_64)

sysstat-10.1.5-4.el7(x86_64)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1(i386)

perl-File-CheckTree-4.42-3.el7(noarch)

[root@pansoft ERPDEV_pansoft]# yum install elfutils*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms | 2.1 kB 00:00:00

rhel-7-server-rpms | 2.0 kB 00:00:00

Package elfutils-libs-0.172-2.el7.x86_64 already installed and latest version

Package elfutils-0.172-2.el7.x86_64 already installed and latest version

Package elfutils-default-yama-scope-0.172-2.el7.noarch already installed and latest version

Package elfutils-libelf-0.172-2.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package elfutils-devel.x86_64 0:0.172-2.el7 will be installed

--> Processing Dependency: pkgconfig(liblzma) for package: elfutils-devel-0.172-2.el7.x86_64

---> Package elfutils-libelf-devel.x86_64 0:0.172-2.el7 will be installed

--> Running transaction check

---> Package xz-devel.x86_64 0:5.2.2-1.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================

Package Arch Version Repository Size

================================================================================================================================

Installing:

elfutils-devel x86_64 0.172-2.el7 rhel-7-server-rpms 87 k

elfutils-libelf-devel x86_64 0.172-2.el7 rhel-7-server-rpms 39 k

Installing for dependencies:

xz-devel x86_64 5.2.2-1.el7 rhel-7-server-rpms 46 k

Transaction Summary

================================================================================================================================

Install 2 Packages (+1 Dependent package)

Total download size: 172 k

Installed size: 496 k

Is this ok [y/d/N]: Y

Downloading packages:

(1/3): elfutils-devel-0.172-2.el7.x86_64.rpm | 87 kB 00:00:00

(2/3): elfutils-libelf-devel-0.172-2.el7.x86_64.rpm | 39 kB 00:00:00

(3/3): xz-devel-5.2.2-1.el7.x86_64.rpm | 46 kB 00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total 775 kB/s | 172 kB 00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : xz-devel-5.2.2-1.el7.x86_64 1/3

Installing : elfutils-libelf-devel-0.172-2.el7.x86_64 2/3

Installing : elfutils-devel-0.172-2.el7.x86_64 3/3

Uploading Package Profile

Verifying : elfutils-libelf-devel-0.172-2.el7.x86_64 1/3

Verifying : xz-devel-5.2.2-1.el7.x86_64 2/3

Verifying : elfutils-devel-0.172-2.el7.x86_64 3/3

Installed:

elfutils-devel.x86_64 0:0.172-2.el7 elfutils-libelf-devel.x86_64 0:0.172-2.el7

Dependency Installed:

xz-devel.x86_64 0:5.2.2-1.el7

Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install libaio-devel

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms | 2.1 kB 00:00:00

rhel-7-server-rpms | 2.0 kB 00:00:00

Resolving Dependencies

--> Running transaction check

---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================

Package Arch Version Repository Size

================================================================================================================================

Installing:

libaio-devel x86_64 0.3.109-13.el7 rhel-7-server-rpms 13 k

Transaction Summary

================================================================================================================================

Install 1 Package

Total download size: 13 k

Installed size: 7.8 k

Is this ok [y/d/N]: Y

Downloading packages:

libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : libaio-devel-0.3.109-13.el7.x86_64 1/1

Uploading Package Profile

Verifying : libaio-devel-0.3.109-13.el7.x86_64 1/1

Installed:

libaio-devel.x86_64 0:0.3.109-13.el7

Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install compat-libstdc*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms | 2.1 kB 00:00:00

rhel-7-server-rpms | 2.0 kB 00:00:00

Nothing to do

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install compat*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms | 2.1 kB 00:00:00

rhel-7-server-rpms | 2.0 kB 00:00:00

Package compat-db-headers-4.7.25-28.el7.noarch already installed and latest version

Package compat-cheese314-3.14.2-1.el7.x86_64 already installed and latest version

Package compat-libtiff3-3.9.4-11.el7.x86_64 already installed and latest version

Package 1:compat-glibc-headers-2.12-4.el7.x86_64 already installed and latest version

Package compat-db47-4.7.25-28.el7.x86_64 already installed and latest version

Package compat-libical1-1.0.1-2.el7.x86_64 already installed and latest version

Package 1:compat-glibc-2.12-4.el7.x86_64 already installed and latest version

Package compat-libgfortran-41-4.1.2-44.el7.x86_64 already installed and latest version

Package 1:compat-openldap-2.3.43-5.el7.x86_64 already installed and latest version

Package compat-libf2c-34-3.4.6-32.el7.x86_64 already installed and latest version

Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version

Resolving Dependencies

--> Running transaction check

---> Package compat-dapl.x86_64 1:1.2.19-4.el7 will be installed

---> Package compat-exiv2-023.x86_64 0:0.23-2.el7 will be installed

---> Package compat-gcc-44.x86_64 0:4.4.7-8.el7 will be installed

---> Package compat-gcc-44-c++.x86_64 0:4.4.7-8.el7 will be installed

---> Package compat-glade315.x86_64 0:3.15.0-1.el7 will be installed

---> Package compat-gnome-desktop314.x86_64 0:3.14.2-1.el7 will be installed

---> Package compat-grilo02.x86_64 0:0.2.12-1.el7 will be installed

---> Package compat-libcogl-pango12.x86_64 0:1.14.0-3.el7 will be installed

---> Package compat-libcogl12.x86_64 0:1.14.0-3.el7 will be installed

---> Package compat-libcolord1.x86_64 0:1.0.4-1.el7 will be installed

---> Package compat-libgdata13.x86_64 0:0.13.3-1.el7 will be installed

---> Package compat-libgnome-bluetooth11.x86_64 1:3.8.2.1-2.el7 will be installed

---> Package compat-libgnome-desktop3-7.x86_64 0:3.8.4-2.el7 will be installed

---> Package compat-libgweather3.x86_64 0:3.8.2-1.el7 will be installed

---> Package compat-libmediaart0.x86_64 0:0.7.0-1.el7 will be installed

---> Package compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7 will be installed

---> Package compat-libupower-glib1.x86_64 0:0.9.20-1.el7 will be installed

---> Package compat-libxcb.x86_64 0:1.9-1.el7 will be installed

---> Package compat-openmpi16.x86_64 0:1.6.4-10.7.el7 will be installed

--> Processing Dependency: environment-modules for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libpsm_infinipath.so.1()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libosmcomp.so.3()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libhwloc.so.5()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

--> Processing Dependency: libesmtp.so.6()(64bit) for package: compat-openmpi16-1.6.4-10.7.el7.x86_64

---> Package compat-opensm-libs.x86_64 0:3.3.15-2.el7 will be installed

--> Processing Dependency: libibumad.so.3(IBUMAD_1.0)(64bit) for package: compat-opensm-libs-3.3.15-2.el7.x86_64

--> Processing Dependency: libibumad.so.3()(64bit) for package: compat-opensm-libs-3.3.15-2.el7.x86_64

---> Package compat-poppler022.x86_64 0:0.22.5-4.el7 will be installed

---> Package compat-poppler022-glib.x86_64 0:0.22.5-4.el7 will be installed

---> Package compat-poppler022-qt.x86_64 0:0.22.5-4.el7 will be installed

--> Running transaction check

---> Package environment-modules.x86_64 0:3.2.10-10.el7 will be installed

--> Processing Dependency: libtcl8.5.so()(64bit) for package: environment-modules-3.2.10-10.el7.x86_64

---> Package hwloc-libs.x86_64 0:1.11.8-4.el7 will be installed

---> Package infinipath-psm.x86_64 0:3.3-26_g604758e_open.2.el7 will be installed

---> Package libesmtp.x86_64 0:1.0.6-7.el7 will be installed

---> Package libibumad.x86_64 0:17.2-3.el7 will be installed

---> Package opensm-libs.x86_64 0:3.3.20-3.el7 will be installed

--> Running transaction check

---> Package tcl.x86_64 1:8.5.13-8.el7 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================

Package Arch Version Repository Size

================================================================================================================================

Installing:

compat-dapl x86_64 1:1.2.19-4.el7 rhel-7-server-rpms 110 k

compat-exiv2-023 x86_64 0.23-2.el7 rhel-7-server-rpms 681 k

compat-gcc-44 x86_64 4.4.7-8.el7 rhel-7-server-rpms 10 M

compat-gcc-44-c++ x86_64 4.4.7-8.el7 rhel-7-server-rpms 6.3 M

compat-glade315 x86_64 3.15.0-1.el7 rhel-7-server-rpms 243 k

compat-gnome-desktop314 x86_64 3.14.2-1.el7 rhel-7-server-rpms 108 k

compat-grilo02 x86_64 0.2.12-1.el7 rhel-7-server-rpms 102 k

compat-libcogl-pango12 x86_64 1.14.0-3.el7 rhel-7-server-rpms 27 k

compat-libcogl12 x86_64 1.14.0-3.el7 rhel-7-server-rpms 282 k

compat-libcolord1 x86_64 1.0.4-1.el7 rhel-7-server-rpms 96 k

compat-libgdata13 x86_64 0.13.3-1.el7 rhel-7-server-rpms 217 k

compat-libgnome-bluetooth11 x86_64 1:3.8.2.1-2.el7 rhel-7-server-rpms 63 k

compat-libgnome-desktop3-7 x86_64 3.8.4-2.el7 rhel-7-server-rpms 88 k

compat-libgweather3 x86_64 3.8.2-1.el7 rhel-7-server-rpms 57 k

compat-libmediaart0 x86_64 0.7.0-1.el7 rhel-7-server-rpms 33 k

compat-libpackagekit-glib2-16 x86_64 0.8.9-1.el7 rhel-7-server-rpms 112 k

compat-libupower-glib1 x86_64 0.9.20-1.el7 rhel-7-server-rpms 33 k

compat-libxcb x86_64 1.9-1.el7 rhel-7-server-rpms 44 k

compat-openmpi16 x86_64 1.6.4-10.7.el7 rhel-7-server-rpms 2.5 M

compat-opensm-libs x86_64 3.3.15-2.el7 rhel-7-server-rpms 18 k

compat-poppler022 x86_64 0.22.5-4.el7 rhel-7-server-rpms 722 k

compat-poppler022-glib x86_64 0.22.5-4.el7 rhel-7-server-rpms 87 k

compat-poppler022-qt x86_64 0.22.5-4.el7 rhel-7-server-rpms 150 k

Installing for dependencies:

environment-modules x86_64 3.2.10-10.el7 rhel-7-server-rpms 107 k

hwloc-libs x86_64 1.11.8-4.el7 rhel-7-server-rpms 1.6 M

infinipath-psm x86_64 3.3-26_g604758e_open.2.el7 rhel-7-server-rpms 186 k

libesmtp x86_64 1.0.6-7.el7 rhel-7-server-rpms 63 k

libibumad x86_64 17.2-3.el7 rhel-7-server-rpms 23 k

opensm-libs x86_64 3.3.20-3.el7 rhel-7-server-rpms 66 k

tcl x86_64 1:8.5.13-8.el7 rhel-7-server-rpms 1.9 M

Transaction Summary

================================================================================================================================

Install 23 Packages (+7 Dependent packages)

Total download size: 26 M

Installed size: 71 M

Is this ok [y/d/N]: Y

Downloading packages:

(1/30): compat-exiv2-023-0.23-2.el7.x86_64.rpm | 681 kB 00:00:00

(2/30): compat-dapl-1.2.19-4.el7.x86_64.rpm | 110 kB 00:00:00

(3/30): compat-gcc-44-4.4.7-8.el7.x86_64.rpm | 10 MB 00:00:00

(4/30): compat-gcc-44-c++-4.4.7-8.el7.x86_64.rpm | 6.3 MB 00:00:00

(5/30): compat-glade315-3.15.0-1.el7.x86_64.rpm | 243 kB 00:00:00

(6/30): compat-gnome-desktop314-3.14.2-1.el7.x86_64.rpm | 108 kB 00:00:00

(7/30): compat-grilo02-0.2.12-1.el7.x86_64.rpm | 102 kB 00:00:00

(8/30): compat-libcogl-pango12-1.14.0-3.el7.x86_64.rpm | 27 kB 00:00:00

(9/30): compat-libcogl12-1.14.0-3.el7.x86_64.rpm | 282 kB 00:00:00

(10/30): compat-libcolord1-1.0.4-1.el7.x86_64.rpm | 96 kB 00:00:00

(11/30): compat-libgdata13-0.13.3-1.el7.x86_64.rpm | 217 kB 00:00:00

(12/30): compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64.rpm | 63 kB 00:00:00

(13/30): compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64.rpm | 88 kB 00:00:00

(14/30): compat-libgweather3-3.8.2-1.el7.x86_64.rpm | 57 kB 00:00:00

(15/30): compat-libmediaart0-0.7.0-1.el7.x86_64.rpm | 33 kB 00:00:00

(16/30): compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64.rpm | 112 kB 00:00:00

(17/30): compat-libxcb-1.9-1.el7.x86_64.rpm | 44 kB 00:00:00

(18/30): compat-libupower-glib1-0.9.20-1.el7.x86_64.rpm | 33 kB 00:00:00

(19/30): compat-opensm-libs-3.3.15-2.el7.x86_64.rpm | 18 kB 00:00:00

(20/30): compat-openmpi16-1.6.4-10.7.el7.x86_64.rpm | 2.5 MB 00:00:00

(21/30): compat-poppler022-0.22.5-4.el7.x86_64.rpm | 722 kB 00:00:00

(22/30): compat-poppler022-glib-0.22.5-4.el7.x86_64.rpm | 87 kB 00:00:00

(23/30): compat-poppler022-qt-0.22.5-4.el7.x86_64.rpm | 150 kB 00:00:00

(24/30): environment-modules-3.2.10-10.el7.x86_64.rpm | 107 kB 00:00:00

(25/30): hwloc-libs-1.11.8-4.el7.x86_64.rpm | 1.6 MB 00:00:00

(26/30): infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64.rpm | 186 kB 00:00:00

(27/30): libesmtp-1.0.6-7.el7.x86_64.rpm | 63 kB 00:00:00

(28/30): libibumad-17.2-3.el7.x86_64.rpm | 23 kB 00:00:00

(29/30): opensm-libs-3.3.20-3.el7.x86_64.rpm | 66 kB 00:00:00

(30/30): tcl-8.5.13-8.el7.x86_64.rpm | 1.9 MB 00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total 24 MB/s | 26 MB 00:00:01

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Installing : compat-poppler022-0.22.5-4.el7.x86_64 1/30

Installing : libibumad-17.2-3.el7.x86_64 2/30

Installing : opensm-libs-3.3.20-3.el7.x86_64 3/30

Installing : hwloc-libs-1.11.8-4.el7.x86_64 4/30

Installing : infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64 5/30

Installing : compat-libcogl12-1.14.0-3.el7.x86_64 6/30

Installing : libesmtp-1.0.6-7.el7.x86_64 7/30

Installing : 1:tcl-8.5.13-8.el7.x86_64 8/30

Installing : environment-modules-3.2.10-10.el7.x86_64 9/30

Installing : compat-openmpi16-1.6.4-10.7.el7.x86_64 10/30

Installing : compat-libcogl-pango12-1.14.0-3.el7.x86_64 11/30

Installing : compat-opensm-libs-3.3.15-2.el7.x86_64 12/30

Installing : compat-poppler022-glib-0.22.5-4.el7.x86_64 13/30

Installing : compat-poppler022-qt-0.22.5-4.el7.x86_64 14/30

Installing : compat-exiv2-023-0.23-2.el7.x86_64 15/30

Installing : 1:compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64 16/30

Installing : 1:compat-dapl-1.2.19-4.el7.x86_64 17/30

Installing : compat-libmediaart0-0.7.0-1.el7.x86_64 18/30

Installing : compat-libgweather3-3.8.2-1.el7.x86_64 19/30

Installing : compat-libupower-glib1-0.9.20-1.el7.x86_64 20/30

Installing : compat-libxcb-1.9-1.el7.x86_64 21/30

Installing : compat-grilo02-0.2.12-1.el7.x86_64 22/30

Installing : compat-gnome-desktop314-3.14.2-1.el7.x86_64 23/30

Installing : compat-glade315-3.15.0-1.el7.x86_64 24/30

Installing : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64 25/30

Installing : compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64 26/30

Installing : compat-libcolord1-1.0.4-1.el7.x86_64 27/30

Installing : compat-libgdata13-0.13.3-1.el7.x86_64 28/30

Installing : compat-gcc-44-4.4.7-8.el7.x86_64 29/30

Installing : compat-gcc-44-c++-4.4.7-8.el7.x86_64 30/30

Uploading Package Profile

Verifying : 1:tcl-8.5.13-8.el7.x86_64 1/30

Verifying : compat-gcc-44-c++-4.4.7-8.el7.x86_64 2/30

Verifying : compat-libgdata13-0.13.3-1.el7.x86_64 3/30

Verifying : compat-gcc-44-4.4.7-8.el7.x86_64 4/30

Verifying : libibumad-17.2-3.el7.x86_64 5/30

Verifying : compat-libcolord1-1.0.4-1.el7.x86_64 6/30

Verifying : libesmtp-1.0.6-7.el7.x86_64 7/30

Verifying : compat-libgnome-desktop3-7-3.8.4-2.el7.x86_64 8/30

Verifying : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64 9/30

Verifying : compat-glade315-3.15.0-1.el7.x86_64 10/30

Verifying : compat-libcogl-pango12-1.14.0-3.el7.x86_64 11/30

Verifying : compat-libcogl12-1.14.0-3.el7.x86_64 12/30

Verifying : compat-gnome-desktop314-3.14.2-1.el7.x86_64 13/30

Verifying : compat-opensm-libs-3.3.15-2.el7.x86_64 14/30

Verifying : compat-grilo02-0.2.12-1.el7.x86_64 15/30

Verifying : compat-libxcb-1.9-1.el7.x86_64 16/30

Verifying : compat-openmpi16-1.6.4-10.7.el7.x86_64 17/30

Verifying : compat-libupower-glib1-0.9.20-1.el7.x86_64 18/30

Verifying : compat-libgweather3-3.8.2-1.el7.x86_64 19/30

Verifying : infinipath-psm-3.3-26_g604758e_open.2.el7.x86_64 20/30

Verifying : compat-poppler022-0.22.5-4.el7.x86_64 21/30

Verifying : environment-modules-3.2.10-10.el7.x86_64 22/30

Verifying : opensm-libs-3.3.20-3.el7.x86_64 23/30

Verifying : compat-poppler022-glib-0.22.5-4.el7.x86_64 24/30

Verifying : compat-libmediaart0-0.7.0-1.el7.x86_64 25/30

Verifying : hwloc-libs-1.11.8-4.el7.x86_64 26/30

Verifying : 1:compat-dapl-1.2.19-4.el7.x86_64 27/30

Verifying : 1:compat-libgnome-bluetooth11-3.8.2.1-2.el7.x86_64 28/30

Verifying : compat-poppler022-qt-0.22.5-4.el7.x86_64 29/30

Verifying : compat-exiv2-023-0.23-2.el7.x86_64 30/30

Installed:

compat-dapl.x86_64 1:1.2.19-4.el7 compat-exiv2-023.x86_64 0:0.23-2.el7

compat-gcc-44.x86_64 0:4.4.7-8.el7 compat-gcc-44-c++.x86_64 0:4.4.7-8.el7

compat-glade315.x86_64 0:3.15.0-1.el7 compat-gnome-desktop314.x86_64 0:3.14.2-1.el7

compat-grilo02.x86_64 0:0.2.12-1.el7 compat-libcogl-pango12.x86_64 0:1.14.0-3.el7

compat-libcogl12.x86_64 0:1.14.0-3.el7 compat-libcolord1.x86_64 0:1.0.4-1.el7

compat-libgdata13.x86_64 0:0.13.3-1.el7 compat-libgnome-bluetooth11.x86_64 1:3.8.2.1-2.el7

compat-libgnome-desktop3-7.x86_64 0:3.8.4-2.el7 compat-libgweather3.x86_64 0:3.8.2-1.el7

compat-libmediaart0.x86_64 0:0.7.0-1.el7 compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7

compat-libupower-glib1.x86_64 0:0.9.20-1.el7 compat-libxcb.x86_64 0:1.9-1.el7

compat-openmpi16.x86_64 0:1.6.4-10.7.el7 compat-opensm-libs.x86_64 0:3.3.15-2.el7

compat-poppler022.x86_64 0:0.22.5-4.el7 compat-poppler022-glib.x86_64 0:0.22.5-4.el7

compat-poppler022-qt.x86_64 0:0.22.5-4.el7

Dependency Installed:

environment-modules.x86_64 0:3.2.10-10.el7 hwloc-libs.x86_64 0:1.11.8-4.el7

infinipath-psm.x86_64 0:3.3-26_g604758e_open.2.el7 libesmtp.x86_64 0:1.0.6-7.el7

libibumad.x86_64 0:17.2-3.el7 opensm-libs.x86_64 0:3.3.20-3.el7

tcl.x86_64 1:8.5.13-8.el7

Complete!

Uploading Enabled Repositories Report

Loaded plugins: product-id, subscription-manager

[root@pansoft ERPDEV_pansoft]# yum install glibc*

Loaded plugins: enabled_repos_upload, package_upload, product-id, search-disabled-repos, subscription-manager

rhel-7-server-rh-common-rpms | 2.1 kB 00:00:00

rhel-7-server-rpms | 2.0 kB 00:00:00

Resolving Dependencies

--> Running transaction check

---> Package glibc.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-common.x86_64 0:2.17-260.el7_6.5 will be updated

--> Processing Dependency: glibc-common = 2.17-260.el7_6.5 for package: glibc-2.17-260.el7_6.5.i686

---> Package glibc-common.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-devel.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc-devel.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-headers.x86_64 0:2.17-260.el7_6.5 will be updated

--> Processing Dependency: glibc-headers = 2.17-260.el7_6.5 for package: glibc-devel-2.17-260.el7_6.5.i686

---> Package glibc-headers.x86_64 0:2.17-260.el7_6.6 will be an update

---> Package glibc-utils.x86_64 0:2.17-260.el7_6.5 will be updated

---> Package glibc-utils.x86_64 0:2.17-260.el7_6.6 will be an update

--> Running transaction check

---> Package glibc.i686 0:2.17-260.el7_6.5 will be updated

---> Package glibc.i686 0:2.17-260.el7_6.6 will be an update

---> Package glibc-devel.i686 0:2.17-260.el7_6.5 will be updated

---> Package glibc-devel.i686 0:2.17-260.el7_6.6 will be an update

--> Finished Dependency Resolution

Dependencies Resolved

================================================================================================================================

Package Arch Version Repository Size

================================================================================================================================

Updating:

glibc x86_64 2.17-260.el7_6.6 rhel-7-server-rpms 3.6 M

glibc-common x86_64 2.17-260.el7_6.6 rhel-7-server-rpms 11 M

glibc-devel x86_64 2.17-260.el7_6.6 rhel-7-server-rpms 1.1 M

glibc-headers x86_64 2.17-260.el7_6.6 rhel-7-server-rpms 684 k

glibc-utils x86_64 2.17-260.el7_6.6 rhel-7-server-rpms 222 k

Updating for dependencies:

glibc i686 2.17-260.el7_6.6 rhel-7-server-rpms 4.3 M

glibc-devel i686 2.17-260.el7_6.6 rhel-7-server-rpms 1.1 M

Transaction Summary

================================================================================================================================

Upgrade 5 Packages (+2 Dependent packages)

Total download size: 22 M

Is this ok [y/d/N]: Y

Downloading packages:

No Presto metadata available for rhel-7-server-rpms

(1/7): glibc-2.17-260.el7_6.6.i686.rpm | 4.3 MB 00:00:00

(2/7): glibc-2.17-260.el7_6.6.x86_64.rpm | 3.6 MB 00:00:00

(3/7): glibc-devel-2.17-260.el7_6.6.i686.rpm | 1.1 MB 00:00:00

(4/7): glibc-common-2.17-260.el7_6.6.x86_64.rpm | 11 MB 00:00:00

(5/7): glibc-devel-2.17-260.el7_6.6.x86_64.rpm | 1.1 MB 00:00:00

(6/7): glibc-headers-2.17-260.el7_6.6.x86_64.rpm | 684 kB 00:00:00

(7/7): glibc-utils-2.17-260.el7_6.6.x86_64.rpm | 222 kB 00:00:00

--------------------------------------------------------------------------------------------------------------------------------

Total 50 MB/s | 22 MB 00:00:00

Running transaction check

Running transaction test

Transaction test succeeded

Running transaction

Updating : glibc-common-2.17-260.el7_6.6.x86_64 1/14

Updating : glibc-2.17-260.el7_6.6.x86_64 2/14

Updating : glibc-headers-2.17-260.el7_6.6.x86_64 3/14

Updating : glibc-2.17-260.el7_6.6.i686 4/14

Updating : glibc-devel-2.17-260.el7_6.6.i686 5/14

Updating : glibc-devel-2.17-260.el7_6.6.x86_64 6/14

Updating : glibc-utils-2.17-260.el7_6.6.x86_64 7/14

Cleanup : glibc-devel-2.17-260.el7_6.5 8/14

Cleanup : glibc-devel-2.17-260.el7_6.5 9/14

Cleanup : glibc-2.17-260.el7_6.5 10/14

Cleanup : glibc-headers-2.17-260.el7_6.5.x86_64 11/14

Cleanup : glibc-utils-2.17-260.el7_6.5.x86_64 12/14

Cleanup : glibc-common-2.17-260.el7_6.5.x86_64 13/14

Cleanup : glibc-2.17-260.el7_6.5 14/14

Uploading Package Profile

Verifying : glibc-utils-2.17-260.el7_6.6.x86_64 1/14

Verifying : glibc-devel-2.17-260.el7_6.6.i686 2/14

Verifying : glibc-2.17-260.el7_6.6.x86_64 3/14

Verifying : glibc-devel-2.17-260.el7_6.6.x86_64 4/14

Verifying : glibc-headers-2.17-260.el7_6.6.x86_64 5/14

Verifying : glibc-2.17-260.el7_6.6.i686 6/14

Verifying : glibc-common-2.17-260.el7_6.6.x86_64 7/14

Verifying : glibc-devel-2.17-260.el7_6.5.i686 8/14

Verifying : glibc-2.17-260.el7_6.5.i686 9/14

Verifying : glibc-utils-2.17-260.el7_6.5.x86_64 10/14

Verifying : glibc-devel-2.17-260.el7_6.5.x86_64 11/14

Verifying : glibc-headers-2.17-260.el7_6.5.x86_64 12/14

Verifying : glibc-common-2.17-260.el7_6.5.x86_64 13/14

Verifying : glibc-2.17-260.el7_6.5.x86_64 14/14

Updated:

glibc.x86_64 0:2.17-260.el7_6.6 glibc-common.x86_64 0:2.17-260.el7_6.6 glibc-devel.x86_64 0:2.17-260.el7_6.6

glibc-headers.x86_64 0:2.17-260.el7_6.6 glibc-utils.x86_64 0:2.17-260.el7_6.6

Dependency Updated:

glibc.i686 0:2.17-260.el7_6.6 glibc-devel.i686 0:2.17-260.el7_6.6

Complete!

[root@pansoft ERPDEV_pansoft]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE}(%{ARCH})\n' binutils \

> compat-libcap1 \

> compat-libstdc++-33 \

> elfutils-libelf \

> elfutils-libelf-devel \

> gcc \

> gcc-c++ \

> glibc \

> glibc-common \

> glibc-devel \

> glibc-headers \

> ksh \

> libaio \

> libaio-devel \

> libgcc \

> libstdc++ \

> libstdc++-devel \

> make \

> libXext \

> libXtst \

> libX11 \

> libXau \

> libxcb \

> libXi \

> libXp \

> libaio \

> sysstat \

> unixODBC \

> unixODBC-devel \

> openmotif21 \

> xorg-x11-utils \

> libXrender \

> perl \

> gdbm \

> libgomp \

> redhat-lsb \

> util-linux \

> sysstat \

> xorg-x11-libs-compat \

> perl-File-CheckTree

binutils-2.27-34.base.el7(x86_64)

compat-libcap1-1.10-7.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(x86_64)

compat-libstdc++-33-3.2.3-72.el7(i686)

elfutils-libelf-0.172-2.el7(x86_64)

elfutils-libelf-devel-0.172-2.el7(x86_64)

gcc-4.8.5-36.el7_6.2(x86_64)

gcc-c++-4.8.5-36.el7_6.2(x86_64)

glibc-2.17-260.el7_6.6(x86_64)

glibc-2.17-260.el7_6.6(i686)

glibc-common-2.17-260.el7_6.6(x86_64)

glibc-devel-2.17-260.el7_6.6(i686)

glibc-devel-2.17-260.el7_6.6(x86_64)

glibc-headers-2.17-260.el7_6.6(x86_64)

ksh-20120801-139.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

libaio-devel-0.3.109-13.el7(x86_64)

libgcc-4.8.5-36.el7_6.2(x86_64)

libgcc-4.8.5-36.el7_6.2(i686)

libstdc++-4.8.5-36.el7_6.2(x86_64)

libstdc++-4.8.5-36.el7_6.2(i686)

libstdc++-devel-4.8.5-36.el7_6.2(x86_64)

libstdc++-devel-4.8.5-36.el7_6.2(i686)

make-3.82-23.el7(x86_64)

libXext-1.3.3-3.el7(i686)

libXext-1.3.3-3.el7(x86_64)

libXtst-1.2.3-1.el7(x86_64)

libXtst-1.2.3-1.el7(i686)

libX11-1.6.5-2.el7(x86_64)

libX11-1.6.5-2.el7(i686)

libXau-1.0.8-2.1.el7(x86_64)

libXau-1.0.8-2.1.el7(i686)

libxcb-1.13-1.el7(x86_64)

libxcb-1.13-1.el7(i686)

libXi-1.7.9-1.el7(x86_64)

libXi-1.7.9-1.el7(i686)

libXp-1.0.2-2.1.el7(i686)

libXp-1.0.2-2.1.el7(x86_64)

libaio-0.3.109-13.el7(x86_64)

libaio-0.3.109-13.el7(i686)

sysstat-10.1.5-4.el7(x86_64)

package unixODBC is not installed

package unixODBC-devel is not installed

openmotif21-2.1.30-11.el7(i686)

xorg-x11-utils-7.5-23.el7(x86_64)

libXrender-0.9.10-1.el7(x86_64)

libXrender-0.9.10-1.el7(i686)

perl-5.16.3-294.el7_6(x86_64)

gdbm-1.10-8.el7(x86_64)

gdbm-1.10-8.el7(i686)

libgomp-4.8.5-36.el7_6.2(x86_64)

redhat-lsb-4.1-27.0.1.el7(x86_64)

util-linux-2.23.2-59.el7_6.1(x86_64)

sysstat-10.1.5-4.el7(x86_64)

xorg-x11-libs-compat-6.8.2-1.EL.33.0.1(i386)

perl-File-CheckTree-4.42-3.el7(noarch)

Monday, May 21, 2018

How to cancel concurrent request from back end.

1. Run the below SQL query. Give the request id.

SQL> select status_code,phase_code from fnd_concurrent_requests where request_id=&RequestID;

Otput Example –

S P S P
- - or - -
D C R R

STATUS :
X =Terminated
I = Inactive(on Hold )
E Completed ( Error )
G = Completed ( Warning )
D Cancelled
C = Completed
, R = Running

2. Run Update Query. Please note it should be same as above.

SQL> update fnd_concurrent_requests set phase_code='C' , status_code='D' where request_id=&RequestID;

SQL> commit; (Do remember to commit)

Commit complete.

Saturday, May 12, 2018

RAC Database Commands

Some useful Oracle RAC Database commands.

Background Processes

ps -ef|grep d.bin
oracle 8818 8814 0 07:23 ? 00:00:00 /u01/app/oracle/product/10.2.0/crs/bin/evmd.bin
root 8952 8111 0 07:23 ? 00:00:04 /u01/app/oracle/product/10.2.0/crs/bin/crsd.bin reboot
oracle 9476 9003 0 07:23 ? 00:00:01 /u01/app/oracle/product/10.2.0/crs/bin/ocssd.bin
root 16124 5740 0 07:35 pts/2 00:00:00 grep d.bin

Cluster logfiles

CRS logs are in $ORA_CRS_HOME/log//crsd/
CSS logs are in $ORA_CRS_HOME/log//cssd/
EVM logs are in $ORA_CRS_HOME/log//evmd/
SRVM (srvctl) and OCR (ocrdump, ocrconfig, ocrcheck) logs are in $ORA_CRS_HOME/log//client/ and in $ORACLE_HOME/log//client/
Oracle Clusterware alerts can be found in alert.log present in the $ORA_CRS_HOME/log/ directory

Stop the Cluster

# ./crsctl stop crs
Stopping resources.
This could take several minutes.
Successfully stopped Oracle Clusterware resources
Stopping Cluster Synchronization Services.
Shutting down the Cluster Synchronization Services daemon.
Shutdown request successfully issued.
# ps -ef|grep d.bin
root 18713 5771 0 07:34 pts/2 00:00:00 grep d.bin

Checking the version of cluster

#./crsctl query crs softwareversion
#./crsctl query crs activersion

List the voting disks used by Cluster

$ crsctl query css votedisk

Backup up OCR file

# pwd
/u01/app/oracle/product/10.2.0/crs/bin
# ./ocrconfig -export -s online
# ./ocrconfig –manualbackup
# ./ocrconfig -showbackup

Restore OCR file

#ocrconfig -restore

Importing an OCR file

• Shut down all the nodes in the cluster and restart one of them in single-user mode.
• Import an OCR export file using the ocrconfig -import command from any node.

Check the integrity of Cluster

ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 2
Total space (kbytes) : 306952
Used space (kbytes) : 4624
Available space (kbytes) : 302328
ID : 148137643
Device/File Name : /dev/raw/raw1
Device/File integrity check succeeded
Device/File not configured
Cluster registry integrity check succeeded

Check the status of the cluster and target nodes

$cd $ORA_CRS_HOME/bin
$ crs_stat -t
Name Type Target State Host
----------------------------------------------------------
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
$crsctl check crs
Cluster Synchronization Services appears healthy
Cluster Ready Services appears healthy
Event Manager appears healthy

Check the number of nodes in Cluster

$ olsnodes -n
rac1 1
rac2 2

Check the status of the database from DB ORACLE_HOME

srvctl status service -d DB_NAME;
srvctl status service -d -s SERVICE_NAME;
select service_name, elapsedpercall, cpupercall from V$SERVICEMETRIC;
select service_name, stat_name from V$SERVICE_STATS where service_name=''
SELECT DISTINCT stat_name FROM v$service_stats;
srvctl config database -d -t
Stop and start the services using srvctl
stop database -d db_name;
srvctl start database -d db_name;
srvctl start service -d db_name -s service_name;
srvctl stop instance -d db_name -i inst_name;
srvctl start instance -d db_name -i inst_name;
srvctl stop nodeapps -n node_name
srvctl start nodeapps -n node_name
srvctl setenv nodeapps -n node_name -t "TNS_ADMIN='Path'"
srvctl getenv nodeapps -n node_name

New Background Processes In 11g

* ACMS -(atomic controlfile to memory service)

Per-instance process is an agent that contributes to ensuring a distributed SGA memory update is either globally committed
on success or globally aborted in the event of a failure in an Oracle RAC environment.

* DBRM - (database resource manager)

Process is responsible for setting resource plans and other resource manager related tasks.<span id="more-145"></span>

* DIA0 - (diagnosability process 0)

(only 0 is currently being used) is responsible for hang detection and deadlock resolution.

* DIAG - (diagnosability)

It is a process performs diagnostic dumps and executes global oradebug commands.

* EMNC - (event monitor coordinator)

It is the background server process used for database event management and notifications.

* FBDA - (flashback data archiver process)

Archives the historical rows of tracked tables into flashback data archives.
Tracked tables are tables which are enabled for flashback archive.
When a transaction containing DML on a tracked table commits,this process stores the pre-image of the rows into the flashback archive.
It also keeps metadata on the current rows.
FBDA is also responsible for automatically managing the flashback data archive for space, organization, and retention and
keeps track of how far the archiving of tracked transactions has occurred.

* GTX0 - (global transaction)

Processes provide transparent support for XA global transactions in an Oracle RAC environment.
The database autotunes the number of these processes based on the workload of XA global transactions.
Global transaction processes are only seen in an Oracle RAC environment.

* KATE

Performs proxy I/O to an ASM metafile when a disk goes offline.

* MARK

Marks ASM allocation units as stale following a missed write to an offline disk.

* SMCO - (space management coordinator)

It is a process coordinates the execution of various space management related tasks, such as proactive space allocation and space reclamation. It dynamically spawns slave processes (Wnnn) to implement the task.

* VKTM - (virtual keeper of time)

It is responsible for providing a wall-clock time (updated every second) and reference-time counter (updated every 20 ms and available
only when running at elevated priority).

* PZ - (PQ slaves used for global Views)

RAC Parallel Server Slave processes, but they are not normal parallel slave processes,
PZnn processes (starting at 99) are used to query GV$ views which is done using Parallel Execution on all instances,
if more than one PZ process is needed, then PZ98, PZ97,.(in that order) are created automatically.

* O00

(ASM slave processes) A group of slave processes establish connections to the ASM instance.
Through this connection pool database processes can send messages to the ASM instance.
For example opening a file sends the open request to the ASM instance via a slave.
However slaves are not used for long running operations such as creating a file.
The use slave (pool) connections eliminate the overhead of logging into the ASM instance for short requests

* x000

Slave used to expell disks after diskgroup reconfiguration

How to compile forms in R12

1. Login to application server.

2. Go to the directory $AU_TOP/forms/US

It could be custom top where you keep your custom fmb files based on your organization standards.

3) Place “.fmb” file in binary mode.

4) Execute the below command to generate “.fmx”.

frmcmp_batch userid=apps/apps_pwd module=$AU_TOP/forms/US/MY_FILE.fmb output_file=$AU_TOP/forms/US/MY_FILE.fmx module_type=form batch=yes compile_all=special

ADEEB ORACLE DBA,RAC & APPS DBA Blog

Thursday, October 24, 2019

alter_ebs_logon_trigger.sql Failed to enable EBS_LOGON trigger

Monday, May 21, 2018

How to cancel concurrent request from back end.

Saturday, May 12, 2018

RAC Database Commands

New Background Processes In 11g

How to compile forms in R12

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

Popular Posts

Facebook

Pages