Blog
Export Oracle SQL PLAN Baselines from one database to another
Category: Database Author: Andre Luiz Dutra Ontalba (Board Member) Date: 2 years ago Comments: 0

Export Oracle SQL PLAN Baselines from one database to another

 
 
 
Hello everyone, a few weeks ago, during a project, our client requested that during the database migration process we take the SQL PLAN Baseline of the current databases.
 
I found the topic interesting to share with you, how to do this migration of SQL PLAN Baselines from one database to another.

NOTE: The database user must have “administer sql management object” to execute the steps below.

1 . Create a staging table from the source database. A staging table cannot be created in SYS schema.(ORA-19381)

I used the SYSTEM schema.

exec DBMS_SPM.CREATE_STGTAB_BASELINE('MIGBASELINE', MIGUSER);
2. Pack baselines in the source database:
 
Here we can do it in four ways.
 
A) Pack all baselines in the database.
set serveroutput on
DECLARE
x number;
BEGIN
x := DBMS_SPM.PACK_STGTAB_BASELINE('MIGBASELINE', MIGUSER);
dbms_output.put_line(to_char(x) || ' plan baselines packed');
END;
/
B) Pack ALL Baselines Plans of a query
set serveroutput on
DECLARE
x number;
BEGIN
x := DBMS_SPM.PACK_STGTAB_BASELINE('MIGBASELINE', MIGUSER, sql_handle => 'SYS_SQL_58d940ad9b3ac043');
dbms_output.put_line(to_char(x) || ' plan baselines packed');
END;
/
C) Pack a specific Baseline Plan of a Query
set serveroutput on
DECLARE
x number;
BEGIN
x := DBMS_SPM.PACK_STGTAB_BASELINE('MIGBASELINE', MIGUSER, sql_handle => ' SYS_SQL_58d940ad9b3ac043', plan_name => 'SYS_SQL_PLAN_d380ae0c0a76c437' );
dbms_output.put_line(to_char(x) || ' plan baselines packed');
END;

/

 
D) Pack only ACCEPTED Baseline Plans of a Query
 
set serveroutput on
DECLARE
x number;
BEGIN
x := DBMS_SPM.PACK_STGTAB_BASELINE('MIGBASELINE', MIGUSER, sql_handle => ' SYS_SQL_58d940ad9b3ac043', accepted => 'YES' );
dbms_output.put_line(to_char(x) || ' plan baselines packed');
END;
/
3. Export the staging table MIGBASELINE from the source database.

4. Import the staging table MIGBASELINE into the target database.

5. Unpack the baselines in the target database.
set serveroutput on
DECLARE
x number;
BEGIN
x := DBMS_SPM.UNPACK_STGTAB_BASELINE('MIGBASELINE', MIGUSERN);
dbms_output.put_line(to_char(x) || ' plan baselines unpacked');
END;
/
I hope this helps you!!!

Andre Luiz Dutra Ontalba

Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited  to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful


Oracle Groundbreakers EMEA – Virtual Tour 2021 (LuxOUG)
Category: Cloud Author: Andre Luiz Dutra Ontalba (Board Member) Date: 3 years ago Comments: 0

Oracle Groundbreakers EMEA - Virtual Tour 2021 (LuxOUG)

 
 
Are you ready to virtually hit the road again this fall ? You should be!
#OGBEMEA Virtual Tour 2021 will take place between 15th of October and 29th of October.
 
This year, 10 Oracle User groups are collaborating to bring together novices and specialists from all over the world.
 
During 11 days more than 70 speakers will present from the #OGBEMEA virtual stage.
 
 
Registration is open!
 
Save this date of October 19, LuxOUG will be part of this great event. See the agenda and register for all events you wish to participate !!!

 

Link to event registration: http://ogbemea.com/agenda-2021/3/#luxoug

 

See you at the event !!

Oracle Linux 8 Security Updates
Category: Operational System Author: César Carvalho Date: 3 years ago Comments: 0

Oracle Linux 8 Security Updates

Today’s topic is very important, we will know the various types of security updates available in Oracle Linux 8, before working on the practical part, we will know some basic definitions of what is CVE and ELSA.
CVE, short for Common Vulnerabilities and Exposures, is a list of publicly disclosed computer security flaws. When someone refers to a CVE, they mean a security flaw that’s been assigned a CVE ID number.
Security advisories issued by vendors and researchers almost always mention at least one CVE ID. CVEs help IT professionals coordinate their efforts to prioritize and address these vulnerabilities to make computer systems more secure.
CVE Details: https://linux.oracle.com/ords/f?p=130:21
                      https://www.cvedetails.com/vulnerability-list/vendor_id-93/year-2021/Oracle.html
                      https://linux.oracle.com/security/
 
ELSA, Enterprise Linux Security Advisory, is nothing more than a way to consult and get details of security holes or bugs and which packages must be updated or have been affected.
ELSA Details: https://linux.oracle.com/ords/f?p=105:21
For this example I used the outdated Oracle Linux 8.0.
 
1 - Checking for security updates available for download and installation.
    Verificando atualizações de segurança disponiveis para download e instalação.
    
[root@ol8 ~]# dnf updateinfo sec
Last metadata expiration check: 0:04:37 ago on Tue 07 Sep 2021 12:15:28 PM -03.
Updates Information Summary: available
    173 Security notice(s) <===================== We see that we have 173 security updates out of which 64 are important.
         64 Important Security notice(s) <========= Vemos que temos 173 atualizações de segurança sendo que as 64 são importantes.
         92 Moderate Security notice(s)  <========= 92 de nivel moderado.
         17 Low Security notice(s)		 17 de nivel baixo de segurança.
		
2 - Checking in detail which packages/applications have updates and should be updated. As the list of packages is very large, I am summarizing the packages listed.
    Verificando de forma detalhada quais pacotes/aplicativos possuem atualizações e devem sofrer atualizações. Como a lista é muito grande de pacotes, estou resumindo os pacotes listados.
    
[root@ol8 ~]# dnf updateinfo list sec | awk '{print $3}'

expiration
NetworkManager-1:1.22.8-5.el8_2.x86_64
NetworkManager-1:1.30.0-7.0.1.el8.x86_64
NetworkManager-libnm-1:1.22.8-5.el8_2.x86_64
NetworkManager-libnm-1:1.30.0-7.0.1.el8.x86_64
NetworkManager-team-1:1.22.8-5.el8_2.x86_64
NetworkManager-team-1:1.30.0-7.0.1.el8.x86_64
NetworkManager-tui-1:1.22.8-5.el8_2.x86_64
NetworkManager-tui-1:1.30.0-7.0.1.el8.x86_64
bash-4.4.19-14.el8.x86_64
bind-export-libs-32:9.11.13-3.el8.x86_64
bind-export-libs-32:9.11.13-5.el8_2.x86_64
bind-export-libs-32:9.11.20-5.el8.x86_64
bind-export-libs-32:9.11.20-5.el8_3.1.x86_64
bind-export-libs-32:9.11.26-4.el8_4.x86_64
bind-export-libs-32:9.11.4-17.P2.el8_0.1.x86_64
bind-export-libs-32:9.11.4-17.P2.el8_0.x86_64
bind-export-libs-32:9.11.4-26.P2.el8.x86_64
brotli-1.0.6-3.el8.x86_64
cpio-2.12-10.el8.x86_64
cryptsetup-libs-2.3.3-2.el8.x86_64
cups-libs-1:2.2.6-33.el8.x86_64
cups-libs-1:2.2.6-38.el8.x86_64
curl-7.61.1-11.el8.x86_64
curl-7.61.1-12.el8.x86_64
curl-7.61.1-14.el8.x86_64
curl-7.61.1-18.el8.x86_64
cyrus-sasl-lib-2.1.27-5.el8.x86_64
dbus-1:1.12.8-10.0.1.el8_2.x86_64
dbus-1:1.12.8-9.0.1.el8.x86_64
dbus-common-1:1.12.8-10.0.1.el8_2.noarch
dbus-common-1:1.12.8-9.0.1.el8.noarch
dbus-daemon-1:1.12.8-10.0.1.el8_2.x86_64
dbus-daemon-1:1.12.8-9.0.1.el8.x86_64
dbus-libs-1:1.12.8-10.0.1.el8_2.x86_64
dbus-libs-1:1.12.8-9.0.1.el8.x86_64
dbus-tools-1:1.12.8-10.0.1.el8_2.x86_64
dbus-tools-1:1.12.8-9.0.1.el8.x86_64
dhcp-client-12:4.3.6-34.el8.x86_64
dhcp-client-12:4.3.6-44.el8_4.1.x86_64
dhcp-common-12:4.3.6-34.el8.noarch
dhcp-common-12:4.3.6-44.el8_4.1.noarch
dhcp-libs-12:4.3.6-34.el8.x86_64
dhcp-libs-12:4.3.6-44.el8_4.1.x86_64
dnf-4.2.7-6.el8.noarch
dnf-data-4.2.7-6.el8.noarch
dnf-plugins-core-4.0.8-3.el8.noarch
e2fsprogs-1.45.4-3.el8.x86_64
e2fsprogs-libs-1.45.4-3.el8.x86_64
elfutils-default-yama-scope-0.176-5.el8.noarch
elfutils-libelf-0.176-5.el8.x86_64
elfutils-libs-0.176-5.el8.x86_64
expat-2.2.5-4.el8.x86_64
freetype-2.9.1-4.el8_3.1.x86_64
gettext-0.19.8.1-17.el8.x86_64
gettext-libs-0.19.8.1-17.el8.x86_64
glib2-2.56.4-10.el8_4.1.x86_64
glib2-2.56.4-10.el8_4.x86_64
glib2-2.56.4-7.el8.x86_64
glib2-2.56.4-8.el8.x86_64
glib2-2.56.4-9.el8.x86_64
glibc-2.28-101.0.1.el8.x86_64
glibc-2.28-127.0.1.el8.x86_64
glibc-2.28-151.0.1.el8.x86_64
glibc-2.28-72.0.1.el8.x86_64
glibc-common-2.28-101.0.1.el8.x86_64
glibc-common-2.28-127.0.1.el8.x86_64
glibc-common-2.28-151.0.1.el8.x86_64
glibc-common-2.28-72.0.1.el8.x86_64
glibc-langpack-en-2.28-101.0.1.el8.x86_64
glibc-langpack-en-2.28-127.0.1.el8.x86_64
glibc-langpack-en-2.28-151.0.1.el8.x86_64
glibc-langpack-en-2.28-72.0.1.el8.x86_64
gnupg2-2.2.20-2.el8.x86_64
gnupg2-smime-2.2.20-2.el8.x86_64
gnutls-3.6.14-7.el8_3.x86_64
gnutls-3.6.14-8.el8_3.x86_64
gnutls-3.6.8-10.el8_2.x86_64
gnutls-3.6.8-11.el8_2.x86_64
gnutls-3.6.8-8.el8.x86_64
grub2-common-1:2.02-78.0.2.el8.noarch
grub2-common-1:2.02-78.0.3.el8_1.1.noarch
grub2-common-1:2.02-82.0.2.el8_2.1.noarch
grub2-common-1:2.02-90.0.2.el8.noarch
grub2-common-1:2.02-90.0.2.el8_3.1.noarch
grub2-pc-1:2.02-78.0.2.el8.x86_64
grub2-pc-1:2.02-78.0.3.el8_1.1.x86_64
grub2-pc-1:2.02-82.0.2.el8_2.1.x86_64

3 - Details of the packages to be updated. As the list of packages is very large, I am summarizing the packages listed.
    Detalhes dos pacotes a serem atualizados. Como a lista é muito grande de pacotes, estou resumindo os pacotes listados.
    
    [root@ol8 ~]# dnf updateinfo list
Last metadata expiration check: 0:10:17 ago on Tue 07 Sep 2021 12:15:28 PM -03.
ELBA-2019-4856 bugfix         NetworkManager-1:1.20.0-3.0.1.el8.x86_64
ELBA-2019-4279 bugfix         NetworkManager-1:1.20.0-5.0.1.el8_1.x86_64
ELBA-2020-1847 bugfix         NetworkManager-1:1.22.8-4.el8.x86_64
ELSA-2020-3011 Moderate/Sec.  NetworkManager-1:1.22.8-5.el8_2.x86_64
ELBA-2020-5474 bugfix         NetworkManager-1:1.26.0-12.0.1.el8_3.x86_64
ELBA-2021-0563 bugfix         NetworkManager-1:1.26.0-13.0.1.el8_3.x86_64
ELBA-2021-1099 bugfix         NetworkManager-1:1.26.0-14.0.1.el8_3.x86_64
ELBA-2020-4499 bugfix         NetworkManager-1:1.26.0-8.0.1.el8.x86_64
ELBA-2020-4850 bugfix         NetworkManager-1:1.26.0-9.0.1.el8_3.x86_64
ELBA-2020-5940 bugfix         NetworkManager-1:1.26.0-9.0.2.el8_3.x86_64
ELBA-2021-3055 bugfix         NetworkManager-1:1.30.0-10.0.1.el8_4.x86_64
ELSA-2021-1574 Moderate/Sec.  NetworkManager-1:1.30.0-7.0.1.el8.x86_64
ELBA-2021-2576 bugfix         NetworkManager-1:1.30.0-9.0.1.el8_4.x86_64
ELBA-2019-4856 bugfix         NetworkManager-libnm-1:1.20.0-3.0.1.el8.x86_64
ELBA-2019-4279 bugfix         NetworkManager-libnm-1:1.20.0-5.0.1.el8_1.x86_64
ELBA-2020-1847 bugfix         NetworkManager-libnm-1:1.22.8-4.el8.x86_64
ELSA-2020-3011 Moderate/Sec.  NetworkManager-libnm-1:1.22.8-5.el8_2.x86_64
ELBA-2020-5474 bugfix         NetworkManager-libnm-1:1.26.0-12.0.1.el8_3.x86_64
ELBA-2021-0563 bugfix         NetworkManager-libnm-1:1.26.0-13.0.1.el8_3.x86_64
ELBA-2021-1099 bugfix         NetworkManager-libnm-1:1.26.0-14.0.1.el8_3.x86_64
ELBA-2020-4499 bugfix         NetworkManager-libnm-1:1.26.0-8.0.1.el8.x86_64
ELBA-2020-4850 bugfix         NetworkManager-libnm-1:1.26.0-9.0.1.el8_3.x86_64
ELBA-2020-5940 bugfix         NetworkManager-libnm-1:1.26.0-9.0.2.el8_3.x86_64
ELBA-2021-3055 bugfix         NetworkManager-libnm-1:1.30.0-10.0.1.el8_4.x86_64
ELSA-2021-1574 Moderate/Sec.  NetworkManager-libnm-1:1.30.0-7.0.1.el8.x86_64
ELBA-2021-2576 bugfix         NetworkManager-libnm-1:1.30.0-9.0.1.el8_4.x86_64
ELBA-2019-4856 bugfix         NetworkManager-team-1:1.20.0-3.0.1.el8.x86_64
ELBA-2019-4279 bugfix         NetworkManager-team-1:1.20.0-5.0.1.el8_1.x86_64
ELBA-2020-1847 bugfix         NetworkManager-team-1:1.22.8-4.el8.x86_64
ELSA-2020-3011 Moderate/Sec.  NetworkManager-team-1:1.22.8-5.el8_2.x86_64
ELBA-2020-5474 bugfix         NetworkManager-team-1:1.26.0-12.0.1.el8_3.x86_64
ELBA-2021-0563 bugfix         NetworkManager-team-1:1.26.0-13.0.1.el8_3.x86_64
ELBA-2021-1099 bugfix         NetworkManager-team-1:1.26.0-14.0.1.el8_3.x86_64
ELBA-2020-4499 bugfix         NetworkManager-team-1:1.26.0-8.0.1.el8.x86_64
ELBA-2020-4850 bugfix         NetworkManager-team-1:1.26.0-9.0.1.el8_3.x86_64
ELBA-2020-5940 bugfix         NetworkManager-team-1:1.26.0-9.0.2.el8_3.x86_64
ELBA-2021-3055 bugfix         NetworkManager-team-1:1.30.0-10.0.1.el8_4.x86_64
ELSA-2021-1574 Moderate/Sec.  NetworkManager-team-1:1.30.0-7.0.1.el8.x86_64
ELBA-2021-2576 bugfix         NetworkManager-team-1:1.30.0-9.0.1.el8_4.x86_64
ELBA-2019-4856 bugfix         NetworkManager-tui-1:1.20.0-3.0.1.el8.x86_64
ELBA-2019-4279 bugfix         NetworkManager-tui-1:1.20.0-5.0.1.el8_1.x86_64
ELBA-2020-1847 bugfix         NetworkManager-tui-1:1.22.8-4.el8.x86_64
ELSA-2020-3011 Moderate/Sec.  NetworkManager-tui-1:1.22.8-5.el8_2.x86_64
ELBA-2020-5474 bugfix         NetworkManager-tui-1:1.26.0-12.0.1.el8_3.x86_64
ELBA-2021-0563 bugfix         NetworkManager-tui-1:1.26.0-13.0.1.el8_3.x86_64
ELBA-2021-1099 bugfix         NetworkManager-tui-1:1.26.0-14.0.1.el8_3.x86_64
ELBA-2020-4499 bugfix         NetworkManager-tui-1:1.26.0-8.0.1.el8.x86_64
ELBA-2020-4850 bugfix         NetworkManager-tui-1:1.26.0-9.0.1.el8_3.x86_64
ELBA-2020-5940 bugfix         NetworkManager-tui-1:1.26.0-9.0.2.el8_3.x86_64
ELBA-2021-3055 bugfix         NetworkManager-tui-1:1.30.0-10.0.1.el8_4.x86_64
ELSA-2019-1959 Important/Sec. kernel-tools-4.18.0-80.7.1.el8_0.x86_64
ELSA-2019-2411 Important/Sec. kernel-tools-4.18.0-80.7.2.el8_0.x86_64
ELSA-2019-3832 Important/Sec. kernel-tools-libs-4.18.0-147.0.2.el8_1.x86_64
ELSA-2019-3871 Important/Sec. kernel-tools-libs-4.18.0-147.0.3.el8_1.x86_64
ELEA-2020-5481 enhancement    microcode_ctl-4:20200609-2.20201112.1.0.1.el8_3.x86_64
ELBA-2021-0621 bugfix         microcode_ctl-4:20200609-2.20210216.1.0.1.el8_3.x86_64
ELBA-2021-1613 bugfix         microcode_ctl-4:20210216-1

4 - Listing the classification of packages by criticality levels (Moderate,Low,Important).
    Listando a classificação dos pacotes por niveis de criticidade (Moderado,Baixo,Importante).
    
[root@ol8 ~]# dnf updateinfo list --sec-severity=Moderate
Last metadata expiration check: 0:12:53 ago on Tue 07 Sep 2021 12:15:28 PM -03.
ELSA-2020-3011 Moderate/Sec. NetworkManager-1:1.22.8-5.el8_2.x86_64
ELSA-2021-1574 Moderate/Sec. NetworkManager-1:1.30.0-7.0.1.el8.x86_64
ELSA-2020-3011 Moderate/Sec. NetworkManager-libnm-1:1.22.8-5.el8_2.x86_64
ELSA-2021-1574 Moderate/Sec. NetworkManager-libnm-1:1.30.0-7.0.1.el8.x86_64
ELSA-2020-3011 Moderate/Sec. NetworkManager-team-1:1.22.8-5.el8_2.x86_64
ELSA-2021-1574 Moderate/Sec. NetworkManager-team-1:1.30.0-7.0.1.el8.x86_64
ELSA-2020-3011 Moderate/Sec. NetworkManager-tui-1:1.22.8-5.el8_2.x86_64
ELSA-2021-1574 Moderate/Sec. NetworkManager-tui-1:1.30.0-7.0.1.el8.x86_64
ELSA-2020-1845 Moderate/Sec. bind-export-libs-32:9.11.13-3.el8.x86_64
ELSA-2020-4500 Moderate/Sec. bind-export-libs-32:9.11.20-5.el8.x86_64
ELSA-2019-3583 Moderate/Sec. yum-4.2.7-6.el8.noarch

[root@ol8 ~]# dnf updateinfo list --sec-severity=Low
Last metadata expiration check: 0:13:01 ago on Tue 07 Sep 2021 12:15:28 PM -03.
ELSA-2021-1679 Low/Sec. bash-4.4.19-14.el8.x86_64
ELSA-2019-3552 Low/Sec. bind-export-libs-32:9.11.4-26.P2.el8.x86_64
ELSA-2020-1765 Low/Sec. cups-libs-1:2.2.6-33.el8.x86_64
ELSA-2020-4469 Low/Sec. cups-libs-1:2.2.6-38.el8.x86_64
ELSA-2019-3575 Low/Sec. elfutils-default-yama-scope-0.176-5.el8.noarch
ELSA-2019-3575 Low/Sec. elfutils-libelf-0.176-5.el8.x86_64

[root@ol8 ~]# dnf updateinfo list --sec-severity=Important
Last metadata expiration check: 0:13:09 ago on Tue 07 Sep 2021 12:15:28 PM -03.
ELSA-2020-2338 Important/Sec. bind-export-libs-32:9.11.13-5.el8_2.x86_64
ELSA-2021-0670 Important/Sec. bind-export-libs-32:9.11.20-5.el8_3.1.x86_64
ELSA-2021-1989 Important/Sec. bind-export-libs-32:9.11.26-4.el8_4.x86_64
ELSA-2019-1714 Important/Sec. bind-export-libs-32:9.11.4-17.P2.el8_0.1.x86_64
ELSA-2019-1145 Important/Sec. bind-export-libs-32:9.11.4-17.P2.el8_0.x86_64
ELSA-2020-3014 Important/Sec. dbus-1:1.12.8-10.0.1.el8_2.x86_64
ELSA-2020-3014 Important/Sec. dbus-common-1:1.12.8-10.0.1.el8_2.noarch
ELSA-2020-3014 Important/Sec. dbus-daemon-1:1.12.8-10.0.1.el8_2.x86_64
ELSA-2020-3014 Important/Sec. dbus-libs-1:1.12.8-10.0.1.el8_2.x86_64
ELSA-2020-3014 Important/Sec. dbus-tools-1:1.12.8-10.0.1.el8_2.x86_64
ELSA-2021-2359 Important/Sec. dhcp-client-12:4.3.6-44.el8_4.1.x86_64
ELSA-2021-2359 Important/Sec. dhcp-common-12:4.3.6-44.el8_4.1.noarch
ELSA-2021-2359 Important/Sec. dhcp-libs-12:4.3.6-44.el8_4.1.x86_64
ELSA-2020-4952 Important/Sec. freetype-2.9.1-4.el8_3.1.x86_64
ELSA-2021-2170 Important/Sec. glib2-2.56.4-10.el8_4.x86_64
ELSA-2021-1206 Important/Sec. gnutls-3.6.14-8.el8_3.x86_64
ELSA-2020-2637 Important/Sec. gnutls-3.6.8-11.el8_2.x86_64
ELSA-2019-4869 Important/Sec. grub2-common-1:2.02-78.0.2.el8.noarch
ELSA-2020-5786 Important/Sec. grub2-common-1:2.02-82.0.2.el8_2.1.noarch
ELSA-2021-9077 Important/Sec. grub2-common-1:2.02-90.0.2.el8.noarch
ELSA-2019-4869 Important/Sec. grub2-pc-1:2.02-78.0.2.el8.x86_64
ELSA-2020-5786 Important/Sec. grub2-pc-1:2.02-82.0.2.el8_2.1.x86_64
ELSA-2021-9077 Important/Sec. grub2-pc-1:2.02-90.0.2.el8.x86_64

6 - To list Common Security Vulnerabilities and Exposures (CVE).
    Para listar Vulnerabilidades e Exposições Comuns (CVE) de segurança.
    
[root@ol8 ~]# dnf updateinfo list cves
# Checking information from a specific CVE.
# Verificando informações de uma CVE especifica.
[root@ol8 ~]# dnf updateinfo list --cve CVE-2020-4000

# Updating a specific CVE.
# Atualizando uma CVE especifica.
[root@ol8 ~]# dnf update --cve CVE-2020-4000

# Fixing or applying ELSA security updates.
# Corrigindo ou aplicando atualizações de segurança ELSA.
[root@ol8 ~]# dnf update --advisory ELSA-2020-4010

7 - To apply all security updates.
    Para aplicar todas as atualizações de segurança.

[root@ol8 ~]# dnf --security update -y
Last metadata expiration check: 0:06:24 ago on Tue 07 Sep 2021 12:29:24 PM -03.
Dependencies resolved.
====================================================================================================================================================================
 Package                                      Arch                    Version                                              Repository                          Size
====================================================================================================================================================================
Installing:
 kernel                                       x86_64                  4.18.0-305.12.1.el8_4                                ol8_baseos_latest                  5.9 M
 kernel-core                                  x86_64                  4.18.0-305.12.1.el8_4                                ol8_baseos_latest                   36 M
 kernel-modules                               x86_64                  4.18.0-305.12.1.el8_4                                ol8_baseos_latest                   28 M
Upgrading:
 libX11                                       x86_64                  1.6.8-4.el8                                          ol8_appstream                      611 k
 libX11-common                                noarch                  1.6.8-4.el8                                          ol8_appstream                      158 k
 libX11-xcb                                   x86_64                  1.6.8-4.el8                                          ol8_appstream                       14 k
 libdrm                                       x86_64                  2.4.103-1.el8                                        ol8_appstream                      165 k
 libglvnd                                     x86_64                  1:1.3.2-1.el8                                        ol8_appstream                      127 k
 libglvnd-glx                                 x86_64                  1:1.3.2-1.el8                                        ol8_appstream                      137 k
 libjpeg-turbo                                x86_64                  1.5.3-10.el8                                         ol8_appstream                      155 k
 libmspack                                    x86_64                  0.7-0.3.alpha.el8.4                                  ol8_appstream                       71 k
 libreswan                                    x86_64                  4.3-3.0.1.el8                                        ol8_appstream                      1.3 M
 mesa-libGL                                   x86_64                  20.3.3-2.el8                                         ol8_appstream                      188 k
 mesa-libglapi                                x86_64                  20.3.3-2.el8                                         ol8_appstream                       65 k
 nspr                                         x86_64                  4.25.0-2.el8_2                                       ol8_appstream                      142 k
 nss                                          x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      723 k
 nss-softokn                                  x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      484 k
 nss-softokn-freebl                           x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      376 k
 nss-sysinit                                  x86_64                  3.53.1-17.el8_3                                      ol8_appstream                       72 k

Complete!

 
8 - Applying security updates by category.
    Aplicando atualizações de segurança por categoria.
 
 # Updates each package to the latest available version that provides a bug fix, enhancement, or fix for a security (security) issue.
 # Atualiza cada pacote para a versão mais recente disponível que fornece uma correção de bug, aprimoramento ou uma correção para um problema de segurança (segurança).
 
 [root@ol8 ~]# dnf --security upgrade-minimal
 ====================================================================================================================================================================
 Package                                      Arch                    Version                                              Repository                          Size
====================================================================================================================================================================
Upgrading:
 libX11                                       x86_64                  1.6.8-4.el8                                          ol8_appstream                      611 k
 libX11-common                                noarch                  1.6.8-4.el8                                          ol8_appstream                      158 k
 libX11-xcb                                   x86_64                  1.6.8-4.el8                                          ol8_appstream                       14 k
 libdrm                                       x86_64                  2.4.103-1.el8                                        ol8_appstream                      165 k
 libglvnd                                     x86_64                  1:1.3.2-1.el8                                        ol8_appstream                      127 k
 libglvnd-glx                                 x86_64                  1:1.3.2-1.el8                                        ol8_appstream                      137 k
 libjpeg-turbo                                x86_64                  1.5.3-10.el8                                         ol8_appstream                      155 k
 libmspack                                    x86_64                  0.7-0.3.alpha.el8.4                                  ol8_appstream                       71 k
 libreswan                                    x86_64                  3.29-7.0.1.el8_2                                     ol8_appstream                      1.3 M
 mesa-libGL                                   x86_64                  20.3.3-2.el8                                         ol8_appstream                      188 k
 mesa-libglapi                                x86_64                  20.3.3-2.el8                                         ol8_appstream                       65 k
 nspr                                         x86_64                  4.25.0-2.el8_2                                       ol8_appstream                      142 k
 nss                                          x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      723 k
 nss-softokn                                  x86_64                  3.53.1-11.el8_2                                      ol8_appstream                      484 k
 nss-softokn-freebl                           x86_64                  3.53.1-11.el8_2                                      ol8_appstream                      289 k
 nss-sysinit                                  x86_64                  3.53.1-17.el8_3                                      ol8_appstream                       72 k
 nss-tools                                    x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      560 k
 nss-util                                     x86_64                  3.53.1-17.el8_3                                      ol8_appstream                      136 k
 plymouth                                     x86_64                  0.9.3-15.0.1.el8                                     ol8_appstream                      114 k
 plymouth-core-libs                           x86_64                  0.9.3-15.0.1.el8                                     ol8_appstream                      114 k
 plymouth-scripts                             x86_64                  0.9.3-15.0.1.el8                                     ol8_appstream                       42 k
 python3-unbound                              x86_64                  1.7.3-15.el8                                         ol8_appstream                      119 k
 rsyslog                                      x86_64                  8.1911.0-3.el8                                       ol8_appstream                      730 k
Transaction Summary
====================================================================================================================================================================
Install   26 Packages
Upgrade  167 Packages
Skip      69 Packages

Total download size: 442 M
Is this ok [y/N]: y <========================= YES
Downloading Packages:
(1/193): kernel-4.18.0-240.22.1.el8_3.x86_64.rpm                                                                                    4.8 MB/s | 4.4 MB     00:00
(2/193): kernel-core-4.18.0-240.22.1.el8_3.x86_64.rpm                                                                               7.9 MB/s |  30 MB     00:03
(3/193): grub2-tools-efi-2.02-90.0.2.el8_3.1.x86_64.rpm                                                                              98 kB/s | 472 kB     00:04
(4/193): kernel-core-4.18.0-305.12.1.el8_4.x86_64.rpm                                                                               7.7 MB/s |  36 MB     00:04
(5/193): libssh-config-0.9.4-2.el8.noarch.rpm                                                                                       103 kB/s |  18 kB     00:00
(6/193): libzstd-1.4.4-1.0.1.el8.x86_64.rpm                                                                                         3.3 MB/s | 266 kB     00:00
(7/193): mozjs60-60.9.0-4.0.1.el8.x86_64.rpm                                                                                        7.1 MB/s | 6.6 MB     00:00
(8/193): perl-Encode-2.97-3.el8.x86_64.rpm                                                                                          7.2 MB/s | 1.5 MB     00:00
(9/193): perl-File-Temp-0.230.600-1.el8.noarch.rpm                                                                                  1.4 MB/s |  63 kB     00:00
(10/193): perl-Getopt-Long-2.50-4.el8.noarch.rpm                                                                                    1.4 MB/s |  63 kB     00:00
(11/193): perl-HTTP-Tiny-0.074-1.el8.noarch.rpm                                                                                     741 kB/s |  58 kB     00:00

Complete!
 
 #====================================================================================================================================================================
 
 # Security updates and bug fixes only pertaining to the kernel.
 #Atualizações de segurança e correções bugs apenas referente ao kernel.
 
[root@ol8 ~]# dnf --security upgrade-minimal kernel*
Last metadata expiration check: 0:49:03 ago on Tue 07 Sep 2021 12:15:28 PM -03.
Dependencies resolved.
====================================================================================================================================================================
 Package                                 Arch                      Version                                               Repository                            Size
====================================================================================================================================================================
Installing:
 kernel                                  x86_64                    4.18.0-240.22.1.el8_3                                 ol8_baseos_latest                    4.4 M
 kernel-core                             x86_64                    4.18.0-305.12.1.el8_4                                 ol8_baseos_latest                     36 M
 kernel-modules                          x86_64                    4.18.0-305.12.1.el8_4                                 ol8_baseos_latest                     28 M
Upgrading:
 dracut                                  x86_64                    049-135.git20210121.0.2.el8                           ol8_baseos_latest                    374 k
 dracut-config-rescue                    x86_64                    049-135.git20210121.0.2.el8                           ol8_baseos_latest                     60 k
 dracut-network                          x86_64                    049-135.git20210121.0.2.el8                           ol8_baseos_latest                    108 k
 dracut-squash                           x86_64                    049-135.git20210121.0.2.el8                           ol8_baseos_latest                     60 k
 iptables                                x86_64                    1.8.4-17.0.1.el8                                      ol8_baseos_latest                    584 k
 iptables-ebtables                       x86_64                    1.8.4-17.0.1.el8                                      ol8_baseos_latest                     72 k
 iptables-libs                           x86_64                    1.8.4-17.0.1.el8                                      ol8_baseos_latest                    107 k
 kernel-tools                            x86_64                    4.18.0-305.12.1.el8_4                                 ol8_baseos_latest                    6.1 M
 kernel-tools-libs                       x86_64                    4.18.0-305.12.1.el8_4                                 ol8_baseos_latest                    5.9 M
 kexec-tools                             x86_64                    2.0.20-46.0.1.el8_4.2                                 ol8_baseos_latest                    510 k
 libnftnl                                x86_64                    1.1.5-4.el8                                           ol8_baseos_latest                     83 k
 linux-firmware                          noarch                    999:20210617-999.8.git0f66b74b.el8                    ol8_baseos_latest                    178 M
 systemd                                 x86_64                    239-45.0.2.el8_4.3                                    ol8_baseos_latest                    3.6 M
 systemd-libs                            x86_64                    239-45.0.2.el8_4.3                                    ol8_baseos_latest                    1.1 M
 systemd-pam                             x86_64                    239-45.0.2.el8_4.3                                    ol8_baseos_latest                    470 k
 systemd-udev                            x86_64                    239-45.0.2.el8_4.3                                    ol8_baseos_latest                    1.4 M
Installing dependencies:
 kernel-core                             x86_64                    4.18.0-240.22.1.el8_3                                 ol8_baseos_latest                     30 M
 kernel-modules                          x86_64                    4.18.0-240.22.1.el8_3                                 ol8_baseos_latest                     26 M

Transaction Summary
====================================================================================================================================================================
Install   5 Packages
Upgrade  16 Packages

Total download size: 322 M
Is this ok [y/N]: y <========================= YES
Downloading Packages:
(1/21): kernel-core-4.18.0-305.12.1.el8_4.x86_64.rpm                                                                                9.5 MB/s |  36 MB     00:03
(2/21): kernel-4.18.0-240.22.1.el8_3.x86_64.rpm                                                                                     610 kB/s | 4.4 MB     00:07
(3/21): kernel-modules-4.18.0-305.12.1.el8_4.x86_64.rpm                                                                             9.0 MB/s |  28 MB     00:03
(4/21): dracut-049-135.git20210121.0.2.el8.x86_64.rpm                                                                               5.0 MB/s | 374 kB     00:00
(5/21): dracut-config-rescue-049-135.git20210121.0.2.el8.x86_64.rpm                                                                 1.6 MB/s |  60 kB     00:00
(6/21): dracut-network-049-135.git20210121.0.2.el8.x86_64.rpm                                                                       1.1 MB/s | 108 kB     00:00
(7/21): dracut-squash-049-135.git20210121.0.2.el8.x86_64.rpm                                                                        1.3 MB/s |  60 kB     00:00
(8/21): iptables-1.8.4-17.0.1.el8.x86_64.rpm                                                                                        6.9 MB/s | 584 kB     00:00
(9/21): iptables-ebtables-1.8.4-17.0.1.el8.x86_64.rpm                                                                               3.8 MB/s |  72 kB     00:00
(10/21): iptables-libs-1.8.4-17.0.1.el8.x86_64.rpm                                                                                  3.3 MB/s | 107 kB     00:00
(11/21): kernel-tools-4.18.0-305.12.1.el8_4.x86_64.rpm                                                                              4.8 MB/s | 6.1 MB     00:01
(12/21): kernel-tools-libs-4.18.0-305.12.1.el8_4.x86_64.rpm                                                                         5.6 MB/s | 5.9 MB     00:01
(13/21): kernel-core-4.18.0-240.22.1.el8_3.x86_64.rpm                                                                               2.3 MB/s |  30 MB     00:13
(14/21): kexec-tools-2.0.20-46.0.1.el8_4.2.x86_64.rpm                                                                               5.2 MB/s | 510 kB     00:00
(15/21): kernel-modules-4.18.0-240.22.1.el8_3.x86_64.rpm                                                                            2.2 MB/s |  26 MB     00:11
(16/21): systemd-239-45.0.2.el8_4.3.x86_64.rpm                                                                                      6.7 MB/s | 3.6 MB     00:00
(17/21): systemd-libs-239-45.0.2.el8_4.3.x86_64.rpm                                                                                 8.6 MB/s | 1.1 MB     00:00
(18/21): systemd-pam-239-45.0.2.el8_4.3.x86_64.rpm                                                                                  5.3 MB/s | 470 kB     00:00
(19/21): systemd-udev-239-45.0.2.el8_4.3.x86_64.rpm                                                                                 8.1 MB/s | 1.4 MB     00:00
(20/21): libnftnl-1.1.5-4.el8.x86_64.rpm                                                                                             27 kB/s |  83 kB     00:03
(21/21): linux-firmware-20210617-999.8.git0f66b74b.el8.noarch.rpm                                                                    14 MB/s | 178 MB     00:12
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                12 MB/s | 322 MB     00:26
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                            1/1
  Running scriptlet: linux-firmware-999:20210617-999.8.git0f66b74b.el8.noarch                                                                                   1/1
  Upgrading        : linux-firmware-999:20210617-999.8.git0f66b74b.el8.noarch                                                                                  1/37
  Upgrading        : iptables-libs-1.8.4-17.0.1.el8.x86_64                                                                                                     2/37
  Upgrading        : systemd-libs-239-45.0.2.el8_4.3.x86_64                                                                                                    3/37
  Running scriptlet: systemd-libs-239-45.0.2.el8_4.3.x86_64                                                                                                    3/37
  Upgrading        : systemd-pam-239-45.0.2.el8_4.3.x86_64                                                                                                     4/37
  Running scriptlet: systemd-239-45.0.2.el8_4.3.x86_64                                                                                                         5/37
  Upgrading        : systemd-239-45.0.2.el8_4.3.x86_64                                                                                                         5/37
  Running scriptlet: systemd-239-45.0.2.el8_4.3.x86_64                                                                                                         5/37
  Upgrading        : systemd-udev-239-45.0.2.el8_4.3.x86_64                                                                                                    6/37
  Running scriptlet: systemd-udev-239-45.0.2.el8_4.3.x86_64                                                                                                    6/37
  Upgrading        : dracut-049-135.git20210121.0.2.el8.x86_64                                                                                                 7/37
  Installing       : kernel-core-4.18.0-240.22.1.el8_3.x86_64                                                                                                  8/37
  Running scriptlet: kernel-core-4.18.0-240.22.1.el8_3.x86_64                                                                                                  8/37
  Installing       : kernel-modules-4.18.0-240.22.1.el8_3.x86_64                                                                                               9/37
  Running scriptlet: kernel-modules-4.18.0-240.22.1.el8_3.x86_64                                                                                               9/37
  Installing       : kernel-core-4.18.0-305.12.1.el8_4.x86_64                                                                                                 10/37
  Running scriptlet: kernel-core-4.18.0-305.12.1.el8_4.x86_64                                                                                                 10/37
  Upgrading        : dracut-network-049-135.git20210121.0.2.el8.x86_64                                                                                        11/37
  Running scriptlet: dracut-network-049-135.git20210121.0.2.el8.x86_64                                                                                        11/37
  Upgrading        : dracut-squash-049-135.git20210121.0.2.el8.x86_64                                                                                         12/37
  Upgrading        : libnftnl-1.1.5-4.el8.x86_64                                                                                                              13/37
  Running scriptlet: libnftnl-1.1.5-4.el8.x86_64                                                                                                              13/37
  Running scriptlet: iptables-1.8.4-17.0.1.el8.x86_64                                                                                                         14/37
  Upgrading        : iptables-1.8.4-17.0.1.el8.x86_64                                                                                                         14/37
  Running scriptlet: iptables-1.8.4-17.0.1.el8.x86_64                                                                                                         14/37
  Upgrading        : kernel-tools-libs-4.18.0-305.12.1.el8_4.x86_64                                                                                           15/37
  Running scriptlet: kernel-tools-libs-4.18.0-305.12.1.el8_4.x86_64                                                                                           15/37

Upgraded:
  dracut-049-135.git20210121.0.2.el8.x86_64        dracut-config-rescue-049-135.git20210121.0.2.el8.x86_64 dracut-network-049-135.git20210121.0.2.el8.x86_64
  dracut-squash-049-135.git20210121.0.2.el8.x86_64 iptables-1.8.4-17.0.1.el8.x86_64                        iptables-ebtables-1.8.4-17.0.1.el8.x86_64
  iptables-libs-1.8.4-17.0.1.el8.x86_64            kernel-tools-4.18.0-305.12.1.el8_4.x86_64               kernel-tools-libs-4.18.0-305.12.1.el8_4.x86_64
  kexec-tools-2.0.20-46.0.1.el8_4.2.x86_64         libnftnl-1.1.5-4.el8.x86_64                             linux-firmware-999:20210617-999.8.git0f66b74b.el8.noarch
  systemd-239-45.0.2.el8_4.3.x86_64                systemd-libs-239-45.0.2.el8_4.3.x86_64                  systemd-pam-239-45.0.2.el8_4.3.x86_64
  systemd-udev-239-45.0.2.el8_4.3.x86_64

Installed:
  kernel-4.18.0-240.22.1.el8_3.x86_64                 kernel-core-4.18.0-305.12.1.el8_4.x86_64               kernel-modules-4.18.0-305.12.1.el8_4.x86_64
  kernel-core-4.18.0-240.22.1.el8_3.x86_64            kernel-modules-4.18.0-240.22.1.el8_3.x86_64

Complete!

# Checking if they still have kernel updates or bugs to apply.
# Verificando se ainda possuem atualizações de kernel ou bugs para serem aplicados.

[root@ol8 ~]# dnf --security upgrade-minimal kernel*
Last metadata expiration check: 0:52:36 ago on Tue 07 Sep 2021 12:15:28 PM -03.
No security updates needed for "kernel*", but 1 update available
Dependencies resolved.
Nothing to do.
Complete!

9 - Checking if we have security updates pending to be applied.
    Verificando se temos atualizações de segurança pendentes para serem aplicadas.
    
[root@ol8 ~]# dnf updateinfo sec
Last metadata expiration check: 0:12:03 ago on Tue 07 Sep 2021 01:25:53 PM -03.
[root@ol8 ~]#

 
 
   
Search for CVE details: https://linux.oracle.com/ords/f?p=130:21
Search for ELSA details: https://linux.oracle.com/ords/f?p=105:21

How to Install Oracle Restart 21c without ASM or ACFS
Category: Database Author: Andre Luiz Dutra Ontalba (Board Member) Date: 3 years ago Comments: 0

How to install Oracle Restart 21c without ASM or ACFS.

This article contains all information related to the install Oracle Restart Database 21c (Linux) without ASM.
I did the test and you can use the same procedure for versions (12.2,18c,19c).
Just change the response_schema for the Grid and Database version you want to use, in the response file.

 

1.  Oracle Database Prerequisites Packages for Oracle Linux

 

Use this procedure to install the Oracle Database prerequisites group package for your Oracle software.
 
The oracle-database-preinstall-21c package installs all the packages required for an Oracle Database and Oracle Grid Infrastructure installation. It also creates the oracle user and the oinstall and dba groups for that user.
 
To install the oracle-database-preinstall-21c package, log in as root, and run the following command on Linux:

 

yum install oracle-database-preinstall-21c

 

2. Installing Oracle Grid Infrastructure Standalone Server for Oracle Linux with Silent Mode

 

Complete these steps to install Oracle Grid Infrastructure for a standalone server and then create a database that is managed by Oracle Restart
 
Install Oracle Grid Infrastructure for a standalone server, which installs Oracle Restart.
 
You should have your network information, storage information, and operating system users and groups available to you before you start the installation. You should also be prepared to run root scripts or provide information to automate root scripts.
 
1 . Log in as the Oracle Restart software owner user (oracle).
 
2. If this is the first time you are installing Oracle software, then create the Oracle base and the Oracle inventory directories as per the Oracle Optimal Flexible Architecture (OFA) recommendations. Specify the correct owner, group, and permissions for these directories.

 

root@dutsDB ~]#  mkdir -p /u01/app/oraInventory

[root@dutsDB ~]#  chown -R oracle:oinstall /u01/app/oracle

[root@dutsDB ~]#  chown -R oracle:oinstall /u01/app/oraInventory

[root@dutsDB ~]#  chmod -R 775 /u01/app

 

3. Download the Oracle Grid Infrastructure for a standalone server installation image files, create the grid home directory, and extract the image files in this grid home directory.

 

[oracle@dutsDB u01]$ mkdir -p /u01/app/oracle/product/21.0.0/grid

[oracle@dutsDB u01]$ cd /u01/app/oracle/product/21.0.0/grid

[oracle@dutsDB grid]$ unzip -q /u01/binarios/Oracle_21_3_Grid.ziprm

[oracle@dutsDB grid]$ rm –rf OPatch

[oracle@dutsDB grid]$ unzip -q /u01/binarios/p6880880_190000_Linux-x86-64.zip

 

4. Prepare the response file grid_setup.rsp.

 

oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v21.0.0

INVENTORY_LOCATION=/u01/app/oraInventory

oracle.install.option=CRS_SWONLY 

ORACLE_BASE=/u01/app

oracle.install.asm.OSDBA=dba

oracle.install.asm.OSASM=oinstall

oracle.install.crs.config.ClusterConfiguration=STANDALONE

 

5. Log in as the Oracle Restart software owner user and run gridSetup.sh with option to applyRU and silent mode:

 

oracle@dutsDB grid]$ ./gridSetup.sh -silent -responseFile /u01/binarios/grid_setup.rsp

Launching Oracle Grid Infrastructure Setup Wizard...




The response file for this session can be found at:

 /u01/app/oracle/product/21.0.0/grid/install/response/grid_2021-09-10_10-55-55AM.rsp




You can find the log of this install session at:

 /tmp/GridSetupActions2021-09-10_10-55-55AM/gridSetupActions2021-09-10_10-55-55AM.log




As a root user, execute the following script(s):

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/21.0.0/grid/root.sh


Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:

[dutsDB]

Execute /u01/app/oracle/product/21.0.0/grid/root.sh on the following nodes:

[dutsDB]


Successfully Setup Software.

Moved the install session logs to:

 /u01/app/oraInventory/logs/GridSetupActions2021-09-10_10-55-55AM

[oracle@dutsDB grid]$

 

6. Execute the script /u01/app/oracle/product/21.0.0/grid/root.sh with root user.

 

[root@dutsDB ~]# /u01/app/oraInventory/orainstRoot.sh

Changing permissions of /u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.


Changing groupname of /u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@dutsDB ~]# /u01/app/oracle/product/21.0.0/grid/root.sh

Check /u01/app/oracle/product/21.0.0/grid/install/root_dutsDB_2021-09-10_11-07-57-619366648.log for the output of root script

[root@dutsDB ~]#

[root@dutsDB ~]#

 

7. Execute the script /u01/app/oracle/product/21.0.0/grid/crs/install/roothas.sh with root user.

 

[root@dutsDB ~]# /u01/app/oracle/product/21.0.0/grid/crs/install/roothas.sh

Using configuration parameter file: /u01/app/oracle/product/21.0.0/grid/crs/install/crsconfig_params

2021-09-10 11:08:47: Got permissions of file /u01/app/crsdata/dutsdb/crsconfig: 0775

2021-09-10 11:08:47: Got permissions of file /u01/app/crsdata: 0775

2021-09-10 11:08:47: Got permissions of file /u01/app/crsdata/dutsdb: 0775

The log of current session can be found at:

  /u01/app/crsdata/dutsdb/crsconfig/roothas_2021-09-10_11-08-47AM.log

2021/09/10 11:09:03 CLSRSC-363: User ignored prerequisites during installation

Redirecting to /bin/systemctl restart rsyslog.service

LOCAL ADD MODE

Creating OCR keys for user 'oracle', privgrp 'oinstall'..

Operation successful.

LOCAL ONLY MODE

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4664: Node dutsdb successfully pinned.

2021/09/10 11:17:27 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

dutsdb     2021/09/10 11:11:57     /u01/app/crsdata/dutsdb/olr/backup_20210910_113257.olr    

2021/09/10 11:33:32 CLSRSC-327: Successfully configured Oracle Restart for a standalone server




[oracle@dutsDB bin]$ ./crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      dutsdb                   STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        OFFLINE OFFLINE                               STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.evmd

      1        ONLINE  ONLINE       dutsdb                   STABLE

--------------------------------------------------------------------------------

[oracle@dutsDB bin]$

 

3. Installing Oracle Database 21c for Oracle Linux with Silent Mode

 

Complete these steps to install Oracle Database 21c.

 

1. Log in as the Oracle software owner user (oracle).
 
2. Download the Oracle Database 21c installation image files, create the oracle home directory, and extract the image files in this oracle home directory.

 

[oracle@dutsDB grid]$ mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1

[oracle@dutsDB grid]$ cd /u01/app/oracle/product/21.0.0/dbhome_1

[oracle@dutsDB dbhome_1]$ unzip -q /u01/binarios/Oracle_21_3_Database.zip

[oracle@dutsDB dbhome_1]$ rm -rf OPatch/

[oracle@dutsDB dbhome_1]$ unzip -q /u01/binarios/p6880880_190000_Linux-x86-64.zip

[oracle@dutsDB dbhome_1]$

 

3.  Prepare the response file.

 

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v21.0.0

oracle.install.option=INSTALL_DB_SWONLY

UNIX_GROUP_NAME=dba

INVENTORY_LOCATION=/u01/app/oraInventory

ORACLE_HOME=/u01/app/oracle/product/21.0.0/dbhome_1

ORACLE_BASE=/u01/app

oracle.install.db.InstallEdition=EE

oracle.install.db.OSDBA_GROUP=dba

oracle.install.db.OSOPER_GROUP=oinstall

oracle.install.db.OSBACKUPDBA_GROUP=oinstall

oracle.install.db.OSDGDBA_GROUP=dba

oracle.install.db.OSKMDBA_GROUP=dba

oracle.install.db.OSRACDBA_GROUP=dba

 

4. Log in as the Oracle software owner user and run runinstaller with option to applyRU and silent mode:

 

[oracle@dutsDB dbhome_1]$ ./runInstaller -silent -responseFile /u01/binarios/db_setup.rsp -ignorePrereqFailure

Launching Oracle Database Setup Wizard...




The response file for this session can be found at:

 /u01/app/oracle/product/21.0.0/dbhome_1/install/response/db_2021-09-10_12-17-55PM.rsp




You can find the log of this install session at:

 /u01/app/oraInventory/logs/InstallActions2021-09-10_12-17-55PM/installActions2021-09-10_12-17-55PM.log



As a root user, execute the following script(s):

/u01/app/oracle/product/21.0.0/dbhome_1/root.sh


Execute /u01/app/oracle/product/21.0.0/dbhome_1/root.sh on the following nodes:

[dutsDB]


Successfully Setup Software.

 

5. Execute the script /u01/app/oracle/product/21.0.0/dbhome_1/root.sh with root user

 

[root@dutsDB ~]# /u01/app/oracle/product/21.0.0/dbhome_1/root.sh

Check /u01/app/oracle/product/21.0.0/dbhome_1/install/root_dutsDB_2021-09-10_12-33-41-458028241.log for the output of root script

[root@dutsDB ~]#

[root@dutsDB ~]# cat /u01/app/oracle/product/21.0.0/dbhome_1/install/root_dutsDB_2021-09-10_12-33-41-458028241.log

Performing root user operation.




The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/oracle/product/21.0.0/dbhome_1

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...




Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

[root@dutsDB ~]#

 

Now create your database and check if it was added in Oracle Restart.

 

[oracle@dutsDB ~]$ crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ons

               OFFLINE OFFLINE      dutsdb                   STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.cssd

      1        OFFLINE OFFLINE                               STABLE

ora.diskmon

      1        OFFLINE OFFLINE                               STABLE

ora.duts.db

      1        ONLINE  ONLINE       dutsdb                   Open,HOME=/u01/app/o

                                                             racle/product/21.0.0

                                                             /dbhome_1,STABLE

ora.duts.dutspdb.pdb

      1        ONLINE  ONLINE       dutsdb                   STABLE

ora.evmd

      1        ONLINE  ONLINE       dutsdb                   STABLE

--------------------------------------------------------------------------------

[oracle@dutsDB ~]$




[oracle@dutsDB ~]$ sqlplus




SQL*Plus: Release 21.0.0.0.0 - Production on Fri Sep 10 14:19:51 2021

Version 21.3.0.0.0




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




Enter user-name: / as sysdba




Connected to:

Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production

Version 21.3.0.0.0




SQL> show pdbs




    CON_ID CON_NAME                       OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

         2 PDB$SEED                       READ ONLY  NO

         3 DUTSPDB                        READ WRITE NO

SQL>

 

I hope this helps you!!!
Stay tuned by following on twitter @aontalba and Linkedin
Andre Luiz Dutra Ontalba

 

 

Disclaimer: “The postings on this site are my own and don’t necessarily represent may actual employer positions, strategies or opinions. The information here was edited  to be useful for general purpose, specific data and identifications was removed to allow reach generic audience and to be useful


1 2 3 4 32