Archive: November, 2016

Oracle Database Health Check up Checklist

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Database Health Check up Checklist 1. Basic Server Status Basic Server related configuration collection CPU Speed Physical Memory, Swap size Disk layouts Log storage Number of database running on the server & in what mode e. (Open or Mount) mode.   Database up/down Whether the database shutdown / started up Any abnormalities noted during the startup or shutdown i.e. any Oracle background process terminated while …

Oracle Database Crash During Hot Backup

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Oracle Database Crash During Hot Backup SCOPE — There can be many reasons for the database to crash during a hot backup—a power outage or rebooting of the server, for example. If these were to happen during a hot backup, chances are that tablespace would be left in backup mode. In that case you must manually recover the files involved, and the recovery operation would …

Oracle Data Pump Overview

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Oracle Data Pump Overview Introduction This white paper gives an overview of the Data Pump architecture, description of the important features of Data Pump, some best practices to use and a comparison of the Data Pump Export and Import utilities to the Export (Exp) and Import (Imp) utilities. Data Pump Overview Data Pump is a fully integrated feature of Oracle Database that provides very high-speed …

Data Block Corruption In Oracle

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

Data Block Corruption In Oracle Case Study :- Once I faced the Data block corruption problem on DishTv site in one of our Oracle Database server. The corrupted block was referring to a table. We tried everything like rebuilding index, correcting the data corruption etc but finally it was detected as a physical data corruption and hence we raised the call with Os vendor. We …

DataGuard Implementation steps

November 12, 2016 by S4

Filed under Oracle

Last modified November 12, 2016

DataGuard Implementation steps Create similar directory structure on Primary and Standby nodes for storing backups and Archive log files. In the test Dataguard Machine, the following Directories were created. Eg mkdir /misc/arch – for specifying a local location of the archive files mkdir /misc/backup – for specifying a backup location for RMAN backup. Please note that this is the directory that stores the RMAN backup …

Multithreading in Java

November 10, 2016 by Manisha Ambekar

Filed under java

Last modified November 10, 2016

Multithreading in java is a process of executing multiple threads simultaneously.Thread is basically a lightweight sub-process, a smallest unit of processing.Multiprocessing and multithreading,both are used to achieve multitasking. But we use multithreading than multiprocessing because threads share a common memory area. They don’t allocate separate memory area so saves memory, and context-switching between the threads takes less time than process.Java is a multi-threaded programming language …

EIGRP Concepts and Operation

November 10, 2016 by Neel Rao

Filed under Network

Last modified November 10, 2016

EIGRP Concepts and Operation Like OSPF, EIGRP follows three general steps to be able to add routes to the IP routing table: Neighbor discovery: EIGRP routers send Hello messages to discover potential neighboring EIGRP routers and perform basic parameter checks to determine which routers should become neighbors. Topology exchange: Neighbors exchange full topology updates when the neighbor relationship comes up, and then only partial updates …

SAP Assets Accounting Depreciation

November 8, 2016 by Neel Rao

Filed under SAP

Last modified November 8, 2016

SAP Assets Accounting Depreciation SAP Assets Accounting Depreciation The depreciation is collectively executed at the company code level. Each asset master contains the necessary information to calculate the depreciation like: Capitalization date Depreciation areas Useful life Scrap Value Asset Value Date The depreciation run is an important periodic processing activity which takes care of calculating depreciation for the assets. This run posts the corresponding transactions …

STP Loop Guard

November 7, 2016 by Neel Rao

Filed under Network

Last modified November 7, 2016

STP Loop Guard: Your network is suffering from regular outages. After troubleshooting, you learn that the transmit lead of a fiber uplink was damaged. Which two features can prevent the same issues in the future? (Choose two.) Root guard Loop guard BPDU guard UDLD BPDU skew detection Answer: 2 & 4  Explanation: STP Loop Guard The STP loop guard feature provides additional protection against Layer …

Which statement is true about Topology Change Notification (TCN) propagation?

November 7, 2016 by Neel Rao

Filed under Network

Last modified December 1, 2016

Which statement is true about Topology Change Notification (TCN) propagation? The originator of the TCN immediately floods this information through the network. The TCN propagation is a two step process. A TCN is generated and sent to the root bridge. The root bridge must flood this information throughout the network.  Answer: 3  Explanation: Explanation New Topology Change Mechanisms When an 802.1D bridge detects a topology …