Oracle安装部署之 timesten install on redhat6.5

原创

wcwen1990 2021-08-06 16:16:35 博主文章分类：Oracle ©著作权

文章标签 oracle安装部署原创文章 linux oracle bash 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者wcwen1990的原创作品，请联系作者获取转载授权，否则将追究法律责任

一、安装前检查

[root@localhost ~]# cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.5 (Santiago)

[root@localhost ~]# uname -a

Linux localhost.localdomain 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

[root@localhost ~]# lsb_release -id

Distributor ID: RedHatEnterpriseServer

Description: Red Hat Enterprise Linux Server release 6.5 (Santiago)

[root@localhost ~]# uname -i -p

x86_64 x86_64

[root@localhost ~]# free -m

total used free shared buffers cached

Mem: 7873 1262 6611 0 47 622

-/+ buffers/cache: 592 7281

Swap: 10439 0 10439

[root@localhost ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda3 88G 42G 42G 50% /

tmpfs 3.9G 72K 3.9G 1% /dev/shm

/dev/sda1 1008M 62M 895M 7% /boot

/dev/sdb1 197G 15G 172G 9% /data

[root@localhost ~]#

二、内核参数（物理机8g内存）

cp /etc/sysctl.conf /etc/sysctl.conf.bak

echo "fs.aio-max-nr = 1048576" >> /etc/sysctl.conf

echo "fs.file-max = 6815744" >> /etc/sysctl.conf

echo "kernel.shmall = 8388608" >> /etc/sysctl.conf --系统可分配贡献内存页的最大大小

echo "kernel.shmmax = 8388608" >> /etc/sysctl.conf --linux系统上贡献内存段最大大小

echo "kernel.shmmni = 4096" >> /etc/sysctl.conf

echo "kernel.sem = 250 32000 100 128" >> /etc/sysctl.conf

echo "net.ipv4.ip_local_port_range = 1024 65500" >> /etc/sysctl.conf

echo "net.core.rmem_default = 262144" >> /etc/sysctl.conf

echo "net.core.rmem_max = 4194304" >> /etc/sysctl.conf

echo "net.core.wmem_default = 262144" >> /etc/sysctl.conf

echo "net.core.wmem_max = 4194304" >> /etc/sysctl.conf

echo "net.ipv4.tcp_window_scanling=1 >>/etc/sysctl.conf"

echo "net.ipv4.tcp_wmem = 262144 262144 262144" >> /etc/sysctl.conf

echo "net.ipv4.tcp_rmem = 4194304 4194304 4194304" >> /etc/sysctl.conf

echo "net.ipv4.tcp_mem= 98304 4194304 4194304" >> /etc/sysctl.conf

sysctl -p

三、依赖软件包：oracle数据库基本软件包

[root@localhost ~]# rpm -qa|grep compat-libstdc++

compat-libstdc++-296-2.96-144.el6.i686

compat-libstdc++-33-3.2.3-69.el6.x86_64

[root@localhost ~]# rpm -qa|grep libaio-devel

libaio-devel-0.3.105-2.x86_64

[root@localhost ~]# rpm -qa|grep unixODBC-devel

[root@localhost ~]# rpm -qa|grep libXp-devel

libXp-devel-1.0.0-15.1.el6.x86_64

[root@localhost ~]#

四、开始安装：timesten11版本的安装和oracle11g对系统的要求几乎一致，但要注意/tmp目录大小

1、建立用户：

[root@localhost ~]# useradd ttadmin -g oinstall -G dba

[root@localhost ~]# passwd ttadmin

2、建立存放tt已安装实例的配置信息目录：

[root@localhost ~]# mkdir /etc/TimesTen

[root@localhost ~]# chown -R ttadmin:oinstall /etc/TimesTen/

3、建立tt的安装目录：

[root@localhost ~]# mkdir /opt/TimesTen

[root@localhost ~]# chown -R ttadmin:oinstall /opt/TimesTen/

4、上传timesten软件并解压

略

5、安装timesten软件

[ttadmin@localhost TimesTen]$ cd /mnt/linux8664/

[ttadmin@localhost linux8664]$ ll

total 420

drwxr-xr-x. 2 root 900 4096 Jan 20 2015 3rdparty

drwxrwxrwx. 2 root 900 4096 Jan 20 2015 doc

-rwxr-xr-x. 1 root root 256471 Jan 20 2015 install.pl

drwxr-xr-x. 2 root 900 4096 Jan 20 2015 LINUX8664

-rwxr--r--. 1 root root 114161 Jan 20 2015 README.html

-rwxr-xr-x. 1 root root 5759 Jan 20 2015 setup.sh

-rwxr-xr-x. 1 root root 34886 Jan 20 2015 uninst.sh

[ttadmin@localhost linux8664]$ ./setup.sh -install

NOTE: Each TimesTen installation is identified by a unique instance name.

The instance name must be a non-null alphanumeric string, not longer

than 255 characters.

Please choose an instance name for this installation? [ tt1122 ]

Instance name will be 'tt1122'.

Is this correct? [ yes ]

Of the three components:

[1] Client/Server and Data Manager

[2] Data Manager Only

[3] Client Only

Which would you like to install? [ 1 ]

Of the following options :

[1] /home/ttadmin

[2] /mnt

[3] Specify a location

[q] Quit the installation

Where would you like to install the tt1122 instance of TimesTen? [ 1 ] 3

Please specify a directory to install TimesTen? [ /home/ttadmin ] /opt/TimesTen

Where would you like to create the daemon home directory? [ /opt/TimesTen/tt1122/info ]

The daemon logs will be located in /opt/TimesTen/tt1122/info

Would you like to specify a different location for the daemon logs? [ no ]

Installing into /opt/TimesTen/tt1122 ...

Uncompressing ...

NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the

daemon port number must be the same across all TimesTen installations

managed within the same Oracle Clusterware cluster.

NOTE: All installations that replicate to each other must use the same daemon

port number that is set at installation time. The daemon port number can

be verified by running 'ttVersion'.

The default port number is 53396.

Do you want to use the default port number for the TimesTen daemon? [ yes ]

The daemon will run on the default port number (53396).

NOTE: For security, we recommend that you restrict access to the

TimesTen installation to members of a single OS group. Only members of

that OS group will be allowed to perform direct mode connections to

TimesTen, and only members of that OS group will be allowed to perform

operations that access TimesTen data stores, TimesTen files and shared

memory. The OS group defaults to the primary group of the instance

administrator. You can default to this group, choose another OS group

or you can make this instance world-accessible. If you choose to make

this instance world-accessible, all database files and shared memory

are readable and writable by all users.

Restrict access to the the TimesTen installation to the group 'oinstall'? [ yes ]

NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.

Would you like to enable PL/SQL for this instance? [ yes ]

In order to use the 'Oracle TimesTen Application-Tier Database Cache' feature in any databases

created within this installation, you must set a value for the TNS_ADMIN

environment variable. It can be left blank, and a value can be supplied later

using <install_dir>/bin/ttModInstall.

Please enter a value for TNS_ADMIN (s=skip)? [ ] /opt/TimesTen/network/admin

/opt/TimesTen/network/admin is not a readable directory, use it anyway ? [ no ] yes

TNS_ADMIN will be set to /opt/TimesTen/network/admin

You can change TNS_ADMIN later by running <install_dir>/bin/ttmodinstall.

NOTE: It appears that you are running version 4 or higher of the g++

compiler. TimesTen ships with multiple sets of client libraries and server

binaries : one built for compatibility with g++ 3.4.6 and one with

g++ 4.1.0. The installer has created links to the 4.1.0 library in the

<install_dir>/lib directory and to the 4.1.0 server binary in the

<install_dir>/bin directory. If you want to use a different compiler,

please modify the links to point to the desired library and server binary.

Installing server components ...

What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53397 ]

Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? [ no ] yes

Where would you like to install the Quick Start and doc directories (s=skip)? [ /opt/TimesTen/tt1122 ]

The TimesTen documentation has been installed in /opt/TimesTen/tt1122.

The TimesTen Quick Start applications can take up to 64 Mbytes of disk space.

Depending on how your system is configured, you may not want to create the

Quick Start DemoDataStore directory in the default location,

/opt/TimesTen/tt1122/info/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /opt/TimesTen/tt1122/info ]

Creating /opt/TimesTen/tt1122/info/DemoDataStore ...

Installing client components ...

Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]

NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.

Run the 'setuproot' script :

cd /opt/TimesTen/tt1122/bin

./setuproot -install

This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :

'/opt/TimesTen/tt1122/startup/tt_tt1122'.

The Quickstart home page can be accessed here :

'/opt/TimesTen/tt1122/quickstart/index.html'

The 11.2.2.8 Release Notes are located here :

'/opt/TimesTen/tt1122/README.html'

Starting the daemon ...

TimesTen Daemon startup OK.

End of TimesTen installation.

[ttadmin@localhost linux8664]$

6、设置ttadmin环境变量

[ttadmin@localhost ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

export TT_HOME=/opt/TimesTen/tt1122/

PATH=$TT_HOME/bin:$PATH:$HOME/bin

export PATH

五、启动与关闭

1、查看进程：

[ttadmin@localhost ~]$ ps -ef|grep timesten

ttadmin 870 1 0 13:46 ? 00:00:00 /opt/TimesTen/tt1122/bin/timestend -initfd 13

ttadmin 874 870 0 13:46 ? 00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000000 -facility user

ttadmin 875 870 0 13:46 ? 00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000001 -facility user

ttadmin 876 870 0 13:46 ? 00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000002 -facility user

ttadmin 877 870 0 13:46 ? 00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000003 -facility user

ttadmin 942 19878 0 13:49 pts/0 00:00:00 grep timesten

[ttadmin@localhost ~]$

2、查看timesten的运行状态

[ttadmin@localhost ~]$ ttstatus

TimesTen status report as of Mon Jun 6 13:50:11 2016

Daemon pid 870 port 53396 instance tt1122

TimesTen server pid 879 started on port 53397

------------------------------------------------------------------------

Accessible by group oinstall

End of report

[ttadmin@localhost ~]$

3、手工启动、关闭timesten

[ttadmin@localhost ~]$ ttdaemonadmin -h

Usage:

ttDaemonAdmin [-h | -help | -?]

ttDaemonAdmin [-V | -version]

ttDaemonAdmin [-force] {-start | -stop | -restart}

ttDaemonAdmin -startserver

ttDaemonAdmin [-force] {-stopserver|-restartserver}

ttDaemonAdmin -verbose

options:

-h | -help | -? Prints this message and exits.

-V | -version Prints the release number and exits.

-start Starts the TimesTen daemon.

-stop Stops the TimesTen daemon.

-restart Restarts the TimesTen daemon.

-startserver Starts the TimesTen Server.

-stopserver Stops the TimesTen Server.

-restartserver Restarts the TimesTen Server.

-force With -start, starts the daemon even

if a PID file exists. With -stop,

kills the process indicated by the

PID file even if ttDaemonAdmin cannot

communicate with the daemon.

When used with -stopserver, client/server

connections to TimesTen databases are

forcefully and immediately terminated,

then the TimesTen Server exits.

[ttadmin@localhost ~]$ ttdaemonadmin -stop

TimesTen Daemon stopped.

[ttadmin@localhost ~]$ ttdaemonadmin -start

TimesTen Daemon startup OK.

[ttadmin@localhost ~]$

4、重启系统自动启动设置

[root@localhost bin]# pwd

/opt/TimesTen/tt1122/bin

[root@localhost bin]# ./setuproot -install

$* is no longer supported at ./setuproot line 260.

Would you like to install the TimesTen daemon startup scripts into /etc/init.d? [ yes ]

Copying /opt/TimesTen/tt1122/startup/tt_tt1122 to /etc/init.d

Successfully installed the following scripts :

/etc/init.d/tt_tt1122

/etc/rc.d/rc0.d/K45tt_tt1122

/etc/rc.d/rc1.d/K45tt_tt1122

/etc/rc.d/rc2.d/S90tt_tt1122

/etc/rc.d/rc3.d/S90tt_tt1122

/etc/rc.d/rc5.d/S90tt_tt1122

/etc/rc.d/rc6.d/K45tt_tt1122

六、卸载timesten

$TT_HOME/bin/ttdeamonadmin -stop

$TT_HOME/BIN/setup.sh -uninstall

或手工删除

rm -rf $TT_HOME/

vim /etc/TimesTen/instance_info (去掉需要删除的实例部分或直接删除该文件)

上一篇：Oracle管理监控之使用utl_mail自动邮件报警配置

下一篇：Oracle AWR 之通过dbms_workload_repository.awr_report_text(html)函数在客户端生成AWR报告

提问和评论都可以，用心的回复会被更多人看到评论

发布评论

相关文章

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯