{"id":3293,"date":"2018-02-28T08:42:22","date_gmt":"2018-02-28T11:42:22","guid":{"rendered":"http:\/\/www.dbarj.com.br\/2018\/02\/creating-oracle-18c-database-in-oci-classic\/"},"modified":"2018-02-28T08:42:22","modified_gmt":"2018-02-28T11:42:22","slug":"creating-oracle-18c-database-in-oci-classic","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/pt-br\/2018\/02\/creating-oracle-18c-database-in-oci-classic\/","title":{"rendered":"Creating Oracle 18c Database in OCI Classic"},"content":{"rendered":"

In this article, I will show you in details how to create the new released 18c Oracle Database on Oracle Cloud Infrastructure Classic<\/strong>.<\/p>\n

1. Creating Trial Account<\/h3>\n

Go to cloud.oracle.com<\/a> and click on right up corner in “Try for Free<\/strong>“. In the new opened page, click on “Create a Free Account<\/strong>“.<\/p>\n

In this page you need to fill all your personal information, including credit card and accept the terms and conditions. Don’t worry about inserting your credit card there, you won’t be charged unless you explicit upgrade your account later. Some very small fees (like US$ 1) will be done and refunded just to check if the credit card is valid.<\/p>\n

After you fill all the form and press “Complete<\/strong>“, some minutes later you will receive an email with your credits, username, temporary password and cloud account name:<\/p>\n

\"\"<\/p>\n

In Brazil we receive 900 BRL (our currency) in credits.<\/p>\n

Now log in your cloud clicking on “Get Started with\u00a0Oracle<\/span>\u00a0Cloud<\/span><\/strong>” in the email you received. Change your temporary password, and now is time to play. =]<\/p>\n

2. Getting PSM<\/h3>\n

When your account is all set, let’s start the pre-reqs to create the 18c DB instance.<\/p>\n

\"\"<\/p>\n

Click on Create Instance<\/strong>\u00a0in your main dashboard. Then go to All Services<\/strong> tab and search for “database<\/strong>“.<\/p>\n

Click Create<\/strong> for normal<\/span> Database, not OCI (normal means Classic in this context). After you are redirected to a new window, click in Custom<\/strong> to personalize your DB.<\/p>\n

Note that on the time I’m writing this article (Feb\/2018), there is still no option to create a 18c via cloud interface:<\/p>\n

\"\"<\/p>\n

So we need to use another approach, like REST calls or PSM. For this article we are using PSM which is easier to use. The official doc for it is described at:<\/p>\n

https:\/\/docs.oracle.com\/en\/cloud\/paas\/java-cloud\/pscli\/abouit-paas-service-manager-command-line-interface.html<\/a><\/p>\n

To download the PSM tool, click on the\u00a0Downloading the Command Line Interface<\/strong>\u00a0link in above URL and follow the instructions. In my case, I used REST API to get it:<\/p>\n

[root@myserver ~]# curl -X GET -u myemail@gmail.com:MyPass.123 \\\r\n-H X-ID-TENANT-NAME:idcs-172740ebxxxxxxxxxxxxxxxxxxxxxxx \\\r\nhttps:\/\/psm.us.oraclecloud.com\/paas\/core\/api\/v1.1\/cli\/idcs-172740ebxxxxxxxxxxxxxxxxxxxxxxx\/client \\\r\n-o psmcli.zip\r\n  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current\r\n                                 Dload  Upload   Total   Spent    Left  Speed\r\n100 80689    0 80689    0     0  45046      0 --:--:--  0:00:01 --:--:-- 45052\r\n[root@myserver ~]# ls -lah psmcli.zip \r\n-rw-r--r--. 1 root root 79K Feb 27 17:21 psmcli.zip\r\n[root@myserver ~]#\r\n<\/pre>\n
You need to have curl, and also your password may not have special characters that can be misinterpreted by your shell (like $). To find out what your identity domain name\u00a0<\/strong>is, just open your\u00a0Oracle Identity Cloud Service<\/strong> in your Dashboard and check your\u00a0Identity Service<\/strong> Id. It starts with “idcs-<\/strong>“:<\/p>\n
\"\"<\/p>\n
With PSM downloaded, next step is to install and configure it.<\/p>\n
I won’t go into details about the pre-reqs for installing it, like python3 requirement. If you don’t have it in your system, I recommend to download, configure, make and install it. Don’t forget openssl-devel package dependency to avoid problems with pip3. Take a look in this articles if you need help with python3:<\/p>\n