kdb在linux下的安装和手动建库

我的操作系统环境如下：

点击(此处)折叠或打开

1. [root@gg ~]# lsb_release -a
2. LSB Version: :base-4.0-amd64:base-4.0-noarch:core-4.0-amd64:core-4.0-noarch:graphics-4.0-amd64:graphics-4.0-noarch:printing-4.0-amd64:printing-4.0-noarch
3. Distributor ID: RedHatEnterpriseServer
4. Description: Red Hat Enterprise Linux Server release 6.6 (Santiago)
5. Release: 6.6
6. Codename: Santiago

我创建了wbg这个用户，来装数据库
需要jdk

点击(此处)折叠或打开

1. [wbg@gg software]$ java -version
2. java version "1.7.0_65"
3. OpenJDK Runtime Environment (rhel-2.5.1.2.el6_5-x86_64 u65-b17)
4. OpenJDK 64-Bit Server VM (build 24.65-b04, mixed mode)

提前安装一些包，下面的是从history里面，粘贴出来的

点击(此处)折叠或打开

1. 265 yum -y install gcc-*
2. 266 yum -y install gcc-c++*
3. 267 yum -y install libgcc*
4. 268 yum -y install libstdc*
5. 269 yum -y install libstdc++-devel*
6. 270 yum -y install compat-libstdc++*
7. 271 yum -y install libaio*
8. 272 yum -y install libaio-devel*

修改内核参数

  [ root@gg yum.repos.d]# echo "10000 32000 10000 10000" > /proc/sys/kernel/sem

   /proc/sys/kernel/shmall 设置为  2097152

   [ root@gg  yum.repos.d]# echo 1073741824 > /proc/sys/kernel/shmmax    //这个要给内存的一半

   /proc/sys/kernel/shmmni 设置为  4096

   /proc/sys/fs/file-max  设置为  6815744

   [ root@gg  yum.repos.d]# echo "1024 65000" > /proc/sys/net/ipv4/ip_local_port_range

编辑wbg的.bash_profile，加入如下内容,和Oracle的env是很类似的

点击(此处)折叠或打开

1. export UP_HOME=/home/wbg/UPDB/updb6
2. export UP_SID=wbg
3. export LD_LIBRARY_PATH=$UP_HOME/lib:$UP_HOME/client/lib
4. export PATH=$PATH:$UP_HOME/bin:$UP_HOME/client/bin

安装软件，只是解压而已，比oracle简单很多

点击(此处)折叠或打开

1. [wbg@gg UPDB]$ tar -zxvf updb6-bin-FS02-linux64-110345-opt-20150911182108-tested.tar.gz
2. [wbg@gg UPDB]$ pwd
3. /home/wbg/UPDB

把 license.xml放在 $UP_HOME/license这个目录下

软件安装，彻底完成

==============================================

开始手动建库了

用脚本来生成一些配置文件

点击(此处)折叠或打开

1. [wbg@gg license]$ cd $UP_HOME/config
2. [wbg@gg config]$ pwd
3. /home/wbg/UPDB/updb6/config
4. [wbg@gg config]$ ./gen_tip.sh //手动建库的第一个脚本
5. Using UP_SID "wbg"
6. /home/wbg/UPDB/updb6/config/wbg.tip generated //等同于oracle的pfile
7. /home/wbg/UPDB/updb6/config/psm_commands generated
8. /home/wbg/UPDB/updb6/client/config/updsn.tbr generated. //等同于oracle的tnsnames.ora
9. Running client/config/gen_esql_cfg.sh
10. Done.

启动实例，检查进程

点击(此处)折叠或打开

1. [wbg@gg config]$ upboot nomount
2. Listener port = 8629
4. UPDB 6
6. UpRight Corporation Copyright (c) 2012. All rights reserved.
7. UPDB instance started up (NOMOUNT mode).
8. [wbg@gg config]$ ps -ef|grep upsvr
9. wbg 2924 1 3 12:20 pts/0 00:00:00 upsvr -t nomount -SVR_SID wbg
10. wbg 2926 2924 0 12:20 pts/0 00:00:00 upsvr_TBMP -t nomount -SVR_SID wbg
11. wbg 2927 2924 0 12:20 pts/0 00:00:00 upsvr_WP000 -t nomount -SVR_SID wbg
12. wbg 2928 2924 0 12:20 pts/0 00:00:00 upsvr_WP001 -t nomount -SVR_SID wbg
13. wbg 2929 2924 0 12:20 pts/0 00:00:00 upsvr_DBWR -t nomount -SVR_SID wbg
14. wbg 2930 2924 0 12:20 pts/0 00:00:00 upsvr_RECO -t nomount -SVR_SID wbg
15. wbg 2983 2791 0 12:20 pts/0 00:00:00 grep upsvr

使用脚本，创建数据库的

点击(此处)折叠或打开

1. [wbg@gg config]$ upsql sys/updb
3. upSQL 6
5. UpRight Corporation Copyright (c) 2012. All rights reserved.
7. Connected to UPDB.
9. SQL>
10. create database "wbg"
11. user sys identified by updb maxinstances 8 maxdatafiles 100 character set MSWIN949 logfile group 1 'log001.log'
12. size 100M,
13. group 2 'log002.log'
14. size 100M,
15. group 3 'log003.log'
16. size 100M
17. maxloggroups 255 maxlogmembers 8 noarchivelog
18. datafile 'system001.dtf'
19. size 100M autoextend on next 100M maxsize unlimited
20. default temporary tablespace TEMP
21. tempfile 'temp001.dtf'
22. size 100M autoextend on next 100M maxsize unlimited extent management local autoallocate
23. undo tablespace UNDO
24. datafile 'undo001.dtf'
25. size 100M autoextend on next 100M maxsize unlimited
26. extent management local autoallocate;

重启数据库

点击(此处)折叠或打开

1. [wbg@gg config]$ upboot
2. Listener port = 8629
4. UPDB 6
6. UpRight Corporation Copyright (c) 2012. All rights reserved.
7. UPDB instance started up (NORMAL mode).

在oracle手动建库之后，会跑3个脚本，这里，kdb也是一样的

点击(此处)折叠或打开

1. [wbg@gg config]$ cd $UP_HOME/scripts
2. [wbg@gg scripts]$ pwd
3. /home/wbg/UPDB/updb6/scripts
4. [wbg@gg scripts]$ ./system.sh
5. Enter SYS password:
7. Enter SYSCAT password:
9. Dropping agent table...
10. Creating the role DBA...
11. Create default system users & roles?(Y/N):
12. Y
14. Creating system users & roles...
15. Creating example users...
16. Creating virtual tables(1)...
17. ................
18. Create system tables related to profile?(Y/N):
19. Y
20. ................
21. Register dbms_stats job to Job Scheduler?(Y/N):
22. Y
23. ..................
24. Create TPR tables?(Y/N):
25. Y
26. ...................
27. Done.
28. For details, check /home/wbg/UPDB/updb6/instance/wbg/log/system_init.log.

手动建库，完成了
完成之后，查看一下

点击(此处)折叠或打开

1. [wbg@gg config]$ cd $UP_HOME/scripts
2. [wbg@gg scripts]$ pwd
3. /home/wbg/UPDB/updb6/scripts
4. [wbg@gg scripts]$ ./system.sh
5. Enter SYS password:
7. Enter SYSCAT password:
9. Dropping agent table...
10. Creating the role DBA...
11. Create default system users & roles?(Y/N):
12. Y
14. Creating system users & roles...
15. Creating example users...
16. Creating virtual tables(1)...
17. ................
18. Create system tables related to profile?(Y/N):
19. Y
20. ................
21. Register dbms_stats job to Job Scheduler?(Y/N):
22. Y
23. ..................
24. Create TPR tables?(Y/N):
25. Y
26. ...................
27. Done.
28. For details, check /home/wbg/UPDB/updb6/instance/wbg/log/system_init.log.
30. 完成之后，查看一下
31. [wbg@gg scripts]$ upsql sys/updb
33. upSQL 6
35. UpRight Corporation Copyright (c) 2012. All rights reserved.
37. Connected to UPDB.
39. SQL> select status from v$instance;
41. STATUS
42. ----------------
43. NORMAL
45. 1 row selected.
47. SQL> select name from v$datafile;
49. NAME
50. --------------------------------------------------------------------------------
51. /home/wbg/UPDB/updb6/database/wbg/system001.dtf
52. /home/wbg/UPDB/updb6/database/wbg/undo001.dtf
53. /home/wbg/UPDB/updb6/database/wbg/usr001.dtf
54. /home/wbg/UPDB/updb6/database/wbg/tpr_ts.dtf
56. 4 rows selected.
58. SQL> select member from v$logfile;
60. MEMBER
61. --------------------------------------------------------------------------------
62. /home/wbg/UPDB/updb6/database/wbg/log001.log
63. /home/wbg/UPDB/updb6/database/wbg/log002.log
64. /home/wbg/UPDB/updb6/database/wbg/log003.log
66. 3 rows selected.

该有的都有了，状态也可以了，就这样吧
额。。。赓赓。。。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30202921/viewspace-1822280/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30202921/viewspace-1822280/