Site Reiability Engineering

Site Reliability Engineering

Install Oracle database 12c R1 CentOS 7.3

Server with GUI

Compatibility Libraries

Development Tools 

$ LANG=C xdg-user-dirs-gtk-update

$ cd /etc/yum.repos.d

$ sudo wget http://public-yum.oracle.com/public-yum-ol7.repo

https://docs.oracle.com/cd/E52668_01/E39381/html/ol_import_gpg.html

$ cd /etc/pki/rpm-gpg

$ sudo wget http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol7

$ gpg --quiet --with-fingerprint ./RPM-GPG-KEY-oracle-ol7

$ sudo rpm --import ./RPM-GPG-KEY-oracle-ol7

$ sudo LANG=C yum install oracle-rdbms-server-12cR1-preinstall

$ sudo yum update

$ sudo passwd oracle

$ sudo mkdir -p /u01/app/oracle

$ sudo chown -R oracle:oinstall /u01/app

$ sudo chmod -R 775 /u01/app/oracle

login as oracle 

$ LANG=C database/runInstaller

login as root

# /u01/app/oraInventory/orainstRoot.sh

# /u01/app/oracle/product/12.1.0/dbhome_1/root.sh

~oracle/.bash_profile

umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export LANG=ja_JP.UTF
export NLS_LANG=Japanese_Japan.AL32UTF8 

https://get.adobe.com/jp/flashplayer/otherversions/

$ sudo yum localinstall adobe-release-x86_64-1.0-1.noarch.rpm

$ sudo yum install flash-plugin

http://www.oracle.com/technetwork/jp/database/enterprise-edition/documentation/db121linux-x64-ja-v10-1984264-ja.pdf

$ cat /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
       (SERVICE_NAME = orcl.localhost)
    )
  )

PDBORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
       (SERVICE_NAME = PDBORCL.localhost)
    )
  )



EM Express 起動

$ sqlplus / as sysdba
SQL> exec dbms_xdb_config.sethttpsport(5500);

Windows 10 Edge や Windows ストアに接続できない

Edgeで接続しようとすると常にこのページは表示できません
Windows ストアも 0x80072F7D になる

wsreset.exe で復活