tag:blogger.com,1999:blog-299891072012-01-20T10:25:14.284+01:00Read what's life like as an Oracle eBS Dba...Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.comBlogger1901100tag:blogger.com,1999:blog-29989107.post-19885119261814838312011-10-17T14:03:00.002+02:002011-10-17T14:16:13.463+02:00

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.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5tag:blogger.com,1999:blog-29989107.post-56661751302106832282011-10-11T11:22:00.003+02:002011-10-11T11:57:28.247+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com12tag:blogger.com,1999:blog-29989107.post-16143984625469767982011-01-03T11:42:00.002+01:002011-01-03T12:26:43.641+01:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-682676902401662382010-10-29T13:44:00.002+02:002010-10-29T13:53:56.487+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-50685058360376594152010-09-28T11:38:00.001+02:002010-09-28T11:46:23.624+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-84275800913169923542010-09-09T15:31:00.002+02:002010-09-09T15:43:33.875+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-44790100717549747092010-08-12T10:41:00.002+02:002010-08-12T10:57:23.920+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-89169423977556898232010-08-06T11:29:00.003+02:002010-08-06T11:43:41.952+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4tag:blogger.com,1999:blog-29989107.post-9042777647262547662010-07-13T09:32:00.002+02:002010-07-13T09:46:33.233+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-68661487098957635982010-04-07T10:09:00.003+02:002010-04-07T10:19:12.278+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-29039926736159123732010-03-31T14:04:00.002+02:002010-03-31T14:14:28.145+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-87625165652124610092009-12-25T12:40:00.001+01:002009-12-25T12:40:20.654+01:00

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-59087861932421343192009-12-04T13:39:00.004+01:002009-12-04T14:07:11.875+01:00

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 ($

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-65573190536846320582009-08-25T08:20:00.002+02:002009-08-25T08:35:52.127+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com15tag:blogger.com,1999:blog-29989107.post-49953053337564163902009-08-23T10:46:00.005+02:002009-09-14T13:52:51.267+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5tag:blogger.com,1999:blog-29989107.post-89595190896899760312009-08-03T08:04:00.000+02:002009-08-03T08:07:56.891+02:00

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...

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-84762681881160288462009-06-25T11:40:00.002+02:002009-06-25T12:02:37.215+02:00

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

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-36106380059532228822009-04-29T10:19:00.002+02:002009-04-29T10:28:22.243+02:00

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]

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-49405066325456932812009-04-20T13:43:00.002+02:002009-04-20T13:49:21.885+02:00

I am facing a problem....Again I am trying to install OEM10gR2 on SUSE LINUX 10.I know it's not certified by Oracle, but I have to install it anyway. Everything seems to go fine, but when the installer wants to start the opmn services...it returns an error.The HTTP_SERVER is not starting, the following error is in the logfile..Cannot load /opt/oracle/product/oem/oms10g/Apache/Apache/libexec/

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-41213483720099819342009-02-09T09:34:00.003+01:002009-02-09T11:19:26.028+01:00

Because of a problem in Oracle Emailcenter I had to create a trace file of my web session.Here are the steps taken :This process can be used to trace any action, anywhere in Oracle Applications and be very useful for the Self-Service Web Applications as there is no utility defined like in the Forms.a. First make sure the necessary profile has the proper permissions. 1. Log onto the Applications

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-66419802220976685802009-01-13T09:45:00.002+01:002009-01-13T09:50:02.263+01:00

It is still two months ahead us, but I already signed up for this session. Amis is presenting the EBS and SOA session on 19 March. The session is located in Nieuwegein and is in dutch.So, if you are living in the Netherlands and interested in eBS and SOA, check the Amis site !!http://www.amis.nl/activiteiten.php?id=682&preview=&draft=

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-39258263195004453322008-12-25T09:55:00.002+01:002008-12-30T07:58:07.460+01:00

I want to wish everybody a merry X'mas and a very good 2009 !!!!

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-44945638958962569032008-12-09T09:57:00.005+01:002008-12-09T10:10:38.966+01:00

We have a lot off forms users in out eBS environment. Because of this there are also a lot of forms sessions running for a long time. I use the Oracle Application Manager to check the current forms sessions and kill them when running for more then 10 hours....In OAM the forms sessions screen looks like this..This print is taken from a test environment, but in the production environment you will

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-61665514668684702702008-11-24T08:43:00.002+01:002008-11-24T08:46:32.515+01:00

And again I am able to offer a 10% discount on any PrepKit from Ucertify.Just go to the site and use the following discount code 'BASK10'. Good luck with your certification...

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-90121459412149145012008-11-19T08:45:00.006+01:002008-11-20T08:09:05.077+01:00

'A Practical guide to planning and implementing SOA Integration and Re-architecting to an Oracle platform'Last week I recieved the book 'Oracle Modernization Solutions' from Packt Publishing. I was asked to review this book. The book is written by Tom Laszewski and Jason Williamson. The book describes different ways to modernize your business IT. The book is a technical dive on two approaches for

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-80374732588972541202008-11-03T09:14:00.002+01:002008-11-03T09:17:49.392+01:00

This morning I arrived at work, as a freelance Oracle eBS Dba. Did I notice anything different ? Not yet, but it sure feels good !

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5tag:blogger.com,1999:blog-29989107.post-68851354282680169392008-10-30T08:00:00.002+01:002008-10-30T08:12:06.294+01:00

Packt, an online book shop will be publishing more than a dozen Oracle titles in 2009. In order to better understand what information the Oracle community wants, they are looking at which topic areas and tools users would like to see covered. Therfore they created a short survey which can be found here https://www.surveymonkey.com/s.aspx?sm=QPlgF94Ha5Q_2fkNiHBvIzaw_3d_3dandSo, check it out and

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-41538736546570241852008-10-14T10:49:00.002+02:002008-10-14T10:53:32.984+02:00

Another great experiment from Steven Chan. A single page with all the certifications for eBS !! Normally I visit Metalink to check if a certain combination is certified, but it takes a few clicks before I see the result.Now all the eBS certifications are bundeled in one site. Great !Check the site yourself...http://blogs.oracle.com/stevenchan/certifications.html

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-24888063122814788002008-09-25T08:55:00.004+02:002008-10-14T10:54:47.026+02:00

Because my former Amis colleques are again present at the OOW, I check the Amis blog every morning for Oracle news. This morning I noticed the following entry about a new oracle database Machine (hardware) called the Exadata Storage Server. So, after introducing their own OS (Oracle Enterprise Linux), they also created their own hardware to run the Oracle database. Check the Amis blog for more

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-20979627283683521662008-09-24T09:28:00.002+02:002008-10-14T10:55:06.452+02:00

a lot of new eBS 11i and R12 Certification Announcements on the Steven Chan site, check for 11i the following url http://blogs.oracle.com/stevenchan/archives11i.html, for R12 http://blogs.oracle.com/stevenchan/archives12.html

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-13431795212098482782008-09-10T15:33:00.006+02:002009-03-10T11:13:18.552+01:00

When cloning an eBS environment on Oracle Enterprise LInux 5, the following error is shown on both the db and app Tier.Checking for make... found - /usr/bin/makeChecking for ld... found - /usr/bin/ldChecking for cc... found - /usr/bin/ccChecking for ar... found - /usr/bin/arChecking for ksh...Unable to find 'kshell' in pathUnable to locate all utilities with system path. Looking in the clone

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-32898013456149016882008-09-10T11:54:00.004+02:002008-09-10T12:03:33.111+02:00

I decided to leave my current company and start my own. I have been thinking about contracting for a year now, and finally took the step. From 1-12-2008 I am working as a contractor Oracle eBS Dba. I already registered my company, called e-BSolutionsI looking forward to this new career move and will continue blogging....

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com6tag:blogger.com,1999:blog-29989107.post-6291733119004531112008-09-02T22:40:00.003+02:002008-09-02T22:48:15.753+02:00

Tonight I downloaded the new Google browser called Chrome. It is  a beta version , but I am going to try it anyway.Will eBS run in this new browser ?

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-88603055643389944612008-08-18T12:54:00.003+02:002008-08-18T13:15:54.425+02:00

Mohan Dutt, a.k.a. OCP Advisor, is presenting a new weekly feature on his OCP blog (http://ebizocp.blogspot.com). It is called 'Meet the Experts' and its' a Q/A with certain Oracle Certified professionals. I am proud to say that I was also asked to be part of this new feature. So, I delivered my certification experience and it will soon be on the OCP blog. So keep checking the OCP blog for the Q/

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-15749778743094248852008-08-15T09:25:00.003+02:002008-09-04T12:58:55.696+02:00

This morning I tested the sollution on another EBS 11.5.1.0.2 environment running on Oracle Linux 5. I also upgraded the database for this environment from 9i to 10.2.0.4, so it's also a test for Discoverer4i on 10gr2. I tried starting the disco processes using the default start script addisctl.sh from Oracle in the $COMMON_TOP/admin/script/ORACLE_SID. When the script tried to start the locator,

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-14173633210680222822008-08-14T19:02:00.002+02:002008-08-14T19:08:40.778+02:00

I solved the issue with Discoverer on Linux 5.I will post the workaround tomorrow, because I have to test it on another enviroment also. To get Discoverer working I had to edit some config files, change it back later on. Patch the disco libraries, undo the patch and so on. To get a good image of the sollution I want to test it on another Linux 5 EBS environment. The service request is still open

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-84435618710662570752008-08-13T09:18:00.003+02:002009-07-23T08:32:48.463+02:00

After I had the EBS 11.5.10.2 running on Oracle Linux 5, I noticed another problem.When trying to start the disco proces using addisctl.sh in the $COMMON_TOP/admin/scripts directory I noticed the following error :/oebs/pubtar21/pubtar21ora/8.0.6/jre1183o/lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)Unable to

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5tag:blogger.com,1999:blog-29989107.post-51197657912832857942008-08-07T14:43:00.004+02:002008-08-07T16:06:14.931+02:00

We have upgrade our Linux OS to Oracle Linux 5. We have 11i running on release 5, and today I tried to clone an EBS environment. At the beginning of the db_Tier the clone script runsinto an error.Enter the APPS password [APPS]:appsChecking for make... found - /usr/bin/makeChecking for ld... found - /usr/bin/ld Checking for cc... found - /usr/bin/cc Checking for ar... found - /usr/bin/ar Checking

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com8tag:blogger.com,1999:blog-29989107.post-18617725497482442702008-07-29T08:17:00.002+02:002008-07-29T09:07:38.522+02:00

I was asked to install an new NLS language on our excisting EBS environment. I had never done this before, usally the NLS is installed during a fresh install of EBS. This time I had to install the German language next to our US end NL languages.Installing a new language is one thing, I downloaded the German langugae cd from e-delivery. This is a patch that can be installed, so no problem so far.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-91435431802500589962008-07-23T08:54:00.002+02:002008-07-23T09:05:23.887+02:00

For some time now, I had some trouble with a database instance in OEM. The agent refused to upload his data to the OMS, giving me the Failed to upload file Bxxxxxx.xml, ret = -2 error. In the log file, the following error occurs :Thread-4595721 ERROR upload: Failed to upload file B0012907.xml, ret = -22008-07-23 Thread-4595721 WARN upload: FxferSend: received http error in header from

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-15647040976467005262008-07-22T10:14:00.003+02:002008-07-22T10:18:25.939+02:00

The problem mentioned before has been solved. Like most of us suspected, there was a synonym missing.SQL> select OWNER, SYNONYM_NAME 2 from all_synonyms 3 where synonym_name like 'MGMT_VIEW_UTIL';no rows selectedSQL> create public synonym MGMT_VIEW_UTIL FOR MGMT_VIEW_UTIL;Synonym created.After creating the synonym, the reports look fine. I believe this porblem was caused by the export/import

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-61819504884671539772008-07-18T08:57:00.009+02:002008-07-18T09:37:07.116+02:00

I am facing a strange problem. Three days ago I tried to run a report in OEM, a database Availability History report. I have to run this report every month for a customer, but this time the output showed an error !The report showed 'Error rendering element. Exception: ORA-00904: "MGMT_VIEW_UTIL"."ADJUST_TZ": invalid identifier'Checking Metalink didn't help me, it seems the error has something to

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com6tag:blogger.com,1999:blog-29989107.post-31071224318114376502008-07-16T09:04:00.002+02:002008-07-16T09:06:30.220+02:00

This morning I received an email from Oracle......The CPU july 2008 was released yesterday.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-1002681309252712132008-07-15T09:48:00.002+02:002008-07-15T09:53:48.213+02:00

After being gone for two weeks on a holiday in Spain, I was glad to find out I was able to continu the CPU April 2008 patches (first the ATG RUP5 patches had to be applied). So, right now I am patching different UAT environments. I also checked if the CPU 072008 was already announced so I could add the july pacthes, but I did not see any announcement on Metalink. Maybe at the time I am patching

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-73459029352793038462008-06-20T09:16:00.003+02:002008-06-20T09:31:18.716+02:00

The ORA-00600 from my previous post is solved. Also the notifications are being send again.The 'ORA-00600 [kwqidrdq: loop], [0], [0], [0], [0], [], [], []' error was shown in the EMD_NOTIFICATION.QUEUE_READY. Normally you receive this error wwhen records are deleted manually from queue tables, which is unsupported (also see note 1070715.6).The problem was solved by executing the following

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-47811817635231103512008-06-19T08:00:00.002+02:002008-06-19T08:11:49.217+02:00

After the export/import of the sysman schema, we recoverd almost 23G of disk space. But yesterday the /oem partition again was 100% full ????Analyzing the different diectories showed an udump directory with 23G of trace files !!!So, something is wrong with OEM. I also noticed no notifications were being send to me. The trace files showed me an ORA-00600 [kwqidrdq: loop], [0], [0], [0], [0], [], [

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com6tag:blogger.com,1999:blog-29989107.post-30863349039465303412008-06-17T16:26:00.004+02:002008-07-18T12:01:22.388+02:00

So, today I actually resized the OEM database. I resized the database from almost 40gb to 17 gb. In my recent post I already mentioned the emd_maintenance.partition_maintenance I used to cleanup old records in the mgmt_metrics_raw table (mgmt_tablespace). Problem was, I could not resize the datafile because of an ORA-03297: file contains used data beyond requested RESIZE value error. Two options

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-55520190239221241892008-06-13T10:24:00.003+02:002008-06-13T10:37:16.522+02:00

We noticed our Grid control (10.2.0.3.0) was not cleaning up his metrics. Because of this we are running out of disk space on the oem volume. I noticed the mgmt_tablespace was 27 gb. The table mgmt_metrics_raw had more then 410 million records. I also found out that almost 4 million records were older than sysdate -9. Oem should automaticly clean up these records after zeven days, so something

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4tag:blogger.com,1999:blog-29989107.post-87945400356873073032008-06-06T09:49:00.002+02:002008-06-06T09:53:00.386+02:00

Sometimes when surfing the internet you find something interesting. I don't know exactly how, but I arrived at the following site with a lot of handy guides for the dba or EBS dba. Check it out !http://www.solutionbeacon.com/tool_pocket.htm

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-71319283421576069302008-05-21T15:15:00.004+02:002008-05-21T15:28:28.100+02:00

This morning all the Oracle databases showed a 'down' status in OEM.Going through my emails, I noticed the that the targets (agents monitoring the databases) were facing some trouble uploading their data. I noticed the oem host was out of disk space...Usually this problem is solved when the *.trc files under $ORACLE_HOME/admin/SID/udump or $ORACLE_HOME/admin/SID/bdump are deleted, so that's what

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-75464675028412764802008-05-15T11:04:00.002+02:002008-05-15T11:12:52.954+02:00

Yesterday I was testing some recovery scenarios with a customer. We decided to restore a backup of a database from a month ago, and recover it to yesterday.Because the backup was one month old, we had to apply a lot off archived log files. First I just recovered using the suggested archives by entering. It took me more then 20 minutes to recover and open the database. SQL> recover database until

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-9110991517787024082008-05-14T09:20:00.002+02:002008-05-14T09:24:40.154+02:00

After writing a review for the Prepkit 10g OCP, uCertify posted some info about me on their own blog. http://www.ucertify.com/blog/bas-appraises-ucertifys-ocp-prepkit.htmlAlso they told me that anybody reading my blog can get a discount when buying any prepkit from uCertify. The discount will be 10%, all you have to do is use the following code "BASK10".So, check it out....

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1tag:blogger.com,1999:blog-29989107.post-14777557147346324942008-04-28T15:54:00.002+02:002008-04-28T15:57:35.604+02:00

Surfing my favorite EBS blogs, I saw something nice on the Online Apps DBA blog.It seems Oracle had developed a new Metalink. Looks a lot better then the old one, check it out for yourself !https://csm.oracle.com/CSP/ui/index.html

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-26025746141348085692008-04-21T13:39:00.002+02:002008-04-21T13:46:30.408+02:00

Today I started the Cpu patch April, 2008.I started with the RDBMS patch, followed by the HTTP patch. No problems so far, unfortunatly for me the EBS 11i patches I have to apply are not cummulative. I have to apply EBS 11i CPU patches from October 2005 till now...When applying so many EBS patches, something must be going wrong :)I will keep you posted.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4tag:blogger.com,1999:blog-29989107.post-47502730950800511282008-04-17T10:13:00.002+02:002008-04-17T10:19:09.355+02:00

During the post 11g upgrade steps, I discovered a new feature in 11g.In the 11g database, you can now create a pfile/spfile from memory ! I was used to create a pfile from the current spfile in 10g, and offcourse create a spfile from the adjusted pfile...but now it's also possible to creaet a pfile from memory. The syntax is almost the same..[oracle@ebs2 log]$ sqlplus '/ as sysdba'SQL*Plus:

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-69548031715790771252008-04-16T10:22:00.004+02:002008-04-17T10:13:06.507+02:00

After the database upgrade, you will have to perform some post upgrade steps like compiling invalid objects etc...These are the steps I have taken :1. verify upgrade by running utlu111s.sql[oracle@ebs2 admin]$ sqlplus /nologSQL*Plus: Release 11.1.0.6.0 - Production on Mon Apr 14 20:30:58 2008Copyright (c) 1982, 2007, Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-83753766145468022822008-04-15T08:58:00.003+02:002008-09-05T09:20:21.100+02:00

Last weekend I started the database upgrade from 10gr2 to 11gr1. As I mentioned before, I decided to manually upgrade the database. Before upgrading I already recieved an error.[oracle@ebs2 admin]$ sqlplus /nologSQL*Plus: Release 11.1.0.6.0 - Production on Thu Apr 10 08:19:14 2008Copyright (c) 1982, 2007, Oracle. All rights reserved.SQL> conn / as sysdbaConnected to an idle instance.SQL> startup

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-32612978341473200192008-04-09T15:51:00.006+02:002008-04-10T20:29:36.461+02:00

Next step is to install the 11g database software. Be sure to install the 11g software in a new ORACLE_HOME. Also, only install the software ! Do not create a new database and do not choose to upgrade the database during the install.After installing the software, create nls/data/9idata directory..[oracle@ebs2 old]$ perl cr9idata.plCreating directory /ebs/proddb/11.1.0/nls/data/9idata ...Copying

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5tag:blogger.com,1999:blog-29989107.post-83126354368045991842008-04-09T08:50:00.004+02:002008-04-09T13:27:01.038+02:00

Yesterday I started the 11g upgrade off my own EBS database (10gr2).Before doing anything with 11g, I first had to patch the EBS environment.The following EBS patches have been applied :1. Patch 3460000, 11.5.10 ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2 2. Patch 6328363, 11GR1 APPS INTEROPERABILITY PATCH 3. Patchset 5903765, 11i.ATG_PF.H.RUP6 After succesfully (allthough Gabor provided me

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-43963395333498853342008-04-08T17:32:00.003+02:002008-04-08T17:41:16.723+02:00

Today I started the database upgrade to 11g on my own EBS 11i environment.Because I did not patch my environment since the 10gr2 upgrade, the first patch to apply on my EBS environment is patch 3460000 'ORACLE E-BUSINESS SUITE CONSOLIDATED UPDATE 2'After this patch I have to install the 11g Release 1 interoperability patch for 11.5.10....At this moment the CU2 is still running. To be continued...

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-37137520672265595612008-04-01T10:23:00.002+02:002008-04-01T10:41:43.819+02:00

We are working with 10g Grid Control (10.2.0.3) for a few months now and we noticed a problem with the notifications from OEM. It seemed OEM was holding back a lot of notifications. I could not find any error in OEM, and because some notifications did reach us by email, the email setup was oke.According to note 285093.1 I installed the EMDiagkit to examine the problem.Running the following

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-32665728999180322962008-03-28T10:41:00.004+01:002008-04-01T10:22:52.481+02:00

I was aked to evaluate the uCertify prep kit oz10-034. Because I am studying for the o1z0-043 exeam anyway, I thought it would be usefull to test the prep kit. For the OCA exam, I only used the OCA study quide from Sybex. For the OCP exam, I also used the Sybex study guide, but also th euCertify prepkit.I must say, the prepkit looks fine to me. It's a user friendly tool, with a lot of options to

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-14521061030822894332008-03-26T14:08:00.001+01:002008-03-26T14:11:15.351+01:00

Today 11g certification for EBS 11i was announced on the Steven Chan blog. See http://blogs.oracle.com/schan/2008/03/26#a2532 for more info..

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-87657522671755673852008-03-14T13:30:00.005+01:002008-03-14T15:27:55.583+01:00

For a demo, I installed Oracle EBS on a laptop with Oracle Linux version 4.Because the consultants take thelaptop with them during the demo, and I am not present at that demo, I wanted the Oracle EBS to start when the laptop was turned on and also stopped when the laptop was turned off...Starting Oracle EBS at laptop startup was not that kind of a problem. I just created a script in the /etc/rc.d

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-1678890106590289002008-03-12T09:54:00.003+01:002008-03-12T10:08:45.639+01:00

On the Oracle Insight blog I found this interesting site : the Oracle White papers siteA nice site with a lot of white papers concerning Oracle..You have to register yourself before accessing the white papers.Enjoy !!

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-58512958604461929252008-03-06T09:28:00.003+01:002008-03-06T12:00:15.814+01:00

Last week I received an email from uCertify. This company creates preparation kits for different certification programs, like Oracle OCP Dba....They noticed my blog and asked me if I was willing to review one of their preparation kits and share my experience with this prep kit. Because I am studying for my OCP 10g, I agreed and yesterday I received the registration key for the 1Z0-043 PrepKit.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-31825370833483004502008-03-04T15:53:00.002+01:002008-03-04T16:10:32.100+01:00

We cloned an Oracle EBS enviroment to a laptop for demo purposes. We installed Oracle Enterprise Linux 4, and cloned an excisting EBS environment. After I got the EBS running, I tried to access the application from the linux laptop. But there was one problem, Jinitiator only works with windows. So, I was able to download the jini.exe, but could not execute it. Another way to work with the Oracle

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4tag:blogger.com,1999:blog-29989107.post-85258176958229275352008-02-29T11:33:00.002+01:002008-02-29T11:43:37.705+01:00

Yesterday evening I visited an Amis query about performance. Speaker this time was Gerwin Hendriksem from Amis, a real performance freak. He designed his own approach for solving performance problems, and it was a good session. Gerwin used Oracle data mining to spot performance issues. He gathered system data for more then a year and using data mining to analyze and predict the bottlenecks. He

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-79342073148295778962008-02-21T09:35:00.002+01:002008-02-21T09:42:11.493+01:00

Because we moved our new OEM10gr2 server to the datacenter, the IP address and the hostname changed. When added to the datacenter I had to start all the services again, but first I had to change the opmn configuration. Instead of changing all the config files by hand, I noticed a shell script in the $OMS_HOME/chgip/scripts, called chgiphost.shThis script changes all the config files and replaces

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com7tag:blogger.com,1999:blog-29989107.post-63453984693405276582008-02-15T10:26:00.002+01:002008-02-15T10:47:16.708+01:00

Yesterday I decided to add a windows host to my Oracle 10gr2 Grid. The 10gr2 Grid control is running on Oracle Enterprise Linux release 4.5I downloaded the windows agent 10.2.0.3 and installed this agent on the windows machine. After installing I checked my OEM site to see if the target was already discovered....I did not see the windows host, so I decided to check the windows agent log files.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-3874341116808608492008-02-05T10:54:00.000+01:002008-02-05T11:14:04.621+01:00

This morning I faced an issue with the concurrent managers in a production environment.After bouncing the database because of a memory fault, I decided also to startup the concurrent managers again.But after starting them, using the start script in the $COMMON_TOP/admin/scripts, the application showed me no concurrent managers ?? Checking the logfile of the internal manager for errors...APP-FND-

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-69577305859765667762008-02-01T15:53:00.000+01:002008-02-01T16:13:39.695+01:00

The last two days I have been busy installing and upgrading Grid control 10g.Because of problems wth an older version of OEM 10g , we decided to install a new version (10gr2). On a new dell server I installed Oracle Enterprise Linux release 4 (update 6). After installing linux, I started the 10.2.0.1 Grid install.Next step was the 10.2.0.3 upgrade of the oms and agent. I also decided to upgrade

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-81258935781655613552008-01-24T15:21:00.000+01:002008-01-24T15:34:52.619+01:00

When trying to compile a package using plsql developer in a 9.2.0.1 Oracle database, the developer ran into an ORA-00600 error. The error is generated in plsql developer and looks like this... This problem can easily be fixed when bouncing the database, but the problem was that this production database could not be stopped. I had to find another way to solve this.Could it be they are using a

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-78161737614028824152008-01-22T15:32:00.000+01:002008-01-22T15:56:17.992+01:00

A customer wanted to know how a certain record in their EBS database was updated. A colleque of mine decided to use logminer to find out what happened to that specific record.Using logminer, all changes in our archived logfiles are written to the v$logmnr_contents and you can query this view using sql statements.So, how does it work ? We choose the online catalog variant..(see Meatlink note

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-35401804550584891192008-01-18T08:30:00.000+01:002008-01-18T08:40:59.848+01:00

For a colleague ( an Oracle EBS functional consultant), I had to install 2 EBS environments on a hard disk (500gb). Using vmware, he would be able to play around, or use the the environments for a demo. I already created both environments using vmware workstation, but decided it would be better to use vmware server. Because vmware server cannot work with the already created workstation

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-74335656391817819562008-01-11T09:07:00.000+01:002008-01-23T13:00:19.424+01:00

I have been tagged.....three times already :). Gareth Roberts , OCP Advisor and Atul Kumar tagged me.Following the rules of this new tagging feature among Oracle bloggers, I shuold now blog 8 things about myself and tag other Oracle bloggers. Look here for the rules.So 8 things about myself you don't know already....Publish Post1. My name is actually Bastiaan2. I have a seasons ticket for Ajax

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-37133748652323633012008-01-10T09:17:00.000+01:002008-01-10T09:48:20.484+01:00

Monday evening I was told a company needed some help recovering an important database.They were not able to get the database back online. The next morning, after the 'oke' from my manager, I visited the company. It seemed the just moved to a new building, stopped all servers and started them again in the new building. The Oracle Dba who used to work over there was gone, so nowbody really knew

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com8tag:blogger.com,1999:blog-29989107.post-49469499488358768652008-01-04T11:15:00.000+01:002008-01-04T11:29:29.300+01:00

Yesterday I started cloning an EBS environment. After running the preclone, I started copying the enviroment on our netapp filer.After the environment was copied, I started the actual clone.But when adcfgclone is trying to create my new controlfile, the following error is reported in my alert.log..Fri Jan 4 10:30:01 2008scumnt: failed to lock /oebs/pubtst22/pubtst22db/9.2.0/dbs/lkPUBTST22

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-31684826447045764062007-12-27T15:14:00.000+01:002007-12-27T15:18:10.407+01:00

Just before the new year, I found this site...https://mix.oracle.com/We all know Linkedin or Plaxo. Now Oracle has it's own network site (beta..)Check it out and login using your Oracle sso account (otn account)

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-37514942097546847882007-12-19T12:00:00.000+01:002007-12-19T12:05:14.223+01:00

Today I received an email from Oracle in which they announced the Oracle EBS R12 Applications DBA Beta Exam. This exam is open to register and this beta period runs from January 03 – April 04, 2008The exam is called :Oracle EBS R12: Install, Patch and Maintain Applications [1Z0-238]This new exam is required as part of earning the new Oracle EBS R12 Applications Database Administrator Certified

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-72618428266240643222007-12-12T09:04:00.000+01:002007-12-12T09:14:22.254+01:00

We had a problem using OEM 10g. During the day a database proces (ora_j001) was consuming 100% cpu. Because of this OEM coud not be reached, oms down. Looking for a solution, I ran into the job_queue_processes database parameter. This parameter was set to 10 in our database. I searched the net and could only find out that the value of this parameter should be > 0, if you want to use OEM.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-88804600603055235662007-12-10T12:56:00.001+01:002007-12-13T09:29:46.248+01:00

So after turning off the colors in the 'ls' command on linux, I also had to deal with the colors using vi...When reading a logfile for example, the file is presented in 5 or 6 different colors..To turn off these colors edit the following file (as root).../usr/share/vim/vim60/macros/vimrcIn this file you will see the following lines: " Switch syntax highlighting on, when the terminal has colors"

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-82640607787763059922007-12-07T10:47:00.000+01:002007-12-07T11:04:08.826+01:00

This week I started my new job with Smartapps. The first thing I usually do is check out the excisting EBS environments. I also did the same starting here...When starting a putty session on one of the EBS nodes, I noticed the different colors when using the ' ls' or 'll' commando. I find it very annoying, so I decided with my new colleagues to remove this.I found this was caused by the use of

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-8109897543958118482007-12-07T09:12:00.000+01:002007-12-07T09:19:48.946+01:00

a few months ago, I had an EBS R12 poll on my blog. The question was if anyone already upgrade their EBS environemnt from 11i to R12. The results of the poll showed me that nobody had upgraded or was going to...For those who are planning to upgrade their 11i environment, Steven Chan has writen an article abouot this on his blog.Check it out !! http://blogs.oracle.com/schan/2007/11/29#a2268

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-26216691207872287652007-11-27T09:26:00.000+01:002007-11-27T09:37:39.979+01:00

Today is my last day at the customer site. I am leaving Amis after almost two years. Last Friday I had diner with my customer colleagues. Almost everyone of them is external. Because I had a great time working with them I decided to place some pictures of Friday night on this blog. In the following order you see : René Kuss, Siwa Soekhoe, Robbert Wolters and Ali Akgurbuz. Missing on the photos is

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-54202677363431234592007-11-14T13:44:00.000+01:002007-11-14T14:14:29.377+01:00

Today I installed to Trace Analyzer (note 224270.1 from Metalink) to see if this tool could make my trace files easier to read.You can download the tool from Metalink in zip format (trca.zip)Install the tool...unzip the trca.zip filein the trca directory start a sqlplus session as sysdba...[oracle@vamisux32 trca]$ sqlplus /nologSQL*Plus: Release 9.2.0.6.0 - Production on Sat Nov 10 17:02:08

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4tag:blogger.com,1999:blog-29989107.post-36064215370656225162007-11-13T10:35:00.000+01:002007-11-13T10:39:52.799+01:00

Oracle announces a new Oracle Virtual Machine..Instead in vmware (for example), you can now use the Oracle VM.Read all about it in this article...http://www.oracle.com/corporate/press/2007_nov/ovm-ga-111107.html?msgid=5803830

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-28736521446869569032007-11-09T09:41:00.000+01:002007-11-09T09:49:14.126+01:00

Some time ago I created my own EBS Dba home page. This homepage is a collection off all the links I once visited because of my work as an EBS Dba. So, maybe there are some use full links for you also...and if you are missing a link..let me know and I will place it on the homepage.url EBS Dba homepage http://oappsdba.jouwpagina.nl/

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-27055493566007407382007-11-07T12:03:00.000+01:002007-11-07T13:00:32.360+01:00

From my great colleague Siwa Soekhoe I received the following tip.After we had cloned an EBS environment (11.5.9), it seemed some application users were missing some or all responsibilities they had in the original environment.When checking the EBS, you could see the responsibilities were granted to the specific application users. No end date, nothing strange in the application.So, why don't they

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-2353502128633069792007-10-23T08:36:00.000+02:002007-11-01T08:39:38.156+01:00

I noticed Oracle Applications Manager has some very handy sql script you can use when monitoring your EBS environment.When starting up OAM, navigate to Site Map ----> Monitoring ----> SQL ExtensionsThe following scripts are available...There is also a way to add your own personal sql scripts to this page. When you follow the steps mentioned in Metalink note 216816.1, you will find your own

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-3504870060725907052007-10-22T07:20:00.000+02:002007-11-01T08:40:14.483+01:00

After two weeks laying down on my back because of a back injury, I started at work today.I did not post anything the last two weeks because I could not sit down to do it :)Hope things will be better from now on...

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-34571334863242130572007-10-04T09:32:00.001+02:002007-11-01T08:40:54.971+01:00

Yesterday I noticed an announcement on Metalink of the 'Maintenance wizard' for the EBS R12 upgrade.I had no idea what the Maintenance wizard looked like, or what it was supposed to do.So, I decided to install the latest full version (2.05) of this wizard.The wizard can be installed by downloading patch 6398371 from Metalink.According to note 329476.1, this version only runs with a 10g database

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-16878061863647103292007-10-03T10:12:00.000+02:002007-11-01T08:42:15.763+01:00

I have added a survey to see how the readers of this blog feel about certain subjects concerning Oracle EBS..

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-87636435340310095072007-09-25T10:59:00.000+02:002007-11-01T08:42:31.638+01:00

So, yesterday I wrote my first guest post for the EBS OCP/OCE certification blog.Check the blog for more interesting posts....http://ebizocp.blogspot.com/

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2tag:blogger.com,1999:blog-29989107.post-10418857400214713352007-09-25T10:56:00.000+02:002007-11-01T08:42:46.511+01:00

After waiting a few weeks, I finally received the OCA certificate....

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-75889829226530006652007-09-18T09:31:00.000+02:002007-11-01T08:43:01.245+01:00

A colleague blogger of mine, Mohan Dutt, asked me to write some posts on his own blog.His blog (http://ebizocp.blogspot.com/) is about Oracle EBS OCP and OCE. Very interesting stuff. I accepted his invitation and agreed to write some posts for his blog.I am going to share my OCE and OCP experience with his blog readers also....So, be sure to visit his blog also.

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-89813280041387249012007-09-11T09:48:00.000+02:002007-11-01T08:43:19.120+01:00

a simple tip I ran into at work.We were working on a jinitiator upgrade (1.3.1.25 to 1.3.1.28), and the upgrade must be tested on both test and production environment.How can we be sure only a few people will test the new jinitiator, while the rest is still working with the old jinitiator ??The answer is easy. By using a profile option at user level.The profile is : 'ICX: Forms Launcher ' , and

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0tag:blogger.com,1999:blog-29989107.post-41141964176321227662007-08-20T08:27:00.000+02:002007-11-01T08:43:38.673+01:00

This morning I was asked to look at a EBS login problem.The customer received the following error when logging in :oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = AppsConnectionManager.appsInitialize(int,int,int,int,Connection):-1,-1,-1,0,oracle.jdbc.driver.OracleConnection@1d12d84; REASON = java.sql.SQLException: ORA-20001: Oracle error -

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3tag:blogger.com,1999:blog-29989107.post-60362218087247823002007-08-07T22:56:00.000+02:002007-08-07T23:04:02.894+02:00

Today I passed the 1z0-042 exam, Oracle Database 10g: Administration I.One step closer to OCP EBS Dba...The next exam will be Oracle Database 10g: Administration II, the final one to become a OCP Dba 10g. Offcourse, there is also the hands on after both exams, but first I will try to pass the OCP exam. After preparing for the OCA exam, it's now time for a holiday. I will be gone for a week,

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com8tag:blogger.com,1999:blog-29989107.post-88194636814992712522007-07-25T11:04:00.000+02:002007-07-25T11:36:33.448+02:00

During the bootcamp and the SSO setup, I ran into some errors when trying to log in Oracle EBS.One of the problems you can encounter is that the redirection to your SSO login page is not working. To find out what's the problem you can check the following :1. Is OID running ? You can log on to OID using the orcladmin account, http://as10g.test.com:7779/oiddas2. Is the iAS10g for your SSO running ?

Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1