Step by step guide to install Oracle 19c on Windows Server 2019 including prechecks and errors

Reference url: https://docs.oracle.com/en/database/oracle/oracle-database/19/ntdbi/oracle-database-software-requirements.html#GUID-CEF225E9-9600-4E01-AC6F-402B562385F8

Below is a brief note only, the detailed video of the installation is reference below…

Step 1) Review the prereqs

HW requirement:

Architecture: x64

Memory: >=2GB

Swap: 2GB to 16GB

temp disk space: 1GB or 4GB based on install type

Disk space for bin: >=6.5GB

Datafile: 5GB (for starter)

TEMP FS: >=128MB

SW Requirement:

Windows OS: A range of OS as listed below...

Oracle Database for Windows x64 is supported on the following operating systems:

Windows 8.1 x64 - Pro and Enterprise editions

Windows 10 x64 - Pro, Enterprise, and Education editions

Windows 11 x64 - Pro, Enterprise, and Education editions

Windows Server 2012 R2 x64 - Standard, Datacenter, Essentials, and Foundation editions

Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions

Windows Server 2019 x64 - Standard, Datacenter, and Essentials editions

Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions

Note:

Windows Multilingual User Interface Pack is supported.

The Server Core option is not supported.

Windows 11 x64 - Pro, Enterprise, and Education editions and Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions are supported starting with Oracle Database 19c Release Update (19.13) or later.

Hypervisor: Oracle VM Server, Hyper V, etc.

Compiler: visual c++ <version> specific to need. For ex. pro*c/c++ - needs visual c++ 2013

Oracle client: 11.2.0.4 or later

unzip: >=6

Users & Groups:

ORA_INSTALL: Group which will be added by default: ORA_INSTALL (which I belive is an equivalent of oinstall in linux)

ORA_DBA,ORA_OPER: groups are created when binary install happens (an equivalent of dba group in linux) - sysdba oracle db role is granted to the members of this group

Os user for binary install: setup additional service account as per organizational need/security policy. The install user can be a local or domain user part of administrator group.

Hostname: DNS resolution works ok

OFA structure:

ORACLE_BASE: DRIVE_LETTER:\app\<username> [default]

username - the oracle install user

ORACLE_HOME: DRIVE_LETTER:\app\<username>\product\19.0.0\dbhome_1

Inventory directory: C:\Program Files\Oracle\Inventory [this is a common location for all the installs and is the default created by the installation]

ADMIN directory: DRIVE_LETTER:\app\<username>\admin\

comments: Subtree for database administration files

RECO space: DRIVE_LETTER:\app\<username>\fast_recovery_area\

DB or Temp Files or controlfiles or redolog files:

D:\app\<username>\oradata

E:\app\<username>\oradata

F:\app\<username>\oradata

Step 2) Setup windows server meeting the prereqs

Step 3) Download the binary

Step 4) Unzip the binary

md c:\app\oracle\product\19.0.0\dbhome_1

cd c:\app\oracle\product\19.0.0\dbhome_1

unzip C:\Users\vagrant\Downloads\V982656-01.zip

Step 5) Frame an install plan

choose: server class deployment, setup new user as part of the deployment

choose: enterprise edition

ORACLE_BASE: c:\app\oracle

ORACLE_HOME: c:\app\oracle\product\19.0.0\dbhome_1

ORACLE inventory: C:\Program Files\Oracle\Inventory

Step 6) Launch the setup.exe, follow the install plan

Step 7) Validate the install by try accessing the sqlplus program and opatch inventory validation

set ORACLE_HOME=c:\app\oracle\product\19.0.0\dbhome_1

sqlplus -v

Error: INS-32015, if you launch the setup.exe from a network share.

Thank you

pgbadger session 1 - installation of pgbadger

 Steps to install pgbadger

From pgBadger documentation: https://pgbadger.darold.net/documentation.html

1. Download the pgbadger from github

url: https://github.com/darold/pgbadger

2. Install using the below step

        tar xzf pgbadger-11.x.tar.gz

        cd pgbadger-11.x/

        perl Makefile.PL

        make && sudo make install

Instead I followed the below steps instead of 1 & 2:

mkdir pgbadger

git clone https://github.com/darold/pgbadger.git pgbadger

perl Makefile.PL

make && sudo make install

-bash-4.2$ git clone https://github.com/darold/pgbadger.git pgbadger

Cloning into 'pgbadger'...

remote: Enumerating objects: 5038, done.

remote: Counting objects: 100% (726/726), done.

remote: Compressing objects: 100% (297/297), done.

remote: Total 5038 (delta 458), reused 541 (delta 403), pack-reused 4312

Receiving objects: 100% (5038/5038), 12.47 MiB | 13.21 MiB/s, done.

Resolving deltas: 100% (3122/3122), done.

-bash-4.2$

-bash-4.2$ perl Makefile.PL

Checking if your kit is complete...

Looks good

Writing Makefile for pgBadger

-bash-4.2$

As root:

[root@vcentos79-postgres-ha1 pgbadger]# make && sudo make install

which: no pod2markdown in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)

Makefile:824: You must install pod2markdown to generate README.md from doc/pgBadger.pod

echo "=head1 SYNOPSIS" > doc/synopsis.pod

./pgbadger --help >> doc/synopsis.pod

echo "=head1 DESCRIPTION" >> doc/synopsis.pod

sed -i.bak 's/ +$//g' doc/synopsis.pod

rm doc/synopsis.pod.bak

sed -i.bak '/^=head1 SYNOPSIS/,/^=head1 DESCRIPTION/d' doc/pgBadger.pod

sed -i.bak '4r doc/synopsis.pod' doc/pgBadger.pod

rm doc/pgBadger.pod.bak

Manifying blib/man1/pgbadger.1p

rm doc/synopsis.pod

which: no pod2markdown in (/sbin:/bin:/usr/sbin:/usr/bin)

Makefile:824: You must install pod2markdown to generate README.md from doc/pgBadger.pod

echo "=head1 SYNOPSIS" > doc/synopsis.pod

./pgbadger --help >> doc/synopsis.pod

echo "=head1 DESCRIPTION" >> doc/synopsis.pod

sed -i.bak 's/ +$//g' doc/synopsis.pod

rm doc/synopsis.pod.bak

sed -i.bak '/^=head1 SYNOPSIS/,/^=head1 DESCRIPTION/d' doc/pgBadger.pod

sed -i.bak '4r doc/synopsis.pod' doc/pgBadger.pod

rm doc/pgBadger.pod.bak

Manifying blib/man1/pgbadger.1p

Installing /usr/local/share/man/man1/pgbadger.1p

Installing /usr/local/bin/pgbadger

Appending installation info to /usr/lib64/perl5/perllocal.pod

rm doc/synopsis.pod

[root@vcentos79-postgres-ha1 pgbadger]# echo $?

0

[root@vcentos79-postgres-ha1 pgbadger]#

Error#1:

-bash-4.2$ perl Makefile.PL

Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at Makefile.PL line 1.

BEGIN failed--compilation aborted at Makefile.PL line 1.

Resolution:

yum install perl-devel

...

Transaction test succeeded

Running transaction

  Installing : gdbm-devel-1.10-8.el7.x86_64                                                                                                                             1/10

  Installing : pyparsing-1.5.6-9.el7.noarch                                                                                                                             2/10

  Installing : systemtap-sdt-devel-4.0-13.el7.x86_64                                                                                                                    3/10

  Installing : perl-ExtUtils-Manifest-1.61-244.el7.noarch                                                                                                               4/10

  Installing : perl-Test-Harness-3.28-3.el7.noarch                                                                                                                      5/10

  Installing : libdb-devel-5.3.21-25.el7.x86_64                                                                                                                         6/10

  Installing : perl-ExtUtils-MakeMaker-6.68-3.el7.noarch                                                                                                                7/10

  Installing : perl-ExtUtils-Install-1.58-299.el7_9.noarch                                                                                                              8/10

  Installing : 4:perl-devel-5.16.3-299.el7_9.x86_64                                                                                                                     9/10

  Installing : 1:perl-ExtUtils-ParseXS-3.18-3.el7.noarch                                                                                                               10/10

  Verifying  : 1:perl-ExtUtils-ParseXS-3.18-3.el7.noarch                                                                                                                1/10

  Verifying  : libdb-devel-5.3.21-25.el7.x86_64                                                                                                                         2/10

  Verifying  : perl-Test-Harness-3.28-3.el7.noarch                                                                                                                      3/10

  Verifying  : perl-ExtUtils-Install-1.58-299.el7_9.noarch                                                                                                              4/10

  Verifying  : perl-ExtUtils-Manifest-1.61-244.el7.noarch                                                                                                               5/10

  Verifying  : systemtap-sdt-devel-4.0-13.el7.x86_64                                                                                                                    6/10

  Verifying  : pyparsing-1.5.6-9.el7.noarch                                                                                                                             7/10

  Verifying  : gdbm-devel-1.10-8.el7.x86_64                                                                                                                             8/10

  Verifying  : perl-ExtUtils-MakeMaker-6.68-3.el7.noarch                                                                                                                9/10

  Verifying  : 4:perl-devel-5.16.3-299.el7_9.x86_64                                                                                                                    10/10

Installed:

  perl-devel.x86_64 4:5.16.3-299.el7_9

Dependency Installed:

  gdbm-devel.x86_64 0:1.10-8.el7                          libdb-devel.x86_64 0:5.3.21-25.el7                       perl-ExtUtils-Install.noarch 0:1.58-299.el7_9

  perl-ExtUtils-MakeMaker.noarch 0:6.68-3.el7             perl-ExtUtils-Manifest.noarch 0:1.61-244.el7             perl-ExtUtils-ParseXS.noarch 1:3.18-3.el7

  perl-Test-Harness.noarch 0:3.28-3.el7                   pyparsing.noarch 0:1.5.6-9.el7                           systemtap-sdt-devel.x86_64 0:4.0-13.el7

Complete!

Error#2:

-bash-4.2$ make && sudo make install

which: no pod2markdown in (/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/usr/pgsql-15/bin:/usr/pgsql-15/lib)

Makefile:824: You must install pod2markdown to generate README.md from doc/pgBadger.pod

cp pgbadger blib/script/pgbadger

/usr/bin/perl -MExtUtils::MY -e 'MY->fixin(shift)' -- blib/script/pgbadger

echo "=head1 SYNOPSIS" > doc/synopsis.pod

./pgbadger --help >> doc/synopsis.pod

echo "=head1 DESCRIPTION" >> doc/synopsis.pod

sed -i.bak 's/ +$//g' doc/synopsis.pod

rm doc/synopsis.pod.bak

sed -i.bak '/^=head1 SYNOPSIS/,/^=head1 DESCRIPTION/d' doc/pgBadger.pod

sed -i.bak '4r doc/synopsis.pod' doc/pgBadger.pod

rm doc/pgBadger.pod.bak

Manifying blib/man1/pgbadger.1p

rm doc/synopsis.pod

We trust you have received the usual lecture from the local System

Administrator. It usually boils down to these three things:

    #1) Respect the privacy of others.

    #2) Think before you type.

    #3) With great power comes great responsibility.

[sudo] password for postgres:

postgres is not in the sudoers file.  This incident will be reported.

-bash-4.2$

Fix: Run the same command as root

[root@vcentos79-postgres-ha1 pgbadger]# make && sudo make install

which: no pod2markdown in (/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin)

Makefile:824: You must install pod2markdown to generate README.md from doc/pgBadger.pod

echo "=head1 SYNOPSIS" > doc/synopsis.pod

./pgbadger --help >> doc/synopsis.pod

echo "=head1 DESCRIPTION" >> doc/synopsis.pod

sed -i.bak 's/ +$//g' doc/synopsis.pod

rm doc/synopsis.pod.bak

sed -i.bak '/^=head1 SYNOPSIS/,/^=head1 DESCRIPTION/d' doc/pgBadger.pod

sed -i.bak '4r doc/synopsis.pod' doc/pgBadger.pod

rm doc/pgBadger.pod.bak

Manifying blib/man1/pgbadger.1p

rm doc/synopsis.pod

which: no pod2markdown in (/sbin:/bin:/usr/sbin:/usr/bin)

Makefile:824: You must install pod2markdown to generate README.md from doc/pgBadger.pod

echo "=head1 SYNOPSIS" > doc/synopsis.pod

./pgbadger --help >> doc/synopsis.pod

echo "=head1 DESCRIPTION" >> doc/synopsis.pod

sed -i.bak 's/ +$//g' doc/synopsis.pod

rm doc/synopsis.pod.bak

sed -i.bak '/^=head1 SYNOPSIS/,/^=head1 DESCRIPTION/d' doc/pgBadger.pod

sed -i.bak '4r doc/synopsis.pod' doc/pgBadger.pod

rm doc/pgBadger.pod.bak

Manifying blib/man1/pgbadger.1p

Installing /usr/local/share/man/man1/pgbadger.1p

Installing /usr/local/bin/pgbadger

Appending installation info to /usr/lib64/perl5/perllocal.pod

rm doc/synopsis.pod

[root@vcentos79-postgres-ha1 pgbadger]# echo $?

0

[root@vcentos79-postgres-ha1 pgbadger]#

3. Verify if the pgbadger file is accessible, if so from where

-bash-4.2$ which pgbadger

/usr/local/bin/pgbadger

-bash-4.2$ ls -altr /usr/local/share/man/man1/

total 48

drwxr-xr-x. 21 root root   243 Mar 19  2023 ..

-r--r--r--.  1 root root 45127 Jan 28 06:38 pgbadger.1p

drwxr-xr-x.  2 root root    25 Jan 28 06:38 .

-bash-4.2$ pgbadger --help

Usage: pgbadger [options] logfile [...]

    PostgreSQL log analyzer with fully detailed reports and graphs.

Arguments:

..

YouTube video: