{"id":42626,"date":"2025-06-10T01:04:33","date_gmt":"2025-06-09T17:04:33","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/42626.html"},"modified":"2025-06-10T01:04:33","modified_gmt":"2025-06-09T17:04:33","slug":"oracle%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ad%a6%e4%b9%a0%e7%ac%94%e8%ae%b0-%e5%88%9b%e5%bb%ba%e3%80%81%e5%a4%87%e4%bb%bd%e5%92%8c%e6%81%a2%e5%a4%8d","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/42626.html","title":{"rendered":"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d"},"content":{"rendered":"<h2>Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 \u521b\u5efa&#xff0c;\u5907\u4efd\u548c\u6062\u590d<\/h2>\n<p>Oracle \u7248\u672c\u57fa\u4e8e11g \u5c3d\u91cf\u4e0d\u4f7f\u7528\u56fe\u5f62\u754c\u9762\u65b9\u5f0f&#xff0c;\u64cd\u4f5c\u9002\u7528\u4e8elinux\u548cwindows<\/p>\n<h3>\u521b\u5efa\u6570\u636e\u5e93<\/h3>\n<h4>\u521b\u5efa\u5b9e\u4f8b<\/h4>\n<p><span class=\"token comment\"># \u6b65\u9aa41&#xff1a;\u8bbe\u7f6e\u73af\u5883\u53d8\u91cf<\/span><br \/>\n<span class=\"token builtin class-name\">export<\/span> <span class=\"token assign-left variable\">ORACLE_SID<\/span><span class=\"token operator\">&#061;<\/span>myorcl<br \/>\n<span class=\"token builtin class-name\">export<\/span> <span class=\"token assign-left variable\">ORACLE_HOME<\/span><span class=\"token operator\">&#061;<\/span>\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1<br \/>\n<span class=\"token builtin class-name\">export<\/span> <span class=\"token assign-left variable\"><span class=\"token environment constant\">PATH<\/span><\/span><span class=\"token operator\">&#061;<\/span><span class=\"token variable\">$ORACLE_HOME<\/span>\/bin:<span class=\"token environment constant\">$PATH<\/span><br \/>\n<span class=\"token comment\"># \u6b65\u9aa42&#xff1a;\u521b\u5efa\u521d\u59cb\u5316\u53c2\u6570\u6587\u4ef6<\/span><br \/>\n<span class=\"token comment\"># \u521b\u5efapfile<\/span><br \/>\n<span class=\"token function\">cat<\/span> <span class=\"token operator\">&gt;<\/span> <span class=\"token variable\">$ORACLE_HOME<\/span>\/dbs\/initmyorcl.ora <span class=\"token operator\">&lt;&lt;<\/span> <span class=\"token string\">EOF<br \/>\ndb_name&#061;myorcl<br \/>\nmemory_target&#061;2G<br \/>\nprocesses&#061;300<br \/>\nsessions&#061;472<br \/>\ndb_block_size&#061;8192<br \/>\ncompatible&#061;19.0.0<br \/>\ndb_create_file_dest&#061;\/u01\/app\/oracle\/oradata<br \/>\ndb_recovery_file_dest&#061;\/u01\/app\/oracle\/fast_recovery_area<br \/>\ndb_recovery_file_dest_size&#061;4G<br \/>\nundo_management&#061;AUTO<br \/>\ncontrol_files&#061;(\/u01\/app\/oracle\/oradata\/myorcl\/control01.ctl,\/u01\/app\/oracle\/oradata\/myorcl\/control02.ctl)<br \/>\nEOF<\/span><br \/>\n<span class=\"token comment\"># \u6b65\u9aa43&#xff1a;\u521b\u5efa\u5fc5\u8981\u76ee\u5f55<\/span><br \/>\n<span class=\"token function\">mkdir<\/span> <span class=\"token parameter variable\">-p<\/span> \/u01\/app\/oracle\/oradata\/myorcl<br \/>\n<span class=\"token function\">mkdir<\/span> <span class=\"token parameter variable\">-p<\/span> \/u01\/app\/oracle\/fast_recovery_area<br \/>\n<span class=\"token function\">mkdir<\/span> <span class=\"token parameter variable\">-p<\/span> \/u01\/app\/oracle\/admin\/myorcl\/adump<br \/>\n<span class=\"token comment\"># \u6b65\u9aa44&#xff1a;\u542f\u52a8\u5b9e\u4f8b\u5e76\u521b\u5efa\u6570\u636e\u5e93<\/span><br \/>\n<span class=\"token comment\"># \u542f\u52a8sqlplus<\/span><br \/>\nsqlplus \/ as sysdba<\/p>\n<p><span class=\"token comment\"># \u5728sqlplus\u4e2d\u6267\u884c<\/span><br \/>\nSTARTUP NOMOUNT<span class=\"token punctuation\">;<\/span><\/p>\n<p>CREATE DATABASE myorcl<br \/>\n<span class=\"token environment constant\">USER<\/span> SYS IDENTIFIED BY oracle123<br \/>\n<span class=\"token environment constant\">USER<\/span> SYSTEM IDENTIFIED BY oracle123<br \/>\nLOGFILE GROUP <span class=\"token number\">1<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/redo01.log&#039;<\/span><span class=\"token punctuation\">)<\/span> SIZE 100M,<br \/>\n        GROUP <span class=\"token number\">2<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/redo02.log&#039;<\/span><span class=\"token punctuation\">)<\/span> SIZE 100M,<br \/>\n        GROUP <span class=\"token number\">3<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/redo03.log&#039;<\/span><span class=\"token punctuation\">)<\/span> SIZE 100M<br \/>\nMAXLOGFILES <span class=\"token number\">3<\/span><br \/>\nMAXLOGMEMBERS <span class=\"token number\">3<\/span><br \/>\nMAXDATAFILES <span class=\"token number\">100<\/span><br \/>\nCHARACTER SET AL32UTF8<br \/>\nNATIONAL CHARACTER SET AL16UTF16<br \/>\nDATAFILE <span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/system01.dbf&#039;<\/span> SIZE 700M REUSE<br \/>\nSYSAUX DATAFILE <span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/sysaux01.dbf&#039;<\/span> SIZE 550M REUSE<br \/>\nDEFAULT TABLESPACE <span class=\"token function\">users<\/span><br \/>\n   DATAFILE <span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/users01.dbf&#039;<\/span> SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED<br \/>\nDEFAULT TEMPORARY TABLESPACE tempts1<br \/>\n   TEMPFILE <span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/temp01.dbf&#039;<\/span> SIZE 20M REUSE<br \/>\nUNDO TABLESPACE undotbs1<br \/>\n   DATAFILE <span class=\"token string\">&#039;\/u01\/app\/oracle\/oradata\/myorcl\/undotbs01.dbf&#039;<\/span> SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token comment\"># \u6b65\u9aa45&#xff1a;\u521b\u5efa\u6570\u636e\u5b57\u5178<\/span><br \/>\n&#8212; \u5728sqlplus\u4e2d\u7ee7\u7eed\u6267\u884c<br \/>\n&#064;?\/rdbms\/admin\/catalog.sql<br \/>\n&#064;?\/rdbms\/admin\/catproc.sql<br \/>\n&#064;?\/sqlplus\/admin\/pupbld.sql<\/p>\n<p>windows\u4e0b\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528Database Configuration Assistant<\/p>\n<h4>\u521b\u5efaListener<\/h4>\n<p>\u76f4\u63a5\u7f16\u8f91listener.ora<\/p>\n<p><span class=\"token comment\"># listener.ora Network Configuration File: C:\\\\app\\\\Administrator\\\\product\\\\11.2.0\\\\dbhome_1\\\\network\\\\admin\\\\listener.ora<\/span><br \/>\n<span class=\"token comment\"># Generated by Oracle configuration tools.<\/span><\/p>\n<p><span class=\"token comment\"># \u5355\u4e2alistener\u76d1\u542c\u591a\u4e2a\u7aef\u53e3&#xff0c;\u6240\u6709\u5b9e\u4f8b\u90fd\u53ef\u901a\u8fc7\u4efb\u4e00\u7aef\u53e3\u8bbf\u95ee<\/span><br \/>\nLISTENER <span class=\"token operator\">&#061;<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span>DESCRIPTION_LIST <span class=\"token operator\">&#061;<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span>DESCRIPTION <span class=\"token operator\">&#061;<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ADDRESS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">(<\/span>PROTOCOL <span class=\"token operator\">&#061;<\/span> TCP<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">(<\/span>HOST <span class=\"token operator\">&#061;<\/span> WIN<span class=\"token operator\">&#8211;<\/span>S6D4H9HDL8B<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">(<\/span>PORT <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1521<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ADDRESS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">(<\/span>PROTOCOL <span class=\"token operator\">&#061;<\/span> TCP<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">(<\/span>HOST <span class=\"token operator\">&#061;<\/span> WIN<span class=\"token operator\">&#8211;<\/span>S6D4H9HDL8B<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">(<\/span>PORT <span class=\"token operator\">&#061;<\/span> <span class=\"token number\">1522<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ADDRESS <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">(<\/span>PROTOCOL <span class=\"token operator\">&#061;<\/span> IPC<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">(<\/span><span class=\"token keyword\">KEY<\/span> <span class=\"token operator\">&#061;<\/span> EXTPROC1521<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><br \/>\n  <span class=\"token punctuation\">)<\/span><\/p>\n<p><span class=\"token comment\"># \u6240\u6709\u5b9e\u4f8b\u7684\u9759\u6001\u6ce8\u518c&#xff08;\u53ef\u901a\u8fc71521\u62161522\u7aef\u53e3\u8bbf\u95ee&#xff09;<\/span><br \/>\nSID_LIST_LISTENER <span class=\"token operator\">&#061;<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span>SID_LIST <span class=\"token operator\">&#061;<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span>SID_DESC <span class=\"token operator\">&#061;<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>GLOBAL_DBNAME <span class=\"token operator\">&#061;<\/span> hicon<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ORACLE_HOME <span class=\"token operator\">&#061;<\/span> C:\\\\app\\\\Administrator\\\\product\\\\<span class=\"token number\">11.2<\/span><span class=\"token number\">.0<\/span>\\\\dbhome_1<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>SID_NAME <span class=\"token operator\">&#061;<\/span> hicon<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span>SID_DESC <span class=\"token operator\">&#061;<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>GLOBAL_DBNAME <span class=\"token operator\">&#061;<\/span> orcl<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ORACLE_HOME <span class=\"token operator\">&#061;<\/span> C:\\\\app\\\\Administrator\\\\product\\\\<span class=\"token number\">11.2<\/span><span class=\"token number\">.0<\/span>\\\\dbhome_1<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>SID_NAME <span class=\"token operator\">&#061;<\/span> orcl<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">(<\/span>SID_DESC <span class=\"token operator\">&#061;<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>GLOBAL_DBNAME <span class=\"token operator\">&#061;<\/span> orclh1<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>ORACLE_HOME <span class=\"token operator\">&#061;<\/span> C:\\\\app\\\\Administrator\\\\product\\\\<span class=\"token number\">11.2<\/span><span class=\"token number\">.0<\/span>\\\\dbhome_1<span class=\"token punctuation\">)<\/span><br \/>\n      <span class=\"token punctuation\">(<\/span>SID_NAME <span class=\"token operator\">&#061;<\/span> orclh1<span class=\"token punctuation\">)<\/span><br \/>\n    <span class=\"token punctuation\">)<\/span><br \/>\n  <span class=\"token punctuation\">)<\/span><\/p>\n<p>ADR_BASE_LISTENER <span class=\"token operator\">&#061;<\/span> C:\\\\app\\\\Administrator<\/p>\n<p>\u8fd9\u662f\u9759\u6001\u6ce8\u518c\u65b9\u5f0f&#xff0c;\u76f4\u63a5\u544a\u8bc9listener\u6709\u591a\u5c11\u4e2a\u5b9e\u4f8b&#xff0c;SID_LIST\u9879\u53ef\u4ee5\u4e0d\u5b58\u5728&#xff0c;\u8fd9\u65f6oracle\u4f1a\u52a8\u6001\u6ce8\u518c\u5b9e\u4f8b\u5230listener&#xff0c;\u53ef\u80fd\u4f1a\u7531\u4e00\u5b9a\u7684\u5ef6\u65f6\u624d\u80fd\u8fde\u4e0a \u5b9e\u4f8b\u53ef\u4ee5\u81ea\u4e3b\u51b3\u5b9a\u4f7f\u7528\u54ea\u4e2alistener \u4e00\u822c\u4e00\u4e2a\u5b9e\u4f8b\u4e0b\u8bbe\u7f6e3~5\u4e2aSchemas\u4e3a\u5b9c<\/p>\n<h4>\u521b\u5efaSchema<\/h4>\n<ul>\n<li>\u9996\u5148\u8fde\u63a5\u5230\u5177\u4f53\u5b9e\u4f8b<\/li>\n<\/ul>\n<p><span class=\"token keyword\">create<\/span> <span class=\"token keyword\">user<\/span> xxx  identified <span class=\"token keyword\">by<\/span> <span class=\"token string\">&#034;password&#034;<\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">grant<\/span> dba <span class=\"token keyword\">to<\/span> xxx<span class=\"token punctuation\">;<\/span><\/p>\n<h3>\u5907\u4efd\u6062\u590d\u6570\u636e\u5e93<\/h3>\n<p><span class=\"token comment\"># \u521b\u5efa\u5907\u4efd\u76ee\u5f55<\/span><br \/>\n<span class=\"token function\">mkdir<\/span> D:<span class=\"token punctuation\">\\\\<\/span>oracle_dump<br \/>\n<span class=\"token comment\"># \u767b\u5165\u73b0\u6709\u5b9e\u4f8b<\/span><br \/>\n<span class=\"token comment\">## \u65b9\u5f0f1<\/span><br \/>\nsqlplus system\/123456&#064;<span class=\"token string\">&#034;(DESCRIPTION&#061;(ADDRESS&#061;(PROTOCOL&#061;TCP)(<br \/>\nHOST&#061;WIN-S6D4H9HDL8B)(PORT&#061;1521))(CONNECT_DATA&#061;(SID&#061;orclh1)))&#034;<\/span><br \/>\n<span class=\"token comment\">## \u65b9\u5f0f2<\/span><br \/>\nsqlplus system\/password&#064;WIN-7JA8JJ4UHP2:1522:orcl2 as sysdba <\/p>\n<p><span class=\"token comment\">## \u914d\u7f6eoracle\u76ee\u5f55\u5bf9\u8c61<\/span><br \/>\nCREATE DIRECTORY dump_dir AS <span class=\"token string\">&#039;D:\\\\oracle_dump&#039;<\/span><span class=\"token punctuation\">;<\/span><br \/>\nGRANT READ, WRITE ON DIRECTORY dump_dir TO system<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token builtin class-name\">exit<\/span> &#8212; \u9000\u51fasql\u6a21\u5f0f<br \/>\n<span class=\"token comment\">## \u5907\u4efd\u6570\u636e\u5e93 &#8211; \u4eceorcl\u5b9e\u4f8b\u4e2d\u5bfc\u51fa<\/span><br \/>\nexpdp system\/123456&#064;WIN-S6D4H9HDL8B:1521\/orcl <span class=\"token assign-left variable\">DIRECTORY<\/span><span class=\"token operator\">&#061;<\/span>dump_dir <span class=\"token assign-left variable\">DUMPFILE<\/span><span class=\"token operator\">&#061;<\/span>smpA_export.dmp <span class=\"token assign-left variable\">LOGFILE<\/span><span class=\"token operator\">&#061;<\/span>smpA_export.log <span class=\"token assign-left variable\">SCHEMAS<\/span><span class=\"token operator\">&#061;<\/span>smpA<\/p>\n<p><span class=\"token comment\">## \u6062\u590d\u6570\u636e\u5e93 &#8211; \u5c06\u5bfc\u51fa\u7684\u6570\u636e\u5e93\u6062\u590d\u5230orclh1\u5b9e\u4f8b<\/span><br \/>\nimpdp system\/123456&#064;WIN-S6D4H9HDL8B:1522\/orclh1 <span class=\"token assign-left variable\">DIRECTORY<\/span><span class=\"token operator\">&#061;<\/span>dump_dir <span class=\"token assign-left variable\">DUMPFILE<\/span><span class=\"token operator\">&#061;<\/span>smpA_export.dmp <span class=\"token assign-left variable\">LOGFILE<\/span><span class=\"token operator\">&#061;<\/span>smpA_import.log <span class=\"token assign-left variable\">SCHEMAS<\/span><span class=\"token operator\">&#061;<\/span>smpA<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb248\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf4\u6b21\u3002\u8fd9\u662f\u9759\u6001\u6ce8\u518c\u65b9\u5f0f\uff0c\u76f4\u63a5\u544a\u8bc9listener\u6709\u591a\u5c11\u4e2a\u5b9e\u4f8b\uff0cSID_LIST\u9879\u53ef\u4ee5\u4e0d\u5b58\u5728\uff0c\u8fd9\u65f6oracle\u4f1a\u52a8\u6001\u6ce8\u518c\u5b9e\u4f8b\u5230listener\uff0c\u53ef\u80fd\u4f1a\u7531\u4e00\u5b9a\u7684\u5ef6\u65f6\u624d\u80fd\u8fde\u4e0a\u3002windows\u4e0b\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528Database Configuration Assistant\u3002\u5c3d\u91cf\u4e0d\u4f7f\u7528\u56fe\u5f62\u754c\u9762\u65b9\u5f0f\uff0c\u64cd\u4f5c\u9002\u7528\u4e8elinux\u548cwindows\u3002\u4e00\u822c\u4e00\u4e2a\u5b9e\u4f8b\u4e0b\u8bbe\u7f6e3~5\u4e2aSchemas\u4e3a\u5b9c\u3002\u5b9e\u4f8b\u53ef\u4ee5\u81ea\u4e3b\u51b3\u5b9a\u4f7f\u7528\u54ea\u4e2alistener\u3002\u76f4\u63a5\u7f16\u8f91listener.ora\u3002Oracle \u7248\u672c\u57fa\u4e8e11g\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[604,3975,371,100],"topic":[],"class_list":["post-42626","post","type-post","status-publish","format-standard","hentry","category-server","tag-oracle","tag-sql-and-database","tag-371","tag-100"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \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\/42626.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb248\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf4\u6b21\u3002\u8fd9\u662f\u9759\u6001\u6ce8\u518c\u65b9\u5f0f\uff0c\u76f4\u63a5\u544a\u8bc9listener\u6709\u591a\u5c11\u4e2a\u5b9e\u4f8b\uff0cSID_LIST\u9879\u53ef\u4ee5\u4e0d\u5b58\u5728\uff0c\u8fd9\u65f6oracle\u4f1a\u52a8\u6001\u6ce8\u518c\u5b9e\u4f8b\u5230listener\uff0c\u53ef\u80fd\u4f1a\u7531\u4e00\u5b9a\u7684\u5ef6\u65f6\u624d\u80fd\u8fde\u4e0a\u3002windows\u4e0b\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528Database Configuration Assistant\u3002\u5c3d\u91cf\u4e0d\u4f7f\u7528\u56fe\u5f62\u754c\u9762\u65b9\u5f0f\uff0c\u64cd\u4f5c\u9002\u7528\u4e8elinux\u548cwindows\u3002\u4e00\u822c\u4e00\u4e2a\u5b9e\u4f8b\u4e0b\u8bbe\u7f6e3~5\u4e2aSchemas\u4e3a\u5b9c\u3002\u5b9e\u4f8b\u53ef\u4ee5\u81ea\u4e3b\u51b3\u5b9a\u4f7f\u7528\u54ea\u4e2alistener\u3002\u76f4\u63a5\u7f16\u8f91listener.ora\u3002Oracle \u7248\u672c\u57fa\u4e8e11g\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/42626.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-09T17:04:33+00:00\" \/>\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=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/42626.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/42626.html\",\"name\":\"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-06-09T17:04:33+00:00\",\"dateModified\":\"2025-06-09T17:04:33+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/42626.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/42626.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/42626.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d\"}]},{\"@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":"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \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\/42626.html","og_locale":"zh_CN","og_type":"article","og_title":"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb248\u6b21\uff0c\u70b9\u8d5e5\u6b21\uff0c\u6536\u85cf4\u6b21\u3002\u8fd9\u662f\u9759\u6001\u6ce8\u518c\u65b9\u5f0f\uff0c\u76f4\u63a5\u544a\u8bc9listener\u6709\u591a\u5c11\u4e2a\u5b9e\u4f8b\uff0cSID_LIST\u9879\u53ef\u4ee5\u4e0d\u5b58\u5728\uff0c\u8fd9\u65f6oracle\u4f1a\u52a8\u6001\u6ce8\u518c\u5b9e\u4f8b\u5230listener\uff0c\u53ef\u80fd\u4f1a\u7531\u4e00\u5b9a\u7684\u5ef6\u65f6\u624d\u80fd\u8fde\u4e0a\u3002windows\u4e0b\u53ef\u4ee5\u76f4\u63a5\u4f7f\u7528Database Configuration Assistant\u3002\u5c3d\u91cf\u4e0d\u4f7f\u7528\u56fe\u5f62\u754c\u9762\u65b9\u5f0f\uff0c\u64cd\u4f5c\u9002\u7528\u4e8elinux\u548cwindows\u3002\u4e00\u822c\u4e00\u4e2a\u5b9e\u4f8b\u4e0b\u8bbe\u7f6e3~5\u4e2aSchemas\u4e3a\u5b9c\u3002\u5b9e\u4f8b\u53ef\u4ee5\u81ea\u4e3b\u51b3\u5b9a\u4f7f\u7528\u54ea\u4e2alistener\u3002\u76f4\u63a5\u7f16\u8f91listener.ora\u3002Oracle \u7248\u672c\u57fa\u4e8e11g\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/42626.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-06-09T17:04:33+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/42626.html","url":"https:\/\/www.wsisp.com\/helps\/42626.html","name":"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-06-09T17:04:33+00:00","dateModified":"2025-06-09T17:04:33+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/42626.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/42626.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/42626.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Oracle\u6570\u636e\u5e93\u5b66\u4e60\u7b14\u8bb0 - \u521b\u5efa\u3001\u5907\u4efd\u548c\u6062\u590d"}]},{"@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\/42626","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=42626"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/42626\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=42626"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=42626"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=42626"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=42626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}