Infrastructure at your Service

All posts by William Sescu

William Sescu
Consultant

William Sescu has more than 17 years of IT experience, more than ten years in Oracle and Unix Consulting. He is specialized in Oracle Database High Availability, RAC Clusters, DataGuard, Backup/Recovery and Database Migrations. Besides that, he is also specialized in different Unix flavours, especially in Linux and Solaris, and also in virtualization technologies like VMware and Solaris Containers. In the OpenSource world, William Sescu is specialized in the areas of MySQL/MariaDB and Galera Clusters. William Sescu also is a Trainer for different disciplines like “Linux for Oracle DBS’s”, “Oracle RMAN”, “Oracle Flashback Techniques” and many more. Prior to joining dbi services, William Sescu was working as an Oracle Database Administrator for Amadeus Data Processing in Germany. William Sescu has two Oracle Master Degrees, one in Oracle 12c and one in Oracle 11g, and several Oracle Certified Expert certifications. Besides that, William Sescu is OCM MAA 12c. A certification, that only a few people worldwide have.
William Sescu

OUD 11.1.2.3 – ODSM Session Timeout

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

The ODSM is a quite powerful tool for managing the Oracle Unified Directory, and quite a lot of default settings are very reasonable. But there is one that disturbed me from the beginning. It is the ODSM Session Timeout. You might see a message like the following. Or maybe this one. It just says, that the page will expire unless a response is received within 2 minutes. Doing some complex searches or similar stuff often…

 
Read More
William Sescu

OUD 11.1.2.3 – How to create an OUD Start/Stop/Status script on Oracle Linux 6

By | Database Administration & Monitoring | No Comments

One of the questions that pops up immediately, after you have installed your OUD successfully is how to integrate it into the automatic startup routines of the OS. My example here show how to do it on Oracle Linux 6. On Oracle Linux 7 it looks a little different. Fortunately, Oracle delivers a script called “create-rc-script”, which can be found in your asinst home directory. It lets you specify the user name under which the…

 
Read More
William Sescu

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF) – Follow Up

By | Database Administration & Monitoring | No Comments

My blog about listener rotation caused some discussion, which is great. It sounds like an easy stuff, but in case of listener logging it isn’t. https://blog.dbi-services.com/oracle-12-2-how-to-rotate-the-12-2-listener-log-diag_adr_enabled_listener-off/ Many ways do exist to rotate the listener log, but I was trying to point out some issues, because there are a few, e.g. What happens when the log file reaches 4G? What are the performance implications? What happens if I move the listener.log while the listener is running…

 
Read More
William Sescu

Oracle 12.2 – How to run a consistent full database export with dbms_datapump and parallel degree of 8

By | Database Administration & Monitoring | 2 Comments

Nowadays, since the cloud is becoming more and more important, the PL/SQL API’s become more and more important too. Fortunately, Oracle has quite a lot of them. E.g. How do you run a Data Pump export if you have no ssh connectivity to the server? You could use the old exp tool, which is still available even with Oracle 12.2, or you can use DBMS_DATAPUMP. The Data Pump API is quite good documented in the…

 
Read More
William Sescu

Oracle 12.2 – How to rotate the 12.2 listener log (DIAG_ADR_ENABLED_LISTENER = OFF)

By | Database Administration & Monitoring, Database management | 6 Comments

The listener log file contains a lot of very useful information, like the program which was used for the connection, the IP address where the connection is coming from, the OS user which was used on the client  and many many more. 05-JUN-2017 12:36:19 * service_update * DBIT122 * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=(PROGRAM=sqlplus@dbidg01)(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42619)) * establish * DBIT122_SITE1_DGMGRL * 0 05-JUN-2017 12:36:19 * (CONNECT_DATA=(SERVICE_NAME=DBIT122_SITE1_DGMGRL)(UR=A)(CID=(PROGRAM=sqlplus@dbidg01)(HOST=dbidg01)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.201)(PORT=42620)) * establish * DBIT122_SITE1_DGMGRL * 0 However,…

 
Read More
William Sescu

OUD – Oracle Unified Directory 11.1.2.3, How to change the Java version of OUD 11.1.2.3 with Weblogic and ODSM

By | Application integration & Middleware, Database Administration & Monitoring | No Comments

In this blog, I would like to show how to change the Java version used by OUD and WebLogic, in case you use the ODSM. The OUD (Oracle Unified Directory) is written purely in Java, not like OID for example, and so, it relies heavily on your installed Java version. From a security point of view, updating the Java version is a task that you might do frequently and you want to do it as…

 
Read More
William Sescu

Oracle 12cR2 – ORA-44777 – Pluggable database service cannot be started

By | Database Administration & Monitoring | No Comments

Have you ever experienced the following error? SQL> alter pluggable database pdb2 open; alter pluggable database pdb2 open * ERROR at line 1: ORA-44304: service does not exist ORA-44777: Pluggable database service cannot be started. The error says, that Oracle is not able to open the pluggable database because a service is missing. At least the default service, which is the name of the pluggable database itself should be there. But in my case, it…

 
Read More
William Sescu

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

By | Database Administration & Monitoring, Operation systems | No Comments

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow. Of course, you are not limited to these files. You can audit whatever you want. Maybe the sqlnet.ora, the /etc/oratab or Oracle wallets are of more interest in your environment. Before we start, we got…

 
Read More
William Sescu

Oracle 12c – Why you shouldn’t do a crosscheck archivelog all in your regular RMAN backup scripts

By | Database Administration & Monitoring | 3 Comments

Crosschecking in RMAN is quite cool stuff. With the RMAN crosscheck you can update an outdated RMAN repository about backups or archivelogs whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository (RMAN controlfile or RMAN catalog) still indicates that the logs are on disk, when in fact they are not. It is important to know, that the RMAN…

 
Read More