Santosh Kangane

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: ...

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/bi...

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. ―  ...

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 ma...