k db1 0安裝介質(zhì)步驟號inspur手動

InspurK-DBInspurK-DB安裝手 手動安裝手 修訂歷 題 環(huán)境確 確認(rèn)內(nèi)核參 更改內(nèi)核參 安裝 手動安裝K- 創(chuàng)建組和用 開始安裝數(shù)據(jù) 生成參數(shù)文件及文 建 [root@ibmtest~]#semmsl10000semmsl10000semmnssemopmsemmnishmmax(byte)shmmni4096file-max65536/proc/sys/fs/file-ip_local_port_range1024~65000#sysctlkernel ##vi/etc/sysctl.conffs.file-max=65536kernel.sem=100003200010000kernel.shmmax#sysctl #java#groupadd#useradd-d/home/kdb-gdba-pkdb-s/bin/bash[kdb@ibmtest~]$vi###Getthealiasesandfunctionsif[-f~/.bashrc];then.#Userspecificenvironmentandstartupprogramsexport####### exportPATH=$JAVA_HOME/bin:$PATH##############SETexportKD_HOME=/home/kdb/inspurexportKD_SID=kdbexportexportexport exportKD_SQLPATH=/home/kdb/inspur#######KDB alias########aliaskdhome='cd$KD_HOME'aliaskdbin='cd$KD_HOME/bin'aliaskdlog='cd$KD_HOME/instance/$KD_SID/log'aliaskdcfg='cd$KD_HOME/config'aliaskdcfgv='vi$KD_HOME/config/$KD_SID.tip'aliaskdcli='cd${KD_HOME}/ aliaskdcliv='vi${KD_HOME}/ aliaskdi='cd~/kdinary'aliasclean='kddownclean'aliasdba='kdsqlsys/kdb'aliastracef='tail-fCP安裝文件和license.xml到安裝 并更改權(quán)[kdb@ibmtest~]$.[kdb@ibmtest~]$tar-xvfinspur-bin-kdb-linux64-91694-opt- f mons- inspur//lib/jar/inspur1-jdbc-14-dbg.jarinspur//lib/jar/internal-jdbc-14-dbg.jarinspur//lib/jar/internal-jdbc-14.jarinspur//lib/jar/inspur1- inspur//include/ociap.hinspur//include/ocikpr.hinspur//include/odci.hinspur/ inspur//include/oratypes.hinspur//include/sqlcli_ext.hinspur//include/orid.h [kdb@ibmtest~]$cd[kdb@ibmtestconfig]$UsingUsingKD_SID mands /config/kddsn.tbrgenerated. [kdb@ibmtestinspur]$[kdb@ibmtestinspur]$mkdir[kdb@ibmtest~]$cplicense.xml$KD_HOME/license/[kdb@ibmtestconfig]$vikdb.tip [kdb@ibmtestconfig]$kdbootListenerListenerport=8629InspurK-DB1SP1InspurK-DBinstancestartedup(NOMOUNT[kdb@ibmtestconfig]$kdbootListenerListenerport=8629InspurK-DB1SP1InspurK-DBinstancestartedup(NOMOUNTmode).[kdb@ibmtestconfig]$kdsqlsys/kdbkdSQL1ConnectedtoInspurK-SQLcreate usersysidentifiedby maxinstancesmaxdatafiles1024charactersetNATIONALCHARACTERSETlogfilegroup1('redo11.log')size1024M,group2('redo21.log')size1024M,group3('redo31.log')size1024Mmaxloggroupsmaxlogmembers8datafilesizeDEFAULTTABLESPACE size1024MDEFAULTTEMPORARYTABLESPACEtempfilesizeextentmanagementlocalautoallocateundotablespaceUNDO0datafilesizeextentmanagementlocalDatabaseDatabaseSQL>[kdb@ibmtestconfig]$ListenerListenerport=8629InspurK-DB1SP1InspurK-DBinstancestartedup(NORMAL[kdb@ibmtestconfig]$cd$KD_HOME/scripts[kdb@ibmtestscripts]$./system.shEnterEnterSYS --此一定要和創(chuàng)建數(shù)據(jù)庫時(shí)的一EnterEnterSYSCAT --此處的一定要輸入CreatingCreatingtheroleCreatedefaultsystemusers&yCreatingCreatingsystemusers&roles...Creatingvirtualtables(1)...CreatingvirtualGrantingpublicaccesstoCreatingthesystemgeneratedsequences...Creatinginternaldynamicperformanceviews...Creatingoutlinetable...Creatingsystemtablesrelatedtodbms_job...Creatingsystemtablesrelatedtodbms_lock...Creatingsystempackages:RunningRunning/home/kdb/inspur/scripts/pkg/pkg_standard_extension.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_output.sql...RunningRunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_obfuscation.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_space_admin.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_space.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_random.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_lock.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_system.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_job.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_raw.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_i18n.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_file.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_str.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_rowid.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_application_info.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_java.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_encode.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_url.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_http.sql...Running/home/kdb/inspur/scripts/pkg/pkg_utl_tcp.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_session.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_crypto.sql...Running/home/kdb/inspur/scripts/pkg/pkg_tool_utility.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_htp.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_htp.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_result_cache.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_flashback.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_debug_jdwp.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_expression.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_xmlgen.sql...CreatingpackagesforRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_types.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_sql.sql...CreatingpackagesforRunningCreatingpublicsynonymsforsystempackages...Creatingauxiliarytablesusedinstaticviews...Createsystemtablesrelatedtoprofile?(Y/N):yCreatingCreatingsystemtablesrelatedtoprofile...Creatingstaticviews...CreatingstaticviewCreatingsystemtablesrelatedtostatistics...Creatingpackagesforstatistics:RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_stats_internal.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_stats.sql...Registerdbms_statsjobtoJobyRegisteringRegisteringdbms_statsjobtoJobScheduler...Creatingpackagesforlogerrors:RunningCreatingpackagesforRunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_mview_util.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_mview.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_mview_refresh_util.sql...RunningRunning/home/kdb/inspur/scripts/pkg/pkg_dbms_mview_refresh_util.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_redefinition_stats.sql...Running/home/kdb/inspur/scripts/pkg/pkg_dbms_redefinition.sql...CreatingpackagesforRunningCreatingremainingpublicsynonymsforsystempackages...Running/home/kdb/inspur/scripts/iparam_desc_gen.sql...RunningCreatingdynamicperformance