Install Oracle Database Windows

[Armanda Kicks]

Thistutorial shows you how to install the Oracle Database 12c software on Microsoft Windows along with a default instance of an Oracle Database that contains example schemas ( including the HR schema).

During the installation process, OUI will start the Oracle Database Configuration Assistant (DBCA) which can install a precreated default database that contains example schemas or can guide you through the process of creating and configuring a customized database.

If you do not create a database during installation, you can invoke DBCA after you have installed the software, to create one or more databases.

Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet the requirements, an error message is displayed. Some of the requirements to install the software are:

The software downloads page displays the files required to download the database. It lists a set of software files to install software such as, Oracle Database Grid Infrastructure and Oracle Database Gateways with the Oracle database. Each set displays a short description of what the file includes. You can choose to download any set of software depending on your requirement.

After downloading the files, use the default built-in extraction tool provided by Windows, or tools such as 7-zip to extract the .zip files. In this OBE, we use the built-in extractor to extract the software files.

The Configure Security Updates window appears. Enter your email address and My Oracle Support password to receive security issue notifications via email. If you do not wish to receive notifications via email, deselect "I wish to receive security updates via My Oracle Support". Click Next to continue. Click "Yes" in the confirmation window to confirm your preference.

The System Class window appears. Select Desktop Class or Server Class depending on the type of system you are using. In this OBE, we will perform the installation on a desktop/laptop. Select Desktop class and click Next.

The Oracle Home User Selection window appears. Starting with Oracle Database 12c Release 1 (12.1), Oracle Database on Microsoft Windows supports the use of an Oracle Home User, specified at the time of installation. This Oracle Home User is used to run the Windows services for a Oracle Home, and is similar to the Oracle User on Oracle Database on Linux. This user is associated with an Oracle Home and cannot be changed to a different user post installation.

Note:

The Typical Install Configuration window appears. Click on a text field and then the balloon icon ( )to know more about the field. Note that by default, the installer creates a container database along with a pluggable database called "pdborcl". The pluggable database contains the sample HR schema. Change the Global database name to orcl. Enter the "Administrative password" as Oracle_1. This password will be used later to log into administrator accounts such as SYS and SYSTEM. Click Next.

After the Database Configuration Assistant creates the database, you can navigate to :5500/em as a SYS user to manage the database using Enterprise Manager Database Express. You can click "Password Management..." to unlock accounts. Click OK to continue.

In this section, you will be performing steps to verify the installation of Oracle Database. If you had changed the default location to install the database, make sure to specify the correct location of the files in the following steps. Alternatively, you can also perform a quick search using the Windows Start Menu to locate files.

Navigate to C:\app\OracleHomeUser1\product\12.1.0\dbhome_1 folder. This folder is the new "Oracle Home" created by the installer and contains software files related to the database.

Create a database connect alias called "PDBORCL" and specify the network configuration settings to access the pluggable database "PDBORCL" that we created during installation. Copy the following code and paste it in the tnsnames.ora file. If necessary, modify the host and port to match the values in the ORCL alias.

The database stores information about MSI files, applications, deployment rules, and deployment rule sets. The database also stores information about agents, Java Runtime Environment (JRE) statistics, and Java Installer configurations. This chapter contains the following sections that describe software requirements for the Oracle Database as well as installation and configuration procedures:

Configure your Oracle database QUOTA to UNLIMITED to ensure that enough database storage is available to support large BLOB entries, such as MSI binaries. If you encounter an issue with the SQL Create User statement, then log out of SQL*Plus application and repeat step 1 and step 2.

Run ./orachk as a root user to check the Oracle database and generate HTML report. This creates a zip file of the report that contains an HTML file. The report includes any issues that were found along with links to MOS notes or documentation to fix the issues.

To ensure a smooth installation of Oracle Database on Windows, you need to meet the necessary system requirements. This involves having the right hardware and software in place, as well as ensuring you have enough available disk space. By understanding these key elements, you can proceed with confidence and successfully start your Oracle Database on Windows.

To start downloading the Oracle Database software for Windows, access the Oracle website and create an account. Then, navigate to the download section. These steps will help you get the necessary software to begin your Oracle database journey on Windows.

To begin the process of installing Oracle Database on your Windows system, follow these steps: run the installer, choose the installation type, configure installation options, and provide necessary information and credentials. Each sub-section will guide you through a specific aspect of the installation, ensuring a successful setup of your Oracle software.

Starting the database instance is important for accessing and manipulating data. Follow these steps to ensure a smooth start. Unlock endless possibilities for data management and analysis by starting your database instance now! Start your journey towards efficient data handling today.

Oracle Database began in 1977 as Software Development Laboratories (SDL). Developed by Larry Ellison, Bob Miner, and Ed Oates, it was designed to be an efficient and scalable solution for enterprise applications. Over the years, Oracle Database has evolved and reinforced its status as a leader in the database industry.

Network connection problems can be caused by an issue with the router. To fix this, unplug the power source, wait a few moments, then plug it back in. Also check if the physical connections between devices and the router are secure.

Second, learn the command prompt and terminal commands for starting the database. These commands help manage and control the operations. Execute the commands to start the process and make sure all services are running.

Q: What alternative methods can I use to start the Oracle database in Windows?

A: Apart from using the Command Prompt and SQL*Plus utility, you can also start the Oracle database using the Oracle Enterprise Manager (OEM) Console or Oracle SQL Developer. These tools provide graphical interfaces that allow you to start and manage the database easily.

I have a Windows 2008 Server with an Oracle 11g R2 (11.2.0.3, Standard, 64-bit) database. I need to install an additional database (11.2.0.3, Standard, 64-bit) for tests on the same server. These tests target database patches, which shall first be applied on the new database before applying these patches on the existing database, to evaluate potential problems after patching.

I am used to install, configure and manage Oracle databases as stand-alone, RAC or as physical standby via DataGuard since 9i - as long as I am in a Un*x / linux (Red Hat Enterprise Linux, CEntOs, Oracle Enterprise Linux, etc.) environment. Setting up multiple instances in a single home or multiple homes has never been an issue for me until now.

I have searched google, oracle.com, and other related forums already. But I could not find any results regarding installing two or more Oracle homes on Windows. I have found guidelines on copying / cloning an instance into a new home, but if i recall correctly it is meant for copying / cloning onto other servers and not on the same server. Since the existing database is installed on Windows, I am afraid that I may damage the existing install by running the setup wizard again, changing Windows registry values and running the database as service.

Viewed 10K+ times! This question is You Asked Oracle 19c installation fails in my system.

When I click the setup I am getting an error "[INS-13001] Oracle Database is not supported on this operating system. Installer will not perform prerequisite checks on the system." and If I continue with this the installation exits in the 3rd step.

I am using windows 64 bit os win10.0.18363. Please help me to fix this.

and Connor said...Windows 64 bit is certainly supported (and I've got several 19c versions installed here on my laptop), so its surprising to see that message.

What happens if you avoid the check, ie?

./runInstaller -ignoreSysPrereqs -ignorePrereq

Rating (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment Comments Comment Ignoring check resulted in a not clean installSubha Sethuraman, February 17, 2022 - 11:08 pm UTC

3a8082e126