{"id":13251,"date":"2025-04-18T20:17:31","date_gmt":"2025-04-18T12:17:31","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/13251.html"},"modified":"2025-04-18T20:17:31","modified_gmt":"2025-04-18T12:17:31","slug":"%e5%ae%9d%e5%a1%94%e6%9c%8d%e5%8a%a1%e5%99%a8-docker%e5%ae%89%e8%a3%85-oracle11g%e9%95%9c%e5%83%8f","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/13251.html","title":{"rendered":"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf"},"content":{"rendered":"

\u6211\u662f\u7528win\u672c\u5730docker\u5148\u5c06 oracle11g\u955c\u50cf\u4e0b\u8f7d\u597d \u7136\u540e\u5bfc\u51fa\u4e0a\u4f20\u5230 \u5b9d\u5854\u9762\u677f\u4e0a\u9762\u7684\u00a0<\/p>\n

\u5177\u4f53\u547d\u4ee4:\u00a0<\/p>\n

\u4e0b\u8f7d\u955c\u50cf:\u5927\u69826.8\u4e2aG\u5de6\u53f3<\/p>\n

docker pull registry.cn-hangzhou.aliyuncs.com\/helowin\/oracle_11g <\/p>\n

\u7136\u540e\u5bfc\u51fa\u955c\u50cf:\u00a0<\/p>\n

docker save -o D:\\\\www\\\\oracle11g.tar registry.cn-hangzhou.aliyuncs.com\/helowin\/oracle_11g <\/p>\n

\u7b49\u5bfc\u51fa\u5b8c\u6210\u540e \u518d\u5c06\u8be5\u6587\u4ef6\u4e0a\u4f20\u5230 \u5b9d\u5854\u670d\u52a1\u5668\u67d0\u4e2a\u8def\u5f84\u5730\u5740<\/p>\n

\"\"<\/p>\n

\u4e0a\u4f20\u6210\u529f\u4ee5\u540e \u4f7f\u7528SSH\u547d\u4ee4 \u5c06\u672c\u5730\u955c\u50cf\u5bfc\u5165\u5230 docker\u91cc\u9762<\/p>\n

docker load -i \/data\/docker\/oracle11g\/oracle_11g_image.tar <\/p>\n

\u9762\u677f\u4e0a\u9762\u4e5f\u6709\u5bfc\u5165\u672c\u5730\u955c\u50cf\u529f\u80fd,\u4f46\u662f\u6211\u4f7f\u7528\u7684\u65f6\u5019\u5bfc\u5165\u5931\u8d25\u4e86..\u00a0\u00a0<\/p>\n

\u5bfc\u5165\u6210\u529f\u4ee5\u540e \u4f7f\u7528 docker images \u547d\u4ee4\u67e5\u770b\u672c\u5730\u955c\u50cf\u5217\u8868<\/p>\n

\"\"<\/p>\n<\/p>\n

\u4e0b\u4e00\u6b65 \u4f7f\u7528\u547d\u4ee4\u5c06\u5bb9\u5668\u542f\u52a8:<\/p>\n

docker run \\\\
\n –privileged \\\\
\n -d \\\\
\n –restart=always \\\\
\n -v \/data\/oracle:\/data\/oracle \\\\
\n -p 1521:1521 \\\\
\n –name oracle11g \\\\
\n -e ORACLE_HOME=\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2 \\\\
\n -e ORACLE_SID=helowin \\\\
\n -e PATH=\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2\/bin:\/usr\/local\/sbin:\/usr\/local\/bin:\/usr\/sbin:\/usr\/bin:\/sbin:\/bin \\\\
\n registry.cn-hangzhou.aliyuncs.com\/helowin\/oracle_11g<\/p>\n

\u6ce8\u610f: \u786e\u4fdd\u5bbf\u4e3b\u673a\u4e0a\u9762\u7684 \/data\/oracle \u8fd9\u4e2a\u76ee\u5f55\u5b58\u5728<\/p>\n

1.\u00a0docker run \u4f5c\u7528：\u8fd9\u662f\u542f\u52a8\u4e00\u4e2a\u65b0\u7684 Docker \u5bb9\u5668\u7684\u547d\u4ee4\u3002
\n2.\u00a0–privileged \u4f5c\u7528：\u6388\u4e88\u5bb9\u5668\u51e0\u4e4e\u6240\u6709\u7684\u4e3b\u673a\u6743\u9650\u3002\u8fd9\u5141\u8bb8\u5bb9\u5668\u5185\u7684\u8fdb\u7a0b\u6267\u884c\u901a\u5e38\u9700\u8981\u8d85\u7ea7\u7528\u6237\u6743\u9650\u7684\u64cd
\n \u4f5c，\u5982\u52a0\u8f7d\u5185\u6838\u6a21\u5757\u3001\u66f4\u6539\u7f51\u7edc\u914d\u7f6e\u7b49\u3002 \u6ce8\u610f\u4e8b\u9879：\u867d\u7136\u6709\u65f6\u662f\u5fc5\u8981\u7684，\u4f46\u5e94\u8c28\u614e\u4f7f\u7528\u6b64\u9009\u9879，\u56e0\u4e3a\u5b83
\n \u53ef\u80fd\u4f1a\u5e26\u6765\u5b89\u5168\u98ce\u9669\u3002
\n3.\u00a0-d \u4f5c\u7528：\u4ee5\u5206\u79bb\u6a21\u5f0f（\u540e\u53f0）\u8fd0\u884c\u5bb9\u5668\u3002\u8fd9\u610f\u5473\u7740\u5bb9\u5668\u4f1a\u5728\u540e\u53f0\u8fd0\u884c，\u800c\u4e0d\u4f1a\u5360\u7528\u5f53\u524d\u7ec8\u7aef\u3002
\n \u7b49\u6548\u9009\u9879：–detach
\n4.\u00a0–restart=always \u4f5c\u7528：\u8bbe\u7f6e\u5bb9\u5668\u7684\u91cd\u542f\u7b56\u7565\u4e3a\u59cb\u7ec8\u91cd\u542f\u3002\u65e0\u8bba\u5bb9\u5668\u56e0\u4ec0\u4e48\u539f\u56e0\u505c\u6b62（\u5305\u62ec\u624b\u52a8\u505c\u6b62），
\n Docker \u90fd\u4f1a\u5c1d\u8bd5\u91cd\u65b0\u542f\u52a8\u5b83\u3002
\n\u5176\u4ed6\u9009\u9879：
\n no：\u4e0d\u81ea\u52a8\u91cd\u542f\u5bb9\u5668\u3002
\n on-failure：\u4ec5\u5728\u5bb9\u5668\u9000\u51fa\u72b6\u6001\u7801\u8868\u793a\u5931\u8d25\u65f6\u91cd\u542f\u3002
\n unless-stopped：\u603b\u662f\u91cd\u542f\u5bb9\u5668，\u9664\u975e\u5bb9\u5668\u88ab\u624b\u52a8\u505c\u6b62\u3002
\n5.\u00a0-v \/data\/oracle:\/data\/oracle \u4f5c\u7528：\u5c06\u4e3b\u673a\u4e0a\u7684\u00a0\/data\/oracle\u00a0\u76ee\u5f55\u6302\u8f7d\u5230\u5bb9\u5668\u5185
\n \u7684\u00a0\/data\/oracle\u00a0\u76ee\u5f55\u3002\u8fd9\u6837\u53ef\u4ee5\u5b9e\u73b0\u6570\u636e\u6301\u4e45\u5316，\u5373\u4f7f\u5bb9\u5668\u505c\u6b62\u6216\u5220\u9664，\u6570\u636e\u4ecd\u7136\u4fdd\u7559\u5728\u4e3b\u673a\u4e0a\u3002
\n \u7b49\u6548\u9009\u9879：–volume
\n\u683c\u5f0f：host_path:container_path[:options]
\n6.\u00a0-p 1521:1521 \u4f5c\u7528：\u5c06\u4e3b\u673a\u7684 1521 \u7aef\u53e3\u6620\u5c04\u5230\u5bb9\u5668\u7684 1521 \u7aef\u53e3\u3002\u8fd9\u4f7f\u5f97\u4f60\u53ef\u4ee5\u901a\u8fc7\u4e3b\u673a\u7684 IP \u5730
\n \u5740\u548c\u7aef\u53e3 1521 \u8bbf\u95ee\u5bb9\u5668\u5185\u7684 Oracle \u6570\u636e\u5e93\u670d\u52a1\u3002
\n \u7b49\u6548\u9009\u9879：–publish
\n \u683c\u5f0f：host_port:container_port
\n7.\u00a0–name oracle11g \u4f5c\u7528：\u4e3a\u5bb9\u5668\u6307\u5b9a\u4e00\u4e2a\u540d\u79f0\u00a0oracle11g\u3002\u8fd9\u4f7f\u5f97\u4f60\u53ef\u4ee5\u901a\u8fc7\u8fd9\u4e2a\u540d\u79f0\u800c\u4e0d\u662f\u5bb9\u5668 ID
\n \u6765\u5f15\u7528\u5bb9\u5668\u3002
\n \u7b49\u6548\u9009\u9879：\u65e0
\n8.\u00a0registry.cn-hangzhou.aliyuncs.com\/helowin\/oracle_11g \u4f5c\u7528：\u6307\u5b9a\u8981\u4f7f\u7528\u7684\u955c\u50cf\u3002\u8fd9\u91cc\u662f\u963f\u91cc
\n \u4e91\u5bb9\u5668\u955c\u50cf\u670d\u52a1\u4e2d\u7684\u00a0helowin\/oracle_11g\u00a0\u955c\u50cf\u3002
\n \u683c\u5f0f：repository\/image_name:tag（\u5982\u679c\u7701\u7565\u6807\u7b7e，\u9ed8\u8ba4\u4f7f\u7528\u00a0latest）
\n\u603b\u7ed3:
\n\u8fd9\u6761\u547d\u4ee4\u7684\u4f5c\u7528\u662f\u542f\u52a8\u4e00\u4e2a\u540d\u4e3a oracle11g \u7684 Docker \u5bb9\u5668，\u4f7f\u7528\u6765\u81ea\u963f\u91cc\u4e91\u7684 helowin\/oracle_11g \u955c\u50cf <\/p>\n

<\/h5>\n

\u5b8c\u4e8b\u513f \u4e0b\u4e00\u6b65 \u76f4\u63a5\u8fdb\u5165\u5230 oracle\u5bb9\u5668\u91cc\u9762\u00a0 \u00a0\u8fd9\u4e00\u6b65\u5f88\u5173\u952e, \u4e4b\u524d\u770b\u522b\u7684\u6587\u7ae0\u662f\u00a0docker exec -it oracle11g bash\u8fd9\u6837\u8fdb\u5165\u7684,\u4f1a\u6709\u4e00\u4e9b\u95ee\u9898\u00a0 \u4e0b\u9762\u76f4\u63a5\u4f7f\u7528 root\u6765\u8fdb\u5165 \u6743\u9650\u5927\u4e00\u70b9<\/p>\n

docker exec -it -u root oracle11g bash <\/p>\n

\u00a0\u4fee\u6539\u73af\u5883\u53d8\u91cf: (\u4e0d\u53ef\u4ee5\u7701\u7565\u00a0 \u4e5f\u521b\u5efa\u4e86\u5427)<\/p>\n

vi \/etc\/profile\u00a0 \u00a0<\/p>\n

export ORACLE_HOME=\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2 export ORACLE_SID=helowin export PATH=$ORACLE_HOME\/bin:$PATH<\/p>\n

\u4fdd\u5b58\u540e\u4f7f\u914d\u7f6e\u6587\u4ef6\u751f\u6548:<\/p>\n

source \/etc\/profile<\/p>\n

\u8bbe\u7f6e\u6743\u9650:\u00a0<\/p>\n

# \u8fdb\u5165\u5bb9\u5668\u5185\u90e8
\ndocker exec -it -u root oracle11g bash<\/p>\n

# \u68c0\u67e5\u73b0\u6709\u7528\u6237\u548c\u7ec4
\nid oracle<\/p>\n

\u8f93\u51fa-> uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba),502(oper)
\noracle \u7528\u6237\u7684 UID \u662f 500\u3002
\ndba \u7ec4\u7684 GID \u662f 501\u3002<\/p>\n

# \u5728\u4e3b\u673a\u4e0a\u6267\u884c
\nchown -R 500:501 \/data\/oracle
\nchmod -R 750 \/data\/oracle
\n\u6216\u8005，\u5982\u679c\u60a8\u66f4\u559c\u6b22\u4f7f\u7528\u7528\u6237\u540d\u548c\u7ec4\u540d：<\/p>\n

# \u5728\u4e3b\u673a\u4e0a\u6267\u884c
\nchown -R oracle:dba \/data\/oracle
\nchmod -R 750 \/data\/oracle
\n\u786e\u4fdd\u66f4\u6539\u5df2\u6b63\u786e\u5e94\u7528：<\/p>\n

ls -l \/data\/oracle
\n\u60a8\u5e94\u8be5\u770b\u5230\u7c7b\u4f3c\u4ee5\u4e0b\u7684\u8f93\u51fa：<\/p>\n

total 8
\ndrwxr-x— 2 oracle dba 4096 Dec 21 09:36 archivelog
\ndrwxr-x— 3 oracle dba 4096 Dec 23 14:12 data <\/p>\n

\u6ce8\u610f:\u4e3a\u4e86\u4ee5\u9632\u4e07\u4e00 \u5bfc\u81f4\u6302\u8f7d\u4e0d\u6210\u529f\u00a0 \u6211\u662f\u5728 \u5bbf\u4e3b\u673a\u670d\u52a1\u5668, \u4ee5\u53ca\u5bb9\u5668\u91cc\u9762 \u4ee5\u53ca\u5bb9\u5668\u91cc\u9762\u7684 su oracle\u7528\u6237\u4e0a\u00a0 \u90fd\u8bbe\u7f6e\u4e86\u4e00\u904d chown -R 500:501 \/data\/oracle \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0chmod -R 750 \/data\/oracle<\/p>\n

😒😒😒😒😒😒😓😓😓😭😭😭😭\u8fd9\u4e2a\u73a9\u610f\u513f \u6298\u817e\u4e86\u6211\u4e00\u4e0b\u5348<\/p>\n

\u8fd9\u4e00\u6b65\u5f88\u91cd\u8981\u554a,, \u9519\u8bef\u7684\u8bdd\u5bfc\u81f4\u5bb9\u5668\u91cd\u542f\u540e \u65e0\u6cd5\u6302\u8f7d\u672c\u5730\u5bfc\u81f4\u6570\u636e\u5e93\u6587\u4ef6\u4e22\u5931\u00a0 \u6211\u5c31\u9047\u5230\u8fd9\u4e2a\u95ee\u9898<\/p>\n<\/p>\n

\u521b\u5efa\u8fde\u63a5\u547d\u4ee4:<\/h6>\n

ln -s $ORACLE_HOME\/bin\/sqlplus \/usr\/bin<\/p>\n

\u00a0\u4e0b\u9762\u662f\u4fee\u6539\u9ed8\u8ba4\u7528\u6237\u5bc6\u7801:<\/p>\n

\u5207\u6362\u7528\u6237，\u5e76\u767b\u5f55 \u00a0 \u00a0 \u00a0 \u00a0 \u547d\u4ee4: su – oracle \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u547d\u4ee4: sqlplus \/nolog \u00a0 \u00a0 \u00a0 \u00a0\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL> conn \/as sysdba \u00a0 \u4fee\u6539sys system\u7528\u6237\u7684\u5bc6\u7801(\u5bc6\u7801\u4e2a\u4eba\u81ea\u5b9a\u4e49,\u8fd9\u91cc\u7528root\u4ee3\u8868) \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL> alter user system identified by root; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL> alter user sys identified by root; \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL> create user admin identified by root; \u00a0 \u00a0 \u00a0 \u00a0–\u521b\u5efa\u4e00\u4e2a\u7ba1\u7406\u8d26\u53f7,\u81ea\u5b9a\u4e49\u8d26\u53f7\u548c\u5bc6\u7801 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 SQL> grant connect,resource,dba to admin; \u00a0 \u00a0 –\u6388\u6743\u7ed9\u7ba1\u7406\u8d26\u53f7 \u00a0 \u00a0<\/p>\n<\/p>\n

#\u5173\u95ed\u6570\u636e\u5e93 SQL> shutdown immediate; #\u5f00\u542fmount\u72b6\u6001 SQL> startup mount; # \u5f00\u542f\u5f52\u6863\u65e5\u5fd7，\u51fa\u73b0Database altered. \u8868\u793a\u5f00\u542f\u6210\u529f SQL> alter database archivelog; #\u67e5\u770b\u5f52\u6863\u72b6\u6001 SQL> SELECT log_mode FROM v$database; #\u6253\u5f00\u6570\u636e\u5e93，\u4e00\u5b9a\u8981\u6267\u884c SQL> alter database open;<\/p>\n<\/p>\n

\u786e\u4fdd\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u88ab\u5199\u5165\u5230\u9884\u671f\u7684\u4f4d\u7f6e\u3002\u4f60\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u6765\u67e5\u770b\u5f52\u6863\u65e5\u5fd7\u7684\u76ee\u7684\u5730：<\/p>\n

SQL> SHOW PARAMETER log_archive_dest_1;<\/p>\n

\u4f60\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0b\u67e5\u8be2\u6765\u67e5\u770b\u5f52\u6863\u65e5\u5fd7\u7684\u72b6\u6001\u548c\u4fe1\u606f：<\/p>\n

SQL> SELECT * FROM v$archived_log;<\/p>\n<\/p>\n

\u4e3a\u4e86\u9632\u6b62\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u5360\u7528\u8fc7\u591a\u78c1\u76d8\u7a7a\u95f4，\u4f60\u53ef\u4ee5\u914d\u7f6e\u81ea\u52a8\u5220\u9664\u65e7\u7684\u5f52\u6863\u65e5\u5fd7\u6587\u4ef6\u3002\u4f8b\u5982，\u8bbe\u7f6e\u4fdd\u7559\u5929\u6570：<\/p>\n

ALTER SYSTEM SET log_archive_max_processes = 4 SCOPE=BOTH;\u00a0<\/p>\n

ALTER SYSTEM SET log_archive_min_succeed_dest = 1 SCOPE=BOTH;\u00a0<\/p>\n

ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE=BOTH;\u00a0<\/p>\n

ALTER SYSTEM SET db_recovery_file_dest = '\/data\/oracle\/archivelog' SCOPE=BOTH;<\/p>\n

\u8981\u786e\u4fdd\u00a0\/data\/oracle\/archivelog\u00a0 oracle\u5bb9\u5668\u91cc\u9762\u7684\u76ee\u5f55\u5b58\u5728<\/p>\n

\u7136\u540e\u91cd\u542f\u6570\u636e:<\/p>\n

SQL> shutdown immediate;\u00a0 —-\u00a0 \u5148\u505c\u6b62 Database closed. Database dismounted. ORACLE instance shut down.<\/p>\n

SQL> startup;\u00a0 \u00a0—-\u518d\u542f\u52a8 ORACLE instance started.<\/p>\n

Total System Global Area 1603411968 bytes Fixed Size \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a02213776 bytes Variable Size \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 419432560 bytes Database Buffers \u00a0 \u00a0 \u00a0 \u00a0 1174405120 bytes Redo Buffers \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a07360512 bytes Database mounted. Database opened.<\/p>\n

SQL> show parameter recovery\u00a0 \u00a0—\u67e5\u770b\u8bbe\u7f6e\u662f\u5426\u751f\u6548<\/p>\n

NAME \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 TYPE \u00a0 \u00a0 \u00a0 \u00a0VALUE ———————————— ———– —————————— db_recovery_file_dest \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0string \u00a0 \u00a0 \u00a0\/data\/oracle\/archivelog db_recovery_file_dest_size \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 big integer 10G recovery_parallelism \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 integer \u00a0 \u00a0 0 SQL>\u00a0<\/p>\n

2025-03-05 \u56de\u6765\u4fee\u6539\u00a0 :\u4ee5\u4e0a\u5f52\u6863\u8bbe\u7f6e\u7684\u6839\u636e\u7a7a\u95f4\u6765\u81ea\u52a8\u6e05\u7406\u7684,\u5bfc\u81f4\u6e05\u7406\u4e0d\u53ca\u65f6 \u4f1a\u9020\u6210\u6570\u636e\u5e93\u65e0\u6cd5\u8fde\u63a5\u60c5\u51b5<\/p>\n

\"\"<\/p>\n

\u89e3\u51b3\u6b64\u9519\u8bef:\u9700\u8981\u5efa\u7acb\u6839\u636e\u65f6\u95f4\u81ea\u52a8\u6e05\u7406\u7684\u811a\u672c\u6587\u4ef6\u00a0 \u53c2\u8003\u4ee5\u4e0b\u56fe\u7247\u5185\u5bb9<\/p>\n

\"\"<\/p>\n

\n

\n<\/p>\n<\/p>\n

\u4e0b\u9762\u9644\u4e0a\u4e00\u4e9b\u5efa\u8868\u76f8\u5173\u8bed\u53e5(\u53c2\u8003\u7528)<\/p>\n

oracle \u521b\u5efa\u8868\u7a7a\u95f4 \u6388\u6743\u7528\u6237\u7b49\u547d\u4ee4 \u521b\u5efa\u8868\u7a7a\u95f4 \u6ce8\u610f:(\/data\/oracle \u8868\u7a7a\u95f4\u4e00\u5b9a\u8981\u5728\u8fd9\u4e2a\u4e0b\u9762 \u56e0\u4e3a\u6b64\u76ee\u5f55\u6302\u8f7d\u5230\u4e86\u5bbf\u4e3b\u673a \u6240\u4ee5\u4e0d\u5728\u8fd9\u513f\u4f1a\u5f15\u8d77\u9519\u8bef\u7684 \u5f88\u9ebb\u70e6) CREATE TABLESPACE tablespace_my DATAFILE '\/data\/oracle\/data\/tablespace_my.dbf' SIZE 512m AUTOEXTEND ON NEXT 32m MAXSIZE 2048m EXTENT MANAGEMENT LOCAL;<\/p>\n

\u521b\u5efa\u7528\u6237 CREATE USER root IDENTIFIED BY 123456 DEFAULT TABLESPACE tablespace_my TEMPORARY TABLESPACE temp PROFILE DEFAULT;<\/p>\n

\u6388\u6743 GRANT CONNECT, RESOURCE TO root; GRANT CREATE SESSION TO root; GRANT CREATE TABLE TO root; GRANT CREATE VIEW TO root; \u5982\u679c\u9700\u8981\u6388\u4e88\u7528\u6237DBA\u6743\u9650（\u8bf7\u8c28\u614e\u64cd\u4f5c，\u56e0\u4e3a\u8fd9\u4f1a\u8d4b\u4e88\u7528\u6237\u5e7f\u6cdb\u7684\u6570\u636e\u5e93\u7ba1\u7406\u6743\u9650）： GRANT DBA TO root;<\/p>\n

\u521b\u5efa\u8868 CREATE TABLE wms_question ( \u00a0 id NUMBER(19,0) NOT NULL, \u00a0 no NUMBER(10,0) NOT NULL, \u00a0 title VARCHAR2(255 CHAR) NOT NULL, \u00a0 txt CLOB, \u00a0 status CHAR(1 CHAR) NOT NULL, \u00a0 del_flag CHAR(1 CHAR) DEFAULT '0' NOT NULL, \u00a0 remark VARCHAR2(200 CHAR) ) TABLESPACE tablespace_my<\/p>\n

\u8bbe\u7f6e\u4e3b\u952e\u81ea\u589e ALTER TABLE wms_question ADD CONSTRAINT pk_wms_question PRIMARY KEY (id);<\/p>\n

\u521b\u5efa\u5e8f\u5217 CREATE SEQUENCE wms_question_seq START WITH 1 INCREMENT BY 1;<\/p>\n

\u521b\u5efa\u89e6\u53d1\u5668 \u67e5\u8be2\u5e8f\u5217\u6bcf\u6b21\u81ea\u589e1 CREATE OR REPLACE TRIGGER wms_question_trg BEFORE INSERT ON wms_question FOR EACH ROW BEGIN \u00a0 SELECT wms_question_seq.NEXTVAL INTO :new.id FROM dual; END;<\/p>\n<\/p>\n

\u4e0b\u9762\u662f\u521b\u5efa\u597d\u4e4b\u540e\u7684\u4e00\u4e9b\u64cd\u4f5c\u8bb0\u5f55(—————\u53ef\u5ffd\u7565)<\/p>\n

[root@392b7517da3f oracle]# ls -l \/usr\/bin\/sqlplus
\nlrwxrwxrwx 1 root root 59 Dec 21 09:19 \/usr\/bin\/sqlplus -> \/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2\/bin\/sqlplus
\n[root@392b7517da3f oracle]#
\n[root@392b7517da3f oracle]#
\n[root@392b7517da3f oracle]#
\n[root@392b7517da3f oracle]#
\n[root@392b7517da3f oracle]#
\n[root@392b7517da3f oracle]# su oracle
\n[oracle@392b7517da3f ~]$ sqlplus \/nolog<\/p>\n

SQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 21 09:29:06 2024<\/p>\n

Copyright (c) 1982, 2009, Oracle. All rights reserved.<\/p>\n

SQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL> conn \/as sysdba
\nConnected.
\nSQL>
\nSQL>
\nSQL>
\nSQL> alter user system identified by root;<\/p>\n

User altered.<\/p>\n

SQL> alter user sys identified by root;<\/p>\n

User altered.<\/p>\n

SQL> create user admin identified by root;<\/p>\n

User created.<\/p>\n

SQL> grant connect,resource,dba to admin;<\/p>\n

Grant succeeded.<\/p>\n

SQL> shutdown immediate;
\nDatabase closed.
\nDatabase dismounted.
\nORACLE instance shut down.
\nSQL> startup mount;
\nORACLE instance started.<\/p>\n

Total System Global Area 1603411968 bytes
\nFixed Size 2213776 bytes
\nVariable Size 402655344 bytes
\nDatabase Buffers 1191182336 bytes
\nRedo Buffers 7360512 bytes
\nDatabase mounted.
\nSQL> alter database archivelog;<\/p>\n

Database altered.<\/p>\n

SQL> SELECT log_mode FROM v$database;<\/p>\n

LOG_MODE
\n————
\nARCHIVELOG<\/p>\n

SQL> alter database open;<\/p>\n

Database altered.<\/p>\n

SQL> lsnrctl status
\nSP2-0734: unknown command beginning "lsnrctl st…" – rest of line ignored.
\nSQL> ALTER SYSTEM SET log_archive_max_processes = 4 SCOPE=BOTH;<\/p>\n

System altered.<\/p>\n

SQL> ALTER SYSTEM SET log_archive_min_succeed_dest = 1 SCOPE=BOTH;<\/p>\n

System altered.<\/p>\n

SQL> ALTER SYSTEM SET db_recovery_file_dest_size = 10G SCOPE=BOTH;<\/p>\n

System altered.<\/p>\n

SQL> ALTER SYSTEM SET db_recovery_file_dest = '\/path\/to\/archivelog' SCOPE=BOTH;
\nALTER SYSTEM SET db_recovery_file_dest = '\/path\/to\/archivelog' SCOPE=BOTH
\n*
\nERROR at line 1:
\nORA-02097: parameter cannot be modified because specified value is invalid
\nORA-01261: Parameter db_recovery_file_dest destination string cannot be
\ntranslated
\nORA-01262: Stat failed on a file destination directory
\nLinux-x86_64 Error: 2: No such file or directory<\/p>\n

SQL> ALTER SYSTEM SET db_recovery_file_dest = '\/data\/oracle\/archivelog' SCOPE=BOTH;
\nALTER SYSTEM SET db_recovery_file_dest = '\/data\/oracle\/archivelog' SCOPE=BOTH
\n*
\nERROR at line 1:
\nORA-02097: parameter cannot be modified because specified value is invalid
\nORA-01261: Parameter db_recovery_file_dest destination string cannot be
\ntranslated
\nORA-01262: Stat failed on a file destination directory
\nLinux-x86_64 Error: 2: No such file or directory<\/p>\n

SQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL> cd \/
\nSP2-0042: unknown command "cd \/" – rest of line ignored.
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL> <\/p>\n

SQL> SQL>
\nSQL>
\nSQL> <\/p>\n

SQL> SQL>
\nSQL>
\nSQL> <\/p>\n

SQL> SQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL> <\/p>\n

SQL> SQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL>
\nSQL> ALTER SYSTEM SET db_recovery_file_dest = '\/data\/oracle\/archivelog' SCOPE=BOTH;<\/p>\n

System altered.<\/p>\n

SQL>
\nSQL>
\nSQL>
\nSQL> SHOW PARAMETER db_recovery_file_dest<\/p>\n

NAME TYPE VALUE
\n———————————— ———– ——————————
\ndb_recovery_file_dest string \/data\/oracle\/archivelog
\ndb_recovery_file_dest_size big integer 10G<\/p>\n

\u5982\u679c\u91cd\u542f\u4e4b\u540e\u5bfc\u81f4\u6570\u636e\u5e93\u76d1\u542c\u5931\u8d25\u7b49\u539f\u56e0 \u53c2\u8003\u4ee5\u4e0b\u64cd\u4f5c<\/p>\n

\u670d\u52a1\u5668docker \u8fdb\u5165oracle
\n\u68c0\u67e5\u73af\u5883\u53d8\u91cf echo $ORACLE_HOME
\n echo $ORACLE_SID
\n echo $PATH<\/p>\n

\u5bb9\u5668:\/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2\/network\/admin
\nlistener.ora \u76d1\u542c\u6587\u4ef6\u5185\u5bb9————— \u8fdc\u7a0b\u94fe\u63a5\u65f6\u5019\u53ef\u80fd\u9700\u8981
\n# listener.ora Network Configuration File: \/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2\/network\/admin\/listener.ora
\n# Generated by Oracle configuration tools.<\/p>\n

LISTENER =
\n (DESCRIPTION_LIST =
\n (DESCRIPTION =
\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
\n (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
\n )
\n )<\/p>\n

LISTENER =
\n (DESCRIPTION_LIST =
\n (DESCRIPTION =
\n (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
\n (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
\n )
\n (DESCRIPTION =
\n (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
\n (SERVICE_NAME = helowin)
\n )
\n )
\nADR_BASE_LISTENER = \/home\/oracle\/app\/oracle<\/p>\n

tnsnames.ora \u6587\u4ef6\u5185\u5bb9———————–
\n# tnsnames.ora Network Configuration File: \/home\/oracle\/app\/oracle\/product\/11.2.0\/dbhome_2\/network\/admin\/tnsnames.ora
\n# Generated by Oracle configuration tools.<\/p>\n

LISTENER_HELOWIN =
\n (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))<\/p>\n

HELOWIN =
\n (DESCRIPTION =
\n (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
\n (CONNECT_DATA =
\n (SERVER = DEDICATED)
\n (SERVICE_NAME = helowin)
\n )
\n )<\/p>\n

~
\n~
\n\u4e00,oracle\u5bb9\u5668\u547d\u4ee4 : docker exec -it -u root oracle11g bash \u4ee5root\u7528\u6237\u8eab\u4efd\u8fdb\u5165bash
\n\u4e8c,\u542f\u52a8\u6302\u8f7d : startup mount; "\u5f53\u4f60\u6267\u884c STARTUP MOUNT; \u547d\u4ee4\u65f6，Oracle \u4f1a\u5b8c\u6210\u4ee5\u4e0b\u64cd\u4f5c：\u542f\u52a8\u5b9e\u4f8b：\u521d\u59cb\u5316 SGA \u5e76\u542f\u52a8\u5fc5\u8981\u7684\u540e\u53f0\u8fdb\u7a0b\u3002\u8bfb\u53d6\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6：\u52a0\u8f7d init.ora \u6216 spfile \u4e2d\u7684\u53c2\u6570\u3002\u6302\u8f7d\u6570\u636e\u5e93：\u8bfb\u53d6\u63a7\u5236\u6587\u4ef6，\u5e76\u9a8c\u8bc1\u6570\u636e\u5e93\u7684\u7269\u7406\u7ed3\u6784（\u5982\u6570\u636e\u6587\u4ef6\u548c\u91cd\u505a\u65e5\u5fd7\u6587\u4ef6\u7684\u4f4d\u7f6e）\u3002\u4f46\u662f，\u5b83\u4e0d\u4f1a\u6253\u5f00\u8fd9\u4e9b\u6587\u4ef6，\u56e0\u6b64\u7528\u6237\u8fd8\u4e0d\u80fd\u8bbf\u95ee\u6570\u636e\u3002"
\n\u4e09,su oracle,
\n sqlplus \/ as sysdba \u547d\u4ee4\u8fdb\u5165
\n(
\n1. \u786e\u8ba4\u6240\u6709\u63a7\u5236\u6587\u4ef6
\n SQL> SHOW PARAMETER CONTROL_FILES;
\n2. \u9009\u62e9\u6700\u65b0\u7684\u63a7\u5236\u6587\u4ef6"\u6839\u636e\u60a8\u7684\u9519\u8bef\u4fe1\u606f，\/home\/oracle\/app\/oracle\/oradata\/helowin\/control01.ctl \u7248\u672c\u4e3a 1963，\u800c \/home\/oracle\/app\/oracle\/flash_recovery_area\/helowin\/control02.ctl \u7248\u672c\u4e3a 841\u3002\u663e\u7136，control01.ctl \u662f\u8f83\u65b0\u7684\u7248\u672c\u3002"
\n3. \u590d\u5236\u6700\u65b0\u7684\u63a7\u5236\u6587\u4ef6 "\u4e3a\u4e86\u786e\u4fdd\u4e00\u81f4\u6027，\u60a8\u53ef\u4ee5\u5c06\u6700\u65b0\u7684\u63a7\u5236\u6587\u4ef6\u590d\u5236\u5230\u5176\u4ed6\u4f4d\u7f6e\u3002\u5047\u8bbe control01.ctl \u662f\u6700\u65b0\u7684\u7248\u672c，\u53ef\u4ee5\u5c06\u5176\u590d\u5236\u5230 control02.ctl \u7684\u4f4d\u7f6e："
\n cp \/home\/oracle\/app\/oracle\/oradata\/helowin\/control01.ctl \/home\/oracle\/app\/oracle\/flash_recovery_area\/helowin\/control02.ctl
\n4. \u91cd\u65b0\u542f\u52a8\u5e76\u6302\u8f7d\u6570\u636e\u5e93
\n SQL> SHUTDOWN IMMEDIATE;
\n SQL> STARTUP MOUNT;
\n # \u5f00\u542f\u5f52\u6863\u65e5\u5fd7，\u51fa\u73b0Database altered. \u8868\u793a\u5f00\u542f\u6210\u529f
\n SQL> alter database archivelog;
\n #\u67e5\u770b\u5f52\u6863\u72b6\u6001
\n SQL> SELECT log_mode FROM v$database;
\n #\u6253\u5f00\u6570\u636e\u5e93，\u4e00\u5b9a\u8981\u6267\u884c
\n SQL> alter database open;
\n)<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.5k\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf29\u6b21\u3002docker \u5b89\u88c5 oracle11g _\u5b9d\u5854\u5b89\u88c5oracle<\/p>\n","protected":false},"author":2,"featured_media":13247,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[27,121,44],"topic":[],"class_list":["post-13251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-docker","tag-121","tag-44"],"yoast_head":"\n\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/13251.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.5k\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf29\u6b21\u3002docker \u5b89\u88c5 oracle11g _\u5b9d\u5854\u5b89\u88c5oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/13251.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-04-18T12:17:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418121728-680242d89a635.jpg\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/13251.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/13251.html\",\"name\":\"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-04-18T12:17:31+00:00\",\"dateModified\":\"2025-04-18T12:17:31+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/13251.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/13251.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/13251.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/13251.html","og_locale":"zh_CN","og_type":"article","og_title":"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb1.5k\u6b21\uff0c\u70b9\u8d5e11\u6b21\uff0c\u6536\u85cf29\u6b21\u3002docker \u5b89\u88c5 oracle11g _\u5b9d\u5854\u5b89\u88c5oracle","og_url":"https:\/\/www.wsisp.com\/helps\/13251.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-04-18T12:17:31+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/04\/20250418121728-680242d89a635.jpg"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"8 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/13251.html","url":"https:\/\/www.wsisp.com\/helps\/13251.html","name":"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-04-18T12:17:31+00:00","dateModified":"2025-04-18T12:17:31+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/13251.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/13251.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/13251.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"\u5b9d\u5854\u670d\u52a1\u5668: docker\u5b89\u88c5 oracle11g\u955c\u50cf"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/13251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=13251"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/13251\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/13247"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=13251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=13251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=13251"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=13251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}