24 December 2010

Step by Step NFS Configuration

1. Introduction
The Network File System is certainly one of the most widely used network services. Network file system (NFS) is based on the Remote procedure call. It allows the client to automount and therefore, transparently access the remote file systems on the network.
2. Scenario
In this scenario we are going to export the file system from the linuxconfig.org (IP address 10.1.1.200) host and mount it on linuxconfig.local(IP address 10.1.1.100).
3. Prerequisites
At this point, we assume that the NFS service daemon is already installed on your system, including portmap daemon on which NFS setupt depends. Moreover, your system needs to support the NFS file system.
$ cat /proc/filesystems

NFS daemon should be listening on both standard ports 2049 and portmap on port 111.

Another way to check if NFS is functioning, is to use the rpcinfo command.
# rpcinfo -p  
You should get a response/output
4. Server export file
All NFS server exports need to be defined in /etc/exports file.
4.1. Most common exports options
Here are the most common export techniques and options:
/home/nfs/ 10.1.1.100(rw,sync)
export /home/nfs directory for host with IP 10.1.1.100 with read, write permissions, and synchronized mode
/home/nfs/ 10.1.1.0/24(ro,sync)
export /home/nfs directory for network 10.1.1.0 netmask 255.255.255.0 with read only permissions and synchronized mode
/home/nfs/ 10.1.1.100(rw,sync) 10.1.1.10(ro,sync)
export /home/nfs directory for host with IP 10.1.1.100 with read, write permissions, synchronized mode, and also export /home/nfs directory for hosts with IP 10.1.1.10 with read only permissions and synchronized mode
/home/nfs/ 10.1.1.100(rw,sync,no_root_squash)
export /home/nfs directory for host with IP 10.1.1.100 with read, write permissions, synchronized mode and the remote root user will be treated as a root and will be able to change any file and directory.
/home/nfs/ *(ro,sync)
export /home/nfs directory for any host with a read only permission and synchronized mode
/home/nfs/ *.linuxconfig.org(ro,sync)
export /home/nfs directory for any host within linuxconfig.org domain with a read only permission and synchronized mode
/home/nfs/ foobar(rw,sync)
export /home/nfs directory for hostname foobar with read, write permissions and synchronized mode
4.2. Edit exports file
Open up your favorite text editor, for example, vim and edit /etc/exports file and add line /home/nfs/ *(ro,sync) to export /home/nfs directory for any host with read only permissions. 
/home/nfs/ *(rw,sync)
Be sure that the directory you export by NFS exists. You can also create a file inside the /home/nfs directory which will help you troubleshoot once you mount this file system remotely.
# touch /home/nfs/test_file
4.3. Restart NFS daemon
Once you edit /etc/exports file you need to restart NFS daemon to apply changes in the /etc/exports file. Depending on your Linux distribution, the restarting of NFS may differ. Debian users:
# /etc/init.d/nfs-kernel-server restart
Redhat users
# /etc/init.d/nfs restart
If you later decide to add more NFS exports to the /etc/exports file, you will need to either restart NFS daemon or run command exportfs:
# exportfs -ra
5. Mount remote file system on client
First we need to create a mount point:
# mkdir /home/nfs_local
If you are sure that the NFS client and mount point are ready, you can run the mount command to mount exported NFS remote file system:
# mount 10.1.1.200:/home/nfs /home/nfs_local
In case that you need to specify a type of the filesystem you can do this by:
# mount -t nfs 10.1.1.200:/home/nfs /home/nfs_local
You may get error message
mount: mount to NFS server failed: timed out (retrying).
This may mean that your server supports higher versions of nfs and therefore you need to pass one extra argument to your nfs client. In this example we use nfs version 3:
# mount -t nfs -o nfsvers=3 10.1.1.200:/home/nfs /home/nfs_local

Now you should be able to see that the file system is mounted. Notice that the mount command reports that the filesystem is mounted as "read and write", although you can see that it provides a "read only" permission.
6. Configure automount
To make this completely transparent to end users, you can automount the NFS file system every time a user boots a PC, or you can also use PAM modules to mount once a user logs in with a proper username and password. In this situation just edit /etc/fstab to mount system automatically during a system boot. You can use your favorite editor and create new line like this:
10.1.1.200:/home/nfs /home/nfs_local/ nfs defaults 0 0
in /etc/fstab or
# echo "10.1.1.200:/home/nfs /home/nfs_local/ nfs defaults 0 0" >> /etc/fstab
Restart you NFSD daemon with following commands:
# /etc/init.d/nfs restart
# /etc/init.d/nfslock restart

13 December 2010

Workflow notification mailer setup in R12 is similar to 11i

I am going to cover Workflow Notification Mailer in Oracle Applications R12/12i.
Workflow notification mailer setup in R12 is similar to 11i ( In both release 11i (OWF.H and higher in 11i) & R12 are Java Mailer)
* Previous version of Notification Mailer in 11i was based on C also called as C Mailer
Things to note
1. You use Oracle Application Manager (OAM) to configure Workflow Notification Mailer.
2. There are two kind of Notification (Outbound & Inbound) in Workflow Mailer
3. For Outbound Notification, CM (Concurrent Manager) node should be able to connect to SMTP (Simple Mail Transfer Protocol) server/relay.
4. For Inbound Notification (Optional), CM node should be able to connect to IMAP (Internet Message Access Protocol) Server.
5. Log file for Workflow Mailer Notification are at $APPLCSF/$APPLLOG/FNDC*.txt
6. Workflow Notification Mailer in background run as Concurrent Manager (Workflow Mailer Service, Workflow Agent Listener Service)
7. If you don’t wish to send mail notification to end user (from Dev/Test instance) then configure Test Address in configuration screen.

Step to configure Workflow Notification Mailer

1. Login to Apps R12 with System Administrator Reponsibility
2. under Workflow : Oracle Applications Manager click on Workflow Manager



If this is first time you are configuring Workflow Notification Mailer in Oracle Apps R12/12i you will see Notification Mailers as unavailable as shown in screenshot

Click on Notification Mailers

In next screen (as shown below, click on Edit Button)

Here you have option to select Inbound notification setup or Just outgoing Notification Setup.

Provide SMTP Server Name (ensure that CM node should be able to connect to SMTP Server or SMTP Relay)

Uncheck Inbound Processing (from above screen), if you don’t wish to configure Inbound Notification Mailer.
If you wish to configure Inbound Notification as well then ensure IMAP Server should be configured with a valid user (create Inbox, Processed & Discard folder for this User)
Click on Apply button to finish configuration, at this stage Notification Mailer will test SMTP Server & IMAP Server connectivity.
For Advanced setup, click on Advanced at top right of configuration screen.

08 December 2010

Modify the Windows XP System Properties logo

  1. The next thing to consider is the image size. The system properties dialog only offers enough real estate for an image of about 180 (wide) x120 (high) pixels. Make sure that you can fit your logo in this area.
  2. Once you have created your logo and saved it as a .bmp file, copy it over to the system32 subfolder of your system folder. If you don’t know where your system folder is :
  3. - Click the Start button and select “Run”
    - In the “open” field, enter “cmd” (without the quotes) and click ok
    - will open up a dos command window
    - In the command window, type “set system” (without the quotes)
    - Look for the line that contains “SystemRoot”, this is where your system directory is (generally, the XP system folder is c:\)
  4. Now that you know where your system folder is, copy your logo image file over to the system32 subfolder of your system folder. Then rename your logo image file to oemlogo.bmp
    Additionally you can create a new file in this same folder and name the new file oeminfo.ini
    In this file you can enter your contact information like in the example below :
    [General]
    Manufacturer=Pctipsbox
    Model=ShowCase
    [Support Information]
    Line1=” ”
    Line2=” For support, sales, upgrades or questions:”
    Line3=”"
    Line4=” Some text to demonstrate the XP System Properties logo”
    Line5=” XP Tips and Tricks ”
    Line6=” Pctipsbox”
    Line7=”"
    Line8=” +1 (888) 888-888 (voice)”
    Line9=” +1 (888) 888-889 (fax)”
    Line10=”"
    Line11=”"
    Line12=” http://www.pctipsbox.com/
    Save and close the file and you are ready. From now on, if someone opens up the system properties dialog, your own XP System Properties logo is in there.

ORA-03113: end-of-file on communication channel

[oracle@our12test 11.1.0]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 8 08:58:06 2010

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2166536 bytes
Variable Size             427819256 bytes
Database Buffers          624951296 bytes
Redo Buffers               14000128 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16033
Session ID: 3000 Serial number: 5


SQL> shut abort
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64                                                                            

bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@our12test 11.1.0]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 8 09:00:20 2010

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

Connected.
SQL> shut abort
ORACLE instance shut down.
SQL> exit
Disconnected
[oracle@our12test 11.1.0]$ sqlplus "/as sysdba"
SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 8 09:00:20 2010

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

Connected.
SQL> shut abort
ORACLE instance shut down.
SQL> exit
Disconnected
[oracle@our12test 11.1.0]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 8 09:00:35 2010

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

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2166536 bytes
Variable Size             427819256 bytes
Database Buffers          624951296 bytes
Redo Buffers               14000128 bytes
Database mounted.
SQL> recover database;
Media recovery complete.
SQL> alter database open;

Database altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64                                                                            

bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@our12test 11.1.0]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 8 09:04:55 2010

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

Then start normaly ...

06 December 2010

Adadmin Compile APPS schema never complete & it running for infinite time

1, check your database alert log file if found and table space error please resolve first

2,stop your application service

3,relink all modules

4,stop your database  services

3, restart your machine then start the all services .

4,then try adadmin

Hi,
I have already raised the SR below detail .

Oracle Support - November 22, 2010 2:04:23 PM GMT+05:30 [ODM Action Plan]
Hi

Thank you for your update
.
=== ODM Action Plan ===
1) Please upload the adadmin regarding relink ad module

2) Have you try to bounce your machine/server ?

3) Please check this

select * from ad_bugs where bug_number='7461070';

4) If nothing help, please backup your environment and apply patch '8502056','R12.AD.B.delta.2'

after re-try adadmin compile apps schema

Best Regards
Valerie

M.SENTHILKUMAR@CHAIN-SYS.COM - November 20, 2010 1:43:46 AM GMT+05:30 [Update from Customer]
Hi,
I have run the below query in apps/apps user only the output is no row selected .I have relinked all the file . still same problem .
please give the immediate soliution . some work is pending on related to this issue .

Regards,
Senthil

Oracle Support - November 19, 2010 2:24:23 PM GMT+05:30 [ODM Action Plan]
Hi

Thank you for your update
.
=== ODM Action Plan ===
1) According to adadmin.log file :

Connecting to APPLSYS......Connected successfully.
AD code level : [B.1]

Connecting to SYSTEM......Connected successfully.

the following select

SELECT bug_number,
decode(bug_number,
'9239089','R12.AD.B.delta.3',
'8502056','R12.AD.B.delta.2',
'7461070','R12.AD.B.1'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN ('9239089','8502056','7461070');

should return something, how have you run the select, via sqlplus apps/apps ?

2) Please try to bounce your server/machine and re-try adadamin

3) Try relink AD module via adadmin

Best Regards
Valerie

M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 10:21:31 PM GMT+05:30 [Update from Customer]
Hi,
I have executed the below query . output is no row selected

Previously adadmin is working fine No changes in my env .

Regards,
Senthil

Oracle Support - November 18, 2010 7:09:14 PM GMT+05:30 [ODM Action Plan]
Hi

Thank you for your update
.
=== ODM Action Plan ===
1) Please execute the following query

SELECT bug_number,
decode(bug_number,
'9239089','R12.AD.B.delta.3',
'8502056','R12.AD.B.delta.2',
'7461070','R12.AD.B.1'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN ('9239089','8502056','7461070');

2) Does adadmin working fine previously ? If yes, what change on your environment ?

Best Regards
Valerie

M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 6:31:37 PM GMT+05:30 [Update from Customer]
Hi,
1) Please could you details, why you are thinking that adadmin doens't work ? Have you wait long time ? It's take a lot of time to compile all objects in APPS schema

I understand it takes a long time, but I have already waited for 2 days .

Regards,
Senthil

M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 5:46:17 PM GMT+05:30 [Update from Customer]
Hi,
I have already uploded the adadmin log below query output .

3) Please run the following query and provide the result
SQL> select product_group_id, product_group_name, release_name,product_group_type, argument1 from fnd_product_groups;
PRODUCT_GROUP_ID PRODUCT_GROUP_NAME


------------------------------------------------------------
RELEASE_NAME

PRODUCT_GROUP_TYPE ARGUMENT1

------------------------------
1 Default product group
12.1.1
Standard
4) Please run the following queries and provide the result

No row selected

Oracle Support - November 18, 2010 4:56:59 PM GMT+05:30 [ODM Action Plan]
Hi

Thank you for using My Oracle Support, I receive your service request, my name is Valerie dijon senior support engineer from ICM (Install and Configuration Management) team and I will be helping you with your issue.
.
=== ODM Action Plan ===
1) Please could you details, why you are thinking that adadmin doens't work ? Have you wait long time ? It's take a lot of time to compile all objects in APPS schema

2) Please upload your adadmin.log file for my review

3) Please run the following query and provide the result

select product_group_id, product_group_name, release_name,
product_group_type, argument1
from fnd_product_groups;

4) Please run the following queries and provide the result

SELECT bug_number, decode(bug_number,
'3438354', '11i.ATG_PF.H - BASE',
'4017300', '11i.ATG_PF.H RUP1',
'4125550', '11i.ATG_PF.H RUP2',
'4334965', '11i.ATG_PF.H RUP3',
'4676589', '11i.ATG_PF.H RUP4',
'5473858','11i.ATG_PF.H.delta.5',
'5903765','11i.ATG_PF.H.delta.6',
'6241631','11i.ATG_PF.H.delta.7'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN (
'3438354', '4017300', '4125550', '4334965', '4676589','5473858', '5903765', '6241631');

SELECT bug_number, decode(bug_number,
'2141471', 'Applications DBA 11i.AD.F Mini Pack',
'2344175', 'Applications DBA 11i.AD.G Mini Pack',
'2673262', 'Applications DBA 11i.AD.H Mini Pack',
'4038964', 'Applications DBA 11i.AD.I.1 Mini Pack',
'4337683', 'Applications DBA 11i.AD.I.2 Mini Pack',
'4229931', '11i.AD.I.delta.2',
'4502904', 'Applications DBA 11i.AD.I.delta3 Post AD.I Consolidated 09/01/05',
'4712852', 'Minipack 11i.AD.I.4',
'4605654', 'Minipack 11i.AD.I. delta4',
'5161676', 'Minipack 11i.AD.I.5',
'5161680', 'Minipack 11i.AD.I.delta 5',
'6502082', 'Minipack 11i.AD.I.6',
'6502079', 'Minipack 11i.AD.I.delta.6',
'7429271', 'Minipack 11i AD.I.7'
) n_patch ,
last_update_date
FROM ad_bugs
WHERE bug_number IN (
'2141471','2344175','2673262','4038964','4337683','4229931','4502904','4712852','4605654','5161676','5161680','6502082','6502079','7429271');

Best Regards
Valerie

M.SENTHILKUMAR@CHAIN-SYS.COM - November 18, 2010 4:05:40 PM GMT+05:30 [Update from Customer]
Hi,
please find the below output . but i am using adadmin utlrp.sql is working fine .adadmin only not working .
OWNER COUNT(*)


----------
BILT 15
APPS 13
Regards,
Senthil

Oracle Support - November 18, 2010 3:25:31 PM GMT+05:30 [Notes]
Generic Note


Hi,

Please connect to the database as sys and run:

SQL> select owner, count(*) from dba_objects where status='INVALID' group by owner;

-- provide the output.

Thanks,
Marius

03 December 2010

Incremental checkpoint up to RBA [0xd9.fa764.0], current log tail at RBA [0xd9.fdd11.0]

Incremental Checkpoint Up To RBA ,Current Log Tail at RBA [ID 568049.1]


In this Document
  Symptoms
  Changes
  Cause
  Solution
  References




Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 30-Sep-2010***

Symptoms

The following message appears several times in the alert.log file:
Incremental checkpoint up to RBA [0x5.f5b51.0], current log tail at RBA [0x5.f6127.0]

Changes

Upgraded to a 10g Database Version.

Cause

Those messages in the alert.log are all fine, and are expected behavior if the parameter LOG_CHECKPOINTS_TO_ALERT is set to TRUE. This logs all the incremental checkpoints to the alert log. So, the above informative messages indicate that incremental checkpoints have occurred.

Solution

To disable these messages,
set log_checkpoints_to_alert=FALSE
in the parameter file and restart the Database.
Also, it's worth checking the FAST_START_MTTR_TARGET parameter. Fast-start checkpointing can be explicitly disabled by setting FAST_START_MTTR_TARGET=0. Disabling fast-start checkpointing leads to the fewest average number of writes per transaction for DBWn for a specific workload and configuration, but also results in the highest MTTR.

your office is not genuine

To disable OGA Notifications and uninstall KB949810, close and exit from all Office applications (including Outlook, Word, Excel, PowerPoint, OneNote, Publisher, Visio and etc.), and search for the following files in %SystemDrive%\Wndows\System32 folder and %SystemDrive%\Windows\SysWow64 folder (for 64-bit OS x64 only).
OGAVerify.exe
OGAAddin.dll
Delete the above files. It’s also possible rename the files so that system cannot find them.
Hack 4: Remove OGAAddin.connect Registry Key in System Registry
Pretty much similar to method 1 and 2, but it’s quicker and will complete remove trace of OGAAddin.connect from registry. Unlike hack 1, Windows Update may prompt you to install again.
  1. Run Registry Editor (RegEdit.exe).
  2. Go to each and every of the following registry keys, and any other which contains OGAAddin.connect registry value sub-key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Word\Addins
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Powerpoint\Addins
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Outlook\Addins
  3. Delete the OGAAddin.connect registry value.

02 December 2010

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.po.setup.server.PurchasingSetupAM'.

Hi am faceing below error

oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.po.setup.server.PurchasingSetupAM'.
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:279)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.
ORA-06512: at "APPS.FND_MESSAGE", line 346
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1
;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.initializeMultiOrg(OADBTransactionImpl.java:3497)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.handleMultiOrgInit(OAApplicationModuleImpl.java:1393)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.setCookie(OADBTransactionImpl.java:1981)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.setCookie(OAApplicationModuleImpl.java:1200)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.validateIcxCookie(OAHttpSessionCookieImpl.java:224)
at oracle.apps.fnd.framework.OASessionCookieHelper.validateIcxSession(OASessionCookieHelper.java:467)
at oracle.apps.fnd.framework.OASessionCookieHelper.initializeApplicationModule(OASessionCookieHelper.java:125)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.initializeApplicationModule(OAHttpSessionCookieImpl.java:936)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:516)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.
ORA-06512: at "APPS.FND_MESSAGE", line 346
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:967)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3327)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3433)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.initializeMultiOrg(OADBTransactionImpl.java:3493)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.handleMultiOrgInit(OAApplicationModuleImpl.java:1393)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.setCookie(OADBTransactionImpl.java:1981)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.setCookie(OAApplicationModuleImpl.java:1200)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.validateIcxCookie(OAHttpSessionCookieImpl.java:224)
at oracle.apps.fnd.framework.OASessionCookieHelper.validateIcxSession(OASessionCookieHelper.java:467)
at oracle.apps.fnd.framework.OASessionCookieHelper.initializeApplicationModule(OASessionCookieHelper.java:125)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.initializeApplicationModule(OAHttpSessionCookieImpl.java:936)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:516)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.
ORA-06512: at "APPS.FND_MESSAGE", line 346
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1
;
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.initializeMultiOrg(OADBTransactionImpl.java:3497)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.handleMultiOrgInit(OAApplicationModuleImpl.java:1393)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.setCookie(OADBTransactionImpl.java:1981)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.setCookie(OAApplicationModuleImpl.java:1200)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.validateIcxCookie(OAHttpSessionCookieImpl.java:224)
at oracle.apps.fnd.framework.OASessionCookieHelper.validateIcxSession(OASessionCookieHelper.java:467)
at oracle.apps.fnd.framework.OASessionCookieHelper.initializeApplicationModule(OASessionCookieHelper.java:125)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.initializeApplicationModule(OAHttpSessionCookieImpl.java:936)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:516)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)
## Detail 0 ##
java.sql.SQLException: ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.INIT, N, ERRNO, -20001, N, REASON, ORA-20001: APP-FND-02901: You do not have access privilege to any operating unit. Please check if your profile option MO: Security Profile includes any operating unit or the profile option MO: Operating Unit is set.
ORA-06512: at "APPS.FND_MESSAGE", line 346
ORA-06512: at "APPS.MO_GLOBAL", line 36
ORA-06512: at "APPS.MO_GLOBAL", line 757
ORA-06512: at "APPS.MO_GLOBAL", line 700
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:967)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3327)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3433)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.initializeMultiOrg(OADBTransactionImpl.java:3493)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.handleMultiOrgInit(OAApplicationModuleImpl.java:1393)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.setCookie(OADBTransactionImpl.java:1981)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.setCookie(OAApplicationModuleImpl.java:1200)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.validateIcxCookie(OAHttpSessionCookieImpl.java:224)
at oracle.apps.fnd.framework.OASessionCookieHelper.validateIcxSession(OASessionCookieHelper.java:467)
at oracle.apps.fnd.framework.OASessionCookieHelper.initializeApplicationModule(OASessionCookieHelper.java:125)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.initializeApplicationModule(OAHttpSessionCookieImpl.java:936)
at oracle.apps.fnd.framework.webui.OAHttpSessionCookieImpl.useApplicationModule(OAHttpSessionCookieImpl.java:516)
at oracle.jbo.common.ampool.SessionCookieImpl.useApplicationModule(SessionCookieImpl.java:424)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:208)
at oracle.apps.fnd.framework.webui.OAJSPApplicationRegistry.registerApplicationModule(OAJSPApplicationRegistry.java:78)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1279)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:532)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:420)
at _OA._jspService(_OA.java:216)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:719)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:270)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:204)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:209)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:322)
at _RF._jspService(_RF.java:225)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:627)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:376)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:230)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$800(ServerSocketAcceptHandler.java:33)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:831)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:595)


Solution:-

DECLARE
stat boolean;
BEGIN
dbms_output.disable;
dbms_output.enable(100000);
stat := FND_PROFILE.SAVE('ORG_ID', 82, 'SITE');
IF stat THEN
dbms_output.put_line( 'Stat = TRUE - profile updated' );
ELSE
dbms_output.put_line( 'Stat = FALSE - profile NOT updated' );
END IF;
commit;
END;

26 November 2010

Step by Step Oracle Data Import Export

Oracle Data Import Export imp / exp on oracle is equivalent to restore and backup data. exp command to put the data from a remote database server to the local exported dmp file, imp command dmp files can be put into the distance from the local database server. This function can be build using the same two databases, one for testing, one for official use.

Execution Environment: SQLPLUS.EXE or in DOS (command line) in the implementation of
DOS can be implemented in oracle 8i because of the installation directory is set to ora81BIN global path,
EXP.EXE the directory has been used with the implementation of IMP.EXE document import and export.
oracle using java prepared, SQLPLUS.EXE, EXP.EXE, IMP.EXE have the two documents may have been the type of paper packaging.
SQLPLUS.EXE call EXP.EXE, IMP.EXE wrapped by the class to complete import and export functions.

Here is an example of import and export.
Data Export:
1 will be derived entirely TEST database, user name, system password manager Export to D: daochu.dmp Medium
exp system / manager @ TEST file = d: daochu.dmp full = y
2 will be system users database table and export sys user
exp system / manager @ TEST file = d: daochu.dmp owner = (system, sys)
3 will be in the database table inner_notify, notify_staff_relat Export
exp aichannel / aichannel @ TESTDB2 file = d: datanewsmgnt.dmp tables = (inner_notify, notify_staff_relat)

4 will be in the database field in the table1 table filed1 to "00" Export data from the beginning
exp system / manager @ TEST file = d: daochu.dmp tables = (table1) query = "where filed1 like'00% '"

Derived above are commonly used for compression, not only put dmp file with winzip compression can be very good.
In the above command can also be followed by compress = y to achieve.

Data import
1 will be D: daochu.dmp in the TEST data into the database.
imp system / manager @ TEST file = d: daochu.dmp
imp aichannel / aichannel @ HUST full = y file = d: datanewsmgnt.dmp ignore = y
Above problem may be a bit, because some form already exists, then it is error, not to import the table.
Behind with ignore = y on it.
2 d: daochu.dmp import table table1
imp system / manager @ TEST file = d: daochu.dmp tables = (table1)

Basically, the above import and export good enough for us. A number of cases is to first delete the complete table, and then import.

Note:
The operator must have enough permissions, it will prompt not enough permissions.
Can be connected to the database of. Tnsping TEST can be used to access the database can connect to the TEST.

Appendix 1:
Import data to the user to increase the operation of the first authority to start the sql * puls
Second, system / manager landed third, create user username IDENTIFIED BY password (if the user has been created, this step can be omitted)
Fourth, GRANT CREATE USER, DROP USER, ALTER USER, CREATE ANY VIEW,
DROP ANY VIEW, EXP_FULL_DATABASE, IMP_FULL_DATABASE,
DBA, CONNECT, RESOURCE, CREATE SESSION TO user name of the fifth, run-cmd-enter the dmp file directory,
imp userid = system / manager full = y file =*. dmp
Or imp userid = system / manager full = y file = filename.dmp

Implementation of examples:
F: WorkOracle_Databackup> imp userid = test / test full = y file = inner_notify.dmp

Screen display
Import: Release 8.1.7.0.0 - Production on Thursday, February 16 16:50:05 2006
(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connect to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production

Derived from the conventional path by EXPORT: V08.01.07 documents have been created ZHS16GBK achieve ZHS16GBK NCHAR character set and character set import server uses UTF8 NCHAR Export Character Set (ncharset the possible conversion)
. AICHANNEL the object being imported into AICHANNEL
.. Is to import table "INNER_NOTIFY" 4 lines are ready to import the opening of constraints ...
Successful termination of import, but a warning.

Appendix Two:
Oracle does not allow direct changes in the owner table, using Export / Import can achieve this purpose.
First set up import9.par,
Then, use the following command: imp parfile = / filepath/import9.par
Example import9.par reads as follows:
FROMUSER = TGPMS
TOUSER = TGPMS2 (Note: the owner of the table FROMUSER replaced by TOUSER, FROMUSER and different users can TOUSER)
ROWS = Y
INDEXES = Y
GRANTS = Y
CONSTRAINTS = Y
BUFFER = 409600
file == / backup/ctgpc_20030623.dmp
log == / backup/import_20030623.log

25 November 2010

How to maintain my laptop battery Life

Laptops tend to lose their charm quickly when you’re constantly looking for the nearest power outlet to charge up.  How do you keep your battery going for as long as possible?  Here are 15 easy ways to do so.
1. Defrag regularly -  The faster your hard drive does its work – less demand you are going to put on the hard drive and your battery.  Make your hard drive as efficient as possible by defragging it regularly. (but not while it’s on battery of course!) Mac OSX is better built to handle fragmentation so it may not be very applicable for Apple systems.
2. Dim your screen – Most laptops come with the ability to dim your laptop screen.  Some even come with ways to modify CPU and cooling performance.  Cut them down to the lowest level you can tolerate to squeeze out some extra battery juice.
3. Cut down on programs running in the background.  Itunes, Desktop Search, etc.  All these add to the CPU load and cut down battery life.  Shut down everything that isn’t crucial when you’re on battery.
4. Cut down external devices – USB devices (including your mouse) & WiFi drain down your laptop battery.  Remove or shut them down when not in use.  It goes without saying that charging other devices (like your iPod) with your laptop when on battery is a surefire way of quickly wiping out the charge on your laptop battery.
5. Add more RAM - This will allow you to process more with the memory your laptop has, rather than relying on virtual memory.  Virtual memory results in hard drive use, and is much less power efficient. Note that adding more RAM will consume more energy, so this is most applicable if you do need to run memory intensive programs which actually require heavy usage of virtual memory.
6. Run off a hard drive rather than CD/DVD - As power consuming as hard drives are, CD and DVD drives are worse.  Even having one in the drive can be power consuming.  They spin, taking power, even when they?re not actively being used.  Wherever possible, try to run on virtual drives using programs like Alcohol 120% rather than optical ones.
7.  Keep the battery contacts clean:  Clean your battery’s metal contacts every couple of months with a cloth moistened with rubbing alcohol.  This keeps the transfer of power from your battery more efficient.
8. Take care of your battery – Exercise the Battery.  Do not leave a charged battery dormant for long periods of time.  Once charged, you should at least use the battery at least once every two to three weeks. Also, do not let a Li-On battery completely discharge. (Discharing is only for older batteries with memory effects)
9. Hibernate not standby – Although placing a laptop in standby mode saves some power and you can instantly resume where you left off, it doesn’t save anywhere as much power as the hibernate function does.  Hibernating a PC will actually save your PC’s state as it is, and completely shut itself down.
10. Keep operating temperature down - Your laptop operates more efficiently when it’s cooler.  Clean out your air vents with a cloth or keyboard cleaner, or refer to some extra tips by
11. Set up and optimize your power options – Go to ‘Power Options’ in your windows control panel and set it up so that power usage is optimized (Select the ‘max battery’ for maximum effect).
12. Don’t multitask – Do one thing at a time when you’re on battery.  Rather than working on a spreadsheet, letting your email client run in the background and listening to your latest set of MP3′s, set your mind to one thing only.  If you don’t you’ll only drain out your batteries before anything gets completed!
13. Go easy on the PC demands – The more you demand from your PC.  Passive activities like email and word processing consume much less power than gaming or playing a DVD.  If you’ve got a single battery charge – pick your priorities wisely.
14. Get yourself a more efficient laptop -  Laptops are getting more and more efficient in nature to the point where some manufacturers are talking about all day long batteries.  Picking up a newer more efficient laptop to replace an aging one is usually a quick fix.
15. Prevent the Memory Effect - If you’re using a very old laptop, you’ll want to prevent the ‘memory effect’ – Keep the battery healthy by fully charging and then fully discharging it at least once every two to three weeks. Exceptions to the rule are Li-Ion batteries (which most laptops have) which do not suffer from the memory effect.

Bonus Tip #1: Turn off the autosave function.  MS-Word’s and Excel’s autosave functions are great but because they keep saving regular intervals, they work your hard driver harder than it may have to. If you plan to do this, you may want to turn it back on as the battery runs low. While it saves battery life in the beginning, you will want to make sure your work is saved when your battery dies.
Bonus Tip #2: Lower the graphics use. You can do this by changing the screen resolution and shutting off fancy graphic drivers. Graphics cards (video cards) use as much or more power today as hard disks – Thanks Andrew
Update 7/7/07: Bonus Tip #1 to give caution about turning off autosave, tip #8 to change information about discharging batteries – thanks to all who pointed it out. Added Bonus tip #2, Tip #1 to add in clause in regards to Mac OSX, Tip #1 about the spinning of hard drives – thanks to all who pointed it out

18 November 2010

APP-FND-01542: This Applications Server is not authorized to access this database

APP-FND-01542

Error Message
APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator.




Solution:
1. Backup context file .
2. Update the context variable:
s_appserverid_authentication

By default in 11.5.10, this is set to SECURE.
In previous 11i versions, this was set to OFF.
For debug purposes, you can use ON or OFF.

Modes:
- ON : Partial
- SECURE : activates full server security (SECURE mode)
- OFF : deactivates server security

3. Run Autoconfig to instantiate the change.

Gkn.OnDemand.Library.LibraryException: Import job failed Import job failed while opening UPK tool

Import job failed while opening UPK tool [ID 734329.1]

In this Document
  Symptoms
  Cause
  Solution



Applies to:

Oracle User Productivity Kit - Version: 3.0 to 3.5
This problem can occur on any platform.

Symptoms

After an single or multi user UPK Installation, while trying to open the UPK tool the following error occurs.

Import Job failed
Gkn.OnDemand.Library.LibraryException: Import job failed at
Gkn.OnDemand.Library.LibraryLoader.importJob_JobProgress(Object
sender, JobProgressEventArgs e) in
E:\BUILDROOT\Builds\Branches\Exton\tfs\Core_DotNet\LibraryComponent\LibraryLoader\LibraryLoader.cs:line 606

Cause

The error happens if there is a previous version of UPK already existing and installation of another version of UPK is done without clearing all required files from client.

Solution

Refer following steps to ensure proper uninstallation of previous version of UPK
 1. Uninstall the previous version of UPK from window client machine using Add/Remove Programs. 
 2. Navigate to the folder where the developer was installed and delete any remaining file/folders
    (C:\Program Files\User Productivity Kit\UPK Developer 31Single User)
 3. Delete this folder: C:\Documents and Settings\{your name}\Local Settings\Application Data\UPDev2   (multiuser installation client ) /SUPDev2 (single user installation).
 4. Now reinstall the new version of UPK which you have downloaded from http://edelivery.oracle.com.

ORA-20100: Error: FND_FILE FAILURE unable to create file in the directory,/usr/tmp.

ORA-20100: Error: FND_FILE FAILURE unable to create file in the directory,/usr/tmp.

Concurrent requests are failed with the below error:

ORA-20100: Error: FND_FILE failure. Unable to create file, o0040178.tmp in thedirectory, /usr/tmp.
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 456
ORA-06512: at line 1

Upon checking below settings there is no issue :

1. The $APPLTMP, $APPLPTMP variables and UTL_FILE_DIR database parameter are valid and pointing to directory where there is enough space and users have written permission.
2. FND_FILE.PUT_LINE is able to create new files in the temporary directory.

FND_FILE.PUT_LINE Checking method:

SQL> exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

This should dump a file on APPLPTMP. If this test works, it would indicate that FND_FILE is ok and the problem is possibly with the Application.

You may want to leave only one entry on utl_file_dir for this test.

finally I checked the utl_file_dir, but there is no entry like /usr/tmp path in that list
SQL> connect / as sysdbaSQL> show parameter UTL_FILE_DIR

just I added /usr/tmp for the UTL_FILE_DIR & restarted the applications & database.

now the issue is resolved & concurrent requests are working fine

13 November 2010

What is FNDLOAD and how to use it?


What is FNDLOAD and how to use it?
FNDLOAD
when we are working in oracle application development/implementation project? The equally important AOL data Migration takes place necessary to synchronize the data across databases instance during installation and upgarde.
Using FNDLOAD can download data from an application entity into an editable text file, which can be uploaded to another database.The Conversion between database format and text file format is specified by a configuration file.
What can be Done?
·It can be done following list
· Concurrent Programs, Executables
· Request Groups, Request Sets
· Profile Options
· Key and Descriptive Flexfields
· Menus and Responsibilities
· Forms and Form Functions
· Attachments
· Messages
· Value Sets and Values
· Lookup Types
· User Responsibilities
· Printer Definitions
· FND Dictionary
· Help Configuration
· Document Sequences
· Concurrent Manager Schedules
Advantages when using FNDLOAD
1. Because downloaded data is stored in a text file, version administration is possible
2. No learning curve. this is relief for developer/dbas
3. Fully supported and recommended by Oracle
4. Capture the migrations in a file and use it during installations(log file).
5. Pin-point when something happened and where (database) easily
6. AOL data migration process is now simplified
!
Disadvantages
1. Applications patching mechanisms use FNDLOAD heavily possibility of negative impact is not zero
2. No validation against migrating database/instance sensitive data
The Syntax
To use FNDLOAD, the following syntax is needed.

FNDLOAD apps/appspwd 0 Y mode configfile datafile entity [parameter1.....]
· The mode is either DOWNLOAD or UPLOAD.
· The configfile is the file that Fndload needs to download on upload data.
· T he data file is the output file, in which the downloaded data is written
· The entity is the entity you want to download,
·
Example of download:
FNDLOADapps/pwd 0 Y DOWNLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt \ PROGRAM CONCURRENT_PROGRAM_NAME= concurrent_program_short_name> APPLICATION_SHORT_NAME=
application_short_name
Example of Upload
FNDLOAD apps/pwd 0 Y UPLOAD ${FND_TOP}/patch/115/import/afcpprog.lct myfile.ldt – CUSTOM_MODE=FORCE undocumented parameter
Where is Config File Located

· Configuration files with extension .lct
o On Unix – all the configuration files are in $FND_TOP/patch/115/import directory
o On Unix Oracle also places the original configuration files in $FND_TOP/admin/import directory
·Data files with extension .ldt
· The configfiles (.lct) are delivered and maintained by Oracle
· It has entity definitions, parent-child relationships and user input parameters identified by :NAME
oDownloading a parent automatically downloads all children – (Example) Concurrent Program download
Sample Script Code for these Objects :
1 – Printer Styles
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcppstl.lct file_name.ldt STYLE PRINTER_STYLE_NAME=printer style name
2 – Lookups
FNDLOAD apps/apps@seed115 O Y DOWN
LOAD $FND_TOP/patch/115/import/aflvmlu.lct file_name.ldt FND_LOOKUP_TYPE APPLICATION_SHORT_NAME=prod LOOKUP_TYPE=lookup name
3 – Descriptive Flexfield with all of specific Contexts
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt DESC_FLEX P_LEVEL=?COL_ALL:REF_ALL:CTX_ONE:SEG_ALL? APPLICATION_SHORT_NAME=prod DESCRIPTIVE_FLEXFIELD_NAME=desc flex name P_CONTEXT_CODE=context name
4 – Key Flexfield Structures
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/pa
tch/115/import/afffload.lct file_name.ldt KEY_FLEX P_LEVEL=?COL_ALL:FQL_ALL:SQL_ALL:STR_ONE:WFP_ALL:SHA_ALL:CVR_ALL:SEG_ALL? APPLICATION_SHORT_NAME=prod ID_FLEX_CODE=key flex code P_STRUCTURE_CODE=structure name
5 – Concurrent Programs
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_name.ldt PROGRAM APPLICATION_SHORT_NAME=prod CONCURRENT_PROGRAM_NAME=concurrent name
6 – Value Sets
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_
name.ldt VALUE_SET FLEX_VALUE_SET_NAME=value set name
7 – Value Sets with values
FNDLOAD apps/apps@seed115 O Y DOWNLOAD $FND_TOP/patch/115/import/afffload.lct file_name.ldt VALUE_SET_VALUE FLEX_VALUE_SET_NAME=value set name

08 November 2010

error while loading shared libraries: libmodapi.so: cannot open shared object file: No such file or directory

I have stated the APEX i am getting below error
Error:-
[oracle@samtest bin]$ ./opmn startall
./opmn: error while loading shared libraries: libmodapi.so: cannot open shared object file: No such file or directory
[oracle@samtest bin]$

Solution:-
please export below env

[oracle@samtest bin]$ export ORACLE_HOME=/backup/SOABPEL/product/10.1.3.1/OracleAS_1/
[oracle@samtest bin]$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/opmn/lib
[oracle@samtest bin]$ export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin


[oracle@samtest bin]$ ./opmnctl startall
opmnctl: starting opmn and all managed processes...
[oracle@samtest bin]$./opmnctl status

Processes in Instance: SOABPEL.samtest.acecranes.com
---------------------------------+--------------------+---------+---------
ias-component                    | process-type       |     pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group          | OC4J:oc4j_soa      |    9697 | Alive
OC4JGroup:default_group          | OC4J:home          |    9698 | Alive
ASG                                           | ASG                |     N/A | Down
HTTP_Server                             | HTTP_Server        |    9696 | Alive
[oracle@samtest bin]

28 October 2010

adbldxml.pl DB tier errors out: FOLLOWING ERROR OCCURED : 3 >= 3

adbldxml.pl DB tier errors out: FOLLOWING ERROR OCCURED : 3 >= 3

The critical error i faced during the upgrade database to 11.2.0 from 9.2.0.5 in oracle Applications 11.5.10.2

Error during adbldxml.pl on Database Tier

FOLLOWING ERROR OCCURED :

3 >= 3


StackTrace:
java.lang.ArrayIndexOutOfBoundsException: 3 >= 3
at java.util.Vector.setElementAt(Vector.java:505)
at oracle.apps.ad.context.GenerateContext.setJRETOP(GenerateContext.java:7471)
at oracle.apps.ad.context.GenerateContext.InstantiateRestForDB(GenerateContext.java:3045)
at oracle.apps.ad.context.GenerateContext.main(GenerateContext.java:8138)



Cause for this issue:
  • GenerateContext.java Release reported in the logfile is 115.87
  • Latest version of GenerateContext.java is 115.103
You need to apply the patch 4709948 in the apps Tier using the tnsnames.ora and listener.ora just we created during the upgrade process in latest RDBMS_ORACLE_HOME (11.2.0)


once applied the patch, synchronize the DB Tier with Apps Tier using admkappsutil.pl from $AD_TOP/bin

Run adbldxml.pl from db Tier now. The error should not appear now.

27 October 2010

ERROR: OPatch failed because of Path problem.

[oracle@muthu 2615271]$ /oracle/NEW/newdb/9.2.0/OPatch/opatch apply
PERL5LIB=/oracle/NEW/newdb/9.2.0/Apache/perl/lib/5.00503:/oracle/NEW/newdb/9.2.0/OPatch/perl_modules; export PERL5LIB
/oracle/NEW/newdb/9.2.0/Apache/perl/bin/perl /oracle/NEW/newdb/9.2.0/OPatch/opatch.pl apply

OPatch Version 1.0.0.0.48
Perl Version 5.00503

/oracle/NEW/newdb/9.2.0/OPatch/opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.

Some commands below are not in your path:
  Command= fuser
  Path= /oracle/NEW/newdb/9.2.0/Apache/perl/bin:/oracle/NEW/newdb/9.2.0/bin:/usr/bin:/usr/sbin:
/oracle/NEW/newdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:
/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin

ERROR: OPatch failed because of Path problem.
[oracle@muthu 2615271]$ which fuser
/usr/bin/which: no fuser in (/oracle/NEW/newdb/9.2.0/Apache/perl/bin:/oracle/NEW/newdb/9.2.0/bin:
/usr/bin:/usr/sbin:/oracle/NEW/newdb/9.2.0/jre/1.4.2/bin:/usr/ccs/bin:/bin:/usr/bin/X11:
/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin)
[oracle@muthu 2615271]$ find / -type f -name fuser
[oracle@muthu 2615271]$ su
Password:
[root@muthu 2615271]# find / -type f -name fuser
/sbin/fuser
[root@muthu 2615271]# exit
exit
[oracle@muthu 2615271]$ vi /oracle/NEW/newdb/9.2.0/NEW_muthu.env

[oracle@muthu 2615271]$ . /oracle/NEW/newdb/9.2.0/NEW_muthu.env

[oracle@muthu DBupdate]$ cd 4167403/
[oracle@muthu 4167403]$ /oracle/NEW/newdb/9.2.0/OPatch/opatch apply
PERL5LIB=/oracle/NEW/newdb/9.2.0/Apache/perl/lib/5.00503:/oracle/NEW/newdb/9.2.0/OPatch/perl_modules; export PERL5LIB
/oracle/NEW/newdb/9.2.0/Apache/perl/bin/perl /oracle/NEW/newdb/9.2.0/OPatch/opatch.pl apply

OPatch Version 1.0.0.0.48
Perl Version 5.00503

Oracle Home = /oracle/NEW/newdb/9.2.0
Location of Oracle Inventory = /oracle/NEW/newdb/9.2.0/inventory
Oracle Universal Installer shared library = /oracle/NEW/newdb/9.2.0/oui/lib/linux/liboraInstaller.so
Path to Java = /oracle/NEW/newdb/9.2.0/jre/1.4.2/bin/java
Location of Oracle Inventory Pointer = /etc/oraInst.loc
Location of Oracle Universal Installer components = /oracle/NEW/newdb/9.2.0/oui
Required Jar File under Oracle Universal Installer = jlib/OraInstaller.jar


Please shut down Oracle instances running out of this ORACLE_HOME
(Oracle Home = /oracle/NEW/newdb/9.2.0)
Is this system ready for updating?
Please respond Y|N >
y
Patching...
Updating inventory...
/oracle/NEW/newdb/9.2.0/OPatch/opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.


OPatch succeeded.
[oracle@muthu 4167403]$

20 October 2010

Oracle Application R12.1.1 inactive manager error

inactive manager error

[oracle@balaji scripts]$ ps -ef |grep FNDLI
oracle    7411  3765  0 11:27 pts/2    00:00:00 grep FNDLI
[oracle@balaji scripts]$

Use sqlplus, login as APPLSYS
SQL>update fnd_concurrent_queues set running_processes=0;

go to your sidappl dirctory and
ls *.env
run APPSSID*.env
-cd $COMMON_TOP/admin/scripts/*
sh adstpall.sh apps/apps this will sto apps tire
-run the follwoing file form the same path adautocfg.sh
then start every thing up by runing adstrtal.sh apps/apps

[oracle@balaji scripts]$ ps -ef |grep FNDLI
oracle   14318 14313  0 01:48 pts/1    00:00:00 FNDLIBR                                                                                                                                               
oracle   14593 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14594 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14595 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                       
oracle   14596 14472  0 01:48 ?        00:00:00 FNDLIBR                                                                                                                                                                                                                                        
oracle   15185   953  0 01:50 pts/1    00:00:00 grep FNDLI
[oracle@balaji scripts]$