Oracle Database 12.1 EE on EC2 をサクッと作る

$ ssh -i ~/mykey.pem clckwrk@ec2-*-***-***-**.ap-northeast-1.compute.amazonaws.com
  • Oracle Database を起動する。
$ sudo su - cwdb01
$ cd scripts/
$ . DB.env
$ ./start_all.sh
The Oracle base remains unchanged with value /oracle/CWDB01
Processing Database instance "CWDB01": log file /oracle/CWDB01/product/12.1.0/startup.log
  • Oracle Database に接続する。
$ sqlplus / as sysdba

SQL*Plus: Release Production on Thu Aug 8 17:54:44 2019

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options