Monday, July 27, 2020

Top Oracle Books

I will recommend you use multiple sources to teach yourself. One good reason for this is, that there is never a single book that speaks to a reader exactly how the reader wishes it to, consistently covering every topic of interest. So when one book doesn’t seem to hit the mark with you effectively, it is always nice to go and read another book to get a different treatment of the same topic. That said, there are a TON of books out there on Oracle.

 I think this is one of the best books that covers everything about the database that I believe is fundamental, the approach to the topics, i.e how to understand the Oracle database, will leave you with the knowledge that will consistently appeal to you as relevant, as you grow into more senior roles.
Then, definitely read the Oracle manuals. In fact, you should perhaps read the Oracle manuals, especially the “Concepts” manual to get a good end to end broad coverage of what is out there in the Oracle database world.

1. Oracle Database 11g DBA Handbook
2  SQL and PL/SQL for Oracle 10g Black Book
3. Oracle Database 10g DBA Handbook

Thursday, July 23, 2020

Oracle Database Installation Through DBCA

1. Open The Terminal 

2. Write Command "dbca"

3. Now Follow The Further Steps By this Video :-

4 . For Further Study Visit O this Website : - Click Here

Oracle Instance Installation

For Installation Follows These steps given in Video :-
1) Download The Software both Zip File .
     To Download 1st Zip File :- Click Here
      To Download 2nd Zip File :- Click Here
2. Extract Both File
    ]$ Unzip “File Name”
3. Go to Database Folder(In Extracted Folder)

    ]$ cd database  
    ]$ ./runInstaller
4. Now Follow These Steps which is given In Video

   To Know More click Here

Oracle Installation

For Installation Follow these steps which are given in video:--

To Download File Click Here

1. login with root user and set kernel parameter in /etc/sysctl.conf
  echo kernel.shmall = 2097152 >> /etc/sysctl.conf
  echo kernel.shmmax = 536870912 >> /etc/sysctl.conf
  echo kernel.shmmni = 4096 >> /etc/sysctl.conf
  echo # semaphores: semmsl, semmns, semopm, semmni >>                /etc/sysctl.conf
  echo kernel.sem = 250 32000 100 128 >> /etc/sysctl.conf
  echo fs.file-max = 65536 >> /etc/sysctl.conf
  echo net.ipv4.ip_local_port_range = 9000 65000 >> /etc/sysctl.conf
  echo net.core.rmem_default=262144 >> /etc/sysctl.conf
  echo net.core.rmem_max=4194304 >> /etc/sysctl.conf
  echo net.core.wmem_default=262144 >> /etc/sysctl.conf
  echo net.core.wmem_max=1048586 >> /etc/sysctl.conf
  echo fs.file-max = 6815744 >> /etc/sysctl.conf
  echo net.ipv4.ip_local_port_range = 9000 65500 >> /etc/sysctl.conf
  echo net.core.wmem_max = 1048576 >> /etc/sysctl.conf
  echo fs.aio-max-nr = 1048576 >> /etc/sysctl.conf

2. Activate the kernel settings

   sysctl -p


   groupadd oinstall
   groupadd dba
   groupadd oper
   groupadd asmdba
   groupadd asmadmin
   useradd -g oinstall -G dba,oper,asmadmin,asmdba oracle
   echo oracle|passwd --stdin oracle


   mkdir  /u01
   chown -R oracle:oinstall /u01
   chmod -R 775 /u01

5. Insert line in /etc/pam.d/login

 echo session    required     /lib/security/ >>     /etc/pam.d/login

6. Insert line in /etc/security/limits.conf
  echo oracle soft nproc 2047 >> /etc/security/limits.conf
  echo oracle hard nproc 16384 >> /etc/security/limits.conf
  echo oracle soft nofile 1024 >> /etc/security/limits.conf
  echo oracle hard nofile 65536 >> /etc/security/limits.conf
  Disable secure linux by editing the /etc/selinux/config file and    reboot the system.

7 .To open the file: vi /etc/selinux/config


8. Install linux RPM:
yum -y install binutils-2.* compat-libstdc33* compat-libstdc33* elfutils-libelf* gcc-4.* gcc-c4.* glibc-2.* glibc-common-2.* glibc-devel-2.* glibc-headers-2.* ksh* libaio-0.* libaio-devel-0.* libgomp-4.* libgcc-4.* libstdc4.* libstdcdevel-4.* make-3.* sysstat-7.* unixODBC-2.* unixODBC-devel-2.* numactl-devel-*

Copy Oracle Setup Directory In Oracle's Home Directory or You Can Paste Anyware.Go to that Setup Directory By Using CD Command And Unzip the files one by one. this will create a database directory.

]$ cd database
]$ ./runInstaller

About Oracle And Architecture

Oracle Database has several structural features that make it popular:
  • Logical data structure – Oracle uses the logical data structure to store data so that you can interact with the database without knowing where the data is stored physically.
  • Partitioning – is a high-performance feature that allows you to divide a large table into different pieces and store each piece across storage devices.
  • Memory caching – the memory caching architecture allows you to scale up a very large database that still can perform at a high speed.
  • Data Dictionary is a set of internal tables and views that support administer Oracle Database more effectively.
  • Backup and recovery – ensure the integrity of the data in case of system failure. Oracle includes a powerful tool called Recovery Manager (RMAN) – allows DBA to perform cold, hot, and incremental database backups and point-in-time recoveries.
  • Clustering – Oracle Real Application Clusters (RAC) – Oracle enables high availability that enables the system is up and running without interruption of services in case one or more server in a cluster fails
  • Oracle Database Architecture

    An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.
    Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

Why Oracle

Most companies aern't interested in databases. They're interested in informationation that applications can give them to serve their business needs.
Most business applications in the past were written against Oracle (some against other DBs, like DB2/Informix/Sybase) because in the past open source database solutions AND computer hardware hadn't matured enough to make open source solutions practicle for databases whose loss could destroy the company.
Because different database systems have different - often not compatible - sometimes not even comparible feature sets, applications were often coded against specific database solutions rather than general SQL or least-common denominator solutions.

How to write a blog

1. Understand your audience.

Before you start writing your blog post, make sure you have a clear understanding of your target audience.

Ask questions like: What do they want to know about? And, what will resonate with them?

This is where creating your buyer personas comes in handy. Consider what you know about your buyer personas and their interests while you're coming up with a topic for your blog post.

For instance, if your readers are millennials looking to start a business, you probably don't need to provide them with information about getting started in social media — most of them already have that down.

You might, however, want to give them information about how to adjust their social media approach (for example — from what may be a casual, personal approach to a more business-savvy, networking-focused approach). That kind of tweak is what helps you publish content about the topics your audience really wants (and needs).

2. Create your blog domain.

Next, you'll need a place to host this and every other blog post you write.

Choose a CMS.

A CMS helps you create a website domain where you'll actually publish your blog. CMS platforms can manage domains (where you create your website) and subdomains (where you create a webpage that connects to an existing website).

HubSpot customers host web content via CMS Hub. Another popular option is a self-hosted WordPress website on WP Engine. Whether you create a domain or a subdomain to start your blog, you'll need to choose a web hosting service after you pick a CMS.

Register a domain or subdomain with a website host.

Your blog's domain will look like this: The name between the two periods is up to you, as long as this domain name doesn't yet exist on the internet.

Want to create a subdomain for your blog? If you already own a cooking business at, you might create a blog that looks like this: In other words, your blog's subdomain will live in its own section of

Some CMSs offer subdomains as a free service, where your blog lives on the CMS, rather than your business's website. For example, it might look like this: However, to create a subdomain that belongs to a company website, register the subdomain with a website host.

3. Customize your blog's theme.

Once you have your domain name set up, customize the appearance of your blog to reflect the theme of the content you plan on creating and your brand.

For example, if you're writing about sustainability and the environment, green might be a color to keep in mind while designing.

If you already manage a website and are writing the first post for that existing website, ensure the article is consistent with the website in appearance and subject matter. Two ways to do this are including your:

Logo: This can be your business's name and/ or logo — it will remind blog readers of who's publishing the content. (How heavily you want to brand your blog, however, is up to you.)

"About" Page: You might already have an "About" blurb describing yourself or your business. Your blog's "About" section is an extension of this higher-level statement. Think of it as your blog's mission statement, which serves to support your company's goals.

4. Identify your first blog post's topic.

Before you write anything, pick a topic for your blog post. The topic can be pretty general to start.

5. Come up with a working title.

You might come up with a few different working titles — in other words, iterations of approaching that topic to help you focus your writing.

For example, you may decide to narrow your topic to "Tools for Fixing Leaky Faucets" or "Common Causes of Leaky Faucets." A working title is specific and will guide your post so you can start writing.

Top Oracle Books

I will recommend you use multiple sources to teach yourself. One good reason for this is, that there is never a single book that speaks t...