Oracle workload replay client error

Does anybody have an uncountered error during replay in enterprise linux x64 wrc client, rac database version 11.1.0.7?If yes, what are you doing to resolve this problem?Windows client crashed when starting replay (under windows xp sp3, windows server 2003/2008).Only in incident folder exist informa ...

NetWorker/Oracle on AIX Problem

Please help me with this case:I can perform a tar to this device and also a "save " with Legato.If I run my RMAN script pointing to a disk device, it works fine ;but if I run my RMAN script pointing to a tape device using 'SBT_TAPE', itdoesn't works.... that's the problem.I am using:NetWorker Module ...

Oracle Database Node Spec

Guys,Need to some rough inputs on my database sizing requirement:Need to build Oracle 11g dB with year 1 size of approx 470 TB ( with backup maintained for 4 years on seperate server - 4 * 470 TB)Initially write intensive system...year 2 onwards will be read/write...Plan to use RAC, Exadata Storage ...

8i client to 10g rac server

Is it possible to connect an oracle 8i client to a 10g server running rac? We have some clients running some 8i clients that cant be upgraded. ...

Instant client support for oracle rac ?

My questions is does instant client support rac ?example : tnsnames.oraRAC =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = DB1-VIP)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = DB2-VIP)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = RAC)(FAILOVER_MODE =(TYPE ...

configuring oracle OCI client for RAC 10.2.0.1

can any one give the links for doc for configuraing oracle OCI client for RAC ...

Oracle Client requirment for 10g RAC

We are planning to deploy Oracle 10g RAC on itanium Cluster. What is the Client and its version requirement to take full advantage of 10g RAC load balancing/fail over ?ShanmuIndia. ...

Oracle Does 8i client support load balance connection on 10g RAC?

We will migrate our server to Oracle 10g with RAC and ASM.On the other hand, our client machines are using Oracle 8i.Does 8i support load balance connection on 10g RAC server? ...

Oracle rac & client connection

i have 3 nodes of 9204 RAC under rhel 2.1SQL> host lsnrctl statusLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 19-FEB-2007 10:53:44Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac1pub)(PORT=1521)))STATUS of the LI ...

Oracle [urgent] 10gR2 RAC Load Balancing Configuration (client and server side)!!

An oracle engineer working with me created a RAC database 10gR2 by runninga database creation script, not DBCA that is recommended from oracle in creating a RAC database. The following is from oracle."http://download-west.oracle.com/docs/cd/B19306_01/rac.102/b28759/configwlm.htm#CHDJIAJH#CHDJIAJH"Th ...

Oracle java thin client with 10g rac db and failover ability

Our devs want to use java's thin client. If they copy in the string for the database in question from the tnsnames.ora, pretty much as is, will failover work? Has anyone confirmed failover in rac works with java's thin client. I'm not an expert in either...just enough knowledge to do what I need to ...

Oracle client connect to RAC

question about client connect to RAC, O connect to one sevice name or load balance to all node? ...

Oracle How does client connect to RAC

I'm confused how client connect to RAC,1) According to this:http://www.datadirect.com/developer/odbc/odbc_oracle_rac/connecting/index.ssp"a ServiceName exists for the entire Oracle RAC system. When an application uses the Oracle RAC system's ServiceName, the Oracle RAC system appears to be a single ...

configured TNS in oracle client to RAC database

I have a 4 nodes oracle RAC in radhat 5.0both oracle database and client as 10.2.0.4.I created a TNS that works in our office but it does not work in our remote brance office.Based on experts instruction, I set up sqlnet trace at client side. but not any file that be gererated.In linux RAC database, ...

Oracle ?? ExaData V2 - Smart Scanning, Flash Cache, RAC, Documentation, POCs ??

- Few questions on eXaData V2 - 1. Smart Scanning As we know, this feature does filters, predicate evaluations, and join filters at storage cell level.a. How do we confirm that query uses smart scan feature ?b. Do we have any specific views that we can query to find out this feature related informat ...

Oracle RAC or Exadata?

I understand that the exadata is primarily aimed at performance and RAC is for high availability. From performance point of view, what should be the criteria to select between RAC or Exa Data for OLTP? ...

Oracle Exadata - RAC - ASM

I recently joined a compnay where exadata is in impementation phase. Here RAC is also implemented. I am new on both this technology but I have to start learning both the technology with a good pace. We are getting some problem with loading the data also. But I do not hv so experience to find out the ...

Oracle Exadata without RAC?

It is possible in a Half Rack of Exadata, configure two nodes on Cold Failover, ie have an active and a passive node without using Oracle RAC? Or this is not supported by Oracle? ...

RAC on ORACLE EXADATA??

All,Is any body install RAC on ORACLE EXADATA?I just want to know the differentiate between RAC installed on ORACLE EXADATA and RAC installed on one high end machine like 24 cores Xeon,128G, VT-x supported. ...

Oracle TNS-12518: TNS:listener could not hand off client connection (RAC)

I've installed Oacle RAC (11.2.0.1.0) w/2 nodes in Linux: RH 2.6.18-238.9.1.el5.[oracle@srv267 bin]$ crsctl check hasCRS-4638: Oracle High Availability Services is online[oracle@srv267 bin]$ lsnrctl statusServices Summary...Service "+ASM" has 1 instance(s).Instance "+ASM1", status READY, has 1 handl ...

Oracle rac one node client

We have rac one node implemented on windows 2008. We are testing the failover from client side . When we tried to relocate the instance from one node to other node, oracle client delays the connectivity for the relocation duration and takes up the connection immediately and automatically , but in th ...

Oracle connect to 10g RAC over JDBC thin client

I'm trying to connect to multiple Oracle 10g databases (failover) over the JDBC thin client, and when I run the following, I get: java.sql.SQLException: Io exception: NL Exception was generated connection = DriverManager.getConnection("jdbc:oracle:thin:@DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROT ...

Oracle Tradeoffs of 8i vs. 9i client against 9i RAC Database

Using the Oracle thin drivers to talk to a 9i RAC database, which drivers would work best with connect time failover? Are there any major reasons to not stay with the 8i drivers? ...

Oracle TAF between Server and client in RAC in Windows (64-bit)

I think not configured properly i dont know, but the comm between client and server is not happening properly. TAF is not working in (2-node) server.Could any body post the correct configuration for TAF for production environment ...

Oracle RAC vip started from second server but not able to ping from client

i have oracle cluster 10.2.0.4 on windows 2008 server, when my first server down the crs able to start the vip from the second server and it is pinging from its own , but from my client where my application are it is not pinging , throwing request timed out.any help please. ...

Oracle Flash Cache (11G, not Exadata) utilization by RAC?

- I'm testing out the 11.2 Flash Cache feature on a 2 node RAC cluster. As near as I can tell (I'm hoping someone knows), it appears that blocks residing in flash are not shared out to other nodes as part of the "fused" cache. To be as clear as I can, if Node 1 has a block in regular DB cache, and t ...

JDBC connection to Oracle 9i RAC

We are migrating from Ora 8.1.7 to 9i RAC. Our Java app currently connects to the 8.1.7 db via the oracle JDBC thin driver. In the process of migrating to 9i, I installed the Oracle client for 9i on my WinNT machine. Having done that, I cannot get SQL Plus for 9i to connect to the DB. SQL Plus fails ...

Testing Oracle10gR2 RAC Installation on Windows with minimum & low price hardware

I have two latest desktop pc (P4) with two LAN cards andone hard disk 80Gb each. One Switch and cables for interconnection. I also have a Laptop for client purpose. I want to install Oracle 10gR2 RAC for learning purpose and have not any extra shared storage device. Using these three computer's, can ...

Oracle RAC. Various interesting errors...

I have an intersting problem that I cant seem to be able to solve. Ive tested about all I can think of so I hope you can come up with what I have missed.What do I want to do:Connect from php to an oracle database. This is running on a rac consisting of 3 nodes. Pretty straight forward i would have i ...

Client or server? Load balancing in database systems.

I'm new here, so welcome First of all, sorry for my English. I hope that it would be able to understand what I'm writing.I'm writing master thesis at the end of my studies. The subjest of this thesis is 'Client or server? Load balancing in database systems.' The main problem is that I cannot find ma ...

Oracle 9.2.0.2 OCI/JDBC-Client with 9.2.0.1 Database

are there any known problems using the oci/jdbc client of oracle 9.2.0.2 (Linux/Itanium) with the 9.2.0.1 Database Server using the RAC-Option (HP-UX on PA-RISC)?Since our application servers run on Itanium and the database on PA-RISC, we are forced to use this combination.Thanks for any comment or ...

Oracle9i RAC+ Apache in 2 nodes system

I'm new to RAC, I setup a 2 nodes RAC system in Win2K using cluster file system. What is the next step I need to do if I want:1) Web app running in Apache server installed in both 2 nodes?2) How to configure in the client side?3) Load balancingIn single instance environment, I only need to point the ...

Oracle Internet Directory (OID) to Resolve RAC Databases

All,We currently use OID to resolve all of our 9i Databases. By configuring your SQLNET.ORA and adding a LDAP.ORA files, clients can utilize OID to do all TNS resolution through OID.Now, when entering in entries to the LDAP that is the foundation of OID, I am having trouble figuring out how to enter ...

Oracle RAC and FGAC

We are developing an application that requires both the use of FGAC and a RAC. We are hoping to leverage a middle tier and the client identifier, however, there is a small note in the 9i Application Developer's Guide that states "Global Application Context is not available in Real Application Cluste ...

Oracle How to connect to RAC with failover enabled?

I want to use instant client to connect to a RAC database. How can I accomplish that without tnsnames.ora file? ...

Oracle RAC Installation

I need to carry out an installation of Oracle9i RAC on Windows 2000 Advanced Server. The OS is already installed and clustering at OS level has also been configured.My senior tells me that OS level clustering on W2K has to be deconfigured(read that as disabled) before going ahead with this, since th ...

Oracle Connect to RAC Database without TNSNAMES (with failover)

I just started using the Instant Client. I am connecting to a 9.2.0.4 RAC database. I can connect to one node or the other without TNSNAMES using //host:port/service, but how do I connect with failover enabled (in TNSNAMES, I could specify the address list, failover settings, etc.). ...

Oracle tnsname for RAC

I am working on RAC.And I want to connect client to the database but I don't know the tnsname's parameter. I tried the normal way which is configuring the IP address and port number and SID and it didn't work. Please help if there is a different way to configure the tnsnames on RAC.Wessam ...

Oracle performance issue w/RAC ?

We have a two node OpenVMS RAC cluster on 9.2.0.5. When running a HTMLDB application, the following two statements are taking the majority of the time. Has anyone else seen anything similar?TIA - Eric--excerpt from tkprof output declarerc__ number;simple_list__ owa_util.vc_arr;complex_list__ owa_uti ...

Oracle 10gR2 RAC Database Connectivety Issue

I have built a two-node RAC database Cluster on Windows 2003. I set up a number client application servers and installed Oracle Client 10.2 to talk to a database on the cluster. Using an SQL Client connect is OK. However when I set up an actual application to use the cluster database I keep losing m ...

Oracle Syncronization across multiple nodes in a RAC environment.

We are currently developing an application to work against Oracle in a RAC (10g) environment. Our system does the following fairly often:Update a table, row, etc via fairly mundane PL/SQLNotify other applications (clients) that a change has occured via some sort of TCP connection (.NET remoting or M ...

Oracle switching jdbc drivers for RAC

The development team has been developing a web application for Oracle 9i using the 10g jdbc thin driver. As it turn out the thin driver does not work with Transparent Application Failover in RAC. The note below says just switch to the oci driver. Is it really that simple? Besides the obvious complet ...

Oracle utl_file_dir configuration on RAC problem

I have a 2 boxes with Oracle 9i using RAC.I have a instance inst1 on node1 and instance inst2 on node2, and INSTPROD as "virtual" instance.On inst1, utl_file_dir configuration is "D:\utlfile" and on inst2, utl_file_dir configuration is "D:\utlfile"The problem is that users are complaining that files ...

Oracle10gR2 - Is TAF useful for Client Application using Oracle ODBC Driver

I wish to configure TAF in my RAC setup but I found that TAF is useful only when Oracle OCI or JDBC Drivers are used by the client applications.I was going through the b14212.pdf (Net Services Administrator’s Guide for Oracle 10 Release 2). The page 194 states the following:"When there is a failure ...

Oracle client install on Windows Cluster

Is it possible to install Oracle Client (say 10g version) on WIndows Cluster (like RAC)?Essentially, I need this to support Linked servers and ODBC connections (to Oracle database) on Sqlserver database which is going to be clustered . I am exploring possibilities of Oracle client installation which ...

Oracle Client Failover in Data Guard Configuration

I managed to get a data guard configuration including a physical standby database up and running.What I now want to implement is a client failover mechanism. It's quite easy to adjust the tnsnames.ora to add more nodes for a specific SID but this only seems to work if the database is not available a ...

Oracle Backup software that WORKS with 10g RAC and ASM.

We tried ArcServe v.11, even upgraded to 11.1, with the Oracle client in hopes it would work with 10g in a RAC environment running on ASM in on Windows 2003. No luck. CA told us today they would be posting information today that it will not work. Question. Does anyone know of a backup solution, usin ...

Oracle JBoss/Hibernate/InstantClient/RAC

First, I have no experience with RAC. I have RAC on two machines with one storage and want to use with load balancing and TAF. On next machine I have JBoss AS where I connect to Oracle via Hibernate whith thin client. All connection data I have in hibernate.cfg.xml file, where I point one database f ...

Oracle JBoss/Weblogic+instantclient+RAC

My question is how should I configured JBoss and WebLogic with Instant Client (so without tnsnames.ora) to work with RAC (I'm going to use TAF). Which JDBC driver, oci or thin, is needed to work with RAC/TAF?Best ...

Oracle RAC configuration overview

I am new to RAC so please bear with me.A client has the following configuration2 * app servers2 * database serversSAN with live and test instances running.is this a RAC able system. the client is after redundancy for his system, to me it looks ok but could someone please confirm this. ...