/**PageBeginHtml Block Begin **/ /***自定义返回顶部小火箭***/ /*生成博客目录的JS 开始*/ /*生成博客目录的JS 结束*/

Win10 安装Oracle21c 教程

 

Win10 安装Oracle21c 教程

 

1：(官方)下载地址

https://www.oracle.com/database/technologies/oracle21c-windows-downloads.html

image

Oracle Database 21c (21.3)

Oracle Database 21c (21.3) for Microsoft Windows x64 (64-bit)

Download

Description
WINDOWS.X64_213000_db_home.zip
 (2,661,783,521 bytes) (sha256sum - 85a41b94bccae23fe2af3f3d1d3d9e7e93e13f32ad7731dcf72d1cc6763c04ad)

Directions
Installation guides and general Oracle Database 19c documentation are here.

 

 

Contains examples of how to use the Oracle Database. Download if you are new to Oracle and want to try some of the examples presented in the Documentation

Oracle Database 21c Client (21.3) for Microsoft Windows x64 (64-bit)

Download

Description
WINDOWS.X64_213000_client_home.zip
 (64-bit) (866,236,510 bytes) (sha256sum - 26ce71a7085a150513018e1dd93c5fac691dba887b301cd05447b94e52438345)
WINDOWS.X64_213000_client.zip
 (64-bit) (963,821,714 bytes) (sha256sum - 967ff01aaed2c0545b20a2eacf10efd40235ff181b60c3c0b66e7642c1930845)

Contains the Oracle Client Libraries for Windows. Download if you want the client libraries only

Oracle Database 21c Client (21.3) for Microsoft Windows (32-bit)

Download

Description
NT_213000_client_home.zip
 (32-bit) (816,095,548 bytes) (sha256sum - ffeebd4a1c44c9687247cc5576a945c2e7d5f6c818d93ef04c71ecd2283f0c18)
NT_213000_client.zip
 (32-bit) (910,656,466 bytes) (sha256sum - d6393209521862d289ecb69a74b93ac0620ec8c83d1e4079b27f95d75c654139)

Contains the Oracle Client Libraries for Windows. Download if you want the client libraries only

 

 

 

 

 

 

 

 

 

 

2：解压压缩包 到Oracle_Home 目录

image

image

 

 

 

在本文中，ORACLE_HOME目录如下：E:\SoftWare\Develop_software\Oracel21c\app\oracle\product\21.3.0\dbhome_1

所有文件将解压到该目录。

image

 

安装Oracle数据库21.3

 

获取镜像后，点击“Setup.exe”，或者在命令行中运行。

 

Microsoft Windows [版本 10.0.17763.4131]
(c) 2018 Microsoft Corporation。保留所有权利。

C:\Windows\system32>cd E:\SoftWare\Develop_software\Oracel21c\app\oracle\product\21.3.0\dbhome_1

C:\Windows\system32>e:

E:\SoftWare\Develop_software\Oracel21c\app\oracle\product\21.3.0\dbhome_1>setup.bat
正在启动 Oracle 数据库安装向导...

libpng warning: iCCP: cHRM chunk does not match sRGB

image

image

 

image

image

image

image

image

image

image

image

image

 

image

image

 

image

image

image

image

image

image

漫长的等待

image

image

 

image

 

 

 

 

 

 

image

处理数据库01033连接错误问题.sql

复制代码
 Microsoft Windows [版本 6.1.7601]
 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
 
 C:\Users\Administrator>sqlplus /nolog
 
 SQL*Plus: Release 12.1.0.2.0 Production on 星期一 7月 25 00:10:15 2016
 
 Copyright (c) 1982, 2014, Oracle.  All rights reserved.
 
  SQL> conn /  as sysdba;
  已连接。
复制代码
 
 
 
 
 
Connected to Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 
Connected as sys@127.0.0.1:1521/orcl AS SYSDBA

SQL>  select * from v$version;
BANNER                                                                           BANNER_FULL                                                                      BANNER_LEGACY                                                                        CON_ID
-------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ----------
Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production           Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production           Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production                    0
                                                                                 Version 21.3.0.0.0                                                                                                                                                

SQL> select sys_context ('USERENV', 'CON_NAME') from dual;
SYS_CONTEXT('USERENV','CON_NAM
--------------------------------------------------------------------------------
CDB$ROOT

SQL>  select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
    CON_ID       DBID NAME                                                                             OPEN_MODE
---------- ---------- -------------------------------------------------------------------------------- ----------
         2 1455667323 PDB$SEED                                                                         READ ONLY
         3  116123274 ORCLPDB                                                                          MOUNTED

SQL> alter pluggable database orclpdb open;
Done

SQL> select con_id,dbid,NAME,OPEN_MODE from v$pdbs;
    CON_ID       DBID NAME                                                                             OPEN_MODE
---------- ---------- -------------------------------------------------------------------------------- ----------
         2 1455667323 PDB$SEED                                                                         READ ONLY
         3  116123274 ORCLPDB                                                                          READ WRITE


SQL> select sys_context ('USERENV', 'CON_NAME') from dual;
SYS_CONTEXT('USERENV','CON_NAM
--------------------------------------------------------------------------------
CDB$ROOT

SQL> alter session set container=ORCLPDB;
Session altered

SQL> select sys_context ('USERENV', 'CON_NAME') from dual;
SYS_CONTEXT('USERENV','CON_NAM
--------------------------------------------------------------------------------
ORCLPDB

SQL>

　　

 

 

 

 

 

、、

posted @ 2023-04-05 22:07  一品堂.技术学习笔记  阅读(864)  评论(0)  编辑  收藏  举报