Articles Comments

AskDba.org Weblog » Author Archive

11gR2: CVU needs SCAN Listeners’ Manual Startup During Grid-Infrastructure Configuration

During configuration phase of Grid Infrastructure for cluster, CVU failed while performing post-checks. Following message is displaced in the Installation Log file: Checking Single Client Access Name (SCAN)... WARNING: PRVF-5056 : Scan Listener "LISTENER" not running Checking name resolution setup for "scan-test.abc.com"... Verification of SCAN VIP and Listener setup failed The LISTENER from Grid Infrastructure home is running fine: $ ps -eaf | grep tns /u01/app/grid_11.2/GridInfra/bin/tnslsnr LISTENER -inherit Same error is observerd by manually runnig CVU as: $ cluvfy comp scan Verifying scan Checking Single Client Access Name (SCAN)... WARNING: PRVF-5056 : Scan Listener "LISTENER" not running Checking name resolution setup for "scan-test.abc.com"... Verification of SCAN VIP and Listener setup failed Verification of scan was unsuccessful on all the specified nodes. Checking the status of SCAN using SRVCTL gives correct results: $ srvctl config scan SCAN name: scan-test.abc.com, Network: 1/165.101.124.0/255.255.254.0/eth0 SCAN VIP name: scan1, IP: /scan-test.abc.com/165.101.125.204 SCAN VIP name: scan2, IP: /scan-test.abc.com/165.101.125.235 SCAN VIP … Read entire article »

Filed under: oracle, rac

How To Discover Disk Name When LUN Number is Known (OEL5)

I am creating 11gR2 RAC setup for one of my client. Following Oracle documentation for storage, I opted for Oracle ASM and asked storage team for new physical devices. Storage admin thus provided me with a set of LUNs instead of actual physical device names like /dev/sdcxxx. Now the major task is to get the actual device name associated with LUNs. In OEL4 this is easy to get by issuing # iscsi-ls -l This command will give output like: DEVICE DETAILS: --------------- LUN ID : 0 Vendor: DELL Model: MD3000i Rev: 0670 Type: Direct-Access ANSI SCSI revision: 05 page83 type3: 6001e4f0003fa9970000083c48573c94 page80: 383438303045500a Device: /dev/sdh LUN ID : 1 Vendor: … Read entire article »

Filed under: Unix, oracle

Life Is Changed Now!!!!!

Life Is Changed Now!!!!!

Hi All, This time I am sharing an experience from my personal life, I got Married on 2nd Dec 2009 I was on holidays since last month and just joined back. In this time I visited beautiful Island of Koh-Samui (Thailand). At this time finding hard to concentrate on work Cheers!!! Saurabh Sood … Read entire article »

Filed under: Random

Get Upgrading: Steps To Upgrade To 11gR2

Get Upgrading: Steps To Upgrade To 11gR2

As 11gR2 is out for Linux, I decided to upgrade one of my existing 10.2.0.3 database to 11.2.0.1 to get the look and feel of 11gR2. Direct upgrade to 11gR2 is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher and 11.1.0.6 or higher. If you have a database 9.2.0.6 then first you need to upgrade to intermediate release i.e 9.2.0.8 then to 11.2.0.1. 9.2.0.6==>9.2.0.8==>11.2.0.1 8.1.7.0==>8.1.7.4==>10.2.0.4==>11.2.0.1 I will discuss how to upgrade an existing Single Instance … Read entire article »

Filed under: Featured, oracle

OCFS2 Configuration Issue

While setting up ocfs2 for OCR and Voting disk storage with following commad: # ocfs2console After clicking on ==>cluster ==> configure nodes, I got a pop-up saying: "Could not start cluster stack. This must be resolved before any OCFS2 filesystem can be mounted." Soon I realized that the thing which takes few minutes to get installed, is going to give me a tough time. /var/log/messages shows following details: Aug 17 14:53:40 rac1 modprobe: FATAL: Module configfs not found. Aug 17 14:55:23 rac1 modprobe: FATAL: Module configfs not found. Aug 17 14:56:56 rac1 modprobe: FATAL: Module configfs not found. This prevents the configuration of OCFS2’s cluster stack, but it is mandatory to have OCFS2 cluster stack “O2CB” running, before we can start anything with OCFS2 filesystem. The stack includes the following services: * NM: Node Manager that keep track … Read entire article »

Filed under: database, oracle

CleanUp Temporary Segments Occupying Permanent Tablespace

There are situations when we see “temporary segments” in permanent tablespaces hanging around and not getting cleaned up. These temporary segments in permanent tablespace can be created by DDL operations like CTAS and “alter index..rebuild” because the new object is created as a temporary segment in the target tablespace and when the DDL action finishes it will be changed to permanent type. These temporary segments take actual disk space when SMON fails to perform its assigned job to cleanup stray temporary segments. Following query finds out these segments: SQL > select tablespace_name, owner, sum(bytes/1024/1024) from dba_segments where segment_type = 'TEMPORARY' group by tablespace_name, owner; TABLESPACE_NAME     OWNER          SEGMENT_NAME     SUM(BYTES/1024/1024) ------------------- ------------   ------------     -------------------- xxxx_DATA           SYS              123.8365          137706 BDEPST_INDEX        SYS              345.8756            8910 KMRPT_DATA          SYS                345.87       25284.875 BILL_INDEX          SYS                                   .25 DSS_DATA            SYS                                   798 MRKT_INDEX          SYS                                   208 SPCT_DATA           SYS                              69642.25 SPCT_INDEX          SYS                              956.4375 Here we can see that tablespace KMRPT_DATA, … Read entire article »

Filed under: database, oracle