My Tech Lab

Step 1: Download the Wallet from ATP database console. Step 2: Launch SQL Developer. Step 3: Click on File > New > Database Connection Step 4: Enter the details

I downloaded the latest version of Oracle SQL developer on my windows laptop and when I started it, the font on GUI was too small. To fix the font size scroll to the bottom of the  'Welcome Page' and uncheck 'show on startup'. Restart the SQL Developer and issue will be fixed.

You receive the following errors when trying to make new connections using SQL Developer or any other client: ORA-00018: maximum number of sessions exceeded Resolution: Login as sysdba  $ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Tue Apr 28 03:32:48 2020 Copyright (c) 1982, 2014, Oracle.   All rights reserved. Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production SQL>   Check the resource limit SQL> set lines 256 SQL> set trimout on SQL> set tab off SQL> select * from v$resource_limit; RESOURCE_NAME                   CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCATION                       LIMIT_VALUE                                   CON_ID ----------------------...

For the cloud enthusiast who wants to explore and start the journey to the Oracle Cloud, Oracle offers free version of various IaaS and PaaS services. In this post, I will discuss how to provision Autonomous Database, VM and Load Balancer on Oracle Cloud. What is Free Trial Oracle provides you with $300 of cloud credits that are valid for up to 30 days when you sign-up. You may spend these credits on any eligible Oracle Cloud Infrastructure service (OCI). After your trial ends, your account remains active. There is no interruption to the availability of the Always Free Resources you have provisioned. You can terminate and re-provision Always Free resources as needed. Paid resources that were provisioned with your credits during your free trial are reclaimed by Oracle unless you upgrade your account. What is always Free resources All OCI accounts (whether free or paid) have a set of resources that are free of charge for the...

Some of the key notes related to S3 from AWS documentation Amazon S3 has a simple web services interface that can be used to store and retrieve any amount of data, at any time, from anywhere on the web. Amazon S3 Data Consistency Model Amazon S3 provides  read-after-write consistency for PUTS of new objects  in your S3 bucket in all Regions with one caveat. The caveat is that if you make a HEAD or GET request to the key name (to find if the object exists) before creating the object, Amazon S3 provides eventual consistency for read-after-write. Amazon S3 offers  eventual consistency for overwrite PUTS and DELETES  in all Regions. Updates to a single key are atomic . For example, if you PUT to an existing key, a subsequent read might return the old data or the updated data, but it never returns corrupted or partial data. Amazon S3 achieves high availability by replicating data across multiple servers within AWS data centers. If a PUT request is successful...

Global Network of AWS Regions Availability Zones means group of Data Centers who are all interconnected to provide high availability and redundancy and are geographically in close proximity. Regions is a geographical area with 2 or more availability zones. AWS at present has: 69 Availability Zones  22 geographic regions  New regions and AZ has been announced: 9 more Availability Zones and  3 more Regions in Cape Town, Jakarta, and Milan North America The AWS Cloud in North America has 21 Availability Zones within six geographic Regions, with 44 Edge Network locations and two Regional Edge Cache locations. Edge Locations: Ashburn, VA (3);  Atlanta GA (3);  Boston, MA;  Chicago, IL (2);  Dallas/Fort Worth, TX (5);  Denver, CO (2);  Hayward, CA;  Jacksonville, FL;  Los Angeles, CA (4);  Miami, FL (3);  Minneapolis, MN;  Montreal, QC;  New York, NY (3);  Newark, N...

AWS Certified Cloud Practitioner AWS is the most used cloud platform in the world and as most of the jobs are focused on cloud based technologies it makes perfect sense to get certified on AWS cloud. The first entry level certification is called as AWS Certified Cloud Practitioner. You can find the details of various certifications on the AWS page https://aws.amazon.com/certification/certified-cloud-practitioner/ In the following blogs I will provide information on various training's and preparations required for this entry level certification. Main topics for the AWS Certified Cloud Practitioner exam are: AWS Infrastructure Compute Storage Database Cloud Migration Network Content Delivery CDN Security Identity Compliance Costing AWS Free Tier AWS has a free tier which provides access to various AWS products. You can use it to explore more than 60 products. Three different types of free offers are available depending on the product used. Check the...

If you want to learn about Git I highly recommend Pro Git book, written by Scott Chacon and Ben Straub. Online version of the book is available here  https://git-scm.com/book/en/v2 Based on the Pro Git book the article here is a quick reference of the most common Git commands mentioned in the book. All content is licensed under the  Creative Commons Attribution Non Commercial Share Alike 3.0 license . Git Repository Initializing To add a directory that is currently not under version control to Git, go to that project’s directory and initialize. This creates a new subdirectory named .git that contains repository files. $ cd /u02/git/poc/myproj1 $ git init Cloning an Existing Repository If the repository exists and you want to set up on your laptop, easiest option is to clone the whole repository. There are options to clone a single branch if you want to. $ cd /u02/git/poc/ $ git clone https://github.com/ /myproj1.git This will create a directory call...