create instance in ec2 in aws - file · web viewget the secure pair key from sysadmin...
TRANSCRIPT
![Page 1: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/1.jpg)
Create instance in EC2 in AWS using AMIURL: http://aws.amazon.com/amis/oracle/
Launch Oracle 11.2.0.1 AMI Image.
![Page 2: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/2.jpg)
![Page 3: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/3.jpg)
![Page 4: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/4.jpg)
![Page 5: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/5.jpg)
![Page 6: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/6.jpg)
--Connect to AWS using Putty
Configure the Auth with Private key for Putty.
Get the secure pair key from Sysadmin - WEB_AWS.ppk
Host: ec2-52-4-239-87.compute-1.amazonaws.com (10.0.10.141)
![Page 7: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/7.jpg)
![Page 8: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/8.jpg)
--Connect using VNC to AWS
--sysadmin to install VNC server pkg and install
--Start VNCserver
Have them open 5900, 5901 and 5902 in security group in AWS.
--------Sftp to AWS from local machine ------
Copy the ppk file on to your C:driveDownload psftp program on c: drive
C:\>psftp -i C:\WEB_AWS.ppk [email protected] username "root"Remote working directory is /rootpsftp>
--------Sftp to AWS from rhdb04server
download the TPC_WEB.pem on /home/oracle on rhdb04
chmod 400 TPC_WEB.pem
[oracle@rhdb04 ~]$ pwd/home/oracle
[oracle@rhdb04 ~]$ ls -ltr *.pem-r-------- 1 oracle oinstall 1692 Jun 9 10:43 TPC_WEB.pem
[oracle@rhdb04 ~]$ sftp -oIdentityFile=TPC_WEB.pem [email protected]
[oracle@rhdb04 ~]$ sftp -oIdentityFile=TPC_WEB.pem [email protected]
--test ssh to AWS
[oracle@rhdb04 ~]$ ssh -i TPC_WEB.pem [email protected]
--test sftp to AWSoracle@rhdb04 ~]sftp -oIdentityFile=TPC_WEB.pem [email protected]
![Page 9: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/9.jpg)
--Create Database on AWS
Login to root on AWS
![Page 10: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/10.jpg)
Note: we mounted /dev/sde1 is EBS storage of 1TB
![Page 11: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/11.jpg)
![Page 12: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/12.jpg)
![Page 13: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/13.jpg)
![Page 14: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/14.jpg)
Got an error stating no disk found.
![Page 15: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/15.jpg)
-------Invoking DBCA to create DB.
![Page 16: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/16.jpg)
![Page 17: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/17.jpg)
![Page 18: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/18.jpg)
![Page 19: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/19.jpg)
![Page 20: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/20.jpg)
Pw= dbasupport
![Page 21: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/21.jpg)
![Page 22: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/22.jpg)
![Page 23: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/23.jpg)
![Page 24: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/24.jpg)
![Page 25: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/25.jpg)
![Page 26: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/26.jpg)
![Page 27: Create instance in EC2 in AWS - file · Web viewGet the secure pair key from Sysadmin - WEB_AWS.ppk](https://reader034.vdocuments.us/reader034/viewer/2022042707/5a7199357f8b9a93538d162d/html5/thumbnails/27.jpg)
TNS:
TPCDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.0.10.14)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TPCDB)
)
)