Creating a Database and Connecting on Oracle Cloud

On this post i will show the steps in order to create an Oracle Database on Oracle Cloud and connect…

1.) Connect o Oracle Cloud, on this case a create a Trial Login, you will receive an amount to try create a lot of stuffs… it’s nice to know better the platform…

1

It’s easy when you use the Guided Journey2

You choose the Integrate, Store and Analyze Data option…

3

Here you can choose the best option… I choose the Custom in order to explore more the options…

45

Here i am no setting up the backup strategy, in another post i will explore more about that…

6

Check also here the Time Zone appropriate for your environment…7

For the SSH Key, I created my own key RSA and this will be used in “SSH Public Key” Field. I am using MobaXterm over Windows.

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/javaservice/JCS/JCS_SSH/create_sshkey.html

8

The summary for your database …

91011

You should receive an email also regarding the Creation of the Database…

12

After creation let’s connect…

13

opc is the default user for Oracle Cloud…14

Connection using sqlplus:

TNS String:
DBCLOUD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 130.61.75.175)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pdb1.svcsubnetad1.svcvcn.oraclevcn.com)
)
)

15

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s