Subscribe to Posts by Email

Subscriber Count

    701

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Oracle Cloud : Installing PSM (PaaS Service Manager) CLI utility for Oracle Cloud

Hello All

In this post, we see how to install the PSM (Paas Service Manager) CLI utility to manage the cloud operations for Oracle. It has vide range of commands to manage different resources and can be useful to automate the Oracle Cloud Infrastructure operations.

The following will be covered in this post.

  1. Install Python 3.3 or later and curl
  2. Install PSM Utility (via Cloud console or using CURL)
  3. Setup PSM
  4. Execute first job & check the status
  5. Look at templates

Install Python 3.3 o later and curl

Download Python Installer from Install Python 3.3 or later from https://www.python.org/downloads/

Download Curl executable from https://curl.haxx.se/download.html (check for SSL enabled  and download)

Download PSM Utility via Cloud Console

Log into your Oracle Cloud Account --> MyServices --> Help Icon > Download Centre --> Click on Download link to download the PSM utility

PSM-1

 

PSM-2

 

 

 

Download PSM Utility via CURL

curl -X GET -u myuser321:mypassword321 -H X-ID-TENANT-NAME:MyIdentityDomain54321 https://psm.us.oraclecloud.com/paas/core/api/v1.1/cli/MyIdentityDomain54321/client -o psmcli.zip

Install PSMUtility with pip3

PSM-3

Setup PSM Utility

PSM-4

Create Sample Template for 18c Database and save as 18cdatabase.json

{
"description": "18c instance",
"edition": "SE",
"level": "PAAS",
"serviceName": "db18c-se-si",
"shape": "oc3",
"subscriptionType": "HOURLY",
"version": "18.0.0.0",
"vmPublicKeyText": "ssh-rsa AzYcAqN ....",
"parameters": [
{
"type": "db",
"usableStorage": "15",
"adminPassword": "Welcome_1",
"sid": "orcl",
"pdbName": "pdb01",
"failoverDatabase": "no",
"backupDestination": "NONE"
}
]
}

Run the PSM Utility to create service / instance or 18c Database

PSM-5

Check in cloud console for the status of the database creation

18C-Database-Status-Cloud

Using PSM Utility ex: list templates for Stacks

PSM-6

Next Post - Using PSM Utility to Manage Database Operations

  • Suresh

 

Comments are closed.