Infrastructure at your Service

All posts by Michael Schwalm

Michael Schwalm
Consultant

Michael Schwalm a deux ans d'expérience en administration de bases de données Oracle. Il possède de bonnes connaissances  dans la mise en place d’infrastructures de virtualisation comme VMware vSphere, et a fait ses premiers pas dans l'administration de bases de données en tant qu'intégrateur d'applications web en environnements Unix, Oracle et Websphere. Michael Schwalm est Oracle Certified Professional 11g. Avant d'entrer chez dbi services, Michael Schwalm était administrateur d'applications chez SOGETI Est (F) pour le compte de PSA Peugeot Citroen et avait en charge la création et la gestion d'environnements Unix et de bases de données Oracle dans le cadre de projets de migration. Michael Schwalm dispose d'un BTS Informatique de Gestion, option Administrateurs de Systemes et Réseaux, obtenu à Belfort (F) et d'un diplome de TSAR (Technicien Supérieur Administrateur de Réseaux) obtenu au CESI de Strasbourg (F) par alternance. Son expérience professionelle couvre les secteurs d'activité suivants: industrie automobile, édition de logiciels, banque, etc.
Michael Schwalm

Oracle OPatch and “Archive not applied” error

By | Database management | One Comment

Recently, I have installed an Oracle 11.2.0.4 RDBMS on a server, and I wanted to install the latest Patch Set Update (PSU) 11.2.0.4.4 from October 2014. During the execution, I fell on the error “Archive not applied” and the job failed. This is how to quickly fix this issue. While installing the PSU 11.2.0.4.4 from October 2014 on my Oracle 11.2.0.4 database server, I experienced the following error: The following actions have failed: Archive not…

 
Read More
Michael Schwalm

Oracle Grid Infrastructure: fixing the PRVG-10122 error during installation

By | Database management | 2 Comments

Making errors is human and when you configure a new Oracle Grid Infrastructure environment (especially one with a large number of nodes), mistakes can happen when configuring ASMLIB on all nodes. If you get an error looking like”PRVG-10122 : ASMLib configuration…does not match with cluster nodes”, there is a simple solution to fix it. When you are installing Grid Infrastructure, the following error can occor in cluvfy output or directly in the pre-requisites check step…

 
Read More
Michael Schwalm

How to remap tablespaces using Oracle Import/Export Tool

By | Database management | One Comment

Since Oracle 10g, Oracle provides a great tool to import and export data from databases: Data Pump. This tool offers several helpful options, particularly one that allows to import data in a different tablespace than the source database. This parameter is REMAP_TABLESPACE. However, how can you do the same when you cannot use Data Pump to perform Oracle import and export operations? I was confronted with this issue recently, and I had to deal with…

 
Read More
Michael Schwalm

Oracle policy managed databases: Policies and policy sets

By | Database management | One Comment

In this post, I will continue my experiments with Oracle policy managed databases with Grid Infrastructure, and present one of the new features introduced with Grid Infrastructure 12c last June: the cluster configuration policies and policy sets. It allows the administrator to dynamically reconfigure all server pools at a time, with a single command, according to the business workload. To take a simple example, imagine you have two servers allocated for your production instances, and…

 
Read More
Michael Schwalm

Implementing policy-managed Oracle databases

By | Database management | No Comments

Policy-managed databases appeared with Oracle 11g R2 but are not very common yet. I never had the opportunity to administer these kind of databases. Since Oracle now presents policy-databases as the default installation mode and as a best practice, I wanted to know more about this feature which fully automatizes the databases repartition within an Oracle cluster. In this post, I will describe how to implement and handle policy-managed databases, and in a future post…

 
Read More
Michael Schwalm

Oracle TNS_ADMIN issues due to bad environment settings

By | Database management | 2 Comments

Recently, I faced a TNS resolution problem at a customer. The reason was a bad environment setting: The customer called the service desk because of a DBLINK pointing to a bad database. The users were supposed to be redirected to a development database, and the DBLINK was redirecting to a validation database instead. The particularity of the environment is that development and validation databases are running on the same server, but on different Oracle homes, each…

 
Read More
Michael Schwalm

Troubleshooting: ORA-29283 when oracle is member of a group with read/write privileges

By | Database management | 6 Comments

Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and consolidated with existing databases. Several jobs are running into the database and need to access the file system to read or write some files. A particular file is received daily from a remote job over…

 
Read More
Michael Schwalm

Oracle LOBs: Infer the file type with dbms_lob package

By | Application integration & Middleware | 3 Comments

LOBs (Large OBjects) first appeared in Oracle 7 and were created to store large amount of data such as document files, video, pictures, etc. Today, we can store up to 128 TB of data in a LOB, depending on the DB_BLOCK_SIZE parameter settings. In this posting, I will show you how to load LOB files into the Oracle database and will present a way to identify the file type of the LOB stored in the…

 
Read More
Michael Schwalm

Oracle 12c: Applying PSU 12.1.0.1.1 with Multitenant DB & unplug/plug

By | Database management | No Comments

The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is that it is now possible to unplug a container database (called PDB) from its original container (called CDB), in order to plug it into a new local or remote Container with a higher level of PSU….

 
Read More
Michael Schwalm

Oracle Grid Infrastructure 12c: Binaries installation

By | Operation systems | One Comment

In a previous article, I have shown how to configure two servers in order to deploy a two-nodes 12c cluster. This time, I am going to describe the Grid Infrastructure 12c installation process using Oracle Universal Installer (OUI). We assume that cluvfy tool has returned no errors (see previous blog). Install Grid Infrastructure Connect as grid and launch the Oracle Universal Installer (OUI) from /software/grid: $ /software/grid/runInstaller.sh Starting Oracle Universal Installer… Checking Temp space: must…

 
Read More