Download Software Tibero 6
Tibero 6 software can be downloaded from the following link. Please apply for an account first and it is free.
https://technet.tmaxsoft.com/en/front/download/findDownloadList.do?cmProductCode=0301
Configuring yum server
Run this if your server have internet connection
# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo
Start install packages using the following commands
yum install <package_name>
Configuring local yum server
Run this if your server do not have internet connection
# cp -R /media/cdrom/Packages /Packages # cd /etc/yum.repos.d # vi local.repo [localrepo] name=localrepo baseurl=file:///repo/ enabled=1 gpgcheck=0
Install the following packages manually before creating the local repository
# rpm -ivh /Packages/deltarpm-* # rpm -ivh /Packages/python-deltarpm-* # rpm -ivh /Packages/createrepo-* # createrepo /Packages
Packages
Install the following packages. Please note the package name and version may differ for each OS and version.
gcc-3.4.6-11 gcc-c++-3.4.6-11 libgcc-3.4.6-11 libstdc++-3.4.6-11 libstdc++-devel-3.4.6-11 compat-libstdc++-33-3.2.3-47.3 libaio-0.3.105-2 libaio-devel-0.3.105-2
This package same for installation oracle database
Kernel parameters
Configure the following parameters in /etc/sysctl.conf
fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 2147483648 kernel.shmmni = 4096 # semaphores: semmsl, semmns, semopm, semmni kernel.sem = 10000 32000 10000 10000 net.ipv4.ip_local_port_range = 8600 65500 net.core.rmem_default=262144 net.core.rmem_max=4194304 net.core.wmem_default=262144 net.core.wmem_max=1048586
Run the following command to change the current kernel parameters after modifying /etc/sysctl.conf
sysctl –p
Shell Limits
Add the following lines to /etc/security/limits.conf
tibero soft nproc 2047 tibero hard nproc 16384 tibero soft nofile 1024 tibero hard nofile 65536
SELinux
Disable SELinux in /etc/selinux/config
SELINUX=DISABLED
Firewall
Disable Firewall in Oracle Linux with the following command.
# service iptables stop # chkconfig iptables off
or
# systemctl stop firewalld
NTP
Add the -x in the following line in /etc/sysconfig/ntpd file and restart the NTP service.
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid" # service ntpd restart
Additional Setup
Create tibero user and group with the following command.
groupadd dba useradd -g dba tibero
Create Home Folder Tibero 6
mkdir -p /tibero6 chown -R tibero:dba /tibero6
Edit /etc/hosts file with the following entries.
192.168.0.106 diarycoding.localdomain diarydb
Create the following file in user home for setting
# su - tibero $ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/bin export PATH export TB_SID=diarycoding export TB_HOME=/tibero6 export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib export PATH=$TB_HOME/bin:$TB_HOME/client/bin:$PATH
Installing Tibero Binaries
Make a directory as /tibero6. Un-tar the file downloaded, The contents of /tibero6 looks like the following.
[tibero@diarydb tibero6]$ pwd /tibero6 [tibero@diarydb tibero6]$ ls -al total 48 drwxr-xr-x. 12 tibero dba 4096 Apr 7 08:39 . dr-xr-xr-x. 27 root root 4096 Apr 16 14:40 .. drwxr-xr-x 3 tibero dba 4096 Apr 7 08:38 bin drwxr-xr-x 10 tibero dba 4096 Apr 7 08:33 client drwxr-xr-x 2 tibero dba 4096 Apr 11 13:09 config drwx------ 5 tibero dba 4096 Apr 9 13:14 database drwxr-xr-x 5 tibero dba 4096 Apr 9 13:03 instance drwxr-xr-x 2 tibero dba 4096 Apr 7 08:33 lib drwxr-xr-x 3 tibero dba 4096 Apr 7 08:35 license drwxr-xr-x 3 tibero dba 4096 Apr 7 08:33 nls drwxr-xr-x 3 tibero dba 4096 Apr 11 14:20 scripts
Installing Tibero 6 License
Copy the license.xml requested earlier into $TB_HOME/license.
Configuring Tibero instance
Create the following tibero.tip file in tac1 under $TB_HOME/config. This is the init file that Tibero instance will read when it start.
DB_NAME=diarydb LISTENER_PORT=8629 CONTROL_FILES="/tibero6/database/tibero/c1.ctl" MAX_SESSION_COUNT=20 TOTAL_SHM_SIZE=512M MEMORY_TARGET=1G DB_CACHE_SIZE=256M DB_CREATE_FILE_DEST="/tibero6/database/tibero"
Add the following entry into tbdsn.tbr file in tac1 node under $TB_HOME/client/config.
tibero=( (INSTANCE=(HOST=192.168.0.106) (PORT=8629) (DB_NAME=diarydb) ) )
After the above files have been created and added, boot the tibero instance in nomount mode.
[tibero@diarydb ~]$ tbboot -t nomount Listener port = 8629 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NOMOUNT mode).
Create database using the following commands. Please note that once the database have been created, the instance will automatically shut down.
[tibero@diarydb ~]$ tbsql sys/tibero tbSQL 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Connected to Tibero. SQL> CREATE DATABASE "diarydb" USER SYS IDENTIFIED BY tibero MAXINSTANCES 32 MAXDATAFILES 6100 CHARACTER SET MSWIN949 LOGFILE GROUP 1 '/tibero6/database/tibero/log0001.log' SIZE 32M, GROUP 2 '/tibero6/database/tibero/log0002.log' SIZE 32M, GROUP 3 '/tibero6/database/tibero/log0003.log' SIZE 32M MAXLOGGROUPS 255 MAXLOGMEMBERS 8 ARCHIVELOG DATAFILE '/tibero6/database/tibero/system001.tdf' SIZE 64M AUTOEXTEND ON NEXT 64M DEFAULT TEMPORARY TABLESPACE tmp TEMPFILE '/tibero6/database/tibero/temp001.tdf' SIZE 64M AUTOEXTEND ON NEXT 64M EXTENT MANAGEMENT LOCAL AUTOALLOCATE UNDO TABLESPACE undo DATAFILE '/tibero6/database/tibero/undo.tdf' SIZE 128M AUTOEXTEND ON NEXT 64M EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT TABLESPACE usr DATAFILE '/tibero6/database/tibero/usr001.tdf' SIZE 128M AUTOEXTEND ON NEXT 64M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE; Database created.
After the DB have been created, issue the following command to boot the instance into open mode.
[tibero@diarydb ~]$ tbboot Listener port = 8629 Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode).
You are not done yet, run the following script to create the database views and etc…
[tibero@diarydb ~]$ cd $TB_HOME/scripts [tibero@diarydb scripts]$ sh system.sh -p1 tibero -p2 syscat -a1 Y -a2 Y -a3 Y -a4 Y Dropping agent table... Creating the role DBA... Creating system users & roles... Creating example users... Creating virtual tables(1)... Creating virtual tables(2)... Granting public access to _VT_DUAL... Creating the system generated sequences... Creating internal dynamic performance views... Creating outline table... Creating system tables related to dbms_job... Creating system tables related to dbms_lock... Creating system tables related to scheduler... Creating system tables related to tsn and timestamp... Creating system package specifications: Running /tibero6/scripts/pkg/pkg_standard.sql... Running /tibero6/scripts/pkg/pkg_standard_extension.sql... Running /tibero6/scripts/pkg/anydata.sql... Running /tibero6/scripts/pkg/pkg_dbms_output.sql... Running /tibero6/scripts/pkg/pkg_dbms_lob.sql... Running /tibero6/scripts/pkg/pkg_dbms_utility.sql... Running /tibero6/scripts/pkg/pkg_dbms_obfuscation.sql... Running /tibero6/scripts/pkg/pkg_dbms_transaction.sql... Running /tibero6/scripts/pkg/pkg_dbms_space_admin.sql... Running /tibero6/scripts/pkg/pkg_dbms_space.sql... Running /tibero6/scripts/pkg/pkg_dbms_random.sql... Running /tibero6/scripts/pkg/pkg_dbms_lock.sql... Running /tibero6/scripts/pkg/pkg_dbms_system.sql... Running /tibero6/scripts/pkg/pkg_dbms_job.sql... Running /tibero6/scripts/pkg/pkg_dbms_scheduler.sql... Running /tibero6/scripts/pkg/pkg_utl_raw.sql... Running /tibero6/scripts/pkg/pkg_utl_i18n.sql... Running /tibero6/scripts/pkg/pkg_utl_file.sql... Running /tibero6/scripts/pkg/pkg_utl_str.sql... Running /tibero6/scripts/pkg/pkg_tb_utility.sql... Running /tibero6/scripts/pkg/pkg_dbms_rowid.sql... Running /tibero6/scripts/pkg/pkg_dbms_repair.sql... Running /tibero6/scripts/pkg/pkg_dbms_application_info.sql... Running /tibero6/scripts/pkg/pkg_dbms_java.sql... Running /tibero6/scripts/pkg/pkg_utl_encode.sql... Running /tibero6/scripts/pkg/pkg_utl_url.sql... Running /tibero6/scripts/pkg/pkg_utl_http.sql... Running /tibero6/scripts/pkg/pkg_utl_tcp.sql... Running /tibero6/scripts/pkg/pkg_dbms_session.sql... Running /tibero6/scripts/pkg/pkg_dbms_crypto.sql... Running /tibero6/scripts/pkg/pkg_tool_utility.sql... Running /tibero6/scripts/pkg/pkg_psm_sql_result_cache.sql... Running /tibero6/scripts/pkg/pkg_htp.sql... Running /tibero6/scripts/pkg/pkg_htf.sql... Running /tibero6/scripts/pkg/pkg_dbms_pipe.sql... Running /tibero6/scripts/pkg/pkg_dbms_utl_tb.sql... Running /tibero6/scripts/pkg/pkg_dbms_sql_translator.sql... Running /tibero6/scripts/pkg/pkg_dbms_mssql_translator.sql... Running /tibero6/scripts/pkg/pkg_dbms_db2_translator.sql... Running /tibero6/scripts/pkg/pkg_dbms_aq.sql... Running /tibero6/scripts/pkg/pkg_dbms_aq_utl.sql... Running /tibero6/scripts/pkg/pkg_dbms_aqadm.sql... Running /tibero6/scripts/pkg/pkg_dbms_fga.sql... Running /tibero6/scripts/pkg/pkg_dbms_result_cache.sql... Running /tibero6/scripts/pkg/pkg_dbms_flashback.sql... Running /tibero6/scripts/pkg/pkg_seaf.sql... Running /tibero6/scripts/pkg/pkg_dbms_debug.sql... Running /tibero6/scripts/pkg/pkg_dbms_debug_jdwp.sql... Running /tibero6/scripts/pkg/pkg_dbms_xplan.sql... Running /tibero6/scripts/pkg/pkg_dbms_verify.sql... Running /tibero6/scripts/pkg/pkg_dbms_expression.sql... Running /tibero6/scripts/pkg/pkg_dbms_rls.sql... Running /tibero6/scripts/pkg/pkg_tudiconst.sql... Running /tibero6/scripts/pkg/pkg_dbms_xmlgen.sql... Running /tibero6/scripts/pkg/pkg_dbms_xmldom.sql... Running /tibero6/scripts/pkg/pkg_dbms_sql_analyze.sql... Running /tibero6/scripts/pkg/pkg_dbms_geom.sql... Running /tibero6/scripts/pkg/pkg_utl_match.sql... Creating packages for sql: Running /tibero6/scripts/pkg/pkg_dbms_types.sql... Running /tibero6/scripts/pkg/pkg_dbms_sql.sql... Creating public synonyms for system packages... Creating auxiliary tables used in static views... Creating system tables related to profile... Creating internal system tables... Creating static views... Creating static view descriptions... Running /tibero6/scripts/pkg/pkg_dbms_assert.sql... Running /tibero6/scripts/pkg/pkg_dbms_sqltune.sql... Creating system tables related to statistics... Creating packages for scheduler: Running /tibero6/scripts/pkg/_pkg_dbms_scheduler.tbw... Creating packages for statistics: Running /tibero6/scripts/pkg/pkg_sys_util.sql... Running /tibero6/scripts/pkg/pkg_dbms_stats_util.sql... Running /tibero6/scripts/pkg/pkg_dbms_stats.sql... Running /tibero6/scripts/pkg/_pkg_dbms_stats_util.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_stats.tbw... Running /tibero6/scripts/pkg/pkg_dbms_metadata.sql... Registering dbms_stats job to Job Scheduler... Creating packages for log errors: Running /tibero6/scripts/pkg/pkg_dbms_errlog.sql... Creating packages for mview: Running /tibero6/scripts/rewrite_table.sql... Running /tibero6/scripts/pkg/pkg_dbms_mview_util.sql... Running /tibero6/scripts/pkg/pkg_dbms_mview.sql... Running /tibero6/scripts/pkg/pkg_dbms_mview_refresh_util.sql... Running /tibero6/scripts/pkg/pkg_dbms_redefinition_stats.sql... Running /tibero6/scripts/pkg/pkg_dbms_redefinition.sql... Creating packages for text: Running /tibero6/scripts/pkg/pkg_text.sql... Creating packages for mayo: Running /tibero6/scripts/pkg/pkg__dbms_mayo.sql... Running /tibero6/scripts/pkg/pkg_dbms_mayo.sql... Creating packages for sph: Running /tibero6/scripts/pkg/pkg_dbms_sph.sql... Creating remaining public synonyms for system packages... Running /tibero6/scripts/iparam_desc_gen.sql... Running /tibero6/scripts/trace_event_desc_gen.sql... Creating dynamic performance views... Creating dynamic performance view descriptions... Creating package bodies: Running /tibero6/scripts/pkg/_pkg_dbms_utility.tbw... Running /tibero6/scripts/pkg/_pkg_utl_i18n.tbw... Running /tibero6/scripts/pkg/_pkg_utl_str.tbw... Running /tibero6/scripts/pkg/_pkg_utl_http.tbw... Running /tibero6/scripts/pkg/_pkg_htp.tbw... Running /tibero6/scripts/pkg/_pkg_htf.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_assert.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_sqltune.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_errlog.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_mview.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_mview_refresh_util.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_redefinition_stats.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_session.tbw... Running /tibero6/scripts/pkg/_pkg_text.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_utl_tb.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_sql_translator.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_aq.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_aq_utl.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_aqadm.tbw... Running /tibero6/scripts/pkg/_pkg__dbms_mayo.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_mayo.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_sph.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_xplan.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_verify.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_sql_analyze.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_metadata.tbw... Check TPR status.. Stop TPR Dropping tables used in TPR... Creating auxiliary tables used in TPR... Creating packages for TPR... Running /tibero6/scripts/pkg/_pkg_dbms_tpr.tbw... Running /tibero6/scripts/pkg/_pkg_dbms_apm.tbw... Start TPR Creating spatial meta tables and views ... Creating internal system jobs... Creating internal system notice queue ... Creating agent table... Done. For details, check /tibero6/instance/tibero/log/system_init.log.
Finish the instalation
www.diarycoding.com