Thursday, August 1, 2024

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

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

No comments:

Post a Comment

Flashback data archive steps

 Objective: Ways to track DML changes in a table Detailed objective: We should be able to track the changes in the table at any point in tim...