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 で復活

grav cms News Feed Error

grav 1.x の admin panel を表示すると News Feed が空白で、

Invalid SSL certificate caused by CURL error number 60

が表示される。


cacert.pem をダウンロード

php.ini に以下を追加する。

[curl]
curl.cainfo = "[path_to]cacert.pem"

Excel の Drop Down を削除

'ドロップダウンの削除。
Sub IMAGE_DELETE_DropDown()

Dim MyOb As Object
With ActiveSheet

'とりあえず図形はすべて対象にしておいて…。
For Each MyOb In .Shapes

'Drop Down のみを処理対象とする。
'(この if がないと、全 Shape が対象。)
If MyOb.Type = 8 Then

'図形を削除する。
MyOb.Delete

End If

Next

End With
Set MyR = Nothing

End Sub

http://hinden.at.webry.info/201105/article_25.html

Enterprise Mode Site List Manager for Windows 10

https://www.microsoft.com/en-us/download/details.aspx?id=49974

Ubuntu, VMWare tools

export LANG=C
sudo apt-get update
sudo apt-get upgrade
sudo vi /etc/init/control-alt-delete.conf
Home > Compatibility Guides > Guest Operating System Installation Guide > Ubuntu 14.04 LTS

https://partnerweb.vmware.com/GOSIG/Ubuntu_14_04_LTS.html#Tools

Linux 仮想マシンへの deployPkg プラグインのインストール (2075742)
http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2075742

curl -O https://packages.vmware.com/tools/keys/VMWARE-PACKAGING-GPG-DSA-KEY.pub
curl -O https://packages.vmware.com/tools/keys/VMWARE-PACKAGING-GPG-RSA-KEY.pub
sudo apt-key add VMWARE-PACKAGING-GPG-DSA-KEY.pub
sudo apt-key add VMWARE-PACKAGING-GPG-RSA-KEY.pub
sudo vi /etc/apt/sources.list.d/vmware-tools.list
 deb http://packages.vmware.com/packages/ubuntu precise main

sudo apt-get update
sudo apt-get install open-vm-tools-deploypkg

sudo apt-get install unbound
sudo apt-get install ldnsutils

cd /etc/unbound/unbound.conf.d/
sudo /usr/sbin/unbound-checkconf