Real Application Clusters :: PSU Patching And Grid Infrastructure Installation
Jun 25, 2012
GRID version: 11.2.0.3 , 11.2.0.2
Platform : AIX 6.1
We install grid using Grid Installer GUI. When doing a fresh installation of Grid Infrastructure 11.2.0.2 or 11.2.0.3 in a new server , I want to apply its latest PSU as well. When should I do this PSU patching ?
A. Should I apply the GI PSU after the entire Grid installation is successfully completed ?
or
B. Should I apply the GI PSU just before running the root.sh ?
i.e. when the installer prompts you to run root.sh (see the screenshot below)
[URL].........
At this stage(before running root.sh) the GI binaries are in place . So , I can apply the PSU on these binaries? Right?Should I follow option A or B above ?
View 1 Replies
ADVERTISEMENT
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
May 7, 2013
I have a 2 node 11.2.0.3 RAC database, OS version is RHEL 6.1
Our existing grid control server setup is 10gR2.Can i install 10.2.0.5 agent on my RAC servers and use the 10g grid to monitor my 11.2.0.3 database(RHEL 6.1) ?
View 6 Replies
View Related
Dec 13, 2012
Grid version: 11.2.0.3
OS : Red Hat Enterprise Linux 5.4
Few months back, in our RAC Cluster, while taking an expdp backup in a local Linux formatted filesystem, I got some errors. Don't quite remember the error code or the scenario now as I had too much work that day. The issue was fixed only when we used an ACFS filesystem location as the directory object for expdp.
Today, in the same RAC cluster, to reproduce that issue, I tested taking an expdp backup in a local Linux formatted file system ( /home/oracle/pumpDir ) and the expdp completed without any issues.
with expdp,impdp in RAC cluster environment because of using a local Linux filesystem ?
View 4 Replies
View Related
Apr 15, 2013
I am new in RAC scenario though i have some system to look after. I want to know, like single instance there is alert log,trace log where we should investigate to check if there is any problem. For RAC system which are the logs that i can find the monitor the incident or regular health checkup under grid and oracle user?
View 3 Replies
View Related
Mar 18, 2012
I got huge problem trying to install grid infrastructure and oracle db. Separately oracle db works fine and installation is going without any problems as for grid not so much.
i got vmware host 4.1 with several vm's on top. One of them i openfiler which gives 2 luns for installation. Two other vm's are host of windows 2008r2(comes only 64bits i know that many of you know but just to be clear). Those two windows should be connected in oracle cluster and should have one oracle db afterwards. I have already AD domain, free disks and all required staff arranged and prepared.
I wont bodder you ppl about previous problems but current one is that i have no clue what's going wrong. I got two logs file which i paste below but there's no error message just some warning which isn't described even properly as for me.
Attached File(s)
installtion_logs.zip ( 66.62K )
Number of downloads: 0
View 2 Replies
View Related
May 22, 2013
I am preparing to install grid infrastructure 11.2.0.3 on AIX 6.2 USING AIX LPARS. I am getting the following errors in the output when runningn the following command...
./runcluvfy.sh stage -pre crsinst -n oradbprd016,oradbprd022 -fixup -verbose
These are the errors...
Check: TCP connectivity of subnet "192.168.99.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
c-oradb003av:192.168.99.32 oradbprd016:192.168.99.32 failed
ERROR:
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd016 : 192.168.99.32" failed
c-oradb003av:192.168.99.32 oradbprd022:192.168.99.235 failed
ERROR:
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd022 : 192.168.99.235" failed
Result: TCP connectivity check failed for subnet "192.168.99.0"
The physical hostnames of the servers are c-oradb003av and c-oradb005av In which they are aliases as follows in the /etc/hosts files.
# c-oradb003av
192.168.99.32 c-oradb003av.corppvt.com c-oradb003av
192.168.99.32 oradbprd016.corppvt.com oradbprd016
192.168.99.243 oradbvip016.corppvt.com oradbvip016
192.168.100.18 oradbpri016.corppvt.com oradbpri016
192.168.103.18 oradbrep016.corppvt.com oradbrep016
[code]....
it would say it is failing between the physical hostname and the alias which are using the same ip address?
PRVF-7617 : Node connectivity between "c-oradb003av : 192.168.99.32" and "oradbprd016 : 192.168.99.32" failed (it's the same address?)
View 3 Replies
View Related
Jan 28, 2013
I'm installing Oracle Grid 11gr2 on windows 2003 server. I installed successfully without domain controller. But when i try to install with Active Domain controller i faced following error
INS-20802 Grid Infrastructure Failed
Cause:Plugin failed
View 4 Replies
View Related
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
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
Oct 3, 2013
i have installed grid(crs+asm) on my two linux node(Enterprise linux 5) setup, using openfiler(SAN) , i have configure grid Home like ORACLE_ HOME=/ u01/ home/app/11.2.0/grid.
1) i don't get any instance specific asm parameter file like init+ASM1.ora instead of that i got ab_+ASM1.dat, hc_+ASM1.dat, init.ora, orapw+ASM four files, do i need to create ASM instance specific parameter manually to create diskgroup in the same location,
2) +DATA diskgroup has been created while grid installation, but when i try to create database, its giving me error diskgroup +DATA doesn't exit or not mount, but when i check it shows me mount like below $cd $ORACLE_HOME/dbs (here oracle home is grid home)$export ORACLE_SID=+ASM1$sqlplus / as sysdba>select name,state from v$asm_diskgroup; name state DATA Mounted even i cant able to dismount diskgroup DATA, it throws an error insufficient privilege.
3) After grid installation how can one create diskgroup i mean what needs to exported as ORACLE_SID like in 10g we have $export ORACLE_SID=+ASM1 then creat diskgroup.
View 5 Replies
View Related
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
Dec 27, 2012
I m trying to make ORACLE RAC 10gr2 on two nodes with openfiler , with ocfs and asm.but i didn't have clusterware 10.2 software to install because oracle has removed software to download, that's why i install clusterware 11.2 . after installation clusterware 11.2 i check status and output is below on both nodes.
[oracle@linux2 bin]$ ./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
but when i try to install oracle 10gr2 software and when i reach to configure asm disks it says "in order to use AUTOMATIC STORAGE MANAGEMENT the oracle cluster synchronization service (CSS) must be up and running. and says to run "/u01/app/oracle/product/10.2.0/db_1/bin/ localconfig reset* as root user.. I run it and it give no error.
View 3 Replies
View Related
Jun 18, 2012
is there any alarm in moving alert logs generated in the grid infrastructure. The alert log in the grid log directory has grown around 2gb .Our CRS version 11.2.02. on linux. Also pls, Sample script for automating the same.
View 4 Replies
View Related
May 5, 2013
oracle 11g ASM RAC under OEL 5.6 . i just want to do a cloning so first i create cloning of my oracle home and then i create pfile and i get this error
SQL> startup nomount;
ORA-29702: error occurred in Cluster Group Service operation
SQL> exiti google it , i found this issue is with relink RAC binaries due to the souce database is RAC and destination is not
[oracle@backuptest ~]$ cd $ORACLE_HOME/rdbms/lib
[oracle@backuptest lib]$ make -f ins_rdbms.mk rac_off
bash: make: command not found
View 5 Replies
View Related
Jan 21, 2013
Trying to find a best practices document from Oracle regarding the use of ASM to store the archivelogs in RAC. Most of the DBA's I know create a non-ASM location to store the archivelogs. Are there any considerations if you are also using dataguard?
View 5 Replies
View Related
Nov 13, 2012
oracle 11g.2 rac with asm RHEL 5
ora.gsd
OFFLINE OFFLINE ccbs01
OFFLINE OFFLINE ccbs02
why it's offline , what this means , what the useuage of this? did have any affect on database availability? the below it's from OEM
[Critical] ABSNL Cluster Resource State State Change
ora.gsd has instances in OFFLINE State Nov 12, 2012 12:15:03 PM
[Warning] ABSNL Cluster Resource State State Change
ora.abs.db has instances in OFFLINE State Nov 12, 2012 12:15:03 PM
View 5 Replies
View Related
Oct 4, 2012
We have java application which uses the ons configuration. Currently app's ons nodes parameter is pointing to vip i.e Node1-vip:6200,Node2-vip:6200. Will Ons nodes parameter support the RAC scan? Can i change to Nodes:RAC-scan:6200?
View 1 Replies
View Related
Sep 30, 2013
Grid Version:11.2.0.3OS : RHEL 5.8 I have succesfully installed cluster (GI) and installed RDBMS software on my 2-Node RAC . But, I don't want to use dbca to create the database due to some custom requirements. Instead , I want to run CREATE DATABASE command manually to create the RAC DB. Once the DB is created in one node, what are the steps I need to do to make this DB a RAC DB?
View 5 Replies
View Related
Dec 11, 2012
1. RACcheck - RAC Configuration Audit Tool - RACcheck 2.1.6
2. In the service add command syntax using the srvctl command, there is a new option that can be used with the srvctl add service command which is [-l <primary, physical-standby, logical_standby>], this option allows the service to be able to start up only when the service role matches the database role that is saved in the OCR.
We can now add a service to a database in the OCR using the following command:
srvctl add service -d <db_unique_name>
-s <service_name>
[-l <primary, physical_standby, logical_standby>]
3. NFS options for 11.2.0.2 RMAN disk backups on Linux 64-bit
4. In RAC environment from 11.2 onwards Backup Or Snapshot controlfile needs to be in shared location
1. Check the snapshot controlfile location:
RMAN> show snapshot controlfile name;
2. Configure the snapshot controlfile to a shared disk:
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '<shared_disk>/snapcf_<DBNAME>.f';
Or in case of ASM use
RMAN> CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+<DiskGroup>/snapcf_<DBNAME>.f';
View 1 Replies
View Related
Jan 7, 2013
I have an java application deployed on websphere that is using Oracle. Datasource are created in websphere using URL like this:
jdbc:oracle:thin:@DBSERVER_NAME:1521:DB_NAME
Now, that we plan to move move to oracle rac, I learnt that we need to make change to datasource like this:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
(HOST=DBSERVER1_NAME)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=DBSERVER2_NAME)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME
=DATABASE_SERVICENAME)))
would that be enough, or I need to make other changes as well from application perspective.
Another thing is that application deployment is done through ant scripts, which at the moment copies some data on /tmp/.. folder on db server and then run db scripts. These scripts make some ddl changes and some record updates. Now with rac implementation, these scripts will be run on one of the rac node(instances), so do I need to run these ddl scripts/record updates scripts on other node in oracle rac or oracle rac would take care of this automatically.
View 1 Replies
View Related
Sep 19, 2013
RHEL 5.811gr2.
I have two node RAC on a test server. I have installed database software but it failed with an error that OEM could not be installed. Now I need installing Enterprise manager.
View 9 Replies
View Related
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
Oct 12, 2012
Version: 11.2.0.2/RHEL 5.4
I was under the impression that you need only one UNDO Tablespace for each instance. But , for our 2-node RAC, I can see three Undo tablespaces.
SQL> select tablespace_name,status from dba_tablespaces where CONTENTS = 'UNDO';
TABLESPACE_NAME STATUS
------------------------------ ---------
UNDOTBS1 ONLINE
UNDOTBS2 ONLINE
UNDOTBS3 ONLINE
SQL> select distinct inst_id from gv$session;
INST_ID
----------
1
2
$ olsnodes -n
thclst214 1
thclst215 2
View 2 Replies
View Related
Oct 2, 2013
Grid Version: 11.2.0.3 OS: Red Hat Enterprise Linux 5.6 Node2 of our two node RAC got rebooted. Upon reboot, CRS and ASM instance came up. But the DB didn't come up. How can I check if DB is linked to CRS startup ?How can I enable DB startup upon CRS startup ?
View 3 Replies
View Related
May 29, 2013
My client asked me to "apply the newest patch" on his RAC 10.2.0.5 environment on Windows.
I've downloaded 10.2.0.5 Patch 20 (the newest version).
My question is: Should i apply it using OPatch to both: ORACLE_HOME and CRS_HOME? or only in ORACLE_HOME? What with 10.2.0.5.2 CRS Patch? Should i apply earlier CPU patches?
View 1 Replies
View Related
Dec 17, 2012
What are the RAC DBA daily(routine) tasks?
View 6 Replies
View Related
Apr 6, 2013
I have installed Oracle RAC 10g on Redhat Linux 4.0. Till yesterday failover was happening that is when i stopped one instance on node01 the vip of node01 was transferred to node02.This was shown using ifconfig -a but now that is now happening.
Below information is given:
[oracle@node01 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.hitesh.db application ONLINE ONLINE node02
ora....h1.inst application ONLINE ONLINE node01
[Code]....
[root@node01 oracle]# ps -ef | grep lmon
oracle 5741 1 0 12:07 ? 00:00:03 ora_lmon_hitesh1
root 22582 20805 0 13:01 pts/2 00:00:00 grep lmon
oracle 23643 1 0 11:58 ? 00:00:01 asm_lmon_+ASM1
View 5 Replies
View Related
Aug 30, 2013
Unable to start the crs in one node, totally it's four node rac and Database version - 10gR2?
View 2 Replies
View Related
Jan 24, 2013
I am wokring on oracle 10.2.0.4 rac 2 node instances on AIX. We have one table having multiple rows defilning jobs will be done by users ...the functionality is that ..when even one user will pick on row (job) , one update statement will issue and it will update status column to 1 which menas job is allocated , this means now this should not allocate to any other user ..
but we are facing issue that once any user will pick that job , in application log files we can see that row gets lock and updates the status to 1 . but then also users connecting to other or some time same instance will get that job...means multiple users can pick same job .. even after already picked by another user ..
Is this can be issue with rac configuration ... like whenever one user updates a row ..it will be in cache of one instance and when another user trys to again update 2nd instance does not have that information and allows user connected to that instance to pick that job..like delay in block transfer or cache fusion..
is this can be issue with rac or it is purely application issue..
View 3 Replies
View Related