windows版本oracle19c安装教程-新手教程

1、文件准备下载地址 Database Software Downloads网盘下载地址WINDOWS.X64_193000_db_home.zip 链接: https://pan.baidu.com/s/1MUKq-AGr67vcnBwAFvJKUg 提取码: vgyb解压安装文件放好位置 安装后不能移动、不能删 (我是放D:oracl 注意文件路径不能有中文不能有空格 之前我放D:\Program Files 双击就闪退或者报错装不了)2、安装看选择就可以第九步 先设置内存 在设置字符集 字符集默认是utf-8不勾选不勾选设置密码 ( 我选的是 三个账号统一用一个 可以分开设置 )录入密码点击下一步 直到 提示完成根据你设置的内存大小安装时间会不一样 设置的很大安装时间会很差 中途很长一段时间 感觉卡了没动 耐心等待安装完成即可 3、端口配置默认端口是1521 若需要外网使用建议改端口全部程序中找到 下图的功能提示完成 关掉窗口需要执行下面代码才能生效# cmd: 查询本机名称 hostname # 修改端口后需要执行以下代码 不然连接不了 HOSTWIN-03OQRTCHUOU改成自己查询的名称 #进入sqlplus sqlplus / as sysdba ALTER SYSTEM SET local_listener(ADDRESS(PROTOCOLTCP)(HOSTWIN-03OQRTCHUOU)(PORT1539)) SCOPEBOTH; ALTER SYSTEM REGISTER;4、数据导入数据库工具登录system 账号执行 --查询pdb SELECT con_id, name, open_mode,RESTRICTED FROM v$PDBs; --切换到 pdb1 在执行后续代码 ALTER SESSION SET CONTAINER PDB1; --创建表空间 表空间名称”DHERP_YUNHE01.DBF“ create tablespace DHERP_YUNHE logging datafile D:\oracle\app\Administrator\oradata\ORCL\pdb1\DHERP_YUNHE01.DBF size 1G autoextend on next 500M extent management local; --创建用户 CREATE USER DHERP_YUNHE IDENTIFIED BY 123456%*** DEFAULT TABLESPACE DHERP_YUNHE TEMPORARY TABLESPACE temp; -- 先撤销权限 revoke dba from DHERP_YUNHE; --1、初装权限 grant connect to DHERP_YUNHE; grant recovery_catalog_owner to DHERP_YUNHE; grant resource to DHERP_YUNHE; grant create session to DHERP_YUNHE; grant create table to DHERP_YUNHE; grant create view to DHERP_YUNHE; grant unlimited tablespace to DHERP_YUNHE; --2、初装完成后增加权限 grant ALTER SESSION to DHERP_YUNHE; grant CREATE CLUSTER to DHERP_YUNHE; grant CREATE SYNONYM to DHERP_YUNHE; grant CREATE SEQUENCE to DHERP_YUNHE; grant CREATE DATABASE LINK to DHERP_YUNHE; grant CREATE TRIGGER to DHERP_YUNHE; grant CREATE TYPE to DHERP_YUNHE; grant CREATE OPERATOR to DHERP_YUNHE; grant CREATE INDEXTYPE to DHERP_YUNHE; grant CREATE JOB to DHERP_YUNHE; grant create database link to DHERP_YUNHE; grant create public database link to DHERP_YUNHE; grant drop public database link to DHERP_YUNHE; grant debug any procedure, debug connect session to DHERP_YUNHE; #创建目录对象 CREATE DIRECTORY DIR_DP AS D:\oracle\oracle_dr_temp; grant read,write on directory DIR_DP to DHERP_YUNHE; grant imp_full_database to DHERP_YUNHE; grant exp_full_database to DHERP_YUNHE; --若之前建过 查询一下 把dmp文件放到这个目录下 SELECT * FROM dba_directories WHERE directory_name DIR_DP;若varchar2字段长度有超过2000的需要 开启超长字符串支持cmd黑窗口 执行------ 若字段长度有超过2000的需要 开启超长字符串支持 --------------- --使用 sysdba 用户登录数据库 sqlplus / as sysdba --修改初始化参数 MAX_STRING_SIZE EXTENDED开启超长字符串支持 默认STANDARD --1修改 CDB (必须最先操作 ALTER PLUGGABLE DATABASE ALL CLOSE IMMEDIATE; SHUTDOWN IMMEDIATE; STARTUP UPGRADE; ALTER SYSTEM SET max_string_sizeEXTENDED SCOPESPFILE; ?/rdbms/admin/utl32k.sql; SHUTDOWN IMMEDIATE; STARTUP; --2修改PDB1当前 MOUNTED 状态 ALTER PLUGGABLE DATABASE pdb1 CLOSE IMMEDIATE; ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE; ALTER SESSION SET CONTAINER pdb1; ALTER SYSTEM SET MAX_STRING_SIZE EXTENDED SCOPE SPFILE; ?/rdbms/admin/utl32k.sql; ALTER PLUGGABLE DATABASE pdb1 CLOSE; ALTER PLUGGABLE DATABASE pdb1 OPEN; -- 查看是否开启 超长字符串支持 EXTENDED SELECT value FROM v$parameter WHERE name max_string_size; --查看 pbd是否启动 READ WRITE SELECT con_id, name, open_mode,RESTRICTED FROM v$PDBs; -----------------------------------------------------------------------导入 备份数据cmd黑窗口 执行--导入语句 转义特殊字符\123456%***\ 没有特殊字符可以不用转义 直接写 impdp DHERP_YUNHE/ 123456192.168.1.9:1539/PDB1 impdp DHERP_YUNHE/\123456%***\192.168.1.9:1539/PDB1 DIRECTORYDIR_DP DUMPFILEDHERP_YUNHE_202608282039.dmp REMAP_SCHEMADHERP_YUNHE:DHERP_YUNHE REMAP_TABLESPACEDHERP_YUNHE:DHERP_YUNHE