RAC & Failsafe :: ASM Candidate Disks Not Found On Grid Reinstall

Aug 27, 2011

I am trying to install 2-node 11gR2 RAC on CentOS 5.6 using VMWare Fusion. I'm in the middle of Grid Infrastructure installation and while choosing the ASM diskgroups I don't see any candidate disks but when I click on all disks i can see them but can't select them.

I tried installing the grid before and ended up with and issue running the root.sh on all the nodes so had to deconfigure the grid binaries using the rootcrs.pl and then deinstalled the grid software using the ./desintall utility.

when tried installing again ...I ran the cluvfy utility ..it doesn't show any errors.

View 2 Replies


ADVERTISEMENT

RAC/ASM Clusterware Installation :: Candidate Disks Disabled During Installation?

Nov 17, 2013

We're trying to utilize Oracle RAC 11.2. We want to have two servers in our grid. These two server are installed on a VM using Hyper-V software.

common storage for asm is also developed on a VM using FreeNAS software.Now, when we try to install Grid Infrastructure the disk that is recognized as a extra drive in both servers are disabled and we can't select it as ASM storage. The OS we're using is Windows Server 2008 R2.I have to say the IP requirements are considered and the servers have two IPs.

View 0 Replies View Related

Exadata :: Move Partition From HP Disks To HC Disks

Jun 27, 2012

We have Exadata -V2 quarter rack with High Performance Disks. We applied EHCC's various compression methods on some of the table's partitions.

Now we are setting up Exadata Expansion Rack - High Capacity Disks. Post implementation, we would be moving older partitions to new Expansion Rack wherein compressed partitions are also included.

In this case, would there be any impact on the compression ratio as the expansion rack is having high capacity disks.

And, moving partition method would be same as it is for non-exadata database i.e. "alter table <table_name> move partition

<partition_name> tablespace <tablespace_name>"

View 2 Replies View Related

RAC & Failsafe :: 11G Release 2 Grid And RAC Installation On Solaris 10

Nov 24, 2010

Share 11g Release 2 Grid infrastructure and RAC installation experience on Sun SPARC. Any documentation which provide complete information from server setup to database setup.

View 2 Replies View Related

RAC & Failsafe :: Oracle Grid Infrastructure Configure Failed

Feb 15, 2011

i am trying to install 2 node RAC on Oracle VMs. Before the installation during the -preinst check there were few issues which were resolved (ex user equivalence). After that during the installation process of the Grid it failed at step "Configure Oracle Grid Infrastructure for a cluster". After it failed at this step, subsequent steps too failed which I asked OUI to ignore and then I ran both the post installation scripts. And then ran post crsinst which failed. Pasting below the output of the root.sh script, post crsinst and other checks.

*************************************
[root@bsfrac01 grid]# sh root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:

ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/11.2/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:

Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created.Finished running generic part of root.sh script.Now product-specific root actions will be performed.

2011-02-13 00:11:55: Parsing the host name
2011-02-13 00:11:55: Checking for super user privileges
2011-02-13 00:11:55: User has super user privileges

[code]....

View 1 Replies View Related

RAC & Failsafe :: Oracle 11gR2 Installation - Grid Infrastructure

Apr 18, 2011

I have some confusions regarding to 11gR2 RAC installation:

- Is Grid Infrastructure only the solution to install Clusterware Application 11gR2? My requirement is to install only the Cluster ware Software for 11gR2 (For 11gR1 we have "linux.x64_11gR1_clusterware.zip") using ocfs2 file system, Archive Mode not enabled.

View 2 Replies View Related

RAC & Failsafe :: Oracle 11g R2 Grid Infrastructure Installation Stuck On 65%?

Mar 15, 2011

I am in process of installing Oracle 11g R2 Grid Infrastructure on 2-node virtual RAC. All went very well until the Grid Installation stuck on 65%. It is saying copying file on remote node ('Copying Oracle Home '/u01/app/11.2.0/grid' to remote nodes 'cxm-vl-rman02'). From the logs it is difficult to figure out where the bottlenecks lies.

View 2 Replies View Related

RAC & Failsafe :: 11g Oracle Grid Cluster Software Configuration - Getting Error?

Jan 31, 2013

While installing 11g oracle grid cluster software. I am getting below error.

[INS-40724] No locally defined network interface matches the SCAN VIP subnet.

i have given scan name as scan-cluster.invent

host-name virtual ip name
rac3 rac3-vip
rac5 rac5-vip

I am able to ping rac3 and rac5 from both nodes.

MY /etc/host file look like this.

192.168.2.133 rac3.invent.com rac3
192.168.2.132 rac3-priv.invent.com rac3-priv
192.168.122.1 rac3-vip.invent.com rac3-vip
192.168.2.136 rac5.invent.com rac5

[code]...

ssh connectivity everything works fine.

View 1 Replies View Related

RAC & Failsafe :: Oracle 11gR2 Grid Infrastructure Installation Hung At 65% Of Completion

Jul 4, 2013

I tried to install 11gR2 grid infrastructure for 2 nodes RAC using VMWare as per the instructions provided in the below link.

[URL]

Until 65% installation went fine without any issues but after reaching this step "updating '/u01/app/11.2.0/grid/install/cluster.ini",it starts to hung. In the installation log file, I found these details.

Quote:filename = /tmp/.GsdDisplayed
INFO: Query Returned: false
INFO: Calling Action fileActions10.2.0.6.0 appendStringToFile
source = /u01/app/11.2.0/grid/install/cluster.ini
stringToAppend = [cluster_info]
cluster_name=rac-scan

[code]....

View 3 Replies View Related

SQL & PL/SQL :: Example Of Composite And Candidate Key

Jul 25, 2013

concept of composite and candidate keys. i have gone through all the definition part but did not understand the concept of creating candidate key for example:-

composite key

create table test(id number,pincode number(4),name varchar2(15),primary key(id,pincode));

table created with composite bcz i took pair of id and pincode.

here base on the same example want to create candidate key with the syntax.

View 24 Replies View Related

XE :: Uninstall Database And Reinstall It?

Oct 23, 2012

I have a Oracle 11g R2 XE installed in my PC. I also have a licensed VB2010 Ultimate(free from class). I have made three systems using this database, 1 using php and 2 using .net.

My question is, if I uninstalled my database and then reinstall it, will it affect my the systems I made(I already backed-up my tables etc.)?

for example, the components for my oracle-vb connection.Why I need to uninstall? Because I got locked out of the System account:, I can't change my password.
C:UsersDavide>SQLPLUS system/secret@127.0.0.1:1521/XE
SQL*Plus: Release 11.2.0.3.0 Production on Tue Oct 23 10:26:31 2012
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-28001: the password has expired

Changing password for system
New password:
Retype new password:
ERROR:
ORA-01017: invalid username/password; logon denied

View 7 Replies View Related

Reinstall Oracle Server Using Existing Directory Structure?

Sep 28, 2010

howto to setup an oracle server and "import" my old databases just from the copied directory structure d:\oracle\product\... ("cold backup") to the new install.i was trying to setup an new server by shutting down the db and just copying back my data/control/log/*.ora files which doesnt seem to work.

i could see the old tables structures in the local sqlplus console, but the databases are not reachable over the net.
also the enterprise manager is not able to startup the dbs, it show just an running listener.

View 3 Replies View Related

Installation :: Reinstall Software After Uninstall With Home Using Universal Installer

Apr 29, 2013

after uninstalling 10g software with home using universal installer how to re-install without deleting all components of database like the database exists i just want to put the oracle software on it and reusing x home location.

View 6 Replies View Related

Grid / Real Application Clusters Grid Computing With RAC

Aug 12, 2010

(Oracle Grid & Real Application Clusters Oracle Grid Computing with RAC) from rampant tech press. I have already ordered it 3 months back and still have not received it as its not printed yet or as i am told is in press. I would be glad to have a copy soon if its published.

View 4 Replies View Related

Application Express :: Display Not-found.png For Image Type When Data Not Found?

May 22, 2013

I have an Image Type on a forum page. I want a default "not-found" image to display if the BLOB column value is null or if there is no data for that search value. The image is stored with the app: #APP_IMAGES#not-found.png

APEX 4.2 (with listener) on Oracle 11gR2

View 10 Replies View Related

New DB - How To Partition Raw Disks

Jan 10, 2012

I am a new Oracle DBA that has been tasked with creating some single node databases for our programmers to connect to. I have never built a database, only upgraded. I will be using a Dell 610 with 10.2.0.4 software. I have been reading the install guides but cannot find a definitive answer for how to create the raw partitions. I have a SAN that I can utilize and my current db is set up with RAID 6 like so:

Disk 2 300 GB 1 Extended 300 GB and 5 logical, 100MB, 30 MB, 100 GB, 100 GB, 100 GB
Disk 3 100GB 1 Extended 100 GB and 3 logical 100 MB, 30 MB, 100 GB

why the old DBA partitioned this way? I am not good with storage and know that I need to understand before I build new databases so I do not duplicate something that is wrong. I was reading articles that recommend SAME but would not know how to do that on the SAN.

I will be using data pump to export the database and import to the new server. I was looking at using transportable tablespaces to do this. Would you recommend that from the cluster to the standalone?

View 4 Replies View Related

Exadata :: How To Find Disks Are HC Or HP

Oct 21, 2013

Is there any command to identify the disks are HC OR HP ? Indirectly i could find with the following exercise -

 $ grep -i MACHINETYPES /opt/oracle.SupportTools/onecommand/databasemachine.xml  <MACHINETYPES>X2-2 Half rack</MACHINETYPES> ASMCMD> lsdgState    Type    Rebal  Sector  Block       AU  Total_MB   Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  NameMOUNTED  NORMAL  N         512   4096  4194304  18235392  10597264          2605056         3996104              0             N  DATA/MOUNTED  NORMAL  N         512   4096  4194304   2087680   2085808           298240          893784              0             Y  DBFS_DG/MOUNTED  NORMAL  N         512   4096  4194304  27240192  18871860          3891456         7490202              0             N  RECO/ = 45TB  >>

[URL] .......  >> Page 5 >> HP SAS disks

View 2 Replies View Related

Creating ASM Disks From NFS Mounted Files

Jul 25, 2010

Regarding 11gR2 RAC, ASM, and NFS. Installing 11gR2 Grid Infrastructure and 11gR2 RAC on OEL 5.5 servers with storage supplied by NetApp NFS shares over TCP/Ethernet.

How do I mount NFS file systems as block devices so ASM will use them?

It is my understanding that Linux mounts NFS file systems as anonymous file systems rather than block devices. ASM requires block devices. The only way I know to have Linux treat an anonymous file system mounted over NFS as a block device is to subsequently mount it as a loop device.The Oracle 11gR2 documentation states, "ASM does not support loop devices". Without defining NFS mounts as loop devices, oracleasm createdisk complains the given file on the NFS mounted file system is not a block device when i run

/usr/sbin/oracleasm createdisk DATA /oradata/prod/data/disk01

where /oradata is an NFS mount from a NetApp volume defined in /etc/fstab and disk01 was created with the dd command.I followed the steps in section 3.3.1.2 'Creating Files on a NAS Device for Use with Oracle ASM' of the Oracle guide..

When I use asmca, it does not find any candidate disks with the search path set accordingly.If successfully implemented ASM using NFS shares for database disk groups from a NAS, Steps I followed are below.

In /etc/fstab:
server-ip-address:/vol/data /oradata nfs rw,bg,hard,nointr,tcp,nfsvers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0 0 0
-- mount and verify. /oradata is mounted with specified options.
# mount -a
# mount
[code]...

Command fails with error message "File /oradata/prod/data/disk01 is not a block device." None of the OUIs (grid installer, asmca, or dbca) identify any disks as ASM candidate disks with the search string '/oradata/prod/data/*'. I also tried using '/*', '/oradata/*', '/oradata/prod/data/*' to no avail.

View 4 Replies View Related

Configuring Udev Rule For Raw Disks?

Jan 1, 2013

I am using oel 5.8, oracle 11.2.0.3. The raw disk permissions are getting changed when the node gets rebooted.I am trying to use udev rule to change the permission permanently but its not working.

CODE[root@VM-PAGRAC3 rules.d]# more 99-asm.rules
KERNEL=="sd", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",*
RESULT=="SATA_VBOX_HARDDISK_VB7a29b7ae-de673b56_",
NAME+="oracleasm/disks/DSK1#" OWNER="grid"
GROUP="asmadmin" MODE="0660"
KERNEL=="sd*", BUS=="scsi", PROGRAM=="/sbin/scsi_id -g -u -s %p",
RESULT=="SATA_VBOX_HARDDISK_VB36f5d134-4e0e4c43_",

[code].....

View 8 Replies View Related

Server Administration :: Switch Between Disks In A Diskgroup?

Aug 31, 2011

I have an Oracle database 11.1.0.6 with ASM storage.

SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
PL/SQL Release 11.1.0.6.0 - Production
CORE 11.1.0.6.0 Production
TNS for Solaris: Version 11.1.0.6.0 - Production
NLSRTL Version 11.1.0.6.0 - Production

There is a disk group named +FRA which has only 1 disk (call it disk 0 for later references).

+FRA disk group is in type of EXTERNAL redundancy

I'd like to add another disk to +FRA disk group and copy all files stored in disk 0 to the new disk (call it disk 1 for ex.), then take off disk 0 (not use for +FRA disk group any more).

Expected result: there is only one disk 1 left in the +FRA disk group, with all the data from disk 0 and keep their original file names

View 5 Replies View Related

Real Application Clusters :: Number Of Local Disks

Jan 20, 2013

We are in preparation for the purchase of equipment for two- node Oracle10g RAC (on Windows Server 2008) and I need to configure the disks on servers. We have an existing EMC VNX5500 storage and SAN 8Gb switches.

My question is with how many disks to configure servers?Originally we planned four SSD discs (two in RAID 1 for OS and two in RAID 1 for locally Oracle home) for each node/server, and everything else on storage disks (Shared Disks Storage).

Whether it is necessary to have more local disks and for what? Where should be redologs files, archivelogs files, backup files…

Whether it is better server to be configured with six SSD disks:
-     two in RAID 1 for OS,
-     four in RAID 10 (or RAID 1) for locally Oracle home, archivelogs files, or something else…?

View 6 Replies View Related

ASMNMP Privileges - Running Dbca And Have Specified Which ASM Disks To Use For Data?

Nov 12, 2010

ASM instance SID = +ASM and the database installation was under SID =rdbms112

Im just in the process of running dbca and have specified which ASM disks to use for data, but then on the next screen of the dbca, im asked for the ASMNMP password,

the password for 'oracle' user is 'oracle' but im getting this message:

"Could not validate ASMNP password due to the following error: "ORA-01031-insufficient privilages" Do you want to continue? If you contiue ASM will not be configured to be moitored by database controll "

when I was asked for privilaged operating system groups when setting up ASM

OSDBA, OSOPER and OSASM ... were all set to group 'dba'

the oracle user is in the 'dba' group

View 2 Replies View Related

Server Administration :: How To Assign Size For Disks In Diskgroup

Mar 3, 2012

you have given 500gb of harddisk. how will u implement the size or how to assing the size for disks in the diskgroup.give me the best practice that is used in production

View 1 Replies View Related

Automatic Storage Management :: Prepare ASM Disks Using ASMlib And Oracleasm

Jun 28, 2012

Normally ASMlib/oracleasm is used to prepare the disks for ASM. I just wonder, besides this tool, is there any other GUI based tool to use for preparing the ASM disks?

View 2 Replies View Related

Automatic Storage Management :: Adding Disks To Existing Data Disk Group

Jun 19, 2012

I have 11.1.0.7 instance running and got more 300G of storage available for the database. I would like to know what are the steps to add these disks/storage to the existing DATA asm disk group?

View 5 Replies View Related

Single Instance Non-Grid To Single Instance Grid Database

Aug 27, 2012

I'm trying to test moving a single instance 11202 database to single instance w/ grid infra.

Here is what I've done:

1. Install a database (11202), single instance and create a database
2. Install Grid Software only (user: grid)
3. start the cluster
4. "srvctl add database -d orclsidb -o $ORACLE_HOME" to register the database with grid.
4.1> I was able to start/stop the database with srvctl command here onwards
5. configure disks using asmlib and start the asm
6. "srvctl add asm" to register asm with grid.
7. PROBLEM ... when I try to "backup as copy database format '+ASM_DATA_DG';" from oracle user it errors out as below:

RMAN> backup as copy database format '+ASM_DATA_DG';

Starting backup at 24-AUG-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00011 name=/fs0/oracle/oradata/orclsidb/sjc883p_indx_large_01.dbf
RMAN-00571:

===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 08/24/2012 08:53:29
ORA-19504: failed to create file "+ASM_DATA_DG"
ORA-12547: TNS:lost contact
ORA-15001: diskgroup "ASM_DATA_DG" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12547: TNS:lost contactConsidering "TNS: lost contact" I tried to see if grid listener is aware of ASM instance:

[Code]....

All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=usracdb03.rwcats.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date                22-AUG-2012 06:08:53
Uptime                    2 days 2 hr. 50 min. 48 sec
Trace Level               off

[Code]....

View 10 Replies View Related

11g Grid On Windows

Mar 22, 2011

I Had installed 11g grid on 32 bit machine. Grid was working fine till yesterday and was also able to monitor agents on 4 diff boxes. Agents installation was smooth using the pull method. But from yesterday onwards grid is not working. OMS service on windows is not getting started. node manager,listener,database service, web tier all services are running fine but for some reasons the Windows OMS service is not coming up .

I also tried to start manually oms_home/emctl start oms but the service doesn't come up.

View 5 Replies View Related

OEM Grid Control 10g Reporting

Aug 19, 2011

I am using OEM Grid control 10g for monitoring/reporting purposes and a bit new to OEM.I am able to generate database alerts sent via email say for DB_abc1 and also generate reports.I installed Oracle 10g agent on a another box and lets say with DB_abc2 running on it,and did not realise that there was a database control already installed on that box, so I

1.Uninstalled database control on DB_abc2 box.
2.Uninstalled Oracle 10g agent and re-installed it on DB_abc2 box.
2.Was able to configure the DB_abc2 database from OEM Grid control gui ie the dbsnmp user password and was able to connect to it.

But when I put in alert for things like ORA-XXXX errors I am not getting any emails, also when I put in database usage reports(to be sent via emails) the reports are not picking up any data, they are empty.

I checked the agent on the box in question and the heart beat is OK, and I manually uploaded using "emctl upload" and it is sucessful.The only alerts I am getting for DB_abc1 is the agent up/down thats it.

DB_abc1 is a 9208 database and DB_abc2 is 10201 database.

View 2 Replies View Related

Installing Grid Control 12c?

Apr 19, 2012

I need to install the new Oracle Grid on a new virtual machine. Currently the new Grid VM server has a different name and IP. After it is setup and tested it will eventually take the place of the old production server using its original IP and name. If I install the new Grid now on this new VM with different name and IP address would I have to reinstall the agents on each of the target database servers?

View 1 Replies View Related

Generate Report From OEM Grid

Feb 6, 2012

Can we collect information(generate report) about user sessions connected, database hit ratios, memory usage and other system metrics of all target databases from OEM grid control repository database. Which tables/views in repository DB will be holding these information.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved