(5.6)
参考URL : https://weblabo.oscasierra.net/installing-mysql57-centos7-yum/
OS : CentOS7.6
DBバージョン : 5.6.42
DBパスワード : password
匿名ユーザ削除 : する
リモートrootログイン禁止 : する
テストDB削除 : する
権限テーブルリロード : する
--mariaDB削除
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
--yum リポジトリの追加
yum install -y http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm
yum info mysql-community-server
--インストール
yum install -y mysql-community-server
mysqld --version
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
初期パスワードなしのため、確認不要
※この状態ではパスワードなしでログイン可能(下記のいずれでもログインできる)
mysql -u root
mysql -u root -p
--セキュリティ設定
mysql_secure_installation
--設定ファイルによる設定
vim /etc/my.cnf
[mysqld]
character-set-server = utf8mb4
max_connections = 300
max_allowed_packet = 1M
query_cache_size = 1M
query_cache_type = 1
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
systemctl stop mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--DB接続
mysql -u root -p
(5.7)
参考URL : https://weblabo.oscasierra.net/installing-mysql57-centos7-yum/
OS : CentOS7.6
DBバージョン : 5.7.24
DBパスワード : password
匿名ユーザ削除 : する
リモートrootログイン禁止 : しない
テストDB削除 : する
権限テーブルリロード : する
--mariaDB削除
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
--yum リポジトリの追加
yum install -y http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
yum info mysql-community-server
--インストール
yum install -y mysql-community-server
mysqld --version
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
--設定ファイルによる設定
vim /etc/my.cnf
[mysqld]
character-set-server = utf8mb4
max_connections = 300
max_allowed_packet = 1M
query_cache_size = 1M
query_cache_type = 1
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
systemctl stop mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--DB接続
mysql -u root -p --show-warnings
(8.0)
参考URL : https://qiita.com/cherubim1111/items/0529910b24136e08cad4
OS : CentOS7.6
DBバージョン : 8.0.13
DBパスワード : password
匿名ユーザ削除 : する
リモートrootログイン禁止 : しない
テストDB削除 : する
権限テーブルリロード : する
--mariaDB削除
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
--yum リポジトリの追加
yum install -y https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm
yum info mysql-community-server
-- 20220325追加(公開鍵がインストールされていません のエラー対応)
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
--インストール
yum install -y mysql-community-server
mysqld --version
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
--設定ファイルによる設定
vim /etc/my.cnf
[mysqld]
character_set_server = utf8mb4
max_connections = 300
max_allowed_packet = 16M
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
systemctl stop mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--DB接続
mysql -u root -p
(8.0)
参考URL : https://qiita.com/yasushi-jp/items/1579c301075d693a2a36
OS : CentOS 8.4
DBバージョン : 8.0.27
DBパスワード : password
--mariaDB削除
dnf remove -y mariadb-libs
rm -rf /var/lib/mysql/
--yum リポジトリの追加
dnf install -y https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm
dnf repolist enabled | grep "mysql.*-community.*"
-- デフォルトのMySQLモジュールの無効化
dnf module disable mysql
--インストール
dnf info mysql-community-server
dnf install -y mysql-community-server
mysqld --version
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
--設定ファイルによる設定
vim /etc/my.cnf
[mysqld]
character_set_server = utf8mb4
max_connections = 300
max_allowed_packet = 16M
max_heap_table_size = 16M
table_open_cache = 500
sort_buffer_size = 2M
read_buffer_size = 128K
read_rnd_buffer_size = 256K
join_buffer_size = 128K
tmp_table_size = 16M
innodb_buffer_pool_size = 800M
innodb_log_file_size = 128M
innodb_log_buffer_size = 20M
systemctl stop mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--DB接続
mysql -u root -p
-------------------------------------------------
--MySQL 5.7 EEのインストール
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
--インストール
rpm -ivh mysql-commercial-client-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-common-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-devel-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-embedded-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-embedded-compat-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-embedded-devel-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-libs-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-libs-compat-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-server-5.7.24-1.1.el7.x86_64.rpm \
mysql-commercial-test-5.7.24-1.1.el7.x86_64.rpm
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
-------------------------------------------------
--MySQL 8.0 EEのインストール
yum remove -y mariadb-libs
rm -rf /var/lib/mysql/
yum -y install perl-JSON
yum install -y *openssl*
--インストール
rpm -ivh mysql-commercial-client-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-devel-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-common-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-backup-8.0.13-1.1.el7.x86_64.rpm \
mysql-router-commercial-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-test-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-server-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-libs-compat-8.0.13-1.1.el7.x86_64.rpm \
mysql-commercial-libs-8.0.13-1.1.el7.x86_64.rpm
--DB起動
systemctl enable mysqld.service
systemctl start mysqld.service
systemctl status mysqld.service
--初期パスワードの確認
cat /var/log/mysqld.log | grep password
--セキュリティ設定
mysql_secure_installation
(12cR1)
(12cR2)
OS : CentOS7.6
yum -y install \
binutils \
compat-libcap1 \
compat-libstdc++-33.i686 \
compat-libstdc++-33 \
glibc.i686 \
glibc \
glibc-devel.i686 \
glibc-devel \
ksh \
libaio.i686 \
libaio \
libaio-devel.i686 \
libaio-devel \
libgcc.i686 \
libgcc \
libstdc++.i686 \
libstdc++ \
libstdc++-devel.i686 \
libstdc++-devel \
libxcb.i686 \
libxcb \
libX11.i686 \
libX11 \
libXau.i686 \
libXau \
libXi.i686 \
libXi \
libXtst.i686 \
libXtst \
make \
net-tools \
nfs-utils \
smartmontools \
sysstat
vim /etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
sysctl -p
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
echo oracle | passwd --stdin oracle
mkdir -p /u01/app/oracle
mkdir /u01/app/oracle/oradata
mkdir /u01/app/oracle/fra
chown -R oracle:oinstall /u01
chmod -R 775 /u01
vim /etc/pam.d/login
session required pam_limits.so
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
vim /home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
umask 022
GRUB_CMDLINE_LINUXの項目に設定追記(transparent_hugepage=never)します
grub2-mkconfig -o /boot/grub2/grub.cfg
reboot
cat /sys/kernel/mm/transparent_hugepage/enabled
--oracleユーザで実行
LANG=C ./runInstaller
(18c)
OS : CentOS7.6
yum -y install \
binutils \
compat-libcap1 \
compat-libstdc++-33.i686 \
compat-libstdc++-33 \
glibc.i686 \
glibc \
glibc-devel.i686 \
glibc-devel \
ksh \
libaio.i686 \
libaio \
libaio-devel.i686 \
libaio-devel \
libgcc.i686 \
libgcc \
libstdc++.i686 \
libstdc++ \
libstdc++-devel.i686 \
libstdc++-devel \
libxcb.i686 \
libxcb \
libX11.i686 \
libX11 \
libXau.i686 \
libXau \
libXi.i686 \
libXi \
libXtst.i686 \
libXtst \
make \
net-tools \
nfs-utils \
smartmontools \
sysstat
vim /etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
sysctl -p
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
echo oracle | passwd --stdin oracle
mkdir -p /u01/app/oracle
mkdir /u01/app/oracle/oradata
mkdir /u01/app/oracle/fra
mkdir -p /u01/app/oracle/product/18.0.0/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
vim /etc/pam.d/login
session required pam_limits.so
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
vim /home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
umask 022
GRUB_CMDLINE_LINUXの項目に設定追記(transparent_hugepage=never)します
grub2-mkconfig -o /boot/grub2/grub.cfg
reboot
cat /sys/kernel/mm/transparent_hugepage/enabled
--oracleユーザで実行
unzip LINUX.X64_180000_db_home.zip -d /u01/app/oracle/product/18.0.0/dbhome_1
cd /u01/app/oracle/product/18.0.0/dbhome_1
LANG=C ./runInstaller
(19c)
-- 従来の方法
OS : CentOS7.6
yum -y install \
binutils \
compat-libcap1 \
compat-libstdc++-33.i686 \
compat-libstdc++-33 \
glibc.i686 \
glibc \
glibc-devel.i686 \
glibc-devel \
ksh \
libaio.i686 \
libaio \
libaio-devel.i686 \
libaio-devel \
libgcc.i686 \
libgcc \
libstdc++.i686 \
libstdc++ \
libstdc++-devel.i686 \
libstdc++-devel \
libxcb.i686 \
libxcb \
libX11.i686 \
libX11 \
libXau.i686 \
libXau \
libXi.i686 \
libXi \
libXtst.i686 \
libXtst \
make \
net-tools \
nfs-utils \
smartmontools \
sysstat
vim /etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
sysctl -p
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
echo oracle | passwd --stdin oracle
mkdir -p /u01/app/oracle
mkdir /u01/app/oracle/oradata
mkdir /u01/app/oracle/fra
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
vim /etc/pam.d/login
session required pam_limits.so
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
vim /home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
umask 022
GRUB_CMDLINE_LINUXの項目に設定追記(transparent_hugepage=never)します
grub2-mkconfig -o /boot/grub2/grub.cfg
reboot
cat /sys/kernel/mm/transparent_hugepage/enabled
--oracleユーザで実行
unzip LINUX.X64_193000_db_home.zip -d /u01/app/oracle/product/19.0.0/dbhome_1
cd /u01/app/oracle/product/19.0.0/dbhome_1
LANG=C ./runInstaller
---- rpmによるインストール
OS : CentOS7.6
https://qiita.com/mon_tu/items/6726524e738071afb7a7
oracle-database-ee-19c-1.0-1.x86_64.rpmをサーバにアップロード
curl -o oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
yum -y localinstall oracle-database-preinstall-19c-1.0-1.el7.x86_64.rpm
yum -y localinstall oracle-database-ee-19c-1.0-1.x86_64.rpm
(21c)
-- 従来の方法
OS : CentOS 8.4
dnf -y install \
bc \
binutils \
compat-openssl10 \
elfutils-libelf \
glibc \
glibc-devel \
ksh \
libaio \
libXrender \
libX11 \
libXau \
libXi \
libXtst \
libgcc \
libnsl \
libstdc++ \
libxcb \
libibverbs \
make \
smartmontools \
sysstat
vim /etc/sysctl.conf
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
sysctl -p
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba oracle
echo oracle | passwd --stdin oracle
mkdir -p /u01/app/oracle
mkdir /u01/app/oracle/oradata
mkdir /u01/app/oracle/fra
mkdir -p /u01/app/oracle/product/21.0.0/dbhome_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01
vim /etc/pam.d/login
session required pam_limits.so
vim /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 32768
vim /home/oracle/.bash_profile
export ORACLE_BASE=/u01/app/oracle
umask 022
GRUB_CMDLINE_LINUXの項目に設定追記(transparent_hugepage=never)します
grub2-mkconfig -o /boot/grub2/grub.cfg
reboot
cat /sys/kernel/mm/transparent_hugepage/enabled
--oracleユーザで実行
unzip LINUX.X64_213000_db_home.zip -d /u01/app/oracle/product/21.0.0/dbhome_1
cd /u01/app/oracle/product/21.0.0/dbhome_1
LANG=C ./runInstaller
---------------------------------------------
---- rpmによるインストールの場合
OS : CentOS 8.4
oracle-database-ee-21c-1.0-1.ol7.x86_64.rpmをサーバにアップロード
curl -o oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm
yum -y localinstall oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm
dnf -y localinstall oracle-database-ee-21c-1.0-1.ol8.x86_64.rpm
---------------------------------------------
(23c)
https://www.oracle.com/jp/news/announcement/oracle-database-23c-free-developer-release-2023-04-03/
https://www.oracle.com/database/free/get-started/
https://qiita.com/500InternalServerError/items/45b4dd0cfc04fb1bab5e
OS: Rocky Linux 8.4
Oracle Database 23c Free-Developer Release
Oracle Database Free supports up to:
2 CPUs for foreground processes
2GB of RAM (SGA and PGA combined)
★12GB of user data on disk (irrespective of compression factor)
wget https://yum.oracle.com/repo/OracleLinux/OL8/developer/x86_64/getPackage/oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm
wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23c-1.0-1.el8.x86_64.rpm
dnf -y localinstall oracle-database-preinstall-23c-1.0-0.5.el8.x86_64.rpm oracle-database-free-23c-1.0-1.el8.x86_64.rpm
cat /etc/sysconfig/oracle-free-23c.conf
/etc/init.d/oracle-free-23c configure
※ORACLE_SIDを変更した場合、下記エラーとなり、変更不可
[FATAL] [DBT-10334] Oracle Database FreeのOracle SID名が無効です。
処置: Oracle Database FreeのSID名はFREEとする必要があります。
mkdir /home/oracle
chown oracle: /home/oracle
su - oracle
vi ~/.bash_profile
export ORACLE_SID=FREE
export ORACLE_HOME=/opt/oracle/product/23c/dbhomeFree
export ORACLE_BASE=/opt/oracle/
export PATH=$PATH:$ORACLE_HOME/bin
export NLS_LANG=Japanese_Japan.AL32UTF8
. ~/.bash_profile
sqlplus / as sysdba
alter session set container=FREEPDB1;
select * from dba_profiles;
alter profile default limit FAILED_LOGIN_ATTEMPTS unlimited;
alter profile default limit PASSWORD_LIFE_TIME unlimited;
alter profile default limit PASSWORD_LOCK_TIME unlimited;
alter profile default limit PASSWORD_GRACE_TIME unlimited;
select * from dba_profiles;
vim $ORACLE_HOME/sqlplus/admin/glogin.sql
set lines 1000
set pages 5000
set trims on
set sqlprompt "&_connect_identifier(&_user)> "
vim ~/.bashrc
alias cdh='cd $ORACLE_HOME'
alias cdb='cd $ORACLE_BASE'
alias sql='sqlplus / as sysdba'
. ~/.bashrc
(9.4)
参考URL : https://qiita.com/uhooi/items/44ed9370740c7521dce4
OS : CentOS7.5
DBバージョン : 9.4.20
PGDATA : /var/lib/pgsql/9.4/data
--yum リポジトリの追加
yum install -y https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7-x86_64/pgdg-redhat94-9.4-3.noarch.rpm
yum info postgresql94-server postgresql94-contrib
--インストール
yum install -y postgresql94-server postgresql94-contrib postgresql94-devel postgresql94-libs
psql --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-9.4/bin/postgresql94-setup initdb
--DB起動
systemctl enable postgresql-9.4.service
systemctl start postgresql-9.4.service
systemctl status postgresql-9.4.service
--DB接続
su - postgres
psql
(9.6)
参考URL : https://qiita.com/uhooi/items/44ed9370740c7521dce4
OS : CentOS7.5
DBバージョン : 9.6.11
PGDATA : /var/lib/pgsql/9.6/data
--yum リポジトリの追加
yum install -y https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm
yum info postgresql96-server postgresql96-contrib
--インストール
yum install -y postgresql96-server postgresql96-contrib postgresql96-devel postgresql96-libs
psql --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-9.6/bin/postgresql96-setup initdb
--DB起動
systemctl enable postgresql-9.6.service
systemctl start postgresql-9.6.service
systemctl status postgresql-9.6.service
--DB接続
su - postgres
psql
(10)
参考URL : https://weblabo.oscasierra.net/postgresql10-centos7-install/
OS : CentOS7.6
DBバージョン : 10.6
PGDATA : /var/lib/pgsql/10/data
yum install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
yum info postgresql10-server
--インストール
yum -y install postgresql10-server postgresql10-contrib postgresql10-devel postgresql10-libs
/usr/pgsql-10/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-10/bin/postgresql-10-setup initdb
--DB起動
systemctl enable postgresql-10
systemctl start postgresql-10
systemctl status postgresql-10
--DB接続
su - postgres
psql
(11)
参考URL : https://qiita.com/tom-sato/items/e1903cb974fb6c6d5664
OS : CentOS7.6
DBバージョン : 11.1
PGDATA : /var/lib/pgsql/11/data
yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum info postgresql11-server
--インストール
yum install -y epel-release centos-release-scl
yum -y install postgresql11-server postgresql11-contrib postgresql11-devel postgresql11-libs
/usr/pgsql-11/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-11/bin/postgresql-11-setup initdb
--DB起動
systemctl enable postgresql-11
systemctl start postgresql-11
systemctl status postgresql-11
--DB接続
su - postgres
psql
(12)
参考URL : https://qiita.com/tom-sato/items/e1903cb974fb6c6d5664
OS : CentOS7.7
DBバージョン : 12.1
PGDATA : /var/lib/pgsql/12/data
yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum info postgresql12-server
--インストール
yum install epel-release centos-release-scl
yum -y install postgresql12-server postgresql12-contrib postgresql12-devel postgresql12-libs
/usr/pgsql-12/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-12/bin/postgresql-12-setup initdb
--DB起動
systemctl enable postgresql-12
systemctl start postgresql-12
systemctl status postgresql-12
--DB接続
su - postgres
psql
(13)
参考URL : https://mebee.info/2020/07/15/post-13465/
OS : CentOS8.2
DBバージョン : 13.0
PGDATA : /var/lib/pgsql/13/data
-- リポジトリの追加
dnf -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql
dnf info postgresql13-server
--インストール
dnf -y install postgresql13-server postgresql13-contrib postgresql13-devel postgresql13-libs
/usr/pgsql-13/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-13/bin/postgresql-13-setup initdb
--DB起動
systemctl enable postgresql-13
systemctl start postgresql-13
systemctl status postgresql-13
--DB接続
su - postgres
psql
(14)
参考URL : https://www.postgresql.org/download/
OS : CentOS8.4
DBバージョン : 14.0
PGDATA : /var/lib/pgsql/14/data
-- リポジトリの追加
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql
→鍵のインポートにかなり時間がかかる。完了するまで待つ。
dnf info postgresql14-server
--インストール
dnf -y install postgresql14-server postgresql14-contrib postgresql14-devel postgresql14-libs
/usr/pgsql-14/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-14/bin/postgresql-14-setup initdb
-- データチェックサムを有効化する場合
-- export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C --data-checksums'
-- /usr/pgsql-14/bin/postgresql-14-setup initdb
--DB起動
systemctl enable postgresql-14
systemctl start postgresql-14
systemctl status postgresql-14
--DB接続
su - postgres
psql
(15)
参考URL : https://www.postgresql.org/download/
OS : Rocky Linux 8.9
DBバージョン : 15.5
PGDATA : /var/lib/pgsql/15/data
-- リポジトリの追加
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql
→鍵のインポートにかなり時間がかかる。完了するまで待つ。
dnf info postgresql15-server
--インストール
dnf --enablerepo=powertools install -y perl-IPC-Run
dnf -y install postgresql15-server postgresql15-contrib postgresql15-devel postgresql15-libs
/usr/pgsql-15/bin/postgres --version
--DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C'
/usr/pgsql-15/bin/postgresql-15-setup initdb
-- データチェックサムを有効化する場合
-- export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C --data-checksums'
-- /usr/pgsql-15/bin/postgresql-15-setup initdb
--DB起動
systemctl enable postgresql-15
systemctl start postgresql-15
systemctl status postgresql-15
--DB接続
su - postgres
psql
(16)
参考URL : https://www.postgresql.org/download/linux/redhat/
OS : Rocky Linux 9.2
DBバージョン : 16.0
PGDATA : /var/lib/pgsql/16/data
-- リポジトリの追加
dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf -qy module disable postgresql
→鍵のインポートにかなり時間がかかる。完了するまで待つ。
dnf info postgresql16-server
-- インストール
dnf --enablerepo=crb install -y perl-IPC-Run
dnf install -y postgresql16-server postgresql16-contrib postgresql16-devel postgresql16-libs
/usr/pgsql-16/bin/postgres --version
-- DB初期化
export PGSETUP_INITDB_OPTIONS='-E UTF8 --locale=C --data-checksums'
/usr/pgsql-16/bin/postgresql-16-setup initdb
-- DB起動
systemctl enable postgresql-16
systemctl start postgresql-16
systemctl status postgresql-16
-- DB接続
su - postgres
psql
(2014)
https://www.ipentec.com/document/sql-server-2014-install
OS:Windows Server 2012R2
(2016)
https://www.ipentec.com/document/sql-server-2016-install
OS:Windows Server 2012R2
(2017)
-- Windows Server へのインストール
https://www.ipentec.com/document/sql-server-2017-install
OS:Windows Server 2012R2
-- CentOS7へのインストール
https://docs.microsoft.com/ja-jp/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017
メモリ2G以上
-- Install SQL Server
curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
/opt/mssql/bin/mssql-conf setup
systemctl status mssql-server
systemctl restart mssql-server
systemctl status mssql-server
-- Install the SQL Server command-line tools
curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo
yum install -y mssql-tools unixODBC-devel
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
-- Connect locally
sqlcmd -S localhost -U SA -P 'password'
CREATE DATABASE test
SELECT Name from sys.Databases
GO
USE test
CREATE TABLE Inventory (id INT, name NVARCHAR(50), quantity INT)
INSERT INTO Inventory VALUES (1, 'banana', 150); INSERT INTO Inventory VALUES (2, 'orange', 154);
GO
SELECT * FROM Inventory WHERE quantity > 152;
GO
(2019)
http://goodfield.jp/2019/12/sql-server-2019-%E3%82%A4%E3%83%B3%E3%82%B9%E3%83%88%E3%83%BC%E3%83%AB/
OS:Windows Server 2016
-- CentOS7へのSQL Server 2019のインストール
https://learn.microsoft.com/ja-jp/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver15
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2019.repo
sudo yum install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
systemctl status mssql-server
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/7/prod.repo
sudo yum install -y mssql-tools unixODBC-devel
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sqlcmd -S localhost -U SA -P 'password'
create database test
go
use test
create table tab1 (col1 int,col2 varchar(100) );
insert into tab1 values(1,'a');
insert into tab1 values(2,'b');
go
select * from tab1;
go
-- RL8へのSQL Server 2022のインストール
https://learn.microsoft.com/ja-jp/sql/linux/quickstart-install-connect-red-hat?view=sql-server-ver16
RHEL 8.0 から 8.6 のマシンには少なくとも 2 GB のメモリが必要です
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2022.repo
sudo dnf install -y mssql-server
sudo /opt/mssql/bin/mssql-conf setup
systemctl status mssql-server
sudo curl -o /etc/yum.repos.d/msprod.repo https://packages.microsoft.com/config/rhel/8/prod.repo
sudo dnf remove unixODBC-utf16 unixODBC-utf16-devel
sudo dnf install -y mssql-tools unixODBC-devel
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bash_profile
echo 'export PATH="$PATH:/opt/mssql-tools/bin"' >> ~/.bashrc
source ~/.bashrc
sqlcmd -S localhost -U SA -P 'password'
create database test
go
use test
create table tab1 (col1 int,col2 varchar(100) );
insert into tab1 values(1,'a');
insert into tab1 values(2,'b');
go
select * from tab1;
go
-----------------------------------------------------
コマンド プロンプトからの SQL Server のインストール
(2019)
https://docs.microsoft.com/ja-jp/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15
https://docs.microsoft.com/ja-jp/sql/database-engine/install-windows/install-sql-server-using-a-configuration-file?view=sql-server-ver15
https://docs.microsoft.com/ja-jp/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
OS:Windows Server 2022
cd c:\
notepad a.ini
[OPTIONS]
IAcceptSQLServerLicenseTerms="True"
IACCEPTPYTHONLICENSETERMS="False"
ACTION="Install"
IACCEPTROPENLICENSETERMS="False"
SUPPRESSPRIVACYSTATEMENTNOTICE="False"
ENU="False"
QUIET="True"
UpdateEnabled="False"
USEMICROSOFTUPDATE="False"
SUPPRESSPAIDEDITIONNOTICE="True"
FEATURES=SQLENGINE
HELP="False"
INDICATEPROGRESS="False"
X86="False"
INSTANCENAME="MSSQLSERVER"
INSTALLSHAREDDIR="C:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL Server"
INSTANCEID="MSSQLSERVER"
SQLTELSVCACCT="NT Service\SQLTELEMETRY"
SQLTELSVCSTARTUPTYPE="Automatic"
INSTANCEDIR="C:\Program Files\Microsoft SQL Server"
AGTSVCACCOUNT="NT Service\SQLSERVERAGENT"
AGTSVCSTARTUPTYPE="Manual"
COMMFABRICPORT="0"
COMMFABRICNETWORKLEVEL="0"
COMMFABRICENCRYPTION="0"
MATRIXCMBRICKCOMMPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
SQLMAXDOP="2"
ENABLERANU="False"
SQLCOLLATION="Japanese_CI_AS"
SQLSVCACCOUNT="NT Service\MSSQLSERVER"
SQLSVCINSTANTFILEINIT="True"
SQLSYSADMINACCOUNTS="MMM062\Administrator"
SQLTEMPDBFILECOUNT="2"
SQLTEMPDBFILESIZE="8"
SQLTEMPDBFILEGROWTH="64"
SQLTEMPDBLOGFILESIZE="8"
SQLTEMPDBLOGFILEGROWTH="64"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"
USESQLRECOMMENDEDMEMORYLIMITS="True"
setup.exe /ConfigurationFile="C:\a.ini"
-- SSMSのインストール
start "" /w .\SSMS-Setup-JPN.exe /Quiet SSMSInstallRoot=C:\SSMS