CPU utilization reached 100% due to dead frmweb process running in EBS R12.

Form dead  "frmweb" Process Running for more than a day in EBS R12 Instance due to CPU utilization reached 100%.

Steps to resolve this issue.

Solution:

1.First we need to identify which process utilizing cpu occupying more using top command in application server.

oracle@hostname$top

  742 oracle   25   0  157m 101m  21m R 100.0  0.4 300312:47 frmweb
 7268 oracle   25   0 98.4m  52m  16m R 100.0  0.2 456687:38 frmweb

frmweb process utilizing cpu process more.

2.Need to look for frmweb processes are running for more than 12 hours,

oracle@hostname: ps -ef |grep frmweb

oracle    344 29925  0 Dec01 ?        00:00:36 /u01/apps/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.4.6.2

oracle    742 29925 99 May08 ?        208-13:11:05 /u01/app/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.0.0.8

oracle   3474 29925  0 Dec02 ?        00:00:24 /u01/app/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.2.1.1

oracle   5232  3510  0 06:33 pts/2    00:00:00 grep frmweb

oracle   7268 29925 99 Jan20 ?        317-03:25:56 /u01/app/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.2.1.7

process "724","7268" running long hours.

3.check for processess which is using high CPU by using top as command:

oracle@hostname:top

  742 oracle   25   0  157m 101m  21m R 100.0  0.4 312:47 frmweb
 7268 oracle   25   0 98.4m  52m  16m R 100.0  0.2 456:38 frmweb

4.Then verfiy that these high cpu occupying processes don't have a database session. This can be verified by below sql command,

 

 select * from v$session where process='<OS process id of frmweb process>'

Below sql query must not return any rows

 SQL> select * from v$session where process='742';

 no rows selected

More than one process is available means

 SQL> select * from v$session where process IN ('742','7248');

 no rows selected

5. Now check the process and kill it

oracle@hostname$ ps -ef|grep 742

oracle    742 29925 99 May08 ?        208-13:11:05 /u01/app/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.0.0.8

oracle@hostname$ kill -9 742

oracle@hostname$ ps -ef|grep 742

              oracle 742 6226260   0 21:08:36  pts/0  0:00 grep 17170608

oracle@hostname$ ps -ef|grep 7268

oracle   7268 29925 99 Jan20 ?        317-03:25:56 /u01/app/oracle/apps/tech_st/10.1.2/bin/frmweb server webfile=HTTP-0,0,1,default,1.2.1.7

oracle@hostname$ kill -9 7268

oracle@hostname$ ps -ef|grep 7268

              oracle 7268 6226260   0 21:08:36  pts/0  0:00 grep 17170608

Then now check top command cpu utilisation comes to normal.

oracle@hostname$top

top - 09:57:14 up 27 days,  3:28,  4 users,  load average: 0.08, 1.88, 4.97

Tasks: 29 total,   1 running, 295 sleeping,   0 stopped,   0

Cpu(s):  0.0%us,  0.0%sy,  0.0%ni, 99.5%id,  0.4%wa,  0.0%hi,  0.0%si,  0.0%st

Mem:  24675248k total, 21263496k used,  3411752k free,   791976k buffers

Swap: 16777208k total,      160k used, 16777048k free, 13119852k cached

ORA-27101: shared memory realm does not exist

java.sql.SQLRecoverableException: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux-x86_64 Error: 2: No such file or directory

This error is occurring while trying to establish the database connection,This error occur due to  

1) Invalid ORACLE_HOME and ORACLE_SID or 

2) Database is down

[oracle@192 ~]$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 16:48:05 2013

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

ERROR:

ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

Linux Error: 2: No such file or directory

Scenario 1: Invalid ORACLE_HOME and ORACLE_SID:

ORA-27101 is usually due to the invalid ORACLE_HOME and ORACLE_SID parameters at OS level. You should investigate that ORACLE_HOME and ORACLE_SID are set correctly, and ORACLE_HOME should be without trailing slash.

[oracle@192 ~]$ echo $ORACLE_HOME

/u01/app/oracle/product/10.2.0/db_1

[oracle@192 ~]$ echo $ORACLE_SID

testdb

In our case ORACLE_SID was not correct, we need to export ORACLE_SID to the valid one which is ora10g

[oracle@192 ~]$ export ORACLE_SID=ora10g

[oracle@192 ~]$ sqlplus scott/tiger

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 16:52:11 2013

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

Scenario 2: Database is down:

You may also face it when the database is down, to solve ORA-27101 you may have to start the database only

[oracle@192 ~]$ sqlplus sys/sys as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 22 17:07:38 2013

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

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1224736768 bytes

Fixed Size                  1219112 bytes

Variable Size             167773656 bytes

Database Buffers         1040187392 bytes

Redo Buffers               15556608 bytes

Database mounted.

Database opened.

Resolved BI publisher install and addin issues(Translation file not found)

This tutorial explains resolution for facing issues while install Oracle BI Publisher Desktop for Word/excel (on Windows). 

This resolution for installation is for Microsoft Office 2007, 2010, 2016 ,etc.

Please download any required version of  BI Publihser32.exe to insall is best for all its working fine for windows 64 or 32 bit version.

!!!!!Please contact me if you need above mention old version and new version(whatsapp : +919043616169)!!!!!!!

1.Before starting to install BI publisher please confirm version of windows and microsoft offfice.

Windows os 7
Microsoft office 2007

You have to download and install Both bipublisher32.exe(12.0.0) and bipublisher32.exe(11.1.17) version to work on Addins perfectly.

For example to work on Word template Addins you need "Bipubllihser32.exe(12.0.0) version.
If you install this version then only you able to see  Word Addins."Bipublisher"
(This version Excel Addins not available)

If you need to work on Excel template Addins you need to install Bipublisher32.exe (11.1.17) version on already installed location bipublisher(12.0.0) location.
You can able to see the "BIpublisher" Addins in excel.Suppose if not display please follow below,
go to "C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\DotNetInstallFiles"

Execute "ETBMenuSetup2003.exe" this setup , then if reopen excel you able to see the Addins "BIpublisher".

Suppose if you installed only Bipublisher (11.1.17) version Excel Addins only work perfect but Word will not work perfect you will get error while loadind xml
"Translation not found error" and so many error.

2.Suppose If you have below version of windows and microsoft offfice.

Windows os 10
Microsoft office 2016

You have to download and install latest version of  bipublisher32.exe(12.2.4) only  Both Excel and word  Addins works perfectly on your pc

3.After installing Bipublisher32.exe setup , need to run the below file to show the Word or Excel Addins "BIpublisher".

To Install Bipubliser Desktop version go to link "https://kirthikannan.blogspot.com/2020/07/install-oracle-bi-publisher-desktop-for.html"

Go to "C:\Program Files\Oracle\BI Publisher\BI Publisher Desktop\DotNetInstallFiles"

Run "ETBAddInSetup.exe" to install/setup/show the Excel Addins "Bipublisher".
(ETBMenuSetup2003.exe setup will only be available in Bipublisher 11.1.17 only)

Run "TBAddInSetup.exe" to install/setup/show the Word Addins "Bipublisher".

Error We faced while installing and setup Bipublisher desktop and Addins:

Below error due to multiple java version installed so please uninstall all java versions also remove the path then reinstall the latest or compatable vesion.

Then retry to load the data issue resolved.

2.This error due to wrong tag configured on Application Developer responsibility > Application > Lookups > Application Object Library > Query in Type "XDO_TEMPLATE_TYPE"

Check and enable checkbox in "XLS" and Enter "XDO_XLS_TEMPL_OUTPUTS" in Tag field and save.

3.This error due not compatable Bipublisher version installed for word ,Pleae install the Bipublihser desktop 12.0.0 version . this issue resolved.

Please contact if you have not able to resolve the above any of the issue.

Below Installation steps for Bipublisher Desktop any version(Better to install 32 bit version)

Installing Oracle BI Publisher Desktop for Word (for Office) is not a difficult task.

First you have to download it from Oracle. You will get the BIPublisher32.exe or BIPublisher64.exe file.

Run this file and you will get the following screen:

Choose the language for installation and click on "OK".

When the preparation is done, you will see the following screen:

Click on "Next".

Choose a directory for installation and click on "Next". When the installation is done, you will see the following screen:

When you open the Microsoft Word you will see "BI Publisher" and you can use this Add-in.

Please update if issue being resolved.!!!!!

gkannan21@gmail.com

Install Oracle BI Publisher Desktop for Word and excel

This tutorial explains you how to Install Oracle BI Publisher Desktop for Word (on Windows). This installation is for Microsoft Office 2007, 2010, 2016 ,etc.

Installing Oracle BI Publisher Desktop for Word (for Office) is not a difficult task. First you have to download it from Oracle. You will get the BIPublisher32.exe or BIPublisher64.exe file. Run this file and you will get the following screen:

Choose the language for installation and click on "OK".

When the preparation is done, you will see the following screen:

Click on "Next".

Choose a directory for installation and click on "Next". When the installation is done, you will see the following screen:

When you open the Microsoft Word you will see "BI Publisher" and you can use this Add-in.

How to enable microsoft excel template in oracle application R12

How to enable/add microsoft excel as a type to create template list of values in oracle application R12

Goto XML_PUBLISHER_RESPONSIBILITY > TEMPLATES > Trying Create Templates as "Microsoft Excel" But excel option is not showing.


To Enable Create template using "EXCEL"

1.Enable "XLS" options in XDO_TEMPLATE_TYPE lookup code:

Application Developer responsibility > Application > Lookups > Application Object Library > Query in Type "XDO_TEMPLATE_TYPE"

Check and enable checkbox in "XLS" and Enter "XDO_XLS_TEMPL_OUTPUTS" in Tag field and save.

2.Also Check the Enable option for EXCEL in "XDO_XLS_TEMPL_OUTPUTS" lookup codein Query Type.

Make sure Excel options is enabled.

3.Now goto XML_PUBLISHER_RESPONSIBILITY > TEMPLATES > Create Templates check "Microsoft Excel" is enabled.

Link your custom godaddy domain to your blogspot account.

If you purchased custom domain in godaddy have to link your custom domain(pics.com) to blogspot account(pics.blospot.com).

1.Please login into your blogspot account goto settings > basic > published tab > click the setup third party account.

2.Enter your custom domain name like "www.pics.com" without omitting "www" as below screenshot.

3.click save you will get an error sayings " we have not been able to verify authority of your domain".

Please take this screenshot for your future reference as shown in below.
Please note the highlighted details in your screenshot.

3.Login into your godaddy account, goto my products > IN domains (select manage) > Additional setting or find the "manage DNS" options > select manage DNS

Domain records list will show here,

4.check CNAME record is there if available try to edit the record 
Add below details its default for google blogspot accounts.

Hostname :  www
Point to   : ghs.google.com
TTL     :1 hour

 5.Click ADD one more CNAME options points to your blog.

    hostname :  copy the hostname  you taken screenshot from  blogspot in 3 rd step
    Point to   : copy the point to link you taken screenshot from  blogspot in 3 rd step
    TTL : 1hours

6.Here you need to add 4 IP addresses which are common for all the blogger users at the same record table shown above.

Click on "ADD" >> In "Type" choose "A" >> in "Host" type "@" >> and in "Points to" field type "216.239.32.21" As shown below;

Again as same as above, including all add following 4 address;
216.239.32.21
216.239.34.21
216.239.36.21
216.239.38.21

 Now domain record show below,

Once you completed all the above steps, then its time to save all the settings and publish the blog.

Again  goto blogspot settings > basic > published tab > save it ,Wait for 1 hours to process your request.

Retrieving all user privileges within Oracle database.

Querying DBA/USER Privilege Views

A database administrator (DBA) can simply execute a query to view the rows in DBA_SYS_PRIVS, DBA_TAB_PRIVS, and DBA_ROLE_PRIVS to retrieve information about user privileges related to the system, tables, and roles, respectively.

For example, a DBA wishing to view all system privileges granted to all users would issue the following query:

SELECT * FROM DBA_SYS_PRIVS;

The DBA_SYS_PRIVS view contains three columns of data:

GRANTEE is the name, role, or user that was assigned the privilege.
PRIVILEGE is the privilege that is assigned.
ADMIN_OPTION indicates if the granted privilege also includes the ADMIN option.
To determine which users have direct grant access to a table we’ll use the DBA_TAB_PRIVS view:

SELECT * FROM DBA_TAB_PRIVS;

GRANTEE is the name of the user with granted access.
TABLE_NAME is the name of the object (table, index, sequence, etc).
PRIVILEGE is the privilege assigned to the GRANTEE for the associated object.
Finally, querying the DBA_ROLE_PRIVS view has much of the same information but applicable to roles instead, where the GRANTED_ROLE column specifies the role in question:

SELECT * FROM  DBA_ROLE_PRIVS;

Querying the Current User’s Privileges
If DBA access isn’t possible or necessary, it is also possible to slightly modify the above queries to view the privileges solely for the current user.

This is done by alternatively querying USER_ versions of the above DBA_ views. Thus, instead of looking at DBA_SYS_PRIVS we’d query USER_SYS_PRIVS, like so:

SELECT * FROM USER_SYS_PRIVS;

Since the USER_ privilege views are effectively the same as their DBA_ counterparts, but specific to the current user only, the type of returned data and column names are all identical to those when querying DBA_ views intead.

RBI 3 EMI Moratorium announcement

RBI 3 Month EMI Moratorium: If you have the money, pay up.

RBI announced to all financial institution to extend the customer Load EMI repayment for 3 month ,Moratorium start from March-2020 to May-2020 only

RBI's 3 EMI Moratorium means simply says it is not exactly relief for you also its increase Burden. 

Consider this example,

You have  taken a  home loan of  Rs. 50 lakh at 8.5% interest for 10 years.

Monthly  EMI is Rs. 62,000 (approximately).

Duration : March-2020 to March-2030

First Emi start from  March-2020 emi amount  Rs 62000 /-    (FYI--"Monthly EMI payment will have (principle amount + interest amount)")

Here EMI includes (28000(principle amount) + 35000 (intrest amount)) = Rs 62000 /-   (approximately)

Now you have to pay the first installment EMI  in March month , but instead of paying EMI you have choosen  3 EMI moratorium.

This means you are not paying the EMI (March to May) , 

Now At end of the March month you loan amount is (principle amount 50 lakh plus intreset for the March month  "8.5%/12 = Rs. 35,000") = 5035000.  (3EMI Moratorium is only for principle amount not for the interest amount,Interest amount will be added to total principle amount).

if we  don’t pay in april month. Interest applies on the FULL amount of  50.35 lakh  now, so it’s a little closer to Rs. 36,000 in April.  The total outstanding becomes Rs. 5071000. 

 After three months, your new principal is Rs. 51.07 lakh. Effectively you’ll have about Rs. 1 lakh in extra interest to be paid to the bank.

The loan extends three more months at the end, (120 month extends to 123 month)

But this Rs. 1.07 lakh extra is additional so decide to increase the EMI, or something else.

Thanks

Please comment if its helpful.

How do i check the status of linux printer using lpstat command

How do i check the status linux printer/check the printer ipaddress using lpstat:

lpstat command to check the linux printer status:

As a oracle apps dba if we need to check the linux printer status using command "lpstat" options.

At some situation users reporting conncurrent program completed with warnings due printer issue (any issues)

To analyse use "lpstat" command on concurrent manager running linux server,

1.lpstat -p

This will display all configured printer name on this server.

printer xxxx1 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx2 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx3 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx4 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx5 disabled since Thu 19 Apr 2012 05:53:30 PM EDT -Paused

2.lpstat -p xxxx1  (Display particular printer details)

printer xxxx1 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT

3.lpstat -a xxxx1   (Display particular printer print accepting status)

xxxx1 accepting requests since Thu 06 Dec 2012 03:57:25 PM EST

4. lpstat -t xxxx1     (This will display all printer pending que jobs in printer que, if will display more jobs we will face printer  print issue)

xxx-655          ora          24576   Tue 08 Dec 2015 01:49:45 PM EST
xxx-656          ora          24576   Tue 08 Dec 2015 09:15:19 PM EST
xxx-657          ora          25600   Tue 08 Dec 2015 09:47:42 PM EST
xxx-658          ora          25600   Tue 08 Dec 2015 10:14:24 PM EST
xxx-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xxx-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT
xx1-683          ora         211968   Tue 15 Aug 2017 03:12:11 AM EDT
xx1-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xx2-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT
xx2-683          ora         211968   Tue 15 Aug 2017 03:12:11 AM EDT
.
.
etc

5.lpstat -t |grep xxx      (This will display the particular printer pending que jobs in printer que)
Display all printer information. Output will resemble the following:
xxx-655          ora          24576   Tue 08 Dec 2015 01:49:45 PM EST
xxx-656          ora          24576   Tue 08 Dec 2015 09:15:19 PM EST
xxx-657          ora          25600   Tue 08 Dec 2015 09:47:42 PM EST
xxx-658          ora          25600   Tue 08 Dec 2015 10:14:24 PM EST
xxx-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xxx-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT

5.lpstat -t |grep xxx |wc -l   (This will display the total pending que job in  printer que)

count 6

This will help to analyse the issue initialy.

Thanks

lpstat command check linux printer details

lpstat command to check linux printer details:

As a oracle apps dba if we need to check the linux printer status using command "lpstat" options.

At some situation users reporting conncurrent program completed with warnings due printer issue (any issues)

To analyse use "lpstat" command on concurrent manager running linux server,

1.lpstat -p

This will display all configured printer name on this server.

printer xxxx1 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx2 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx3 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx4 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT
printer xxx5 disabled since Thu 19 Apr 2012 05:53:30 PM EDT -Paused

2.lpstat -p xxxx1  (Display particular printer details)

printer xxxx1 is idle.  enabled since Thu 03 Nov 2011 03:21:24 PM EDT

3.lpstat -a xxxx1   (Display particular printer print accepting status)

xxxx1 accepting requests since Thu 06 Dec 2012 03:57:25 PM EST

4. lpstat -t xxxx1     (This will display all printer pending que jobs in printer que, if will display more jobs we will face printer  print issue)

xxx-655          ora          24576   Tue 08 Dec 2015 01:49:45 PM EST
xxx-656          ora          24576   Tue 08 Dec 2015 09:15:19 PM EST
xxx-657          ora          25600   Tue 08 Dec 2015 09:47:42 PM EST
xxx-658          ora          25600   Tue 08 Dec 2015 10:14:24 PM EST
xxx-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xxx-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT
xx1-683          ora         211968   Tue 15 Aug 2017 03:12:11 AM EDT
xx1-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xx2-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT
xx2-683          ora         211968   Tue 15 Aug 2017 03:12:11 AM EDT
.
.
etc

5.lpstat -t |grep xxx      (This will display the particular printer pending que jobs in printer que)

xxx-655          ora          24576   Tue 08 Dec 2015 01:49:45 PM EST
xxx-656          ora          24576   Tue 08 Dec 2015 09:15:19 PM EST
xxx-657          ora          25600   Tue 08 Dec 2015 09:47:42 PM EST
xxx-658          ora          25600   Tue 08 Dec 2015 10:14:24 PM EST
xxx-659          ora          25600   Tue 08 Dec 2015 10:29:23 PM EST
xxx-682          ora         173056   Thu 20 Jul 2017 08:04:28 PM EDT

5.lpstat -t |grep xxx |wc -l   (This will display the total pending que job in  printer que)

count 6

This will help to analyse the issue initialy.

Thanks

report builder not open (minimized in taskbar)

Unable to Open Reports Builder 11g (ICON Appears Minimized in Taskbar)

-->

This  is a known issue where if you try to launch Reports Builder 11g in Windows 7 , the Reports Builder will not launch. However, the icon for it appears in the Windows taskbar. 

To fix the problem, follow these steps:

1.  Go to D:\oracle\devsuitehome_1\

2.  Make a backup of cauprefs.ora

3.  Look for these entries:

Reports.root_x = “#####”

Reports.root_y = “#####”

4.  Replace the numbers (represented by #####) with 0 so that they look like this:

Reports.root_x = 0

Reports.root_y = 0

5.  Save and close the file

6.  Launch Reports Builder. Reports Builder should work successfully.

NOTE: If you open up Reports Builder at a later date and the problem reoccurs, open up cauprefs.ora and modify the same parameters again with the following:

Reports.root_x = 80
Reports.root_y = 30
Reports.root_y = 76

After applying the settings above, Reports Builder should open successfully(1478627.1)