Основы Oracle 18c — 19c часть 1 — установка Express Edition

Основы Oracle 18c — 19c часть 1 — установка Express Edition

Для этого необходимо будет зарегистрироваться

Предисловие

Утилита SQL*Plus — входит в состав дистрибутива
С ее помощью можно подключаться к базе данных, выполнять команды

После установки дистрибутива рассмотрим подключение к базе данных

Учётная записи — SYS, SYSTEM, PDBADMIN
Пароль — указываете свой

Подключение к серверу

Запустите SQL*Plus
Введите учетную запись, пароль

Частые ошибки

TNS:could not resolve service name
Проверьте правильность написания строки соединения
Проверьте работоспособность сетевой службы

invalid username/password; logon denied
Проверьте правильность написания логина и пароля

Однако есть и другой вариант с готовой виртуальной машиной 19c

Как по мне, он интереснее:

Установка
Шаг 1. Загрузите и установите Oracle VM VirtualBox в вашей хост-системе.

Шаг 2. Загрузите файлы (настоятельно рекомендуется использовать менеджер загрузок):

Шаг 3. Импортируйте виртуальную машину:

Шаг 4.

Когда вы попадаете на экран Enterprise Linux 6, вы можете войти в систему

Имя пользователя и пароль — oracle

Для подключения к oracle:

Учётная записи — SYS, SYSTEM
Пароль — oracle

Утилиту sqlcl найдете на рабочем столе

Пример логина: sys as sysdba

Oracle database 19c установка windows

Oracle Database Database Client Installation Guide, 19c for Microsoft Windows

Copyright © 1996, 2020, Oracle and/or its affiliates.

Primary Authors: Tanaya Bhattacharjee, Sunil Surabhi

Contributing Author: Prakash Jashnani, Mark Bauer, Douglas Williams, Bharathi Jayathirtha

Contributors: Barb Glover, Eric Belden, Sudip Datta, David Friedman, Alex Keh, Christian Shay, Peter LaQuerre, Rich Long, Matt McKerley, Sham Rao Pavan, Hanlin Qian, Sujatha Tolstoy, Michael Verheij, Madhu Velukur, Sergiusz Wolicki, Sue Mavris, Mohammed Shahnawaz Quadri, Vishal Saxena, Krishna Itikarlapall, Santanu Datta, Sivaselvam Narayasamy, Michael Coulter, Robert Achacoso, Malai Stalin, David Price, Ramesh Chakravarthula

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are «commercial computer software» or “commercial computer software documentation” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Oracle database 19c установка windows

Oracle Database Database Installation Guide, 19c for Microsoft Windows

Copyright © 1996, 2020, Oracle and/or its affiliates.

Primary Authors: Sunil Surabhi, Tanaya Bhattacharjee

Contributing Authors: Prakash Jashnani, Mark Bauer, Bharathi Jayathirtha

Contributors: Barb Glover, Eric Belden, Sudip Datta, David Friedman, Alex Keh, Peter LaQuerre, Rich Long, Matt McKerley, Sham Rao Pavan, Hanlin Qian, Sujatha Tolstoy, Sergiusz Wolicki, Sue Mavris, Mohammed Shahnawaz Quadri, Vishal Saxena, Krishna Itikarlapall, , Santanu Datta, Christian Shay, Aneesh Khanderwal, Michael Coulter, Robert Achacoso, Malai Stalin, David Price, Ramesh Chakravarthula

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs) and Oracle computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are «commercial computer software» or “commercial computer software documentation” pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction, duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle programs (including any operating system, integrated software, any programs embedded, installed or activated on delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms governing the U.S. Government’s use of Oracle cloud services are defined by the applicable contract for such services. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.

Инсталляция Oracle DataBase

Коллеги, выложили видео с информацией, как развернуть базу с помощью Vagrant + ssh скриптов. Используется Oracle Linux 8 и база Oracle 19C. Для инсталляции необходимо скопировать дистрибутив в нужный каталог и запустить vagrant. Все остальное, скрипты сделают самостоятельно.

Для информации:

Если нет задачи поставить Oracle на какую-то конкретную операционную систему и задача, в первую очередь, сводится к изучению Oracle, рекомендую ставить базу на Oracle Linux. Oracle взяла исходники RedHat и собрала свой дистрибутив. В публичном репозитории Oracle Linux имеются пакеты, которые могут сильно упростить инсталляцию базы и дополнительные пакеты, расширяющие стандартные возможности. В дополнении ко всему вышесказанному, вы можете использовать допиленное ядро UEK, которое, вроде как, в некоторых случаях имеет некоторые преимущесва перед стандартным. Но здесь нужно проводить тесты конкретного приложения. Ссылки на дистрибутив Oracle Lunux в теме для инсталляции.

Подготовка к инсталляции базы данных Oracle:

(Использовать, если в самом документе отстуствует информация о том как это делается)

Single-Instance Architecture

Инсталляция базы данных Oracle в операционной системе Microsoft Windows:

Инсталляция базы данных Oracle в операционной системе Oracle Linux:

Дополнительно инсталляция с использованием ASM:

ASM — более “правильный” способ подготовки окружения Oracle. Суть в том, что для хранения данных используется не файловая система (например, ext*), заточенная для обычных операций в операционной системе, а файловая система разработанная специалистами из Oracle для хранения данных.

“Сырые” (RAW) жесткие диски без файловой системы объединяются в пулы специальными средствами Oracle, что позволяет их логически организовывать и иметь какие-то преимущества по сравнению с файловой системой операционной системы.

При этом создается дополнительный экземпляр Oracle, инсталлируется GRID, появляются еще какие-то дополнительные возможности. Администрирование несколько усложняется.

Лично мне, не приходилось плотно работать с окружением, где бы использовался ASM (поэтому может чего и не знаю), но приходилось устанавливать (установил, отдал и забыл) и настраивать ASM в окружении для RAC.

Если я понял что-то неправильно, поправьте.

Инсталляция Oracle Client:

Oracle Client нужен, чтобы подключиться к базе с помощью большого количества программ для работы с базами данных, например таких как PL/SQL Developer, SQL Navigator, TOAD.

Программой SQL Developer от Oracle можно подключиться без установки Oracle Client.

Instantclient — альтернатива стандартному Oracle Client. Проще в установке на Linux (если нужно поставить client на Ubuntu, то лучше исользовать его). А так это минимальный набор библиотек для удаленного подключения к серверу баз данных. В дополнение, я обычно устанавливаю утилиту командной строки SQLPlus. И все, больше ничего для нормальной работы и не требуется.

Install Oracle Database 19c on Windows: Complete Guide

Are you planning to install Oracle 19c on Windows Server or Windows 10? Then this step by step guide is for you.

The installation of Oracle Software is not always an obvious operation, as it is the case for many DBMS (SQL Server, MySQL, etc.). The steps are however simple, but If you read Oracle documentation, more than 190 pages, you can get lost pretty quickly. There is a lot of information.

In this guide, I’ll simplify theses processes for you. I’ll show you the key steps to successfully install Oracle 19c on Windows, from the first attempt. Upon completion of this installation, all of the components required to create and administer a database in Oracle Database 19c will be available.

So I assume that you already have your Windows server set up and running. To avoid issues during the installation process, make sure your environment meets Oracle 19c installation requirements.

Install Oracle Database 19c on Windows step by step

1. Download Oracle Database 19c software for Windows

Our first step is to get the Oracle 19c software for Windows from the official Oracle download page. On this page you will find many packages. In this guide, we will focus on the Oracle Database 19c (19.3) for Microsoft Windows x64 (64-bit) package. If you want to access your future Oracle database remotely, you can also download the Oracle Database 19c Client (19.3) for Microsoft Windows x64 (64-bit) or Oracle Database 19c Client (19.3) for Microsoft Windows (32- bit) according to the architecture of the client computer.

Downloading Oracle 19c software is free, however to use it in the production environment requires a license. Note also that downloading requires an Oracle account.

2. Launch the setup wizard

Once the download is complete

• unzip the package then copy it to the root of your disk;
• rename the folder, choose a shorter name (eg. db_home);
• then launch the setup.

Note: the installation wizard may take several minutes to open. So be patient.

3. Choose database installation options

This step is very important. It allows you to choose the database installation options. You can install Oracle software and create a database at the same time (Create and configure a single instance database).Since we only want to install the Oracle 19c software and its components, we will opt for “Set up Software Only”. This option installs the essential components for creating and administering a database. You can also use it to upgrade an older version of Oracle (example: 12c or 18c) or install RAC.

4. Select database installation type

The first option allows you to install a single instance database on your server. Oracle Database with the Oracle Real Application Clusters (RAC) option allows multiple instances running on different servers to access the same physical database stored on shared storage.As we want to install Oracle 19c on a single server, we select option 1.

You can create a database after installation by using Oracle Database Configuration Assistant (Oracle DBCA).

5. Choose database edition

The version of the database to install depends on your needs. For an application developer or and medium-size companies, the standard version covers practically all needs.To take full advantage of Oracle 19c, you can install the Enterprise version. Obviously, the Enterprise version requires more resources (storage, RAM, CPU).

6. Specify Oracle home user

During Oracle Database installation, you can specify an optional Oracle home user associated with the Oracle home. Oracle home user can be a Windows built-in account (LocalSystem for Server and LocalService for Client), virtual account, or a regular (not an administrator) Windows account. If you specify an existing user as the Oracle home user, then the Windows user account you specify can either be a Windows domain user or a Windows local user.

A Windows user account need not be created by the administrator if a virtual account or a Windows built-in account is used during installation. If you specify a non-existing user as the Oracle home user, then the Windows user account you specify must be a Windows local user. The installer creates this account automatically to run the Windows services for the Oracle home. Do not log in using this account to perform administrative tasks.

7. Specify the location of Oracle software

In a default Windows installation, the Oracle base directory appears as follows: DRIVE_LETTER:\app\username where username is the Oracle installation user if you choose Windows built-in a ccount, else it is the Oracle Home user (standard Windows user account). You can change this directory at your convenience or leave it as default.

8. Minimum requirements checks, summary and end of the installation

After these initial phases of configuration, let’s check the installation prerequisites. If, however, there are errors, try to readjust the minimum installation requirements and start again.

Click install if no error occurs.

That’s it. You can close the installation wizard now.

You can take a look at the different components of your installation from the Windows start menu.

Still having trouble installing Oracle 19c on Windows? Leave a comment below. I will assist you troubleshooting your installation.