Welcome to the Beyond Blog

John's Blog

This is my blog of various topics, from things that I think might be useful to others, to things that I just find interesting personally. If you have any comments or questions on any of my posts then please do ask - any positive contribution is very much welcomed.




The views expressed in this blog and completely my own and do not reflect those of Beyond Systems Ltd. All content is provided for informational purposes only, and you are solely responsible for how you use this on your own or others systems. We accept no liability for any losses or damages caused.
2 minutes reading time (376 words)

Provisioning an Oracle Database Cloud Instance - For Free!

If you haven't already started using Oracle Cloud services, then what better way than to sign up for $300 free credits for a pay-as-you-go subscription (valid for one month)? Simply visit https://cloud.oracle.com/tryit and click Sign Up. I did it earlier - it's really easy and was set up within an hour. To try it out, I provisioned myself a Standard Edition Database service - again, pretty easy. You can choose either a predefined set of options, or customise it to suit your needs (in terms of CPU's, memory, database version etc). You'll see the service in your console with a status of "Creating service...".

Creating Service

After about half an hour the service provisioning is complete. You may notice that provisioning a Database service actually gives you a couple of supporting others too - you can of course provision these standalone if required.

Services

Starting/Stopping a particular service is as easy as this:

Starting and Stopping Services

Next was to get access via SSH. To do that you will need to generate a key pair on your client machine using ssh-keygen. Then simply copy your public key up to the client.


 

SSH Key

Now all we have to do from the client is ssh This email address is being protected from spambots. You need JavaScript enabled to view it. and we have standard terminal access.

SSH Login

This means you can then access the database using your favourite command line tool. :)

sqlplus

The final thing to do is enable the port to allow external access to APEX (this is disabled by default) using these instructions.

Rule Enabled

All done!

APEX

Definitely worth a try if you have't already. You have to provide a credit card but you're assured that you won't be billed anything unless you opt to upgrade to a paid plan. If you are an enterprise looking for an Oracle database with minimal setup costs and maintenance overhead, this seems a great option.

Connecting your DBaaS Cloud Instance to your On-Pr...
Automating Oracle APEX Backups with Subversion
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Thursday, 18 October 2018

Demonstration

Request a demo of our products here

REQUEST DEMO

Contact

Beyond Systems Limited

76 King Street, Manchester

M2 4NH United Kingdom

 

 

Tel:    +44(0)8450 940 998

Email:  contact@wegobeyond.co.uk