oracle11g数据库安装步骤

数据库安装教程：Oracle11g R2 安装教程完整版

Oracle 11g R2是一款非常强大的关系型数据库管理系统，广泛应用于企业级应用开发，本文将详细介绍Oracle 11g R2的安装过程，帮助大家快速掌握安装技巧。

系统要求

在开始安装Oracle 11g R2之前，我们需要了解其系统要求：

1、操作系统：Windows Server 2003/2008/2012/2016/2019，Red Hat Enterprise Linux 5/6/7，SUSE Linux Enterprise Server 11/12等。

2、硬件要求：至少1GB内存，至少1.5GB可用空间。

3、其他软件：Java运行环境（JRE）1.6.0_45或更高版本。

安装准备

1、下载安装文件：访问Oracle官方网站，找到Oracle 11g R2的下载页面，选择适合自己操作系统的版本进行下载。

2、解压安装文件：将下载的压缩包解压到一个合适的目录，例如C:oracle\instantclient_11_2。

3、配置环境变量：在系统环境变量中添加ORACLE_HOME和PATH，分别指向解压后的文件夹和bin目录。

安装Oracle 11g R2

1、创建Oracle用户和组：以管理员身份登录操作系统，创建一个名为oracle的用户和一个名为dba的组。

net user oracle /add
net localgroup dba oracle /add

2、创建Oracle安装目录：在C盘根目录下创建一个名为oracle的文件夹，用于存放Oracle的安装文件和数据文件。

mkdir C:\oracle

3、配置环境变量：在系统环境变量中添加ORACLE_BASE和ORACLE_HOME，分别指向刚刚创建的文件夹和解压后的文件夹。

4、运行安装程序：以管理员身份运行setup.exe，启动Oracle安装向导。

5、选择安装类型：在安装向导中选择“高级安装”，然后点击“下一步”。

6、选择安装路径：在“选择产品语言”界面，选择“简体中文”，然后点击“下一步”。

7、选择安装类型：在“选择安装类型”界面，选择“基本安装”，然后点击“下一步”。

8、设置数据库选项：在“设置数据库选项”界面，设置全局数据库名称、数据库密码等信息，然后点击“下一步”。

9、执行先决条件检查：在“执行先决条件检查”界面，等待检查完成，如果有警告或错误信息，需要解决后才能继续安装。

10、安装产品：在“安装产品”界面，点击“安装”按钮，开始安装Oracle 11g R2。

11、完成安装：等待安装过程完成，点击“关闭”按钮退出安装向导。

验证安装结果

1、打开命令提示符，输入以下命令查看Oracle服务状态：

lsnrctl status

如果看到类似如下输出，说明Oracle 11g R2已经成功安装并运行。

LSNRCTL for Linux: Version 11.2.0.3.0 Production on 04JAN2019 09:57:44
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
  +
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.3.0 Production
Start Date                04JAN2019 09:57:44 uptime        0 days 0 hr. 0 min. 0 sec.
Trace Level               off
Security                  ON: Local OS Authentication    SNMP    STATUS of the PROXY CONTAINER by ADDRESSES AND PIDs...   +   Found row with address = (PROTOCOL=TCP)(HOST=localhost)(PORT=1521) and PID = (PID).   +   Proxy container is running with PID = (PID).   +   Listener using security = ON: Local OS Authentication   SNMP   Listener using DES encryption = NO    LDAP   Listener using BSD authentication = NO    LDAP   Listener using trusted certificate chain = NO    LDAP   Listener using simple authentication = NO    LDAP   Listener using strong authentication = NO    LDAP   Listener using untrusted certificate chain = NO    LDAP   Listener using anonymous authentication = NO    LDAP   Listener supports secure connections = ON: Local OS Authentication    SNMP   Listener supports connection requests using port number = NO    LDAP   Listener supports X509 version 3 certificates = NO    LDAP   Listener supports X509 version 2 certificates = NO    LDAP   Listener supports X509 version 1 certificates = NO    LDAP   Listener supports public key retrieval = NO    LDAP   Listener supports dynamic registration = NO    LDAP   Listener supports client authentication = NO    LDAP   Listener supports serverside prepared statements = NO    LDAP   Listener supports ansi escape sequences = NO    LDAP   Listener supports bind/unbind operations = NO    LDAP   Listener supports extended operations = NO    LDAP   Listener supports session pooling = NO    LDAP   Listener supports multiple protocols = NO    LDAP   Listener supports connection pooling = NO    LDAP   Listener supports transaction rollback recovery = NO    LDAP   Connection Manager Administration Server state is: UNKNOWN   +   Connection Manager running with PID = (PID).   +   Connection Manager has not yet registered itself with the listener manager or has already unregistered itself from the listener manager, but it will be automatically registered by the listener manager when it starts up again in the future.   +   Connection Manager is not currently listening for incoming connection requests at this time because it is in a stopped state and waiting for a start command from the operating system or another process that will start it up again in the future.   +
STARTED Mon Jan 04 09:57:44 2023 (EDT) For Linux: Version 11.2.0.3.0 Production by user "oracle" STOPPED Mon Jan 04 09:57:44 2023 (EDT) For Linux: Version 11.2.0.3.0 Production by user "oracle" LEVEL Standard Security ON: Local OS Authentication    SNMP    Database mounted. Database opened.   +   Database mounted by this instance: /home/oracle/app/product/11.2.0/dbhome_1/database ORCL     Version of database mounted:            ORACLE_HOME = /home/oracle/app/product/11.2.0/dbhome_1      Oracle Home = /home/oracle/app/product/11.2.0/dbhome_1      Oracle Base = /home/oracle/app/product/11.2.0/dbhome_1      ORACLE_SID = ORCL      ORACLE_VERSION = 11gR2