VEGE 数据库 搭建 服务器端

服务器软件安装

服务器开启oracle 1521 端口

oracle服务器端安装

服务器重启

创建服务器实例

这里需要注意文字编码要修改成JA16SJISTILED
密码设定为Vmanager21

添加服务器监听

服务器重启

以上服务器端安装完成

创建用户和表空间，设定时区，导入数据

设定时区

 #查看当前时区
 SELECT dbtimezone FROM DUAL;
 #设为日本时区
 ALTER DATABASE SET TIME_ZONE='+09:00';

NLS_LANG
JAPANESE_JAPAN.JA16SJISTILDE

重启服务器

SELECT * FROM nls_database_parameters

服务器端启动PDB

   #再服务区短cmd命令行登陆sqlplus
   sqlplus /nolog
   conn /as sysdba
   #打开PDB，VEGEEDI为PDB名
   alter pluggable database VEGEEDI open;  //打开PDB
      （select con_id,dbid,NAME,OPEN_MODE from v$pdbs查看pdb容器）
   #设置PDB启动数据库的时候 自动启动
   ALTER PLUGGABLE DATABASE VEGEEDI SAVE STATE;
   #将当前session切换到PDB
   alter session set container=VEGEEDI
   #显示当前所有的PDB名
   show pdbs;

创建用户和表空间

#再服务器端sqlplus执行创建表空间和用户操作
CREATE TEMPORARY TABLESPACE VEGEEDI_TEMP
TEMPFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_TEMP01.DBF' SIZE 32574M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
/

CREATE TABLESPACE VEGEEDI
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI01.DBF' SIZE 11904M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE VEGEEDI_ACC
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_ACC01.DBF' SIZE 8064M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE VEGEEDI_COM
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_COM02.DBF' SIZE 10240M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED,
         'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_COM01.DBF' SIZE 20480M REUSE AUTOEXTEND ON NEXT 128M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE VEGEEDI_INDX01
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_INDX01_01.DBF' SIZE 1024M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE VEGEEDI_INDX02
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_INDX02_02.DBF' SIZE 1024M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE TABLESPACE VEGEEDI_INDX03
DATAFILE 'C:\ORACLE\oradata\VEGETECH\VEGEEDI\VEGEEDI_INDX03_03.DBF' SIZE 17824M REUSE AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED
LOGGING
ONLINE
BLOCKSIZE 8K
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
SEGMENT SPACE MANAGEMENT AUTO
/

CREATE USER VEGEUSER
IDENTIFIED BY KSR          
DEFAULT TABLESPACE VEGEEDI
TEMPORARY TABLESPACE VEGEEDI_TEMP
PROFILE DEFAULT
/
GRANT CONNECT TO VEGEUSER WITH ADMIN OPTION
/
GRANT DATAPUMP_EXP_FULL_DATABASE TO VEGEUSER WITH ADMIN OPTION
/
GRANT DATAPUMP_IMP_FULL_DATABASE TO VEGEUSER WITH ADMIN OPTION
/
GRANT DBA TO VEGEUSER WITH ADMIN OPTION
/
GRANT EXP_FULL_DATABASE TO VEGEUSER WITH ADMIN OPTION
/
GRANT IMP_FULL_DATABASE TO VEGEUSER WITH ADMIN OPTION
/
GRANT RESOURCE TO VEGEUSER WITH ADMIN OPTION
/
GRANT ALTER ANY INDEX TO VEGEUSER WITH ADMIN OPTION
/
GRANT CREATE ANY INDEX TO VEGEUSER
/
GRANT UNLIMITED TABLESPACE TO VEGEUSER WITH ADMIN OPTION
/

创建服务器路径

CREATE DIRECTORY VEGE_IMP AS 'C:\ORACLE\imp';

导入数据

impdp VEGEUSER/KSR@VEGEEDI DIRECTORY=VEGE_IMP DUMPFILE=VEGE_20240820.dmp FULL=Y

错误解决

ora-12638

将sqlnet.ora的

NTS改为NONE