TimesTen Classic系统及其与Oracle的用户缓存部署（上篇）

▼▼▼
mkdir /etc/TimesTen
chmod 770 /etc/TimesTen
mkdir -p /timesten/ttuser/datads
mkdir -p /timesten/ttuser/logds
chmod 775/timesten/ttuser/datads
chmod 775 /timesten/ttuser/logds

▼▼▼
groupadd -g 10000 ttadmins
useradd -u 55000 -g ttadmins -d /timesten/ttuser -m ttuser
echo "ttuser"|passwd --stdin ttuser
chgrp -R ttadmins /etc/TimesTen
chgrp -R ttadmins /timesten/ttuser/datads
chgrp -R ttadmins /timesten/ttuser/logds

▼▼▼
hostnamectl set-hostname timesten1

▼▼▼
vi /etc/sysconfig/network-scripts/ifcfg-enp0s3

▼▼▼
[ttuser@timesten1 datads]$ cat ~/.bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
export TT_HOME=/timesten/ttuser/tt181
export LD_LIBRARY_PATH=$TT_HOME/lib
export CLASSPATH=$TT_HOME/lib/ttjdbc8.jar
export THREADS_FLAG=native
export PATH=$TT_HOME/bin:$PATH
export TMPDIR=/tmp
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
. $TT_HOME/bin/ttenv.sh

▼▼▼
[ttuser@timesten1 datads]$ cat /etc/sysctl.conf 
# sysctl settings are defined through files in
# /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/.
#
# Vendors settings live in /usr/lib/sysctl.d/.
# To override a whole file, create a new file with the same in
# /etc/sysctl.d/ and put new settings there. To override
# only specific settings, add a file with a lexically later
# name in /etc/sysctl.d/ and put new settings there.
#
# For more information, see sysctl.conf(5) and sysctl.d(5).

kernel.sem = 400 32000 100 128
net.ipv4.tcp_rmem=4096 4194304 4194304
net.ipv4.tcp_wmem=98304 4194304 4194304
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=4194304
net.ipv4.tcp_window_scaling=1
net.ipv4.ip_local_port_range=1024 65000
net.ipv4.tcp_rmem=4096 4194304 4194304
net.ipv4.tcp_wmem=98304 4194304 4194304
net.core.rmem_default=65535
net.core.wmem_default=65535
net.core.rmem_max=4194304
net.core.wmem_max=4194304
net.ipv4.tcp_window_scaling=1

▼▼▼
instanceadmin soft memlock 50331648
instanceadmin hard memlock 50331648

▼▼▼
chown ttuser:ttadmins -R tt18.1.4.5.0
  su - ttuser
  cd tt18.1.4.5.0
  ./setup.sh


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? [ tt181 ] tt181 --输入实例名，回车
  Instance name will be 'tt181'.
  Is this correct? [ yes ] 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] /timesten/ttuser
    [2] /oracle/soft_install
    [3] Specify a location
    [q] Quit the installation

  Where would you like to install the tt181 instance of TimesTen? [ 1 ] 1  --选择，回车
  Where would you like to create the daemon home directory? [ /timesten/ttuser/tt181/info ] --回车

  The daemon logs will be located in /timesten/ttuser/tt181/info
  Would you like to specify a different location for the daemon logs? [ no ] yes 
  Where would you like the daemon logs to be written? [ /timesten/ttuser/tt181/info ] /timesten/ttuser/logs
  Are you sure you want the daemon logs to be written to /timesten/ttuser/logs? [ yes ] yes
  Installing into /timesten/ttuser/tt181 ...
  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 ] no
  Please enter a unique port number for the TimesTen daemon (<CR>=list)? [ ] 53388

  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 'ttusers'? [ yes ] --回车

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

  Would you like to enable PL/SQL for this instance? [ yes ] 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)? [ ] s --输入s，回车


  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.. The installer has created links to the 4.1. library in the
      <install_dir>/lib directory and to the 4.1. 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? [ 53389 ] --回车
  Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? [ no ] --回车
  Would you like to install the documentation (without the Quick Start Sample Programs)? [ yes ] --回车
  Where would you like to create the doc directory? [/timesten/ttuser/tt181/doc ] --回车
  The TimesTen documentation has been installed in /timesten/ttuser/tt181/doc.
  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 /timesten/ttuser/tt181/bin
      ./setuproot -install
  This will move the TimesTen startup script into its appropriate location.

  The startup script is currently located here :
    '/timesten/ttuser/tt181/startup/tt_tt181'.

  The 18.1.4.5. Release Notes are located here :
    '/timesten/ttuser/tt18.1.4.5.0/README.html'

  Starting the daemon ...
  TimesTen Daemon startup OK.
  End of TimesTen installation.

▼▼▼
cd /timesten/ttuser/tt181/conf
vi sys.odbc.ini

▼▼▼
[ODBC Data Sources]
sampledb=TimesTen 18.1 Driver
#sampledbCS=TimesTen 18.1 Client Driver

[sampledb]
Driver=/timesten/ttuser/tt181/install/lib/libtten.so
DataStore=/timesten/ttuser/datads/sampledb
PermSize=512
TempSize=128
LogBufMB=256
LogFileSize=256
LogDir=/timesten/ttuser/logds/logs
DatabaseCharacterSet=AL32UTF8
OracleNetServiceName=ordb


#[sampledbCS] 
#TTC_SERVER=sampledb_CS
#TTC_SERVER_DSN=sampledb

▼▼▼
vi /timesten/ttuser/tt181/conf/tnsnames.ora
  chmod u+w $TIMESTEN_HOME/conf/tnsnames.ora

▼▼▼
ORDB =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.108)(PORT = 1521))
        (CONNECT_DATA =
          (SERVICE_NAME = pdbordb)
        )
      )

▼▼▼
Instance Info
  -------------
  
  Name: tt181
  Version: 18.1.4.1.
  Location: /timesten/ttuser/tt181/conf
  Installation: /timesten/ttuser/tt18.1.4.1.0
  Daemon Port: 6624
  Server Port: 6625
  
  Would you like to change the installation that this instance points to? [ no ]
  
  The daemon for instance 'tt181' is currently configured to use port 6624.
  Would you like to change this port? [ no ]
  The server for instance 'tt181' is currently configured to use port 6625.
  Would you like to change this port? [ no ]
  TNS_ADMIN for the instance 'tt181' is currently not set.
  Would you like to change TNS_ADMIN for this instance? [ no ] yes
  Please enter a value for TNS_ADMIN (q=quit)? [ ] /timesten/ttuser/tt181/conf
  
  Do you want to restart the daemon using the new configuration? [ yes ]
  Restarting the daemon ...
  TimesTen Daemon (PID: 6392, port: 6624) stopped.
  TimesTen Daemon (PID: 15305, port: 6624) startup OK.
  The instance 'tt181' is now configured with :
  TNS_ADMIN=/timesten/ttuser/tt181/conf
  Would you like to configure TimesTen Replication with Oracle Clusterware? [ no ]