1. 初始化安装
1.1添加运行用户
[root@gs01]#useradd sunje useradd csii
[root@gs01]#useradd sunje passwd csii
1.2解压安装包
–通过md5校验安装包是否完整
[csii@gs01 ~]$md5sum Sundb-server-venus.3.2.5-linux-x86_64.tar.gz
9636f3eca93891225e54ca7b821217be Sundb-server-venus.3.2.5-linux-x86_64.tar.gz
[csii@gs01 ~]$tar xf Sundb-server-venus.3.2.5-linux-x86_64.tar.gz
[csii@gs01 ~]$mv Sundb-server-venus.3.2.4-linux-x86_64 product
1.3修改属主
[root@gs01]# chown -R csii.csii /home/csii
1.4配置环境变量
修改环境变量，追加以下内容：
[csii@gs01 ~]$vi /home/csii/.bash_profile
export SUNDB_DATA=${HOME}/product/Sundb_data
export PATH=.:$SUNDB_HOME/bin:$PATH
export LD_LIBRARY_PATH=$SUNDB_HOME/lib:$LD_LIBRARY_PATH
export CLASSPATH=$SUNDB_HOME/lib/Sundb8.jar:/home/csii/product/Sundb_home/sample:$JAVA_HOME/lib:${CLASSPATH}
#alias
alias gs='gsql sys gliese --as sysdba --prompt=gSQL'
alias gsn=' gsqlnet sys gliese --as sysdba --prompt=gSQLNET'
#安装了rlwrap可以使用以下别名
#alias rgs='rlwrap gsql sys gliese --as sysdba --prompt=gSQL'
#alias rgsn=' rlwrap gsqlnet sys gliese --as sysdba --prompt=gSQLNET'
生效环境变量
[csii@gs01 ~]$source /home/csii/.bash_profile
1.5添加license
写入获得的license。
[csii@gs01 ~]$vi /home/csii/product/Sundb_home/license/license
1.6.修改配置文件【按需配置】
以下参数为初始化时建议修改的一些参数，请按需修改。
[csii@gs01 conf]$ cat Sundb.properties.conf
SPIN_COUNT = 1000 # def: 1000
BUSY_WAIT_COUNT = 1000 # def:50
OS_GROUP_ACCESS = YES
SHARED_SESSION = NO
SESSION_FATAL_BEHAVIOR = 1
SYSTEM_MEMORY_DATA_TABLESPACE_SIZE = 5G
SYSTEM_MEMORY_TEMP_TABLESPACE_SIZE = 5G
SYSTEM_MEMORY_UNDO_TABLESPACE_SIZE = 4G
SYSTEM_MEMORY_DICT_TABLESPACE_SIZE = 512M
SHARED_MEMORY_STATIC_SIZE = 15G
PRIVATE_STATIC_AREA_SIZE = 6G
TRACE_DDL = YES
TRACE_LONG_RUN_SQL = 0
TRACE_LONG_RUN_CURSOR = 0
NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'
DISABLE_DDL_CDC_GIVEUP = YES
DISABLE_UPDATE_PK_CDC_GIVEUP = YES
CLIENT_MAX_COUNT = 4096
PROCESS_MAX_COUNT = 4096
TRANSACTION_TABLE_SIZE = 5120
UNDO_RELATION_COUNT = 4096
UNDO_SHRINK_THRESHOLD = 1048576
PARALLEL_IO_FACTOR = 6
LOG_FILE_SIZE = 5G
LOG_BUFFER_SIZE = 1G
PENDING_LOG_BUFFER_COUNT = 8
PARALLEL_LOAD_FACTOR = 16
RECOMPILE_PAGE_PERCENT = 0
PLAN_CACHE = YES
PLAN_CACHE_SIZE = 104857600
CLUSTER_ASYNC_COMMIT = YES
CLUSTER_DISPATCHER_IN_QUEUE_SIZE = 2048
CLUSTER_DISPATCHER_OUT_QUEUE_SIZE = 2048
CLUSTER_SERVER_RESPONSE_QUEUE_SIZE = 2048
CDISPATCHER_THREADS = 4
CDISPATCHER_HOT_POLICY_INTERVAL = 5000000
QUERY_TIMEOUT = 600
SNAPSHOT_STATEMENT_TIMEOUT = 900
IDLE_TIMEOUT = 0
DDL_LOCK_TIMEOUT = 3
TRANSACTION_TIMEOUT = 1200
CSERVERS = 64
INDEX_ROOT_MIRRORING_DEPTH = 2
CLUSTER_DATA_SYNC_SERVERS = 10
CLUSTER_CM_BUFFER_COUNT = 128
CDISPATCHER_SOCKET_BUFFER_SIZE = 10M
MEMORY_MERGE_RUN_COUNT = 64
CLUSTER_SPLIT_BRAIN_RESOLUTION_POLICY = 0
GLOBAL_TRANSACTION_LOG_FILE_SIZE = 2G
CLUSTER_COMMIT_STREAM_ISOLATION = YES
SQL_HISTORY_SIZE = 100
TIMED_STATISTICS = 1
CLUSTER_HEARTBEAT_INTERVAL = 1
TRACE_ALTER_SYSTEM = YES
2.初始化数据库
使用gcreatedb创建数据库
[csii@gs01]$gcreatedb --db_name=“gsdb” --db_comment=“Sundb database” --timezone="+08:00" --character_set=“UTF8” --char_length_units=“OCTETS” –silent
[csii@gs01]$ls $SUNDB_DATA/db
README system_aux.dbf system_data.dbf system_dict.dbf system_undo.dbf
[csii@gs01]gs Copyright © 2010 SUNJESOFT Inc. All rights reserved. Release Venus.3.2.4 revision(27858) Connected to an idle instance. gSQL> startup Startup success gSQL>quit 查看后台进程 [csii@gs01]ps -ef|grep csii|grep -v ssh|grep -v grep
3.构建字典信息
为了能够查询系统及相关对象的信息，需生成如下schema。
⚫ DICTIONARY_SCHEMA : 由DBA_，ALL_，USER_*等查询对象信息的视图和表组成
⚫ INFORMATION_SCHEMA :由包含在SQL标准的INFORMATION_SCHEMA中的视图和表组成
⚫ PERFORMANCE_VIEW_SCHEMA : 通过组合固定表的信息来查询系统信息的视图组成
[csii@gs01]$gsql sys gliese --as sysdba --import $SUNDB_HOME/admin/standalone/DictionarySchema.sql
[csii@gs01]$gsql sys gliese --as sysdba–import $SUNDB_HOME/admin/standalone/InformationSchema.sql
[csii@gs01]$gsql sys gliese --as sysdba–import $SUNDB_HOME/admin/standalone/PerformanceViewSchema.sql
4.开启监听
[csii@gs01]glsnr –start 查看监听状态 [csii@gs01]glsnr –status
