Showing posts with label 18c. Show all posts
Showing posts with label 18c. Show all posts

Nov 1, 2018

Oracle Database 18c: Installation via rpm (without runInstaller.sh)

Three months after writing the post Where to find the oracle-database-ee-18c-1.0-1.x86_64.rpm package? Oracle released the rpms on their download page:


https://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle18c-linux-180000-5022980.html

So let's give it a try.


First thing is to install the prerequisites:
# yum install oracle-database-preinstall-18c


...
=================================================================================================================================================
 Package                                      Arch                 Version                                        Paketquelle              Größe
=================================================================================================================================================
Installieren:
 oracle-database-preinstall-18c               x86_64               1.0-1.el7                                      ol7_latest                18 k
Als Abhängigkeiten installiert:
 bc                                           x86_64               1.06.95-13.el7                                 ol7_latest               114 k
 bind-libs                                    x86_64               32:9.9.4-61.el7                                ol7_latest               1.0 M
 bind-utils                                   x86_64               32:9.9.4-61.el7                                ol7_latest               204 k
 compat-libcap1                               x86_64               1.10-7.el7                                     ol7_latest                17 k
 compat-libstdc++-33                          x86_64               3.2.3-72.el7                                   ol7_latest               190 k
 glibc-devel                                  x86_64               2.17-222.el7                                   ol7_latest               1.1 M
 glibc-headers                                x86_64               2.17-222.el7                                   ol7_latest               678 k
 gssproxy                                     x86_64               0.7.0-17.el7                                   ol7_latest               108 k
 kernel-headers                               x86_64               3.10.0-862.9.1.el7                             ol7_latest               7.1 M
 keyutils                                     x86_64               1.5.8-3.el7                                    ol7_latest                53 k
 ksh                                          x86_64               20120801-137.0.1.el7                           ol7_latest               881 k
 libICE                                       x86_64               1.0.9-9.el7                                    ol7_latest                66 k
 libSM                                        x86_64               1.2.2-2.el7                                    ol7_latest                39 k
 libX11                                       x86_64               1.6.5-1.el7                                    ol7_latest               606 k
 libX11-common                                noarch               1.6.5-1.el7                                    ol7_latest               163 k
 libXau                                       x86_64               1.0.8-2.1.el7                                  ol7_latest                28 k
 libXext                                      x86_64               1.3.3-3.el7                                    ol7_latest                38 k
 libXi                                        x86_64               1.7.9-1.el7                                    ol7_latest                40 k
 libXinerama                                  x86_64               1.1.3-2.1.el7                                  ol7_latest                13 k
 libXmu                                       x86_64               1.1.2-2.el7                                    ol7_latest                70 k
 libXrandr                                    x86_64               1.5.1-2.el7                                    ol7_latest                27 k
 libXrender                                   x86_64               0.9.10-1.el7                                   ol7_latest                25 k
 libXt                                        x86_64               1.1.5-3.el7                                    ol7_latest               172 k
 libXtst                                      x86_64               1.2.3-1.el7                                    ol7_latest                20 k
 libXv                                        x86_64               1.0.11-1.el7                                   ol7_latest                18 k
 libXxf86dga                                  x86_64               1.1.4-2.1.el7                                  ol7_latest                18 k
 libXxf86misc                                 x86_64               1.0.3-7.1.el7                                  ol7_latest                19 k
 libXxf86vm                                   x86_64               1.1.4-1.el7                                    ol7_latest                17 k
 libaio-devel                                 x86_64               0.3.109-13.el7                                 ol7_latest                12 k
 libbasicobjects                              x86_64               0.1.1-29.el7                                   ol7_latest                25 k
 libcollection                                x86_64               0.7.0-29.el7                                   ol7_latest                40 k
 libdmx                                       x86_64               1.1.3-3.el7                                    ol7_latest                15 k
 libevent                                     x86_64               2.0.21-4.el7                                   ol7_latest               208 k
 libini_config                                x86_64               1.3.1-29.el7                                   ol7_latest                62 k
 libnfsidmap                                  x86_64               0.25-19.el7                                    ol7_latest                49 k
 libpath_utils                                x86_64               0.2.1-29.el7                                   ol7_latest                27 k
 libref_array                                 x86_64               0.1.5-29.el7                                   ol7_latest                26 k
 libstdc++-devel                              x86_64               4.8.5-28.0.1.el7_5.1                           ol7_latest               1.5 M
 libtirpc                                     x86_64               0.2.4-0.10.el7                                 ol7_latest                88 k
 libverto-libevent                            x86_64               0.2.5-4.el7                                    ol7_latest               8.2 k
 libxcb                                       x86_64               1.12-1.el7                                     ol7_latest               210 k
 lm_sensors-libs                              x86_64               3.4.0-4.20160601gitf9185e5.el7                 ol7_latest                41 k
 mailx                                        x86_64               12.5-19.el7                                    ol7_latest               244 k
 net-tools                                    x86_64               2.0-0.22.20131004git.el7                       ol7_latest               305 k
 nfs-utils                                    x86_64               1:1.3.0-0.54.0.1.el7                           ol7_latest               407 k
 psmisc                                       x86_64               22.20-15.el7                                   ol7_latest               140 k
 quota                                        x86_64               1:4.01-17.el7                                  ol7_latest               178 k
 quota-nls                                    noarch               1:4.01-17.el7                                  ol7_latest                90 k
 rpcbind                                      x86_64               0.2.0-44.el7                                   ol7_latest                59 k
 smartmontools                                x86_64               1:6.5-1.el7                                    ol7_latest               460 k
 sysstat                                      x86_64               10.1.5-13.el7                                  ol7_latest               310 k
 tcp_wrappers                                 x86_64               7.6-77.el7                                     ol7_latest                78 k
 unzip                                        x86_64               6.0-19.el7                                     ol7_latest               169 k
 xorg-x11-utils                               x86_64               7.5-22.el7                                     ol7_latest               113 k
 xorg-x11-xauth                               x86_64               1:1.0.9-1.el7                                  ol7_latest                29 k
Aktualisiert für Abhängigkeiten:
 libstdc++                                    x86_64               4.8.5-28.0.1.el7_5.1                           ol7_latest               303 k

Transaktionsübersicht
=================================================================================================================================================
Installieren   1 Paket  (+55 Abhängige Pakete)
Aktualisieren           (  1 Abhängiges Paket)
...
These packages are installed on a minimal Oracle Linux system.

After that i started the installation of the rpm database package:
 [root@localhost oracle]# yum install -y oracle-database-ee-18c-1.0-1.x86_64.rpm 
Geladene Plugins: ulninfo
oracle-database-ee-18c-1.0-1.x86_64.rpm wird untersucht: oracle-database-ee-18c-1.0-1.x86_64
oracle-database-ee-18c-1.0-1.x86_64.rpm wird zum Installieren markiert
Abhängigkeiten werden aufgelöst
--> Transaktionsprüfung wird ausgeführt
---> Paket oracle-database-ee-18c.x86_64 0:1.0-1 markiert, um installiert zu werden
--> Abhängigkeitsauflösung beendet

Abhängigkeiten aufgelöst

=============================================================================================================
 Package                       Arch          Version       Paketquelle                                 Größe
=============================================================================================================
Installieren:
 oracle-database-ee-18c        x86_64        1.0-1         /oracle-database-ee-18c-1.0-1.x86_64        7.8 G

Transaktionsübersicht
=============================================================================================================
Installieren  1 Paket

Gesamtgröße: 7.8 G
Installationsgröße: 7.8 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installieren     : oracle-database-ee-18c-1.0-1.x86_64                                                 1/1 
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-18c configure
  Überprüfung läuft: oracle-database-ee-18c-1.0-1.x86_64                                                 1/1 

Installiert:
  oracle-database-ee-18c.x86_64 0:1.0-1                                                                      

Komplett!

The documentation says about the configurtion:


and

 [root@localhost oracle]# /etc/init.d/oracledb_ORCLCDB-18c configure
Configuring Oracle Database ORCLCDB.
DB-Vorgang vorbereiten
8 % abgeschlossen
Datenbankdateien werden kopiert
31 % abgeschlossen
Oracle-Instanz wird erstellt und gestartet
32 % abgeschlossen
36 % abgeschlossen
40 % abgeschlossen
43 % abgeschlossen
46 % abgeschlossen
Erstellen von Datenbank wird abgeschlossen
51 % abgeschlossen
54 % abgeschlossen
Integrierbare Datenbanken werden erstellt
58 % abgeschlossen
77 % abgeschlossen
Aktionen nach Abschluss der Konfiguration werden ausgeführt
100 % abgeschlossen
Erstellen der Datenbank abgeschlossen. Einzelheiten finden Sie in den Logdateien in:
 /opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Datenbankinformationen:
Globaler Datenbankname:ORCLCDB
System-ID (SID):ORCLCDB
Weitere Einzelheiten finden Sie in der Logdatei "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log".

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.
and a last check with sqlplus:
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 - Production on Thu Nov 1 11:21:50 2018
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Verbunden mit: 
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0

SQL> set lines 200
SQL> set pages 200
SQL> select * from v$instance;

INSTANCE_NUMBER INSTANCE_NAME     HOST_NAME                              VERSION        VERSION_LEGACY    VERSION_FULL    STARTUP_ STATUS       PAR    THREAD# ARCHIVE
--------------- ---------------- ---------------------------------------------------------------- ----------------- ----------------- ----------------- -------- ------------ --- ---------- -------
LOG_SWITCH_WAIT LOGINS       SHU DATABASE_STATUS     INSTANCE_ROLE        ACTIVE_ST BLO     CON_ID INSTANCE_MO EDITION FAMILY
--------------- ---------- --- ----------------- ------------------ --------- --- ---------- ----------- ------- --------------------------------------------------------------------------------
DATABASE_TYPE
---------------
          1 ORCLCDB      localhost.localdomain                          18.0.0.0.0    18.0.0.0.0          18.3.0.0.0    01.11.18 OPEN          NO       1 STOPPED
        ALLOWED    NO  ACTIVE         PRIMARY_INSTANCE   NORMAL    NO       0 REGULAR     EE
SINGLE

If you do not want to set a database with other options, you have to skip the
/etc/init.d/oracledb_ORCLCDB-18c configure
Just run the dbca and set up the options as you want.

Jul 30, 2018

Where to find the oracle-database-ee-18c-1.0-1.x86_64.rpm package?

After writing about the release of Oracle database 18c i wanted to download
oracle-database-ee-18c-1.0-1.x86_64.rpm
to try the rpm-based installation.
But this rpm is not included in
LINUX.X64_180000_db_home.zip
The oracle documentation shows:
 But on OTN and Delivery Cloud only the zipfile without the rpm can be downloaded...

So let's see, when the download pages are updated...

(Three months later: https://dietrichschroff.blogspot.com/2018/11/oracle-database-18c-installation-via.html)

Jul 25, 2018

Oracle 18c database is released for Linux (on premise)

After my posting nearly a week ago about the published 18c documentation on monday the binaries for Oracle 18c database were released:


and

 Here the link to the download page: oracle.com

In one of the next postings i will try a rpm installation...

Jul 16, 2018

Oracle Database 18c: Documentation released!

Today i surfed to docs.oracle.com and there i found the documentation for oracle database 18c:


In march 2018 i wrote about the new installation procedure of oracle database 18c via rpm, which was announced inside the "new features".

The installation guide for Linux contains now the commands for installing the database via rpm. Here a screencopy of chapter 11:
 rpm -ivh oracle-ee-db-18.1.0.0.0-1.x86_64.rpm
This command creates the Oracle home at the location /opt/oracle/product/18.0.0.0.0-1/dbhome_1.
Cool!

The next step is to run the dbca:
7 The screen displays information that prompts you to create a database by using Oracle Database Configuration Assistant (Oracle DBCA) in silent mode.
[...]
8 Log in as the oracle user and run Oracle DBCA in silent mode to create the database.
[...]
Oracle DBCA creates the Oracle Database listener, the Oracle Database instance, starts the instance, and completes the Oracle Database creation process. Review the status information that is displayed on your screen.

Here the link to docs.oracle.com chapter 11 "Running RPM Packages to Install Oracle Database".

Jul 2, 2018

Oracle Database Software Downloads: 18c released

Ok - not the database binaries but the Oracle Database 18c Release 1 Client is released:

Only for windows and linux - not really suprising, but that shows, which platforms are well supported ;-)

The documentation can be found here.


The documentation is for solaris, too - but without binaries this sounds a little bit strange:

Mar 3, 2018

Oracle database 18c: Installation via RPM

After the release of 18c i did a short dive into the "guide to new features" announced on oracle.com:

 And take a look, what can be found in "Database Overall -> Install, config, and patch":


RPM-based Database Installation
RPM-based Database Installation (RDI) enables an RPM-based installation of the Oracle Database software. Using the rpm-ivh command, an RPM-based database installation performs the preinstallation validations, extracts the packaged software, reassigns the ownership of the extracted software to the preconfigured user and groups, maintains the Oracle inventory, and executes all the root operations required to complete the Oracle Database software installation.
RPM-based Database Installation enables you to leverage an RPM framework to easily deploy Oracle Database.
A kind of rpm installation was introduced for the installation of grid infrastructure in 12.2 (oracle documentation): Image based installation
So no worries, you have to start the runInstaller.sh after rpm -i. But let's see, how you have to specify the Oracle_Home in this rpm-process.

EDIT: On 20th july 2018 the documentation is released. See here.
EDIT2: October 2018: Installation done via rpm

Feb 20, 2018

Oracle Database 18c released! Image-based Installation?

Today i discovered on otn.oracle.com --> database:

The downloads-page looks like the last weeks - 12c is the default...

... but the documentations tab lists 18c:

blogs.oracle.com shows the following:


So the "cloud first" strategy is still in place (by the way: is this something like "america first"?).

The installation procedure looks strange:
Starting with Oracle Database 18c, installation and configuration of Oracle Database software is simplified with image-based installation.
To install Oracle Database, create the new Oracle home, extract the image file into the newly-created Oracle home, and run the setup wizard to register the Oracle Database product.
Using image-based installation, you can install and upgrade Oracle Database for single-instance and cluster configurations.
Oracle shows up this:
 But there is no 18c on OTN for download...


UPDATE: The rpm based installation is ready for download now: https://dietrichschroff.blogspot.com/2018/11/oracle-database-18c-installation-via.html

Oct 3, 2017

Oracle 18c: self-driving, self-scaling, self-repairing AND documentation-free (?)

Yesterday Larry Ellison announced Oracle 18c:
After 12c now 18c?
Why 18 and not another number greater 12?
Inside a whitepaper released with the announcment the version 18c is not named at all.

The whitepaper just contains some high level information about the autonomous database:

and some licensing information:
But no real information about this new database 18c.
If this new database works like promised:
Fully automated patching, upgrades, backups, and availability architecture perform all routine database maintenance tasks—without the need for human intervention.
then there is no need for documentation at all...