当前位置： 首页 > news >正文

(二)docker：建立oracle数据库mount startup

news 2026/4/21 3:46:16
  • 这章其实我想试一下startup部分做mount，因为前一章在建完数据库容器后，需要手动创建用户，授权，建表等，好像正好这部分可以放到startup里，在创建容器时直接做好；因为setup部分我实在没想出来能做什么，所以那部分就不做试验了。后边的链接是官方文档里的描述，主要根据这部分做。
    /opt/oracle/scripts/startup
    Running scripts after setup and on startup
Running Oracle Database 21c/18c Express Edition in a container
To run your Oracle Database 21c, or 18c Express Edition container image use the docker run command as follows:docker run --name <container name> \
-p <host port>:1521 -p <host port>:5500 \
-e ORACLE_PWD=<your database passwords> \
-e ORACLE_CHARACTERSET=<your character set> \
-v [<host mount point>:]/opt/oracle/oradata \
oracle/database:21.3.0-xeParameters:--name:        The name of the container (default: auto generated)-p:            The port mapping of the host port to the container port.Two ports are exposed: 1521 (Oracle Listener), 5500 (EM Express)-e ORACLE_PWD: The Oracle Database SYS, SYSTEM and PDB_ADMIN password (default: auto generated)-e ORACLE_CHARACTERSET:The character set to use when creating the database (default: AL32UTF8)-v /opt/oracle/oradataThe data volume to use for the database.Has to be writable by the Unix "oracle" (uid: 54321) user inside the container!If omitted the database will not be persisted over container recreation.-v /opt/oracle/scripts/startup | /docker-entrypoint-initdb.d/startupOptional: A volume with custom scripts to be run after database startup.For further details see the "Running scripts after setup and on startup" section below.-v /opt/oracle/scripts/setup | /docker-entrypoint-initdb.d/setupOptional: A volume with custom scripts to be run after database setup.For further details see the "Running scripts after setup and on startup" section below.

1.首先将前一章创建的容器停止，删除

sixdog@sixiaodong oracle % 
sixdog@sixiaodong oracle % docker ps 
CONTAINER ID   IMAGE                       COMMAND                   CREATED       STATUS                 PORTS                                            NAMES
0aa0fc400733   oracle/database:21.3.0-xe   "/bin/bash -c $ORACL…"   5 hours ago   Up 5 hours (healthy)   0.0.0.0:1521->1521/tcp, 0.0.0.0:5500->5500/tcp   oracle21
sixdog@sixiaodong oracle % docker stop oracle21
oracle21
sixdog@sixiaodong oracle % docker rm oracle21
oracle21
sixdog@sixiaodong oracle % docker ps           
CONTAINER ID   IMAGE     COMMAND   CREATED   STATUS    PORTS     NAMES
sixdog@sixiaodong oracle %

2.目录结构
在本地电脑的创建的oracle目录下的树形结构
├── oradata
├── scripts
│ ├── setup
│ └── startup
│ ├── 01_create.sql
│ ├── 02_dept.sql
│ └── 03_emp.sql

01-03 sql文件里的内容就是前一章创建用户权限以及创建表的sql

3.创建并启动容器
这里需要注意，我是拿前一章我写的命令改的，但是复制到命令窗口就报：docker: invalid reference format.错误，应该是有些什么格式被拷到命令行了，完全手打一边执行就好了

sixdog@sixiaodong oracle % docker run -d \                      
--name oracle21 \
-p 1521:1521 -p 5500:5500 \
-e ORACLE_PWD:123456 \
-v ./oradata:/opt/oracle/oradata \
-v ./scripts/startup:/opt/oracle/scripts/startup \
oracle/database:21.3.0-xe
35493050254a5b507d281467771986cd28b61873c555abe2df6023500bef832a

4.三个sql文件的内容
4.1.vi ./scripts/startup/01_create.sql

alter session set container = XEPDB1;
CREATE USER SIXDOG IDENTIFIED BY 123456;
GRANT CONNECT, RESOURCE, DBA TO SIXDOG;

4.2.vi ./scripts/startup/02_dept.sql

alter session set container = XEPDB1;--------------------------------------------------------
--  文件已创建 - 星期六-十月-21-2023
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table DEPT
--------------------------------------------------------CREATE TABLE "SIXDOG"."DEPT"(    "DEPTNO" NUMBER(2,0),"DNAME" VARCHAR2(14 BYTE),"LOC" VARCHAR2(13 BYTE)) SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255NOCOMPRESS LOGGINGSTORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ;
REM INSERTING into SIXDOG.DEPT
SET DEFINE OFF;
Insert into SIXDOG.DEPT (DEPTNO,DNAME,LOC) values (10,'ACCOUNTING','NEW YORK');
Insert into SIXDOG.DEPT (DEPTNO,DNAME,LOC) values (20,'RESEARCH','DALLAS');
Insert into SIXDOG.DEPT (DEPTNO,DNAME,LOC) values (30,'SALES','CHICAGO');
Insert into SIXDOG.DEPT (DEPTNO,DNAME,LOC) values (40,'OPERATIONS','BOSTON');
--------------------------------------------------------
--  DDL for Index PK_DEPT
--------------------------------------------------------CREATE UNIQUE INDEX "SIXDOG"."PK_DEPT" ON "SIXDOG"."DEPT" ("DEPTNO")PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ;
--------------------------------------------------------
--  Constraints for Table DEPT
--------------------------------------------------------ALTER TABLE "SIXDOG"."DEPT" ADD CONSTRAINT "PK_DEPT" PRIMARY KEY ("DEPTNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS"  ENABLE;commit;

4.3.vi ./scripts/startup/03_emp.sql

alter session set container = XEPDB1;
--------------------------------------------------------
--  文件已创建 - 星期六-十月-21-2023   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table EMP
--------------------------------------------------------CREATE TABLE "SIXDOG"."EMP"(    "EMPNO" NUMBER(4,0),"ENAME" VARCHAR2(10 BYTE),"JOB" VARCHAR2(9 BYTE),"MGR" NUMBER(4,0),"HIREDATE" DATE,"SAL" NUMBER(7,2),"COMM" NUMBER(7,2),"DEPTNO" NUMBER(2,0)) SEGMENT CREATION IMMEDIATEPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255NOCOMPRESS LOGGINGSTORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ;
REM INSERTING into SIXDOG.EMP
SET DEFINE OFF;
insert into SIXDOG.emp values( 7839, 'KING', 'PRESIDENT', null, to_date('17-11-1981','dd-mm-yyyy'), 5000, null, 10 );
insert into SIXDOG.emp values( 7698, 'BLAKE', 'MANAGER', 7839, to_date('1-5-1981','dd-mm-yyyy'), 2850, null, 30 );
insert into SIXDOG.emp values( 7782, 'CLARK', 'MANAGER', 7839, to_date('9-6-1981','dd-mm-yyyy'), 2450, null, 10 );
insert into SIXDOG.emp values( 7566, 'JONES', 'MANAGER', 7839, to_date('2-4-1981','dd-mm-yyyy'), 2975, null, 20 );
insert into SIXDOG.emp values( 7788, 'SCOTT', 'ANALYST', 7566, to_date('13-7-87','dd-mm-rr') - 85, 3000, null, 20 );
insert into SIXDOG.emp values( 7902, 'FORD', 'ANALYST', 7566, to_date('3-12-1981','dd-mm-yyyy'), 3000, null, 20 );
insert into SIXDOG.emp values( 7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980','dd-mm-yyyy'), 800, null, 20 );
insert into SIXDOG.emp values( 7499, 'ALLEN', 'SALESMAN', 7698, to_date('20-2-1981','dd-mm-yyyy'), 1600, 300, 30 );
insert into SIXDOG.emp values( 7521, 'WARD', 'SALESMAN', 7698, to_date('22-2-1981','dd-mm-yyyy'), 1250, 500, 30 );
insert into SIXDOG.emp values( 7654, 'MARTIN', 'SALESMAN', 7698, to_date('28-9-1981','dd-mm-yyyy'), 1250, 1400, 30 );
insert into SIXDOG.emp values( 7844, 'TURNER', 'SALESMAN', 7698, to_date('8-9-1981','dd-mm-yyyy'), 1500, 0, 30 );
insert into SIXDOG.emp values( 7876, 'ADAMS', 'CLERK', 7788, to_date('13-7-87', 'dd-mm-rr') - 51, 1100, null, 20 );
insert into SIXDOG.emp values( 7900, 'JAMES', 'CLERK', 7698, to_date('3-12-1981','dd-mm-yyyy'), 950, null, 30 );
insert into SIXDOG.emp values( 7934, 'MILLER', 'CLERK', 7782, to_date('23-1-1982','dd-mm-yyyy'), 1300, null, 10 );--------------------------------------------------------
--  DDL for Index PK_EMP
--------------------------------------------------------CREATE UNIQUE INDEX "SIXDOG"."PK_EMP" ON "SIXDOG"."EMP" ("EMPNO")PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS" ;
--------------------------------------------------------
--  Constraints for Table EMP
--------------------------------------------------------ALTER TABLE "SIXDOG"."EMP" ADD CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)TABLESPACE "USERS"  ENABLE;
--------------------------------------------------------
--  Ref Constraints for Table EMP
--------------------------------------------------------ALTER TABLE "SIXDOG"."EMP" ADD CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")REFERENCES "SIXDOG"."DEPT" ("DEPTNO") ENABLE;commit;

4.4.仔细看会发现每个sql文件里都加了这句sql：alter session set container = XEPDB1;这是因为当执行完01的sql后，在02执行时又变回未变更的状态，记得是什么cbd，所以第二个文件执行书会报错，找不到01里创建的sixdog用户，因此每个sql文件开头都要执行下alter session set container = XEPDB1;这句话，才能后边正常执行完

5.启动时的log，能看到startip的sql的执行结果等信息

sixdog@sixiaodong oracle % docker logs -f -t --tail=200 oracle21
2023-10-21T13:14:21.122127328Z Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
2023-10-21T13:14:21.122205148Z Confirm the password:
2023-10-21T13:14:21.125179095Z Configuring Oracle Listener.
2023-10-21T13:14:22.170274929Z Listener configuration succeeded.
2023-10-21T13:14:22.170293197Z Configuring Oracle Database XE.
2023-10-21T13:14:27.431078459Z Enter SYS user password: 
2023-10-21T13:14:27.431797591Z ******************
2023-10-21T13:14:27.432183957Z Enter SYSTEM user password: 
2023-10-21T13:14:27.433604612Z ****************
2023-10-21T13:14:27.434078778Z Enter PDBADMIN User Password: 
2023-10-21T13:14:27.435423640Z *******************
2023-10-21T13:14:32.338077207Z Prepare for db operation
2023-10-21T13:14:32.447725526Z 7% complete
2023-10-21T13:14:32.448756267Z Copying database files
2023-10-21T13:15:30.528078655Z 29% complete
2023-10-21T13:15:30.528738192Z Creating and starting Oracle instance
2023-10-21T13:15:31.399441903Z 30% complete
2023-10-21T13:15:35.816375473Z 33% complete
2023-10-21T13:18:09.118585435Z 37% complete
2023-10-21T13:18:09.392835416Z 40% complete
2023-10-21T13:18:38.738733843Z 43% complete
2023-10-21T13:18:38.738941299Z Completing Database Creation
2023-10-21T13:18:39.965427557Z 47% complete
2023-10-21T13:20:26.284353176Z 50% complete
2023-10-21T13:20:26.285642082Z Creating Pluggable Databases
2023-10-21T13:20:36.479225831Z 54% complete
2023-10-21T13:20:36.479553205Z 71% complete
2023-10-21T13:20:36.480084657Z Executing Post Configuration Actions
2023-10-21T13:20:36.480585492Z 93% complete
2023-10-21T13:20:36.481269227Z Running Custom Scripts
2023-10-21T13:20:37.341984478Z 100% complete
2023-10-21T13:20:37.343098621Z Database creation complete. For details check the logfiles at:
2023-10-21T13:20:37.343115107Z  /opt/oracle/cfgtoollogs/dbca/XE.
2023-10-21T13:20:37.343122165Z Database Information:
2023-10-21T13:20:37.343130299Z Global Database Name:XE
2023-10-21T13:20:37.343134676Z System Identifier(SID):XE
2023-10-21T13:20:37.346008056Z Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.
2023-10-21T13:20:37.710223931Z 
2023-10-21T13:20:37.724147696Z Connect to Oracle Database using one of the connect strings:
2023-10-21T13:20:37.724166410Z      Pluggable database: 35493050254a/XEPDB1
2023-10-21T13:20:37.724180637Z      Multitenant container database: 35493050254a
2023-10-21T13:20:37.724183312Z Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE
2023-10-21T13:20:37.735017669Z 
2023-10-21T13:20:37.735076915Z SQL*Plus: Release 21.0.0.0.0 - Production on Sat Oct 21 13:20:37 2023
2023-10-21T13:20:37.735084400Z Version 21.3.0.0.0
2023-10-21T13:20:37.735086955Z 
2023-10-21T13:20:37.735088957Z Copyright (c) 1982, 2021, Oracle.  All rights reserved.
2023-10-21T13:20:37.735090961Z 
2023-10-21T13:20:37.779185240Z 
2023-10-21T13:20:37.779206298Z Connected to:
2023-10-21T13:20:37.779209146Z Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
2023-10-21T13:20:37.779211365Z Version 21.3.0.0.0
2023-10-21T13:20:37.779213319Z 
2023-10-21T13:20:37.799757965Z SQL> 
2023-10-21T13:20:37.799839527Z System altered.
2023-10-21T13:20:37.799847394Z 
2023-10-21T13:20:37.818350175Z SQL> 
2023-10-21T13:20:37.818380568Z System altered.
2023-10-21T13:20:37.818383592Z 
2023-10-21T13:20:37.832978864Z SQL> 
2023-10-21T13:20:37.833043587Z Pluggable database altered.
2023-10-21T13:20:37.833055564Z 
2023-10-21T13:20:37.953638976Z SQL> 
2023-10-21T13:20:37.953663825Z PL/SQL procedure successfully completed.
2023-10-21T13:20:37.953667379Z 
2023-10-21T13:20:37.954561400Z SQL> SQL> 
2023-10-21T13:20:37.954578271Z Session altered.
2023-10-21T13:20:37.954581370Z 
2023-10-21T13:20:37.988116413Z SQL> 
2023-10-21T13:20:37.988138506Z User created.
2023-10-21T13:20:37.988141479Z 
2023-10-21T13:20:37.997585183Z SQL> 
2023-10-21T13:20:37.997606753Z Grant succeeded.
2023-10-21T13:20:37.997610047Z 
2023-10-21T13:20:38.027503674Z SQL> 
2023-10-21T13:20:38.027551906Z Grant succeeded.
2023-10-21T13:20:38.027559235Z 
2023-10-21T13:20:38.041915587Z SQL> 
2023-10-21T13:20:38.042085919Z Grant succeeded.
2023-10-21T13:20:38.042113900Z 
2023-10-21T13:20:38.052054079Z SQL> 
2023-10-21T13:20:38.052076380Z User altered.
2023-10-21T13:20:38.052079478Z 
2023-10-21T13:20:38.054248698Z SQL> SQL> Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
2023-10-21T13:20:38.054267456Z Version 21.3.0.0.0
2023-10-21T13:20:38.064175825Z 
2023-10-21T13:20:38.064196359Z SQL*Plus: Release 21.0.0.0.0 - Production on Sat Oct 21 13:20:38 2023
2023-10-21T13:20:38.064208466Z Version 21.3.0.0.0
2023-10-21T13:20:38.064210797Z 
2023-10-21T13:20:38.064212732Z Copyright (c) 1982, 2021, Oracle.  All rights reserved.
2023-10-21T13:20:38.064214745Z 
2023-10-21T13:20:38.094925444Z 
2023-10-21T13:20:38.094945962Z Connected to:
2023-10-21T13:20:38.094949031Z Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
2023-10-21T13:20:38.094951413Z Version 21.3.0.0.0
2023-10-21T13:20:38.094953490Z 
2023-10-21T13:20:38.153361362Z SQL> 
2023-10-21T13:20:38.153383521Z PL/SQL procedure successfully completed.
2023-10-21T13:20:38.153386644Z 
2023-10-21T13:20:38.155045301Z SQL> Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
2023-10-21T13:20:38.155063894Z Version 21.3.0.0.0
2023-10-21T13:20:38.170215533Z The Oracle base remains unchanged with value /opt/oracle
2023-10-21T13:20:38.353386413Z The Oracle base remains unchanged with value /opt/oracle
2023-10-21T13:20:38.451122990Z #########################
2023-10-21T13:20:38.451146204Z DATABASE IS READY TO USE!
2023-10-21T13:20:38.451150177Z #########################
2023-10-21T13:20:38.458289969Z 
2023-10-21T13:20:38.458363508Z Executing user defined scripts
2023-10-21T13:20:38.459129203Z /opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/startup/01_create.sql
2023-10-21T13:20:38.577575694Z 
2023-10-21T13:20:38.577593539Z Session altered.
2023-10-21T13:20:38.577596448Z 
2023-10-21T13:20:38.697569152Z 
2023-10-21T13:20:38.697595114Z User created.
2023-10-21T13:20:38.697598534Z 
2023-10-21T13:20:38.709579959Z 
2023-10-21T13:20:38.709607819Z Grant succeeded.
2023-10-21T13:20:38.709614822Z 
2023-10-21T13:20:38.712083354Z 
2023-10-21T13:20:38.712102217Z 
2023-10-21T13:20:38.712105469Z /opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/startup/02_dept.sql
2023-10-21T13:20:38.754994131Z 
2023-10-21T13:20:38.755013344Z Session altered.
2023-10-21T13:20:38.755016207Z 
2023-10-21T13:20:39.524282554Z 
2023-10-21T13:20:39.524307249Z Table created.
2023-10-21T13:20:39.524310831Z 
2023-10-21T13:20:39.529534041Z 
2023-10-21T13:20:39.529555468Z 1 row created.
2023-10-21T13:20:39.529558762Z 
2023-10-21T13:20:39.530490912Z 
2023-10-21T13:20:39.530521095Z 1 row created.
2023-10-21T13:20:39.530645955Z 
2023-10-21T13:20:39.531657233Z 
2023-10-21T13:20:39.531671160Z 1 row created.
2023-10-21T13:20:39.531673879Z 
2023-10-21T13:20:39.532556601Z 
2023-10-21T13:20:39.532569384Z 1 row created.
2023-10-21T13:20:39.532572118Z 
2023-10-21T13:20:39.553528886Z 
2023-10-21T13:20:39.553550820Z Index created.
2023-10-21T13:20:39.553553750Z 
2023-10-21T13:20:39.616002309Z 
2023-10-21T13:20:39.616038649Z Table altered.
2023-10-21T13:20:39.616042965Z 
2023-10-21T13:20:39.616527761Z 
2023-10-21T13:20:39.616545175Z Commit complete.
2023-10-21T13:20:39.616550413Z 
2023-10-21T13:20:39.619908927Z 
2023-10-21T13:20:39.619946046Z 
2023-10-21T13:20:39.619952773Z /opt/oracle/runUserScripts.sh: running /opt/oracle/scripts/startup/03_emp.sql
2023-10-21T13:20:39.663941954Z 
2023-10-21T13:20:39.663973429Z Session altered.
2023-10-21T13:20:39.663978939Z 
2023-10-21T13:20:39.682552373Z 
2023-10-21T13:20:39.682605415Z Table created.
2023-10-21T13:20:39.682612553Z 
2023-10-21T13:20:39.685820831Z 
2023-10-21T13:20:39.685841309Z 1 row created.
2023-10-21T13:20:39.685844372Z 
2023-10-21T13:20:39.687053680Z 
2023-10-21T13:20:39.687068893Z 1 row created.
2023-10-21T13:20:39.687072478Z 
2023-10-21T13:20:39.688332356Z 
2023-10-21T13:20:39.688346240Z 1 row created.
2023-10-21T13:20:39.688348930Z 
2023-10-21T13:20:39.689552873Z 
2023-10-21T13:20:39.689568292Z 1 row created.
2023-10-21T13:20:39.689574128Z 
2023-10-21T13:20:39.690735517Z 
2023-10-21T13:20:39.690775905Z 1 row created.
2023-10-21T13:20:39.690782551Z 
2023-10-21T13:20:39.691759649Z 
2023-10-21T13:20:39.691772139Z 1 row created.
2023-10-21T13:20:39.691774823Z 
2023-10-21T13:20:39.693302713Z 
2023-10-21T13:20:39.693316161Z 1 row created.
2023-10-21T13:20:39.693318938Z 
2023-10-21T13:20:39.694130277Z 
2023-10-21T13:20:39.694143434Z 1 row created.
2023-10-21T13:20:39.694146282Z 
2023-10-21T13:20:39.695387687Z 
2023-10-21T13:20:39.695401444Z 1 row created.
2023-10-21T13:20:39.695403986Z 
2023-10-21T13:20:39.696347720Z 
2023-10-21T13:20:39.696370274Z 1 row created.
2023-10-21T13:20:39.696373093Z 
2023-10-21T13:20:39.697666397Z 
2023-10-21T13:20:39.697681239Z 1 row created.
2023-10-21T13:20:39.697683941Z 
2023-10-21T13:20:39.698633514Z 
2023-10-21T13:20:39.698685685Z 1 row created.
2023-10-21T13:20:39.698693709Z 
2023-10-21T13:20:39.700066338Z 
2023-10-21T13:20:39.700122568Z 1 row created.
2023-10-21T13:20:39.700133319Z 
2023-10-21T13:20:39.701774785Z 
2023-10-21T13:20:39.701841707Z 1 row created.
2023-10-21T13:20:39.701849451Z 
2023-10-21T13:20:39.711369030Z 
2023-10-21T13:20:39.711399066Z Index created.
2023-10-21T13:20:39.711404466Z 
2023-10-21T13:20:39.722503272Z 
2023-10-21T13:20:39.722532388Z Table altered.
2023-10-21T13:20:39.722535656Z 
2023-10-21T13:20:39.735012744Z 
2023-10-21T13:20:39.735036580Z Table altered.
2023-10-21T13:20:39.735041588Z 
2023-10-21T13:20:39.735377936Z 
2023-10-21T13:20:39.735418523Z Commit complete.
2023-10-21T13:20:39.735432204Z 
2023-10-21T13:20:39.738078540Z 
2023-10-21T13:20:39.738097892Z 
2023-10-21T13:20:39.738100866Z DONE: Executing user defined scripts
2023-10-21T13:20:39.738103114Z 
2023-10-21T13:20:39.738561858Z The following output is now a tail of the alert.log:
2023-10-21T13:20:39.739961363Z 2023-10-21T13:20:37.793437+00:00
2023-10-21T13:20:39.739980593Z ALTER SYSTEM SET control_files='/opt/oracle/oradata/XE/control01.ctl' SCOPE=SPFILE;
2023-10-21T13:20:39.739983557Z 2023-10-21T13:20:37.815907+00:00
2023-10-21T13:20:39.739985839Z ALTER SYSTEM SET local_listener='' SCOPE=BOTH;
2023-10-21T13:20:39.739987851Z ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE
2023-10-21T13:20:39.739989767Z Completed: ALTER PLUGGABLE DATABASE XEPDB1 SAVE STATE
2023-10-21T13:20:39.739991704Z 2023-10-21T13:20:38.832451+00:00
2023-10-21T13:20:39.739993721Z XEPDB1(3):Resize operation completed for file# 10, fname /opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf, old size 337920K, new size 348160K
2023-10-21T13:20:39.739995793Z 2023-10-21T13:20:38.895745+00:00
2023-10-21T13:20:39.739997693Z XEPDB1(3):Resize operation completed for file# 10, fname /opt/oracle/oradata/XE/XEPDB1/sysaux01.dbf, old size 348160K, new size 358400K

6.DBeaver连接确认
在这里插入图片描述

在这里插入图片描述
在这里插入图片描述
7,成功！

相关文章：

(二)docker：建立oracle数据库mount startup

这章其实我想试一下startup部分做mount&#xff0c;因为前一章在建完数据库容器后&#xff0c;需要手动创建用户&#xff0c;授权&#xff0c;建表等&#xff0c;好像正好这部分可以放到startup里&#xff0c;在创建容器时直接做好&#xff1b;因为setup部分我实在没想出来能做…...

编程日记 2023/10/22 10:15:50

Hash Join（PostgreSQL 14 Internals翻译版）

一阶段哈希连接&#xff08;One-Pass Hash Joins&#xff09; 散列连接使用预构建的散列表搜索匹配的行。下面是一个使用这种连接的计划的例子&#xff1a; 在第一阶段&#xff0c;哈希连接节点1调用哈希节点2&#xff0c;哈希节点2从其子节点提取整个内部行集&#xff0c;并将…...

编程日记 2023/10/22 10:13:46

《SQLi-Labs》04. Less 23~28a

title: 《SQLi-Labs》04. Less 23~28a date: 2023-10-19 19:37:40 updated: 2023-10-19 19:38:40 categories: WriteUp&#xff1a;Security-Lab excerpt: 联合注入&#xff0c;注释符过滤绕过之构造闭合&#xff0c;%00 截断、二次注入、报错注入&#xff0c;空格过滤绕过&…...

编程日记 2023/10/22 10:12:45

文件打包下载excel导出和word导出

0.文件下载接口 请求 GET /pm/prj/menu/whsj/download/{affixId} 文件affixId多个id以逗号隔开。多个文件会以打包得形式。 1.Excel导出 1.0接口 POST 127.0.0.1:8400/pm/io/exportExcel/year-plan-table-workflow/report 参数 [{"org":"011","re…...

编程日记 2023/10/22 10:11:44

模拟退火算法求解TSP问题（python）

模拟退火算法求解TSP的步骤参考书籍《Matlab智能算法30个案例分析》。 问题描述 TSP问题描述在该书籍的第4章 算法流程 部分实现代码片段 坐标轴转换成两点之间直线距离长度的代码 coordinates np.array([(16.47, 96.10),(16.47, 94.44),(20.09, 92.54),(22.39, 93.37),(2…...

编程日记 2023/10/22 10:09:42

电路基础元件

文章目录 每周电子w5——电路元件基本电路元件电阻元件电容元件电感元件 每周电子w5——电路元件 基本电路元件 电路元件&#xff1a;是电路中最基本的组成单元 电路元件通过其端子与外部相连接&#xff1b;元件的特性则通过与端子有关的物理量描述每一种元件反映某种确定的电…...

编程日记 2023/10/22 10:08:41

百度地图API：JavaScript开源库几何运算判断点是否在多边形内（电子围栏）

百度地图JavaScript开源库&#xff0c;是一套基于百度地图API二次开发的开源的代码库。目前提供多个lib库&#xff0c;帮助开发者快速实现在地图上添加Marker、自定义信息窗口、标注相关开发、区域限制设置、几何运算、实时交通、检索与公交驾车查询、鼠标绘制工具等功能。 判…...

编程日记 2023/10/22 10:07:40

BFS专题8 中国象棋-马-无障碍

题目&#xff1a; 样例&#xff1a; 输入 3 3 2 1 输出 3 2 1 0 -1 4 3 2 1 思路&#xff1a; 单纯的BFS走一遍即可&#xff0c;只是方向坐标的移动变化&#xff0c;需要变化一下。 代码详解如下&#xff1a; #include <iostream> #include <vector> #include…...

编程日记 2023/10/22 10:06:39

R语言中fread怎么使用？

R语言中 fread 怎么用&#xff1f; 今天分享的笔记内容是数据读取神器fread&#xff0c;速度嘎嘎快。在R语言中&#xff0c;fread函数是data.table包中的一个功能强大的数据读取函数&#xff0c;可以用于快速读取大型数据文件&#xff0c;它比基本的read.table和read.csv函数更…...

编程日记 2023/10/22 10:05:38

element-plus 表格-自定义样式实现2

<template><h2>表格修改样式利用属性修改</h2><h3>row-style 行样式</h3><h3>row-style header-row-style 不能改背景色</h3><h3>cell-style header-cell-style能改背景色</h3><el-tableref"tableRef":dat…...

编程日记 2023/10/22 10:04:37

Mysql中的RR 隔离级别，到底有没有解决幻读问题

Mysql 中的 RR 事务隔离级别&#xff0c;在特定的情况下会出现幻读的问题。所谓的幻读&#xff0c;表示在同一个事务中的两次相同条件的查询得到的数据条数不一样。 在 RR 级别下&#xff0c;什么情况下会出现幻读 这样一种情况&#xff0c;在事务 1 里面通过 update 语句触发当…...

编程日记 2023/10/22 10:03:36

Visual Studio 2022下载安装的详细步骤-----C语言编辑器

目录 一、介绍 &#xff08;一&#xff09;和其他软件的区别 &#xff08;二&#xff09;介绍编写C语言的编辑器类型 二、下载安装 三、创建与运行第一个C语言程序 &#xff08;一&#xff09;创建项目 &#xff08;二&#xff09;新建文件 &#xff08;三&#xff09…...

编程日记 2023/10/22 10:01:34

数据可视化与GraphQL：利用Apollo创建仪表盘

前言 「作者主页」&#xff1a;雪碧有白泡泡 「个人网站」&#xff1a;雪碧的个人网站 「推荐专栏」&#xff1a; ★java一站式服务 ★ ★ React从入门到精通★ ★前端炫酷代码分享 ★ ★ 从0到英雄&#xff0c;vue成神之路★ ★ uniapp-从构建到提升★ ★ 从0到英雄&#xff…...

编程日记 2023/10/22 10:00:33

Java中静态常量和枚举类的区别

在项目中我们有时候会使用常量、静态常量以及枚举&#xff0c;那么他们有什么区别呢&#xff1f;我们先看几个例子&#xff1a; 若依框架中使用的常量&#xff1a; /** 正常状态 */public static final String NORMAL "0";/** 异常状态 */public static final Stri…...

编程日记 2023/10/22 9:59:32

GenericWriteAheadSink每次checkpoint后事务是否必须成功

背景 GenericWriteAheadSink原理是把接收记录按照检查点进行分段&#xff0c;每个到来的记录都放到对应的分段中&#xff0c;这些分段内的记录是作为算子状态的形式存储和故障恢复的&#xff0c;对于每个分段内的记录列表&#xff0c;flink会在收到检查点完成的通知时把他们都…...

编程日记 2023/10/22 9:58:31

[深入浅出AutoSAR] SWC 设计与应用

依AutoSAR及经验辛苦整理&#xff0c;原创保护&#xff0c;禁止转载。 专栏 《深入浅出AutoSAR》 全文 3100 字&#xff0c; 包含 1. SWC 概念 2. 数据类型&#xff08;Datatype&#xff09; 3. 端口&#xff08;Port&#xff09; 4. 端口接口&#xff08;Portinterface&…...

编程日记 2023/10/22 9:57:30

【Ubuntu系统搭建STM32开发环境（国内镜像全程快速配置)】

源于本人失败的经历苦心研究 虚拟机安装ubuntu换源VScode安装安装Java环境安装cubemx安装 arm-Linux-gcc安装gdb server安装OpenOCD 虚拟机安装ubuntu 系统镜像可以在阿里云镜像站且下载速度很快。 选择安装的版本。 我选择的是&#xff1a;ubuntu-22.10-desktop-amd64.iso。…...

编程日记 2023/10/22 9:56:29

Java 中的 Default 关键字

default 关键字&#xff1a;是在 Java 8 中引入的新概念&#xff0c;也可称为 Virtual extension methods——虚拟扩展方法与public、private等都属于修饰符关键字&#xff0c;与其它两个关键字不同之处在于default关键字大部分都用于修饰接口。 default 修饰方法时只能在接口…...

编程日记 2023/10/22 9:55:28

AdaBoost：增强机器学习的力量

一、介绍 机器学习已成为现代技术的基石&#xff0c;为从推荐系统到自动驾驶汽车的一切提供动力。在众多机器学习算法中&#xff0c;AdaBoost&#xff08;自适应增强的缩写&#xff09;作为一种强大的集成方法脱颖而出&#xff0c;为该领域的成功做出了重大贡献。AdaBoost 是一…...

编程日记 2023/10/22 9:54:27

c++踩坑点，类型转换

std::string转换到PVOID std::string转换到PVOID的方式如下 这样的话成功转换 “const char *” 类型的实参与 “WCHAR *” “const char *” 类型的实参与 “WCHAR *” 类型的形参不兼容 可以看到这种报错&#xff0c;可以直接强转如下&#xff1a; 但是在我们这里不适…...

编程日记 2023/10/22 9:53:26

C#事务处理最佳实践：别再让“主表存了、明细丢了”的破事发生

大家好&#xff0c;我是刚子。做业务开发的时候&#xff0c;经常遇到一个操作要同时更新好几张表的情况。比如保存一张单据&#xff0c;既要写主表&#xff0c;又要写明细&#xff0c;还得写关联条件。这种场景下&#xff0c;要么全部成功&#xff0c;要么全部失败&#xff0c;…...

编程新知 2026/4/21 3:39:08

X-World：小鹏面向规模化端到端自动驾驶的可控自车中心多相机世界模型

「自车中心、纯环视、全层级文本可控」 目录 01 研究背景&#xff1a;端到端自动驾驶世界模型的现存痛点 02 X-World核心创新点&#xff1a;重构自动驾驶世界模型的技术范式 1. 纯量产相机驱动&#xff0c;自车中心多视角几何一致性建模 2. 流式自回归生成架构&#xff0c;…...

编程新知 2026/4/21 3:17:48

Qwen3.5-4B-Claude-Opus应用场景：游戏开发中NPC对话逻辑生成引擎

Qwen3.5-4B-Claude-Opus应用场景&#xff1a;游戏开发中NPC对话逻辑生成引擎 1. 游戏NPC对话系统的挑战与机遇 在游戏开发过程中&#xff0c;NPC&#xff08;非玩家角色&#xff09;的对话系统一直是开发者面临的重要挑战。传统NPC对话系统通常采用以下几种方式&#xff1a; …...

编程新知 2026/4/21 2:41:23

[盖茨同步带] 盖茨 Poly Chain® ADV® 同步带 | ADV 14MGT/19MGT

关键词&#xff1a;盖茨 Poly Chain ADV 型号&#xff0c;同步带 Poly Chain ADV&#xff0c;工业皮带描述&#xff1a;盖茨Poly Chain ADV同步带参数详解&#xff0c;涵盖材质、规格、适配设备及核心优势&#xff0c;专业工业皮带选型参考&#xff0c;支持价格咨询与定制服务&…...

编程新知 2026/4/21 2:15:48

编写程序搭建社保医保代扣对账校验工具，核对智能代扣流水与缴费标准，自动筛查扣费误差漏扣错扣异常账单。

面向高校财务、HR、会计实训场景&#xff0c;用于批量核对代扣流水 vs 缴费标准&#xff0c;自动发现漏扣、错扣、金额异常。 一、实际应用场景描述 典型场景&#xff08;高校 / 中小企业&#xff09;&#xff1a; - 某高校人事处每月为教职工代扣&#xff1a; - 养老保险 - 医…...

编程新知 2026/4/21 1:41:51

从‘够用’到‘电影级’：我是如何用HDRP让我的Unity独立游戏画面质感翻倍的

从‘够用’到‘电影级’&#xff1a;我是如何用HDRP让我的Unity独立游戏画面质感翻倍的 去年夏天&#xff0c;当我第一次在Steam上发布自己的独立游戏时&#xff0c;评论区里出现最多的评价是"玩法有趣&#xff0c;但画面像十年前的作品"。这句话像根刺一样扎在心里—…...

编程新知 2026/4/20 23:26:43

DROID-SLAM性能优化技巧：7个关键参数调优指南

DROID-SLAM性能优化技巧&#xff1a;7个关键参数调优指南 【免费下载链接】DROID-SLAM 项目地址: https://gitcode.com/gh_mirrors/dr/DROID-SLAM DROID-SLAM是一款强大的深度视觉SLAM系统&#xff0c;支持单目、双目和RGB-D相机&#xff0c;能够实时构建环境的三维地图…...

编程新知 2026/4/20 22:36:23

南宁宠物医院哪家好

在南宁这座充满活力的城市里&#xff0c;宠物已经成为许多家庭不可或缺的一员。当毛孩子出现健康问题时&#xff0c;选择一家值得信赖的宠物医院成为宠物主人的首要任务。今天&#xff0c;让我们一同走进广西阿荣宠物医院&#xff0c;了解这家陪伴宠物和主人走过13年时光的医疗…...

编程新知 2026/4/20 20:53:25

Obsidian与RAG：知识管理的未来之战

Obsidian、llm-wiki-skill与传统RAG的深度对比 目录 Obsidian、llm-wiki-skill与传统RAG的深度对比 一、三者核心定位与基本原理 1. 传统RAG（检索增强生成） 2. Obsidian 3. llm-wiki-skill 二、多维度详细对比 三、llm-wiki-skill的核心创新点 1. 范式转移：从"知识检索…...

编程新知 2026/4/20 20:34:57

MCP 工具数量爆炸后，如何高效做 Tool Selection？

MCP 工具数量爆炸后&#xff0c;如何高效做 Tool Selection&#xff1f; 背景&#xff1a;规模扩展带来的路由难题 在 MCP&#xff08;Model Context Protocol&#xff09;架构中&#xff0c;随着接入工具数量的增长&#xff0c;一个问题会越来越突出&#xff1a;LLM 开始选错工…...

编程新知 2026/4/20 20:14:11