Santosh Kangane

Simple steps to remove Oracle instance…. 1) Login to the server machine with Oracle user 2) Set ORACLE_HOME, ORACLE_SID 3) Open SQL Plus [oracle$] sqlplus / as sysdba SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount EXCLUSIVE ORACLE instance started. Total System Global Area 3.2068E+10 bytes Fixed Size                  2214736 bytes Variable Size            1.5838E+10 bytes Database Buffers         1.6106E+10 bytes Redo Buffers              122404864 bytes Database mounted. SQL> alter system enable restricted session; System altered. SQL> drop database; Database dropped. Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>

To verify the SQL Server setup compliance with Microsoft Best Practices has become more easier now. Microsoft has provided “SQL Server 2008 R2 Best Practices Analyzer” tool. One can install following two components on Server or any remote machine (additional settings will required in 2nd case) 1) Microsoft® SQL Server® 2008 R2 Best Practices Analyzer 2) Microsoft Baseline Configuration Analyzer 2.0 On Execution tool will detail out the compliance report as per the Microsoft’s best recommended practices. To tune any SQL Server we can use this as startup point…   

I thought, setting up Distributed, NOSQL, Big Data must be a complex process. However, when I actually did it for cassandra, I found it like installing some simple OS package !!!.. Cassandra is too simple to setup and play around it. I found it more like plug and play engine. The Cassandra database very well explained in Book : O’Reilly Cassandra: The Definitive Guide, Nov 2010   So, Here is how to do it…. A) Pre requisites : jdk1.6 or grater version.        If you don’t have, you can download and configure it. How ? B) Cassandra on Linux           1. Create user for cassandra root@PTS0012:/usr/lib# id cassandra uid=506(cassandra) gid=0(root) groups=0(root) root@PTS0012:/usr/lib# 2. Create Dir for cassandra database root@PTS0012:/usr/lib# mkdir -p /var/log/cassandra root@PTS0012:/usr/lib# chown -R cassandra /var/log/cassandra root@PTS0012:/usr/lib# mkdir -p /var/lib/cassandra root@PTS0012:/usr/lib# chown -R cassandra /var/lib/cassandr

To generate the AWR report: Log in to the machine hosting Oracle server. Connect to Oracle server with SYS or equivalent DBA level access user. At a command prompt, issue the following command: @$ORACLE_HOME/rdbms/admin/ awrrpt.sql << This script will create an interactive session follow the instruction as shown below.>> Specify a format for the report and press Enter . Specify the Database instance on which to run the report by typing in the database ID from the list of instances and press Enter (in most cases there is only one choice, but if there is more than one,  find out which instance hosts the your schema). Type the Inst Num and press Enter . Specify when the report should start: You can choose to enter a numeric value for the most recent number of days (e.g., entry of 1 produces a report on the most recent one day of workload). To have finer unit than days hit enter with no values and a list of snapshots will appear: Typ

I installed the Oracle 11g RAC successfully, But when tried connecting from remote client via SCAN, it used to raise ORA-12537. This is the most common issues that the happens with SCAN listener. And there are few common mistakes that generally  cause this issue. . So, here is how we can troubleshoot the connectivity issues with SCAN, and cases out the possibilities. 1)  Check if Local_listener and remote_listener parameter are set properly on all nodes. 2)  The very common issue is with permissions. SCAN will always be created under grid user (Grid cluserware installation user). Oracle will also create one local listener “LISTENER” during grid infrastructure installation. But if that is not present then always make sure that you create a local listener with grid user. This is required to handover the connection between remote and local listener. 3)  Also “oracle” executable should have given to oracle and grid user i.e. 6751.  Under $ORACLE_HOME/bin. If permission are not

Standard configuration options Tool provided by Storage vendors OpenFiler Open source   DOS Manual Setup using iSCSI protocol   Target is the storage server and Initiator is the client.   Target (Ubuntu 12.04) Ø   Install iscsitarget, iscsitarget-source, iscsitarget-dkms package Ø   Format the disk and create the partitions as per your requirements. ( I have 10 GB for OCR &Voting Disk; 61 GB for oracle storage). Ø   edit /etc/default/iscsitarget . Change the default value of ISCSITARGET_ENABLE=false over to ISCSITARGET_ENABLE=true. Ø   Define LUNs in  /etc/iet/ietd.conf       Target iqn.2012-08.in.co.persistent:storage.disk0. pts0012                   LUN 0 Path =/dev/cciss/c0d1p5,Type=fileio,ScsiId=lun0,ScsiSN=lun0 Node: ―         0th LUN is mandatory. ―         Make sure there is no space in LUN Definition above and every parameter is separated by “,” Restart the service iscsitarget Initiator (All RAC node RHEL5) Ø   Install iscsi-

Successfully Implemented Oracle 11gR2 RAC on Redhat   Enterprise Linux 5.0. !!!  This is in continuation of my last post of Oracle RAC 11gR2 failed on Ubuntu 12.04 Linux   You may find this useful. Oracle 11g R2 RAC implementation and concept from Santosh Kangane Oracle 11g R2 RAC setup on rhel 5.0 from Santosh Kangane

I have tried following steps for RAC implementation... unfortunately it failed on Ubuntu 12.04 as Oracle Grid infrastructure is not been supported on Ubuntu drivers. Going ahead, Oracle is no more supporting RAC on Red hat and SuSe starting with release Red hat 6.0 and SuSe 12. ( As per information I got so far) Now Oracle RAC will be available only on Oracle Enterprise Linux and Solaris.... Specification : 1) 2 Node RAC setup 2) Each machine with Linux Ubuntu 12.04 (x86_64 bit, Kernel : 3.2.0-23-generic) 3) Oracle 11gR2 Database 4) Oracle 11gR2 Grid Infrastructure. Pre-Installation :      1) All the nodes should have same OS and Kernel version and bits (x86 or x86_64 ) For Linux use $uname –a it should show same output on all the nodes.      2) Each of the Server should have 2 NIC cards - Where group of 2 ( one from each machine) should have same name(say eth0 /eth1 ) and IP subnet Mask Ex : 1) Each of the machine has