金倉數(shù)據庫管理系統(tǒng)KingbaseESV8.62022年9月6日目錄目錄HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK.......................................................HYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK....................................................HYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINKHYPERLINK...................................................HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINK..................................................HYPERLINKHYPERLINK...................................................HYPERLINKHYPERLINK.................................................HYPERLINKHYPERLINK...........................................HYPERLINKHYPERLINK.......................................HYPERLINKHYPERLINK..............................................HYPERLINKHYPERLINK...................................................12HYPERLINKHYPERLINK..............................................12HYPERLINKHYPERLINK................................................12HYPERLINKHYPERLINK................................................13HYPERLINKHYPERLINK..........................................13HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK...................................................16HYPERLINKHYPERLINK..............................................16HYPERLINKHYPERLINK................................................19HYPERLINKHYPERLINK...............................................20HYPERLINKHYPERLINK...........................................21HYPERLINKHYPERLINK..............................................22I目錄HYPERLINKHYPERLINK.............................................23HYPERLINKHYPERLINK...............................................24HYPERLINKHYPERLINK................................................25HYPERLINKHYPERLINK..............................................26HYPERLINKHYPERLINK................................................28HYPERLINKHYPERLINKHYPERLINK...............................................29HYPERLINKHYPERLINK...................................................30HYPERLINKHYPERLINK..............................................30HYPERLINKHYPERLINK...................................................30HYPERLINKHYPERLINK................................................31HYPERLINKHYPERLINK...............................................32HYPERLINKHYPERLINK...........................................33HYPERLINKHYPERLINK..............................................34HYPERLINKHYPERLINK.............................................34HYPERLINKHYPERLINK...............................................35HYPERLINKHYPERLINK................................................36HYPERLINKHYPERLINK................................................36HYPERLINKHYPERLINK..............................................37HYPERLINKHYPERLINK................................................40HYPERLINKHYPERLINKHYPERLINK...............................................41HYPERLINKHYPERLINK....................................................41HYPERLINKHYPERLINK...........................................41HYPERLINKHYPERLINK................................................43HYPERLINKHYPERLINK..............................................43HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK.................................................47HYPERLINKHYPERLINK...................................................47HYPERLINKHYPERLINK................................................47HYPERLINKHYPERLINK................................................49HYPERLINKHYPERLINK................................................49HYPERLINKHYPERLINK................................................50HYPERLINKHYPERLINK...................................................51HYPERLINKHYPERLINK................................................51HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK................................................52HYPERLINKHYPERLINK....................................................53HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK.................................................55II目錄HYPERLINKHYPERLINK................................................55HYPERLINKHYPERLINK...........................................55HYPERLINKHYPERLINK...........................................56HYPERLINKHYPERLINK..............................................57HYPERLINKHYPERLINK.........................................58HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK................................................59HYPERLINKHYPERLINK...........................................59HYPERLINKHYPERLINK...........................................60HYPERLINKHYPERLINK..............................................61HYPERLINKHYPERLINK.........................................62HYPERLINKHYPERLINK...........................................63HYPERLINKHYPERLINK...........................................64HYPERLINKHYPERLINK.................................................64HYPERLINKHYPERLINK................................................64HYPERLINKHYPERLINK...........................................64HYPERLINKHYPERLINK.........................................66HYPERLINKHYPERLINK...........................................67HYPERLINKHYPERLINK...........................................68HYPERLINKHYPERLINK................................................68HYPERLINKHYPERLINK...........................................68HYPERLINKHYPERLINK.........................................70HYPERLINKHYPERLINK..........................................71HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK...............................................72HYPERLINKHYPERLINK...................................................73HYPERLINKHYPERLINK...............................................74HYPERLINKHYPERLINK..................................74HYPERLINKHYPERLINKHYPERLINKHYPERLINK........................................74HYPERLINKHYPERLINK....................................74HYPERLINKHYPERLINK..........................................75HYPERLINKHYPERLINK.............................76HYPERLINKHYPERLINK......................................76HYPERLINKHYPERLINK..................................76HYPERLINKHYPERLINKHYPERLINK.........................76HYPERLINKHYPERLINKHYPERLINKHYPERLINKHYPERLINK..76HYPERLINKHYPERLINK）.45第5章ksql${./ksql-p54321-Usystemtest-p參數(shù)指定初始化數(shù)據庫時設置的端口。-U參數(shù)指定初始化數(shù)據庫時設置的管理員用戶，也可以是其他ksqlKingbaseES_ksqlksqlKStudio.5${./kingbaseV;ksqlselectversion();6.soso${安ldd*|grep"notfound"在${,sols${so${,exportLD_LIBRARY_PATH=$LD_LIBRARY_PATH:`pwd`${,soKingbaseESV8.6:46第6章第6章卸載KingbaseES???HYPERLINK\l"br51"HYPERLINK\l"br55"HYPERLINK\l"br57"6.1刪除數(shù)據庫服務root.shrootuninstall.sh123..root.${}/install/script/rootuninstall.sh。6.2圖形化卸載6.2.1啟動卸載kingbase${}/UninstallshUninstaller-iswing47第6章圖6.2.1:48第6章6.2.2確認卸載圖6.2.2:6.2.3正在卸載49第6章圖6.2.3:6.2.4完成卸載50第6章圖6.2.4:6.3控制臺卸載6.3.1啟動卸載kingbase${}/UninstallshUninstaller-iconsole51第6章6.3.2準備卸載圖6.3.1:輸入quit再按退出卸載過程；直接按繼續(xù)進行下一步。若無特殊說明，以下各步驟皆6.3.3正在卸載圖6.3.2:6.3.4完成卸載52第6章圖6.3.3:6.4靜默卸載kingbase${}/UninstallshUninstaller-isilent-i-i53第7章第7章增刪組件KingbaseESV8.6圖7.1:??HYPERLINK\l"br59"HYPERLINK\l"br68"54第7章7.1圖形化增刪組件7.1.1增加組件啟動入口以kingbase用戶登錄系統(tǒng)后，進入安裝程序setup.sh所在目錄，執(zhí)行setup.sh。選擇“修改存在的實例”并選圖7.1.1:55第7章添加功能圖7.1.2:56第7章確認圖7.1.3:57第7章選擇功能組件圖7.1.4:58第7章安裝進度圖7.1.5:此步驟用于顯示安裝進度。如果選擇的組件包含數(shù)據庫服務器，則后續(xù)會繼續(xù)選擇授權文件、初始化數(shù)據庫步完成安裝100%7.1.2刪除組件啟動入口以kingbasesetup59第7章shsetup.sh-iswing準備卸載圖7.1.6:60第7章確認圖7.1.7:61第7章選擇功能組件圖7.1.8:選擇需要卸載的功能組件，取消其勾選狀態(tài)；點擊【卸載】按鈕，開始刪除操作。點擊【取消】按鈕，取消卸62第7章正在移除圖7.1.9:63第7章卸載完成圖7.1.10:7.2命令行增刪組件7.2.1增加組件啟動入口setup.shkingbaseshsetup.sh-iconsole64第7章圖7.2.1:2165第7章選擇功能組件圖7.2.2:按照提示按，顯示可以添加的組件列表。輸入不需要安裝的組件編號，多個編號用逗號隔開。按<:66第7章安裝進度圖7.2.3:此步驟用于顯示安裝進度。如果選擇的組件包含數(shù)據庫服務器，則后續(xù)會繼續(xù)選擇授權文件、初始化數(shù)據庫步67第7章完成安裝圖7.2.4:7.2.2刪除組件啟動入口以kingbase${}/UninstallshUninstaller-iconsole68第7章圖7.2.5:2269第7章選擇功能組件圖7.2.6:70第7章刪除及完成圖7.2.7:71第8章第8章附錄???HYPERLINK\l"br76"HYPERLINK\l"br77"HYPERLINK\l"br78"8.1靜默安裝配置文件#1licensefilepath,forexample/home/kingbase/license_1309_0-sales.datforlinuxorC:\\license_309_0-sales.datforwindowsKB_LICENSE_PATH=installset,optionsareFull,Client,CustomCHOSEN_INSTALL_SET=Fullcomponentlist,optionsareSERVER,KSTUDIO,KDTS,INTERFACE,DEPLOY,KINGBASEHACHOSEN_FEATURE_LIST=SERVER,KSTUDIO,KDTS,INTERFACE,DEPLOY,KINGBASEHAinstalldirpath,forexample/opt/Kingbase/ES/V8forlinuxorC:\\ProgramFiles\\Kingbase\\ES\\###V8forwindowsUSER_INSTALL_DIR=/opt/Kingbase/ES/V8#datadirpath,forexample/opt/Kingbase/ES/V8/dataforlinuxorC:\\ProgramFiles\\Kingbase\\ES\\V8\\dataforwindowsUSER_SELECTED_DATA_FOLDER=##initdbparamsserverport,requied,between1and65535DB_PORT=54321username,required,lengthlessthan63bytesDB_USER=systempassword,requiredDB_PASS=1passwordconfirm,requiredDB_PASS2=1encoding,required,optionsareUTF8,GBK,GB18030ENCODING_PARAM=UTF8####72第8章#compatibilitymode,required,optionsareORACLE,PGDATABASE_MODE_PARAM=ORACLEcasesensitivity,required,optionsareYES,NOCASE_SENSITIVE_PARAM=YESblocksize,required,optionsare8k,16k,32k##BLOCK_SIZE_PARAM=8k8.2目錄一覽表數(shù)據庫安裝完成后，進入安裝目錄，使用ll或者ls-l列出數(shù)據庫安裝后生成的目錄和文件，下面列出主要文件和目錄清單。由于完全安裝、客戶端安裝、定制安裝安裝的服務不同，對應生成的文件目錄也有所不同，請以實際的安裝為準。KESRealPro目錄下按版本號放置不同版本的程序內容。安裝根目錄下的其他目錄和文件都是軟連接，實KESRealPro?–Server/bin：服務器二進制文件，可以在該路徑下進行啟動服務、連接數(shù)據庫、物理備份還原、邏輯備份?–guitools/KStudio：開發(fā)管理工具，能運行在各種平臺的圖形工具，用于管理和配置King-baseES數(shù)據庫服務器，管理各種KingbaseES數(shù)據庫對象，進行KingbaseES數(shù)據庫的安全管理，調用SQL––ClientTools/guitools/KDts：數(shù)據庫遷移工具，可以用于跨平臺數(shù)據交換和遷移，支持同異構數(shù)據源之間ClientTools/