Friday, October 29, 2010

Concurrent request error

A concurrent request was running into an error. The following error was shown in the logfile of the request.

APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM, because the environment variable &BASEPATH is not set for the application to which the concurrent program executable &EXECUTABLE belongs.

I noticed the $CUSTOM_TOP variable was not set, but after setting this variable the same error occurred. 

Then I noticed something strange, the $XXX_TOP was not set in the environment. After adding this top to the adovars.env (to test the request), the concurrent request ended without error.

Tuesday, September 28, 2010

Configure Oracle dbconsole...

For a 10g database I wanted to check something in the database console. When trying to start this console, I received the following error : OC4J Configuration issue. Oracle/ora102/oc4j/j2ee/OC4J_DBConsole_.local_ not found

The ORACLE_HOME is a shared one, meaning different databases use the same ORACLE_HOME. So, because of this there were some other directories but not the one I needed. I decided to configure the dbconsole for this database using the emca tool. ./emca -config dbcontrol db

STARTED EMCA at Sep 27, 2010 10:38:38 AM

EM Configuration Assistant, Version Production

Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information:

Database SID:

Listener port number: 1521

Password for SYS user:

Password for DBSNMP user:

Password for SYSMAN user:  

Email address for notifications (optional):

Outgoing Mail (SMTP) server for notifications (optional): ----------------------------------------------------------------- You have specified the following settings Database ORACLE_HOME ................ /oracle/ora102 Database hostname ................

Listener port number ................ 1521

Database SID ................

Email address for notifications ...............

Outgoing Mail (SMTP) server for notifications ............... -----------------------------------------------------------------

Do you wish to continue? [yes(Y)/no(N)]: Y

Sep 27, 2010 10:43:24 AM

oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /oracle/ora102/cfgtoollogs/emca/wtcgo/emca_2010-09-27_10-38-38-AM.log. Sep 27, 2010 10:43:27 AM oracle.sysman.emcp.util.DBControlUtil startOMS

INFO: Starting Database Control (this may take a while) ... Sep 27, 2010 10:45:02 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: Database Control started successfully Sep 27, 2010 10:45:02 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration

INFO: >>>>>>>>>>> The Database Control URL is http://host.domain:5503/em <<<<<<<<<<<

Enterprise Manager configuration completed successfully

FINISHED EMCA at Sep 27, 2010 10:45:02 AM

After this the dbconsole was running and I was able to check something for the customer.

Thursday, September 09, 2010

Oracle webcache and Oracle eBS 11i....

I have installe Oracle webcache to act as a reverse proxy server for our Oracle eBS environments.
After installing the webcache, I used note 380486.1 to configure webcache for our R12 environments. Now, we can use the webcache url to enter the R12 application.
For our 11i environments I used note 306653.1
Using the webcache I am able to login the 11i application, but when starting a forms session I see the following error

'You don't have permission to access /pls//fnd_icx_launch.launch on this server.'

What is going on here ???

Thursday, August 12, 2010

Read/Write NTFS on my MacBook Pro

Today I tried to start my virtual linux machines (created in vmware workstation on windows to install/upgrade eBS environments) on my MacBook Pro. I downloaded a trial version of Vmware Fusion. When trying to start a virtual machine, Vmware would show me the following error 'Read only file system' and the machine would not start. It seemed I could not write to the folders containing the Vmware files. So, this is a Mac problem ?

It seems my Mac cannot work with the NTFS filesystem on my external disk. To solve the problem I downloaded the following file 'ntfs-3g-2010.5.22-macosx.dmg' from
After installing the file, I was able to open my virtual machines on my MacBook Pro.

Friday, August 06, 2010

Agent blocked....

In our 11g Grid Control I noticed an agent that was not uploading any data to the oms anymore.
When checking the status of the agent I noticed the following:

Last successful upload : (none)
Last attempted upload : (none)
Total Megabytes of XML files uploaded so far : 0.00
Number of XML files pending upload : 199
Size of XML files pending upload(MB) : 50.03
Available disk space on upload filesystem : 28.80%
Collection Status : Disabled by Upload Manager
Last attempted heartbeat to OMS : 2010-08-06 11:11:46
Last successful heartbeat to OMS : unknown

So, it seems to be disabled by the upload manager ??? When forcing an upload using the '
./emctl upload agent' it showed the 'oms version not checked' error. Because this a very common error, I decided the focus on the 'disabled by upload manager' error.

It seemed the agent was blocked for some reason. To fix this problem I did the following :

1. In Grid Control 11g go to Setup->agents-> Misconfiguration Alerts and Blocked Agents

You will see the 'blocked' agent in this section.

2. Go the home page of the blocked agent and in the right upper corner press the button 'Resynchronize'
3. When succesful go back to the setup page in step 1.
4. Unblock the agent
5. force an upload on the command line..

./emctl upload agent
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
EMD upload completed successfully

The agent is up and running again.

Tuesday, July 13, 2010

Incomplete restore....

Yesterday I was asked to help during a restore/recovery operation of the eBS datbase. Before restoring the dba'er removed the original database (rm *). After restoring the database files from the backup abd trying to start the database, we noticed the database did not to start because he could not find his redo log files. It seemed the redo log files were not in the backup, and therefore not restored.

Database was brought down before the backup (cold backup), no redo logs and no archivelogs available.
Because the dba already tried to start the database, we had to restore it again.
After the second restore I tried to open the database using a new control file. I used the backup controlfile to trace option to create the controlfile creation script.
After the controlfile was created and the database mounted, I still could not see the new logfiles on disk ? I noticed the redolog files are created when opening the database using the resetlogs option ( alter database open resetlogs).
So, database is up again.

Wednesday, April 07, 2010

Oracle.exe on Windows

So, I solved my last problem. Deleting the registry entry of NLS_LANG solved the problem. After this, the open database also showed me the NLS error again. I decided to start again with another environment, maybe the source was the problem ;)

With a new set, I ran into another problem...the database service cannot be started.

DIM-00019: Create Service Error

The Oracle Service service terminated with service-specific error 997

So, why can't I create this service anymore ???
It does create an entry in the registry....

Wednesday, March 31, 2010

Cloning eBS environment on windows....

For a new project I am working with Oracle eBS 11i on the windows platform. When cloning an environment using rapidclone, the database clone is showing me an error. When the clone is trying to create a new controlfile, the following error is shown :

The log information will be written to
ECHO is off.
ECHO is off.
Creating the control file for beh database ...
ECHO is off.
SQL*Plus: Release - Production on Wed Mar 31 12:51:21 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ORA-12705: invalid or unknown NLS parameter value specified

ORA-01031: insufficient privileges

The Oracle service on windows is started, but when I try to connect using sql..

F:\oracle\behdb\9.2.0>sqlplus /nolog
SQL*Plus: Release - Production on Wed Mar 31 14:03:12 2010
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn / as sysdba

ORA-12705: invalid or unknown NLS parameter value specified

So what is going wrong here ?? I have checked the NLS settings. They look the same as the ones in the source db. In the registry only the NLS_LANG is set.
I also tried creating the Oracle service by starting it with the pfile, but still the same error...
I am still looking for a solution...