Automatic Shared Memory Management problem ?

Uncategorized
| Mar 14, 2013
From time to time one of out 10g databases (10.2.0.5) seems to 'hang' Our monitoring shows a 'time out' on different checks and when trying to connect using sql, the sql session is hanging. No connection is possible. A few days ago, something like this happened again. Instead of bouncing the database, I decided to look for clues to find out why the database was 'hanging'. The server itself did

Missing controlfiles ?

Uncategorized
| Dec 10, 2012
During the backup check this morning, I noticed something strange.. The backup logfile was showing the following error :

Oracle OEM 12c unzipping…..

Uncategorized
| Oct 17, 2011
I decided to download the OEM12c software from Oracle to install the new OEM.After downloading the software, I had some trouble unzipping the two files.The files downloaded where :- em12_linux_x86_disk1of2.zip- em12_linux_x86_disk2of2.zipWhen unzipping the files, the following error occurred :[oracle@localhost software]$ unzip em12_linux_x86_disk2of2.zipArchive: em12_linux_x86_disk2of2.

Oralce eBS R12 Financials Cookbook

Uncategorized
| Oct 11, 2011
Last week I was reading a Oracle eBS R12 Financials Cookbook. This book is written for Oracle functional eBS specialists. The book describes the most important processes in financials, and how to execute those processes. For example, voiding a payment. The book is showing screen prints of how to do this in R12. Not only is the book using screen pints from R12, but also a step by step explanation

Oem Agent not starting anymore..

Uncategorized
| Jan 3, 2011
This morning I noticed a database down in our OEM application. I also received an email from the inicident, so I decided to look into this problem. I found a sollution very quick. It seemed the dbsnmp password of the target database was not valid anymore. So I changed the password in OEM, configured the target again en the problem was solved...But then the agent stopt running and was producing al

Concurrent request error

Uncategorized
| Oct 29, 2010
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

Configure Oracle dbconsole…

Uncategorized
| Sep 28, 2010
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 foundThe 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

Oracle webcache and Oracle eBS 11i….

Uncategorized
| Sep 9, 2010
I have installe Oracle webcache 10.1.2.3.0 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.1Using the webcache I am able to login the 11i application, but when starting a

Read/Write NTFS on my MacBook Pro

Uncategorized
| Aug 12, 2010
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

Agent blocked….

Uncategorized
| Aug 6, 2010
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.00Number of XML files pending upload : 199Size of XML files pending

Incomplete restore….

Uncategorized
| Jul 13, 2010
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

Oracle.exe on Windows

Uncategorized
| Apr 7, 2010
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

Cloning eBS environment on windows….

Uncategorized
| Mar 31, 2010
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"F:\oracle\behdb\9.2.0\appsutil\log\beh_smdbp02\adcrdb.txt"ECHO is off.ECHO is off.Creating the control file

Happy Xmas to everybody !!!!!

Uncategorized
| Dec 25, 2009

Login problems R12

Uncategorized
| Dec 4, 2009
On our R12 eBS environment we are facing a problem when loggin in. It does not happen all the time, because we use more then one web node (loadbalancer), but when trying to acces the login page the following error is shown..."Unable to generate forwarding URL. Exception: oracle.apps.fnd.cache.CacheException"or a blank page is shown instead of the login page. In the applications.log file ($

Missing AppsLogin.jsp…

Uncategorized
| Aug 24, 2009
I am still facing the same problem with my R12 upgrade.When running the post install checks using Rapidwiz , only the JSP and the Login page show errors.For jsp I see 'JSP not responding, waiting 15 seconds and retesting'and the Login Page shows 'RW-50016: Error. -{0} was not created. File= {1}'The strange thing is that all other checks are oke. Even the /OA_HTML/help check !So, the problem is

R12 upgrade

Uncategorized
| Aug 23, 2009
I Finally upgraded my 11.5.10.2 environment to R12.I followed the steps mentioned in the different upgrade guides. What do I have runing right now ?- Oracle eBS 12.0.6- Oracle database 10.2.0.4- Oracle tech stack (old ora directory) 10.1.2.3.0- Oracle tech stack (old iAS directory) 10.1.3.4.0So, having no problems during the upgrade proces, I finished starting al services. When trying to login my

R12 upgrade

Uncategorized
| Aug 2, 2009
Finally I started my owm R12 uprgade last week.I installed 11.5.10.2 on Oracle Linux 5, so I could upgrade this environment to R12.At this moment I am installing the upgrade pacth for R12. After installing the vision environment 11i, I used the rapidwiz to create the R12 environment on that same machine.I will post al the upgrade steps when I am finished upgrading...

Removing Credentials from a Cloned EBS Database

Uncategorized
| Jun 25, 2009
During the post clone actions, changing the apps pasword went wrong. Because of that the applsys and apps password were not the same anymore. Trying to fix the problem using FNDCPASS was useless, FNDCPASS was not working anymore.We saw 'APP-FND-02704: Unable to alter user APPS to change password.' in the log file. After trying it again, 'APP-FND-02704: Unable to alter user APPLSYS to change

OEM problem solved…

Uncategorized
| Apr 29, 2009
The OEM problem with the http server not startign is solved. We solved the problem by installing an older version of the package libdb.so.2 (for Suse 10 install older version of 1_db).After this the http server started and I was able to continue the install.At the end of the install again a http error...[Wed Apr 22 11:41:33 2009] [error] mod_ossl: Unknown error[Wed Apr 22 11:41:37 2009] [error]