Generating RSA-SSH Public Key, OpenSSH & PuTTY Compatible Private Keys using PuTTYgen. In a consideration of security, most of the remote SSH connectivity are now transforming to Password-less RSA Authentication. Basically in this method, authentication is being done on the basis of Private / Public key. In which, Server will have a Public Key and a Client should have corresponding Private key for authentication in order to connect to the Server. In this demonstration we’ll see how to generate Public […]
Author: Huzefa Patel
Upgrading Oracle Grid Infrastructure 12cR2 to Oracle Grid Infrastructure 18cR1 – With Little Hack (Including how you can get it). Though 18c is not yet officially available for On-Premises except for Exadata, we will going to do it with little hack, and let’s see if it works. 1. Download Oracle Grid Infrastructure 18c setup from Oracle e-Delivery. Visit Oracle Software Delivery Cloud and click on Sign In. Enter your credentials and Sign In or Create an Account if you don’t have
Migrating Oracle Database 12cR2 from On-Premises to Oracle Database 18cR1 on Oracle Cloud As we’ve already done creating Oracle Database 18cR1 on Oracle Cloud in our previous post, now we’ll be migrating our On-Premises Database to our newly created Cloud Database from version 12cR2 to 18cR1. There’re several methods of migrating On-Premises Database to Cloud Database, This is one of them in which we’ll be using expdp/impdp. So this will go like, 1. Export On-Premises Database (DEMTEST) using expdp utility. Before
Migrating On-Premises Database 12cR2 to Oracle Cloud Database 18cR1Read More »
Setting Up VNC Server On Oracle Enterprise Linux 6.7 VNC stands for Virtual Network Computing, which allows us to access GUI of our server remotely. Though we DBA does our every task by connecting to our server via SSH-TTY tunnel. However in some cases we need to have GUI access of the server to perform certain tasks, which needs a Display. We’ll just need to have VNC Client Application to access it. So in this post we’ll see how to
Setting Up VNC Server On Oracle Enterprise Linux 6.7Read More »
Getting started with (DBaaS) Oracle Database 18c on Cloud In past few months Oracle DBaaS, Oracle Cloud, Oracle Database 18c, Cloud Database and many more terms are trending in Database and IT world. Oracle DBaaS is nothing but a Database provided by Oracle as a Service (Database as a Service) in which our complete database with workloads will reside in Oracle’s cloud. And we’ll get Web based Dashboard (UI) to manage our Database Instances, backups, storage and so on. We
Oracle Database 18c on Cloud – A Complete ProcessRead More »
Installing Oracle Enterprise Linux 6.7 on Physical Standalone Server (Customized Storage Design). Being an Oracle DBA, we all must have had to install Linux in our machines to work with the Database. However most of the time we do install it in a Virtual Machine which would have been a completely different approach when coming to install it on Physical Server. And especially when it is for dedicated Database server. Here we’ll see how to install OEL on physical standalone
Installing Oracle Enterprise Linux 6.7 on Physical Standalone Server (Customized Storage)Read More »
Creating test Database with name DEMTEST manually on Oracle Database 12cR2 with Automatic Storage Management (ASM). You can create your database using GUI utility of Oracle called DBCA as well by pretty easy Next – Next wizard, However approach of creating database manually is industrial practice and the reason is that you have more control over your choices. Here we’re creating database manually but with very minimal parameters in create database script. you’ll have lots of options to fully customize your Database
Manually Database Creation on Oracle Database 12cR2 with ASMRead More »
Installation of Oracle Database 12cR2 and Oracle Grid Infrastructure 12cR2 on Oracle Enterprise Linux 6.7 (Physical Server – Not a VM). Every DBA Trainee or a Jr DBA must need to perform installation of Oracle Database on their home / test machines for practicing their DBA activities. However installation of Oracle Database is not a rocket science and pretty easy. You will find many blogs across the internet for step by step installation guide in which the demonstration will be
Oracle Database 12cR2 with ASM on Oracle Linux 6.7Read More »