Scan In 4 Node Cluster
Jun 24, 2013We are going to setup a 4 node rac cluster. So i think we need to configure only one SCAN with 3IP's. And how the scan listeners are configured on these 4 nodes.
View 1 Replies
ADVERTISEMENT
Real Application Clusters :: Reallocate Scan Listener And Scan Vip In 3 Node Rac?
Apr 9, 2013We are using oracle 11.2.0.3.0 with 3 node rac. Earlier 3 scan vip and 3scan listener running on each node.But we found recently node1 running using 2vip and 2scanlistener and in node2 1vip and 1scanlisteners were running.but no longer running scan vip or scan listener in node 3. If i decided to reloacate the scan vip/Scan_listener to node3 from ndoe 1 using below command,does it cause any impact on my transcation?
$ srvctl relocate scan -i 2 -n node03
$ srvctl relocate scan_LISTENER -i 2 -n node03
find the below details
$ bash
bash-4.2$ srvctl status scan
SCAN VIP scan1 is enabled
[Code]....
RAC/ASM Clusterware Installation :: Query On Adding New Node To Existing 2 Node Cluster
Jun 15, 2012current environment
Oracle VM 2 Node RAC cluster
Oracle 11G 11.2.0.3.0
Oracle 11g rel 2 GI
on current 2 node cluster we have GI and RAC db configured Nodes: vmorarac1,vmorarac2
we shutdown vmorarac1 to clone it to vmorarac5
on new node I have changed the hostname to vmorarac5 In /etc/sysconfig/network-scripts/ifcfg-eth0 change ip to new ip and same for /etc/sysconfig/network-scripts/ifcfg-eth1 152.144.199.210,152.144.199.211
mad echanges to /etc/hosts on vmorarac1/2 for 2 new IP address assigned to vmorarac5
152.144.199.171 vmorarac1.pbi.global.pvt vmorarac1
192.168.2.30 vmorarac1-priv.pbi.global.pvt vmorarac1-priv
152.144.199.184 vmorarac1-vip.pbi.global.pvt vmorarac1-vip
[Code]....
Query is is that all ok to reboot the new node to reflect changes as below and change the hostname to vmorarac2
152.144.199.210 vmorarac2.pbi.global.pvt vmorarac2
192.168.2.32 vmorarac2-priv.pbi.global.pvt vmorarac2-priv
152.144.199.211 vmorarac2-vip.pbi.global.pvt vmorarac2-vip
hostname change in /etc/sysconfig/network
On new node vmorarac5, there is alreay software for RAC DB and GUI cloned from vmorarac1
addnode.sh is used to add existing node, but as part of pre-requisite configuratoin is there any config step missing
Add Third Node To Existing Two Node Cluster
Feb 3, 2012I'm trying to add the third node to my existing two node cluster. In fact i succeded adding the node but i have the following problem:
-when i start node 1 and 2, everything is ok, but on node 3 startup one of the other nodes fails
-this happens in any combination: start 1 and 3, everything is ok. when i start node 2, node 3 fails
The asm configuration (disks, permissions, etc) is the same on all three nodes.find below the asm and crsd log details from the failure time:
alert_ASM.log
NOTE: enlarging ACD for group 1/0x124851d1 (DATA)
WARNNING: cache read a corrupted block group=DATA dsk=4 blk=1 from disk 4
+NOTE: a corrupted block from group DATA was dumped to /u01/app/oracle/diag/asm/+asm/+ASM3/trace/+ASM3_rbal_4109.trc+
WARNNING: cache read(retry) a corrupted block group=DATA dsk=4 blk=1 from disk 4
[code]...
Adding New Node Back To Cluster Via Documentation
Apr 10, 2012I have a 3 node RAC server on Windows Server 2008. Last week the hard drive went out on one of the nodes and I have had to rebuild as I could not recover anything.
I went through and deleted the old node and now I have just finished adding the new node back to my cluster via documentation. Once I created the new instance on that server DBCA attempted to start and it failed gaving me a crs error. I found out later that the other 2 nodes went down and the new one that did not start correctly was the only one up!! I went and stopped the new instance and restarted the first 2. The associated services did not start with the instance so I had to start each manually. The trace files show an ORA-29702 error with cluster group service and the instance being stopped on both of the existing nodes. No other error messages stood out.
Now I cannot get any crs services to start on that 3rd node even if I attempt to start manually. I have also tried stopping all and restarting and that does not work. I found another post on this forum from you and followed it. The ASM service was fine the entire time through all the logs and I don't know how to verify LMON in Windows but I didn't see any LMON errors in the alert log. Also, the voting disks are online. Each node has their own and they are mirrored. Where else to look?
Data Guard :: How To Find Apply Node In RAC Two Node Standby DB
Aug 16, 2013I believe, in a multiple RAC Physical Standby nodes only one node applies the archivelogs to the standby database. How you can find which node is the APPLY NODE using a SQL query?
I know you can veiw this information by querying the standby configuration using DGMGRL but how would you find out this information from a remote client using SQLPlus/PLSQL?
RAC & Failsafe :: Migrating Single Node Database To New 2-node Environment
Jan 24, 2011We have oracle database 10g(10.2.0.4) running on AIX 5.1. we have installed 2-node RAC on another server AIX 6.1 . Now we want to migrate our single node database to new 2-node rac environment. how we can move/migrate/cluster-aware our single node database to 2-node rac?
View 3 Replies View RelatedRAC/ASM Clusterware Installation :: VIP Node Application Failing In Second Node
Jul 18, 2013I am installing Oracle 10g Clusterware in RHEL 5 Server. When i run root.sh in the second node the last step Running vipca(silent) for configuring nodeapps failed. Then i run VIPCA manually in second node and configured vip configuration successfully,but when i checked the post-checks for cluster services the Checking existence of VIP node application,Checking existence of ONS node application and Checking existence of GSD node application in second node failed. I am able to ping both the servers one another with vip name successfully and the CSS,CRS and EVM appears healthy in both nodes. 1. Does the vip configuration is proper? If no what is causing this error and how to rectify it? Find the output below
[root@Rhel52 bin]# ./crsctl check crsCSS appears healthyCRS appears healthyEVM appears healthy[root@Rhel52 bin]#[root@Rhel52 bin]# clear[root@Rhel52 bin]#[root@Rhel52 bin]# ./crs_stat -tName Type Target State Host------------------------------------------------------------------------------------ora.rhel5.gsd application ONLINE ONLINE rhel5ora.rhel5.ons application ONLINE ONLINE rhel5ora.rhel5.vip application ONLINE ONLINE rhel5ora.rhel52.gsd application ONLINE ONLINE rhel52ora.rhel52.ons application ONLINE ONLINE rhel52ora.rhel52.vip application ONLINE ONLINE rhel52 [root@Rhel52 bin]#./runcluvfy.sh stage -post crsinst -n
[code]....
RAC & Failsafe :: Single Node RAC - Configure Only One Server Instead Of Two Node?
Sep 13, 2012 I would like get more details about single node RAC.. What is single Node RAC?..
1). just configure only one server instead of two node... same RAC installation.. cluster installation and shared disk configuration in single server itself.. in future we can add node to this ...
2). in 11gR2 having new feature Single Node RAC.. Multiple instances running on same node and configure using Cluster...
is there any advantage using single node rac(other than online upgrade to full RAC).
RAC & Failsafe :: SCAN IP For Oracle 11g R2?
Sep 1, 2011I am planning to install oracle RAC 11g R2 on RHEL 5.3. I have 2 RAC nodes and one openfiler NAS. I need to understand how will I configure SCAN IP. Do I need to configure it some where in DSN and OS level or just I need to give this IP and SCAN name while grid install and oracle will create these things?overall steps to configure this or direct me to some documentation where this thing is detailed.
View 6 Replies View RelatedTable Scan From The Application?
May 21, 2013We have an application where delete statement is taking a long time ( 30-40 seconds).v$session_longops shows the sql statement is doing a full table scan. The statement is "delete tablename where column_name =:B1". The table is indexed and the indexed column is being used in the where clause. When I do an explain plan on the same statement with a value for column_name, it uses an index scan. The table has 9 million rows and the delete statement deletes 15 rows. Not sure why SQL when running through the application does not use index. The stats are current.
View 11 Replies View RelatedLocal Index Scan
Nov 17, 2012if i have local index, does query which uses this index always have to scan all partitions?
For example, I have hash-partitioned table on column A. There is local index on column B. I am querying:
select * from my_table where A='ABC' and B>123.
I know that records with A='ABC' are in 2nd partition. Does only 2nd partition of local index will be scanned or all of them must be scanned?
Getting Query To Do Full Table Scan?
Aug 18, 2012I�m Using Oracle 11.I have a table with 16 million rows and an index (let's call it the employee table with an index on department). I need to select all the employees whose departments are located in the uk. I achieve this by selecting all the department numbers from departments where location = 'UK' in a sub select then plug this into the main query as follows:
SELECT *
FROM employees
WHERE department IN (SELECT department from departments where location = 'UK');
It takes ages, 25 seconds or more, the explain plan shows its doing a full table scan on emplyees. I need it to use the index. The sub query is instant and returns only 5 rows. If I explicitly put the 5 numbers in the IN clause the query uses the index and executes in 0.04 seconds. See below:
SELECT *
FROM employees
WHERE department IN (1,2,3,4,5);
I need it to use the subquery once and then use the index on the main table.
Forms :: How To Scan Pics Using Oracle
Jul 8, 2012I need to create a form that will enable me to scan pages and save it into a specified folder using the scanner connected to the PC.
View 1 Replies View RelatedPerformance Tuning :: Row ID Range Scan
Dec 19, 2011I want to make full table scan of my query so that I can execute it using parallel option & the query will get completed in few mins. Even though I used this hint "/*+ parallel(t2,4) full(t2) */, the query is executing with 8 parallel processes but it is going for "Rowid Range Scan" and it is taking more time to complete. How to make this query to go for full table scan instead of "Rowid Range Scan" so that this query can be tuned.
SELECT /*+ parallel(t2,4) full(t2)*/ID, COUNT (1) FROM acnt_transact t2 GROUP BY ID;
Forms :: Image Scan In Oracle 6i?
Sep 19, 2010scan image from Oracle Form Builder 6i and store the image location in the oracle 9i database. Here important issue is we just store the image location in the database not the image. We'll store the images in a storage device and store the location path in the database. And retrive the image from storage device using the path.
For example: User Scan the image using Form builder 6i then save the image like 1001-DPS-1.jpg in the default location like D:Image.. And in oracle 9i database data save like : 1001 DPS 1 D:Image1001-DPS-1.jpg User_Name Sysdate
Data save automatically in the database when image scanned and saved in physical drive. This is our main purpose.
Is it possible to solve this task using Oracle 9i and Developer 6i?
Enterprise Manager :: Why Scan Address Used In OEM
May 1, 2012I am an OEM Gird Control 11g server with Oracle 11.2.0 running on OEL 5.3
I also have 2 node RAC cluster running Oracle 11.2.0 on OEL 5.3. I have installed OEM Agent on nodes of this cluster. I can see them on OEM Grid Console. When I check the configuration of the Database Instance GTRD1 (one of my target instance)I can see that the "Listener Machine Name" is the management IP address of target database server. Similarly Database Instance GTRD2 has the management IP address of target database server. When I click test conenctions it works. This is without entering any reference to this server/IP address in /etc/hosts file.
But when I select targets->all targets->Database Instance GTRD1 and then try to access performance tab, it does not connect. I get this error "The Network Adapter could not establish the connection"
Looking at the "emoms.trc" I find the follwing
2012-04-30 14:02:12,071 [EMUI_14_02_12_/console/database/instance/sitemap] ERROR perf.sitemapPerfChart logp.251 - java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))java.sql.SQLException: The Network Adapter could not establish the connection
The Connect Descriptor was (description=(address=(host=GTRD-scan.GTRD)(protocol=tcp)(port=1521))(connect_data=(service_name=GTRD1)(instance_name=GTRD1)(UR=A)))
But when I enter the scan address in the /etc/hosts as "112.5.14.154 GTRD-scan.GTRD" Then everythign work works.
NOTE: 112.5.14.154 is GTRD1 server and 112.5.14.155 is GTRD2 server
Now my questions are:
1. Do I must enter scan address/ref "GTRD-scan.GTRD" in /etc/hosts?
2. Is there are way to change it to use hostname or the IP address?
3. If I am to use scan address, then how I refer to the other IP address in hosts file?
SQL & PL/SQL :: Difference Of Unique And Range Scan
Mar 11, 2010diff of unique scan and range scan?
View 1 Replies View RelatedRAC/ASM Clusterware Installation :: Can SCAN IP Be Used For Ftp Of Files
Sep 25, 2013I would like to know, if SCAN IP can be used by clients or applications to FTP files to either of the database nodes?
View 3 Replies View RelatedUse Scan Name In Tnsfile - Not Able To Connect To DB Through JDBC Connection?
Aug 4, 2010I have installed 2 node RAC -11gR2 on ORACLE VM Server 2.2.1.now, I want to give tnsentry to my dev team to use this RACDB going forward.I am using scan name in tnsnames.ora file. Also I have make scan name entry in /etc/hosts not in the DNS.
I have below entry in RACDB server...
RACDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = RWCORA-cluster-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
now just for testing purpose, I added this tnsentry in my machine to check the connectivity.I have to add scan name with IP address in /etc/hosts --. and try to connect sqlplus sys@rwcdb as sysdba --> not workingI have to add scan name with IP address , and two RAC VIPs (of both nodes) in /etc/hosts -- and try to connect sqlplus sys@rwcdb as sysdba --> then its working...but again SQL*Developer is not able to connect.
I have make below entry in my machine's /etc/hosts file:
10.40.0.51 RWCORARAC1-vip
10.40.0.52 RWCORARAC2-vip
10.40.0.50 RWCORA-cluster-scan
perfect link through which I can connect OCI, JDBC connection from client side.
Forms :: Scan Image From Oracle 10g By Using Scanner?
Dec 11, 2012i need scan image from oracle forms 10g by using scanner.
View 2 Replies View RelatedServer Administration :: Use CSSCAN To Scan Through Database
Mar 18, 2012Since the past, our developer uses this command
"update props$ set value$ set = 'ZHS16GBK' where name='NLS_CHARACTERSET' ;" and
update props$ set value$='WE8MSWIN1252' where name='NLS_CHARACTERSET';
to update the sys table which is not supported by oracle.
However, I decided to use CSSCAN to scan through the database and see if the new character set will work.But before using CSSCAN, I will like to know which character set to set back as our developer does not know which is the original character set.
Real Application Clusters :: ONS Configuration For Scan?
Oct 4, 2012We 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 RelatedPerformance Tuning :: How To Force SQL To Use Index Range Scan
Jul 15, 2011How can i force a sql use index range scan?
View 10 Replies View RelatedPerformance Tuning :: How To Keep RANGE SCAN Even After Adding New Conditions
Aug 29, 2011I am adding condition in color to my existing query but my query taking too long time after that. This condition calculates last 3 month end dates from given COB (20110516).
SUMMARY is my summarized table and COB is my reference table
Without adding condition in query it gives
INDEX (RANGE SCAN)--PK_SUMMARY(INDEX(UNIQUE))
After adding condition in query it gives
INDEX(FAST FULL SCAN)--PK_SUMMARY(INDEX(UNIQUE))
how can i keep RANGE SCAN even after adding my new conditions?
SELECT
distinct
COB.COB_ID_C,
SUMMARY.SUMM_COB_ID_C
FROM
[code]...
Performance Tuning :: Force Index Unique Scan?
Jun 14, 2012Is there any hint to force "Index Unique Scan" over "Index Range Scan".
My query is generating different plans with the above two, and very slow when it uses "Index Range Scan".
Forms :: FRM-41344 OLE Not Defined For SCAN In Current Record
Jun 1, 2010my problem is this that i have developed a form.fmb in 6i for images scanning direct from scanner but its generating error something like that "FRM-41344 OLE not defined for SCAN in the current record"
li have a winxp enviroment i have already downloaded and installed "IMAGING FOR WINDOW"(GLOBAL 360) but despite this its not working same error is still there .
one more thing why imgscan.ocx is not registering in winxp.
Real Application Clusters :: Password For Scan Listener
Aug 17, 2012How to set the password for SCAN listener in 11gr2 ?
View 9 Replies View RelatedPL/SQL :: Number Range Query Causes Repeated Scan By Index
Oct 16, 2012I have a query that seems to repeatedly call an index scan on a table for reasons I'm not sure about. Why it would be doing the index scan on totaldwellingarea in the dimensions table (DIMEN_PID_TDWELLAREA) repeatedly? This only seems to happen when I put on the range clause d.totaldwellingarea between scr.lowvalue and scr.highvalue.
I am using Oracle version 9.2.0.3.
select d.propertyid,d.totaldwellingarea, e.size_, scr.size_
from eqid e, dimensions d, brt_eval.size_code_ranges scr
where e.style not in ('1','A','G','L') and e.size_ = '0'
and d.propertyid = e.propertyid and e.style = scr.style and d.totaldwellingarea between scr.lowvalue and scr.highvalue;
CREATE
TABLE "BRT_ADMIN"."EQID"
(
"PROPERTYID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"EQID" CHAR(10 BYTE),
"ZONE_" CHAR(1 BYTE),
"AREA" CHAR(1 BYTE),
[code].....
Rebuild Local Index Partition Is Using Full Table Scan
Apr 23, 2012I am rebuilding some UNUSABLE local index partitions on Oracle 8.1.7.4.0 (64bit) database . The platform is a HPUX machine.
The DDL of the partition table/indexes:
=========================
CREATE TABLE TESTME
( INST_NO CHAR(3) NOT NULL,
ACCT_NO CHAR(16) NOT NULL,
REC_NO CHAR(9) NOT NULL,
TRAN_TYPE CHAR(2) DEFAULT ' ',
STAT CHAR(2) DEFAULT ' ',
[code]...