Oracle

question about upgrade to 11gR2 RAC
Dear group, We are currently on Oracle 10.2.0.4 Oracle RAC on RedHat Linux. We are about to upgrade to 11gR2. According Oracle document, Prior to upgrading to Oracle RAC 11g, the Oracle Clusterware must be at least version 10.2.0.3 or 10.2.0.2 with CRS Bundle Patch #2 (reference Bug 5256865) if you would l... 24 Jun 2010 00:58

The Oracle ODBC driver story
What is the story with Oracle ODBC driver? Oracle is stubbornly shipping the driver that doesn't work with unixODBC shipped with the Red Hat distribution. I complained several times, never got any usable reply. The ODBC driver for Linux is still pretty much useless, unless you compile the newer version of unixO... 13 Jun 2010 22:40

Recommend SQL Server Book
Anyone can recommend a SQL Server (2008) book a long-time Oracle developer ? ... 10 Jun 2010 20:08

How to login to Oracle using Active Directory Account
Hi, I want that users can login to Oracle 10g without creating account in Oracle. I have to install a new server and want that my users can login using their AD-Accounts. I have Windows Server 2008 and dont wont to change the scheme if posible. I found only old pdf´s which describes how to use IDM. But I´m lo... 15 Jun 2010 16:30

Is there way to do Custom installation of 11gR2?
I was trying to install 11gR2 on AIX and couldn't find option for Custom installation. The Installer allows to choose Enterprise Edition (7.09 GB), Standard Edition (6 GB), or Standard Edition One (also 6 GB). In earlier versions I used Custom option to remove things like Enterprise Manager and to minimize size o... 9 Jun 2010 09:42

ORA-04031 errors and size of 'sql area'
We started getting ORA-04031 errors in a small 9.2.0.8. It happened for no apparent reason. The errors produced trace files (see below), while going through the trace I noticed following: - Only one sub-pool - this makes analysis much easier as it is possible to use V$SGASTAT/STATS$SGASTAT - Very small 'sql area' ... 8 Jun 2010 22:47

OLM Functional Lead - St. Louis, MO
OLM Functional Lead - St. Louis, MO Location - St. Louis, MO Duration - 4 months ROLE: OLM Functional Lead REQUIRED SKILLS: - Strong functional knowledge of Oracle Learning Management(OLM) - Analytic Ability - Experience in all phases of the product life cycle - Ability to multitask and meet tight time... 8 Jun 2010 13:41

Multiple Requirements
Hi, Greetings!!!!! Here are urgent requirements . Please check requirement and get to back me with up dated profiles as soon as possible. Requirement:1) Title: Data Architect(SAP MDM) 7-8 Years of relevant experience with at least 5 Implementation SAP experience with good Understanding of business envi... 8 Jun 2010 12:33

about nvl2 function
HI, sorry , I'm new to oracle world.. who could help explain following.. I expected following SQL would error out.. but I got following result. I don't understand, how date format string '1/1/2010' could convert to number .000497512, and how date format string 1-1-2010 could convert to number -2010? ... 9 Jun 2010 10:49

ORA-06502: PL/SQL: numeric or value error: character stringbuffer too small
On Mon, 07 Jun 2010 07:43:39 -0700, Sanjeev wrote: So, Is there any SQL datatype which will allow more than 4000 character so as to change data type of column 'LocDetail' in LocationDetail table. CLOB and LONG. LONG is deprecated, both types are a pain in the neck or lower. -- http://mgogala.byeth... 7 Jun 2010 21:03