https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/admin\/creating-and-configuring-an-oracle-database.html#GUID-18B03451-5C74-4B53-A892-656C3E8A2556<\/a><\/p>\n\n\n\n\u5efa\u8bae\u5b89\u88c5 rlwrap \u5de5\u5177<\/p>\n\n\n\n
\u4e00\u3001\u73af\u5883\u8bbe\u7f6e<\/p>\n\n\n\n
1\u3001SID\u7684\u8bbe\u7f6e<\/p>\n\n\n\n
export ORACLE_SID=ORCL<\/p>\n\n\n\n
2\u3001pifle\u6587\u4ef6<\/p>\n\n\n\n
cd $ORACLE_HOME\/dbs\ncontrol1.ctl hc_ORCL.dat init.ora initORCL.ora lkORCL spfileORCL.ora\n[oracle@iZ2zecu3ctp6ahd3y793b2Z dbs]$ cat initORCL.ora \ndb_name='ORCL'\nmemory_target=2G\nprocesses = 1500\naudit_file_dest='\/u01\/app\/oracle\/admin\/orcl\/adump'\naudit_trail ='db'\ndb_block_size=8192\ndb_recovery_file_dest='\/oraback\/fast_recovery_area'\ndb_recovery_file_dest_size=2G\ndiagnostic_dest='\/u01\/app\/oracle\/'\ndispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'\nopen_cursors=300 \nremote_login_passwordfile='EXCLUSIVE'\nundo_tablespace='UNDOTBS1'\ncontrol_files = '\/u01\/app\/oracle\/product\/19.3.0\/dbhome_1\/dbs\/control1.ctl','\/oradata\/ORCL\/control2.ctl'<\/pre>\n\n\n\n3\u3001\u76f8\u5173\u76ee\u5f55<\/p>\n\n\n\n
mkdir -p \/u01\/app\/oracle\/admin\/orcl\/adump\nmkdir -p \/oraback\/fast_recovery_area\nmkdir -p \/oradata\/ORCL\/\nmkdir -p \/oraback\/ORCL\/<\/pre>\n\n\n\n\u4e8c\u3001\u521b\u5efa\u6570\u636e\u5e93<\/p>\n\n\n\n
CREATE DATABASE ORCL\n USER SYS IDENTIFIED BY oracle\n USER SYSTEM IDENTIFIED BY oracle\n LOGFILE GROUP 1 ('\/oradata\/ORCL\/redo01a.log','\/oraback\/ORCL\/redo01b.log') SIZE 100M BLOCKSIZE 512,\n GROUP 2 ('\/oradata\/ORCL\/redo02a.log','\/oraback\/ORCL\/redo02b.log') SIZE 100M BLOCKSIZE 512,\n GROUP 3 ('\/oradata\/ORCL\/redo03a.log','\/oraback\/ORCL\/redo03b.log') SIZE 100M BLOCKSIZE 512\n MAXLOGHISTORY 1\n MAXLOGFILES 16\n MAXLOGMEMBERS 3\n MAXDATAFILES 1024\n CHARACTER SET AL32UTF8\n NATIONAL CHARACTER SET AL16UTF16\n EXTENT MANAGEMENT LOCAL\n DATAFILE '\/oradata\/ORCL\/system01.dbf'\n SIZE 700M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED\n SYSAUX DATAFILE '\/oradata\/ORCL\/sysaux01.dbf'\n SIZE 550M REUSE AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED\n DEFAULT TABLESPACE users\n DATAFILE '\/oradata\/ORCL\/users01.dbf'\n SIZE 500M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED\n DEFAULT TEMPORARY TABLESPACE tempts1\n TEMPFILE '\/oradata\/ORCL\/temp01.dbf'\n SIZE 20M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED\n UNDO TABLESPACE undotbs1\n DATAFILE '\/oradata\/ORCL\/undotbs01.dbf'\n SIZE 200M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED\n USER_DATA TABLESPACE usertbs\n DATAFILE '\/oradata\/ORCL\/undotbs1.dbf'\n SIZE 200M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;<\/pre>\n\n\n\n\u4e09\u3001\u8fd0\u884c\u811a\u672c<\/p>\n\n\n\n
$ORACLE_HOME\/perl\/bin\/perl $ORACLE_HOME\/rdbms\/admin\/catctl.pl -d $ORACLE_HOME\/rdbms\/admin -n 4 -l \/home\/oracle\/log\/catpcat.sql catpcat.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"19c \u65e0\u56fe\u5f62\u5b89\u88c5db \u53c2\u8003\u6587\u6863 https:\/\/docs. …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[2],"tags":[],"class_list":["post-444","post","type-post","status-publish","format-standard","hentry","category-oracle"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7zRbQ-7a","_links":{"self":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/444","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=444"}],"version-history":[{"count":3,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/444\/revisions"}],"predecessor-version":[{"id":460,"href":"https:\/\/www.lisq.net\/index.php?rest_route=\/wp\/v2\/posts\/444\/revisions\/460"}],"wp:attachment":[{"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lisq.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}