Bas Klaassen

Nice feature for Oracle dba's to handle the backups using NetApp technology. Check this demo.. http://community.netapp.com/t5/FAS-Data-ONTAP-and-Related-Plug-ins-Articles-and-Resources/Video-NetApp-Plug-in-2-0-for-Oracle-RMAN-MML-Demo/ta-p/87711Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4

Today we encountered some performance problems at our customer site. After checking with the customer it seemed that especially the CIFS shares were having problems. At first CIFS was getting slower until the shares were not even accessible anymore. Restarting the CIFS on the filer did solve the problem for a few minutes, but within half an hour the the problems were back again.  Checking the /Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com4

Vanuit Proact organiseren wij het kennisplatform SYNC 2014 op 17 september in de Rotterdam Cruise Terminal. Alle hedendaagse IT-infrastructuurontwikkelingen in 1 dag: • Een interactief programma o.l.v. dagvoorzitter Lars Sørensen o.a. bekend van BNR • Een keynote van Marco Gianotten van Giarte, de Nederlandse “Gartner” op het gebied van Outsoucing/Managed Services • Huisman Equipment over de Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com3

We noticed the MGMT_TABLESPACE in our 12c Grid Control instance was very big. Almost 380gb of data was stored in this tablespace. Because of all the targets registered in this Grid Control instance and the frequent usage of this Grid Control, I did not think anything was wrong. Untill someone looked into this and found out it was a bug in 12c... Note 1502370.1 describes this bug and also the Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com34

This morning I will be taking the Oracle 12c database install/admin beta exam..Hoping I am well prepared for this three hour exam...Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com6

I was checking Oracle 12c again, because of a beta exam end of october, and noticed something strange. This time I decided to install 12c Grid software first to use the 12c ASM for the 12c database. After installing ASM, I tried to check the disks available in ASM... [oracle@localhost ~]$ . oraenvORACLE_SID = [oracle] ? +ASMThe Oracle base has been set to /opt/oracle[oracle@localhost ~]$ Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1

After creating the second pluggable database, next step is to connect to the pluggable databases and cretae a tablespace in one of them. Before connecting, be sure the pluggable databases are listed in the listener.ora.. LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5

Last week I downloaded the new Oracle 12c database to check this new feature called 'Plugable database'. Using the runnstaller I fist created the 12c database with the 'Create as container database' option enabled. After installing the database, I dicided to use the dbca to create another plugable database. So, there should be 2 plugable databases and one container database rightBas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com5

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 Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1

During the backup check this morning, I noticed something strange.. The backup logfile was showing the following error : Normal 0 21 false false false NL X-NONE X-NONE Bas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com2

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

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

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 alBas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com1

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 thisBas Klaassenhttp://www.blogger.com/profile/04080547141637579116noreply@blogger.com0

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

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

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

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

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

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