▼▼▼
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
更改:
BOOTPROTO=static
添加:
IPADDR=192.168.56.108
NETMASK=255.255.255.0
1) 配置環境變量ttuser:
▼▼▼
[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
vi /etc/security/limits.conf
添加:
▼▼▼
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 (=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/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.0. The installer has created links to the 4.1.0 library in the
/lib directory and to the 4.1.0 server binary in the
/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.0 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)
)
)
執行:ttinstancemodify
▼▼▼
Instance Info
-------------
Name: tt181
Version: 18.1.4.1.0
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 ]
更多精彩干貨分享
點擊下方名片關注
IT那活兒
文章版權歸作者所有,未經允許請勿轉載,若此文章存在違規行為,您可以聯系管理員刪除。
轉載請注明本文地址:http://specialneedsforspecialkids.com/yun/129920.html
摘要:大勢所趨,云原生數據庫的崛起不過,在全球數據庫領域,目前恐怕還不止這兩股力量。在年數據庫系統的魔力象限中,阿里云數據庫被列入遠見者象限,這是國產數據庫首次進入魔力象限。從傳統數據庫到云原生數據庫,這50年來,數據庫行業到底都發生了怎樣的變化?以Oracle為代表的傳統數據庫廠商,不斷邁向云化的過程,從中嘗到了甜頭。不僅可以讓用戶Oracle數據庫遷移到Oracle云上,順帶也把用戶業務帶上O...
摘要:和聯合總裁及董事會成員將在下周宣布更多的戰略。曾在去年月的大會上宣布了公共云計劃,其中包含了和的相關功能,以及云服務和數據庫云服務。目前已經表示將會把和整合進自身的公有云之中。但截至到目前,這些組件仍然處在預覽階段。 在當前的云計算時代,PaaS領域已經成為各大巨頭必爭之地。PaaS提供應用服務引擎,用戶基于該應用服務引擎可構建該類的應用,典型的案例有Google App Engine、...
摘要:甲骨文的一名代表拒絕證實裁員消息的細節,但表示公司將繼續尋求平衡資源,并圍繞其云產品以重組我們的開發團隊。甲骨文并不是今年唯一一家裁員的主要云軟件供應商。被甲骨文稱為基于的最初。自年發布第二代稱為,以來,甲骨文基本上已經淘汰了。過去一周,不少社交媒體和論壇上的許多帖子都提到了甲骨文(Oracle)裁員的事情,這些人聲稱自己被甲骨文解雇了,或者了解其他人被甲骨文解雇的事情。目前,該裁員風波波及...
摘要:方法也可以接收一個參數表示數據請求著請求的數據大小,但是可讀流可以根據需要忽略這個參數。讀取數據大部分情況下我們只要簡單的使用方法將可讀流的數據重定向到另外形式的流,但是在某些情況下也許直接從可讀流中讀取數據更有用。 介紹本文介紹了使用 node.js streams 開發程序的基本方法。 We should have some ways of connecting programs ...
閱讀 1346·2023-01-11 13:20
閱讀 1684·2023-01-11 13:20
閱讀 1132·2023-01-11 13:20
閱讀 1858·2023-01-11 13:20
閱讀 4100·2023-01-11 13:20
閱讀 2704·2023-01-11 13:20
閱讀 1385·2023-01-11 13:20
閱讀 3595·2023-01-11 13:20