AskDba.org Weblog » Entries tagged with "11gR2"
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 »
11gR2: Steps to Rename ASM Diskgroup with DB files
11gR2 introduced renamedg utility to rename diskgroups. I would discuss renaming a diskgroup on a Standalone Grid Infrastructure installation with Oracle Restart. Before you use the command, ensure that ASM diskgroup is dismounted. Below is syntax for the command. You can refer to 11gR2 docs for details renamedg [phase={ one|two |both } ] dgname=diskgroup newdgname=newdiskgroup [config=configfile] [ asm_diskstring=discoverystring, discoverystring ... ] [ clean={true|false} ] [ check={true|false} ] [ confirm={true|false}] [ verbose={ true|false} ] [ keep_voting_files={true|false}] Basically we have two phases of using renamedg command, phase … Read entire article »
11gR2 – SysAsm vs SysDba
SYSASM role was introduced in 11gR1 and was designed to administer ASM instances. In 11gR1 , if you connected with SYSDBA role , you used to get a warning which was only recorded in alert log (Refer to my earlier post here). But things have changed in 11gR2. While trying to dismount a Diskgroup, I found following errors SQL> alter diskgroup flash_arc mount; alter diskgroup flash_arc mount * ERROR at line 1: ORA-15032: not all alterations performed ORA-15260: permission denied on ASM disk group Above error indicates that I do not have permission on the ASM Diskgroup. As per 11gR2 documentation, SYSASM privilege is used for carrying out administration tasks on ASM Diskgroups. SYSDBA privilege can be used only for creating/deleting aliases and querying ASM dictionary views. Frankly speaking, you should unlearn the habit of connecting as “/ … Read entire article »
Link:11gR2 RAC installation steps on OEL4
If you are looking for steps for 11gR2 RAC installation, you can refer to this article by Rajeev Ramdas at Dbastreet.com. Article lists down steps for installing 11gR2 RAC on 64 bit Oracle Enterprise Linux 4 (OEL4) using ASM for storage. As Raw devices are no longer supported, OCR and Voting Disks are also stored on ASM. Yes, this is one more cool New Feature available in 11gR2. … Read entire article »
11gR2: Monitoring Real Time SQL Plan Execution from Oracle Enterprise Manager
Ever since 11gR2 has been released, it has created a lot of buzz in Oracle Blogosphere with various posts on 11g Release 2 (11gR2 ) New Features primarily ASM New features. I would like to introduce you all to a feature which has been incorporated in 11gR2 Oracle Enterprise Manager to display Real-Time SQL Monitoring information . I would say that this was much awaited feature which had to be implemented in OEM and comes as a handy … Read entire article »
Filed under: Featured, performance
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 »
Subscribe To Feed
License
AskDba.org Forum
- Mahesh.G on "DR rebuild- Data restore issue" March 12, 2010
- Mahesh.G on "DR rebuild- Data restore issue" March 11, 2010
- Saurabh Sood on "DR rebuild- Data restore issue" March 11, 2010
- sunkkuma on "DR rebuild- Data restore issue" March 11, 2010
- Amit Bansal on "DB and Listener availability monitoring script" March 11, 2010
Recent Comments