Opslag

HDI

 What have been learned! Overview: Creating a new Datawarehouse database using the combined data at HanRe.  This will be produced as an Oracle PDB database, based on an existing CDB.  After this it will be copied to HDI using an Azure Blob container, as no direct connection is allowed due to firewall rules.  Providing enough diskspace 7 Tb was allocated, a separate Oracle CDB and PDB will be created at HDI, which then will form the database which is to be copied over to T-Systems via a database link using the private VPN, where the final PDB will be created for Dev, Test and Production systems. Findings after initial run Conception Database setup should have been started as initial task! Contacts -- initial setup/koncept/discussion should have been made! No discussion of alternatives PDB  Azure Blob Obstacles Firewall as an obstacle HanRe => HDI HDI => T-Systems Azure Blob:  No real knowledge of this! HDI Datenbases "Has to be"  Encryption -- Por...

Oracle 19C, Linux update and migration

 dnf update && dnf upgrade && dnf autoremove Adapting /etc/hosts hostname -b  redhat9-o19.localdomain curl -o oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf tmp.sh :  dnf install -y bc binutils compat-openssl11 elfutils-libelf fontconfig glibc glibc-devel ksh libaio libasan liblsan libX11 libXau libXi libXrender libXtst libxcrypt-compat libgcc libibverbs libnsl librdmacm libstdc++ libxcb libvirt-libs make policycoreutils policycoreutils-python-utils smartmontools sysstat glibc-headers ipmitool libnsl2 net-tools nfs-utils gcc unixODBC tuned-profiles-oracle tigervnc-server vi /etc/selinux/config SELINUX=permissive tuned-adm profile oracle Enabled "tigervnc-server" for X usage (installat...