Oracle 19C, Linux update and migration

  1.  dnf update && dnf upgrade && dnf autoremove
  2. Adapting /etc/hosts
  3. hostname -b  redhat9-o19.localdomain
  4. 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
  5. dnf -y localinstall oracle-database-preinstall-19c-1.0-1.el9.x86_64.rpm
  6. /sbin/sysctl -p /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf
  7. tmp.sh : 
    1. 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
  8. vi /etc/selinux/config
    1. SELINUX=permissive
  9. tuned-adm profile oracle
  10. Enabled "tigervnc-server" for X usage (installation of Oracle)
    1. needed to get X going:
      1. "yum group install GNOME base-x Fonts"
      2. systemctl start vncserver@:13 
  11. Download: oracle-database-ee-19c-1.0-1.x86_64.rpm
    1. yum localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
      1. "install done!"
    2. vi  /etc/sysconfig/oracledb_ORCLCDB-19c.conf
    3. root: "export CV_ASSUME_DISTID=OL7"
        1. ... from log file.....
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB1.log" for further details.  Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.

  1. After a LOT of issues... the solution is as follows:

# Fix for linking error suggested by Steven Kennedy.
cd $ORACLE_HOME/lib/stubs
mv libc.so libc.so.hide
mv libc.so.6 libc.so.6.hide 
  1. oracle@redhat9o19 dbhome_1]$ unzip -q ~/Downloads/p6880880_190000_Linux-x86-64.zip
  2. [oracle@redhat9o19 dbhome_1]$ cd patches/37260974/ 
  3. [oracle@redhat9o19 37260974]$ opatch apply 
  4.  Mismatch errors in cloned PDB in restricted mode (Doc ID 2964459.1)

    5.             --- run the script, close the PDB and reopen .. and done!

Database Express:
    to see data:
        ALTER SYSTEM SET control_management_pack_access="diagnostic+tuning" scope=both ;

Kommentarer

Send en kommentar

Populære opslag fra denne blog

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...
Læs mere