Skip to main content

Posts

Showing posts from 2021

Linux Installation on a VM to install Oracle 19c database.

 1) Configure VM Create New VM during which you will have to select below list of parameters ⦁ VM Name ⦁ VM Machine files location ⦁ OS Type ⦁ Version ⦁ Ram allocation from physical Ram available on host machine (here Windows 10) ⦁ Select “Create a virtual hard disk now” as we are building a new machine. ⦁ Finally click on create it will open a new window where it will ask some details for  ⦁ disk size ⦁ disk type ⦁ disk allocation type.  Click on settings and new window will open then we have to do some changes here in all tabs. General >> General >> Advanced >> Shared Clipboard >> Bidirectional General >> Advanced >> Drag n Drop >> Bidirectional 2A. System ⦁ Motherboard>>Unselect Floppy A) System ⦁ Processor increase the number of cpus if you have resources  Storage >> Here we have to add more storage when required for Grid Home, Oracle Home, Asm Disks….etc For now we have left it with ...

15 Things fresher DBA must know

This blog post is a quick summary of How to become a DBA course – A 100% free course which speaks about everything you need to become an Oracle DBA. Learning SQL is just not enough to become an Oracle DBA. You need much more skills and learn other things to crack your first job interview. In this blog post, I would like to talk about 15 things you must know as a Junior (Fresher) DBA even before you would like to start your career as database administrator. 1. Linux Administration 98% of the servers in all the MNCs out there use Unix or Linux operating system. It is obvious that the Oracle database you will be working on would also be hosted on some Linux server. And, not having good hands-on knowledge on Linux will be one of the biggest road blocks in your path to become a DBA. 2. Virtualization Now that you know the importance of Linux operating system, the next big question is how to practice it. In order to learn Linux, you need to install it on your laptop (or desktop) to master it...

Typical Shift for a Oracle DBA

. Usually We start by checking on call mailbox for any alerts/issues like following OEM Alerts Mount point full Tablespace alert Listener down Server down Backups failuer . Shift handover report, it contains pending request. . Daily tickets/Incidents by using available ticketing tool. .Daily scheduled Change Req & Service Req as per schedule. . Alert log error checking. . Verify all instances are online. . Check tablespaces should not be used more that 95% . Check all last night backups were successful. . Check OEM Alerts and resolve them. . Schema level refreshing by using exp/imp, expdp/impdp. . Explaining the plans for particular table to tune the databases. . Taking backups by using RMAN on daily and weekly basis.

Doubt regarding opatch

can we create an SR  for clarifying why napply option of opatch is used exactly . http://docs.oracle.com/cd/E11882_01/em.112/e12255/oui7_opatch.htm#OUICG319 1) Napply Command for OUI-based Oracle Homes This command applies interim patches to several Oracle homes at the same time. 2) Or is it used ofr applying multiple patches in single shot  ?