Hostname in Oracle Enterprise Linux 7 anpassen – hostnamectl

In Oracle Enterprise Linux 6 konnte man den Hostname beispielsweise mit Tools wie system-config-network oder durch editieren vom /etc/sysconfig/network File anpassen. In der Version 7 kann der Hostname mit dem Tool hostnamectl geändert werden. Ein Editieren vom Network-File funktioniert nicht mehr, der Hostname wird aus dem File /etc/hostname abgeleitet. Auszug aus den Oracle Enterprise Linux 7 Release Notes – https://docs.oracle.com/cd/E52668_01/E53499/html/section-bbw-bzj-4n.html: Nebst hostnamectl gibt es mit Tools für den NetworkManager wie nmtui und nmcli weitere Möglichkeiten, den Hostname anzupassen. Anzeigen vom Hostname mit hostnamectl Neben dem eigentlichen Hostname werden noch Zusatzinformationen der Plattform angezeigt. Das gute alte hostname Kommando funktioniert natürlich weiterhin. [root@bern ~]# hostnamectl Static hostname: bern.martinberger.com Icon name: computer-vm Chassis: vm Machine ID: ce02b4d58dda49e8be5cce2650782d5b Boot ID: c25fd1d532b64fe58296c50e61bd7fa3 Virtualization: vmware Operating System:…

Read More

Oracle Enterprise Manager 13c – KILL SESSION for Application Administrators – Part 1

Basically to execute a ALTER SYSTEM KILL SESSION command you have to be a) a DBA or b) you need the ALTER SYSTEM privilege. Granting the ALTER SYSTEM privilege to a Non-DBA has big risks. This user is now able to change a lot of parameters like memory parameters, NLS settings etc. In one of my projects, a small team of well known application administrators is having a read-only account in Enterprise Manager 12c to verify the performance, see the user sessions and many more of their subset of databases. And sometimes, they have to kill a hanging Oracle session. Until now they called the DBA: “Please do it for me”. Sure, we can build a small PL/SQL procedure on every database…

Read More

EM12c Agent – java.lang.OutOfMemoryError: Java heap space

After an AIX 7.1 server reboot, there was one agent which did not started. The command emctl start agent resulted in a java.lang.OutOfMemoryError: Java heap space message. In the agent subdirectory some dumpfiles were created: -rw-r—– 1 oracle dba 291373 Oct 19 11:00 javacore.20151019.110002.14876844.0002.txt -rw-r—– 1 oracle dba 22182281 Oct 19 11:00 heapdump.20151019.110002.14876844.0001.phd -rw-r–r– 1 oracle dba 167408 Oct 19 11:00 Snap.20151019.110002.14876844.0003.trc First I took a look in the agent logfiles to gather more information. /u00/app/oracle/product/agent12c/agent_inst/sysman/log/emdctlj.log 2015-10-19 10:59:11,711 [1:F7DA781F:main-16449708] INFO – EmdCtl Timezone = Europe/Zurich 2015-10-19 10:59:11,884 [1:F288756D:main-11600120] INFO – EmdCtl Timezone = Europe/Zurich 2015-10-19 10:59:13,584 [1:2CF29A0A] INFO – Disconnecting: client terminus 2015-10-19 10:59:13,585 [1:2CF29A0A] INFO – stdout: Status agent Failure:unable to connect to http server at https://srvaix111.mvn.ch:3874/emd/lifecycle/main/. [peer not aut henticated]…

Read More

cloud.oracle.com – Create a Storage Container for a Backup in the Cloud

Why to use the Oracle Backup  Cloud storage? During the instance creation process – the full deployed instance, not for the virtual machine – you can select if you want to store your database local or in the cloud – or both. The benefit to store a instance backup by RMAN in the cloud? Storage redundancy, easy access, full RMAN integration and with a service price of $33 / TB / Month it’s a real storage option. Here is the step where you can select the backup storage option. Information Gathering Before you can use this storage, you have to configure a storage container first. This can be done via REST command for example by a tool like curl. In…

Read More