Patrick, Here is a KB article on the subject that includes a discussion configuration and a reference to the cleanup script for the indexes.
https://kb.bmc.com/infocenter/index?page=content&id=KA406947 Oh, and Fred.... I notice you need the 11.2 Oracle clients not just 11g. (see what reading the actual details of the docs points out....) And finally, yes, it talks about cursor sharing EXACT and the recommendation is for cursor sharing FORCE... YES, this is a conflict. FORCE is a better cursor sharing mode for AR System and that is still true. HOWEVER, if you set the sharing to FORCE, case insensitivity really doesn't work correctly. It does with cursor sharing set to EXACT. So, to get full and complete and always cursor sharing, I strongly recommend that you use EXACT as the cursor sharing. This does mean that you need to deal with the performance impact on the system that using EXACT vs. FORCE generates. This can be mitigated to a reasonable degree by giving your DB more memory. NOTE that is the DB not AR System. Giving the DB more memory for its working space helps overcome the performance penalty of the EXACT mode vs. the FORCE mode. NOTE: Full support is in the 8.1 and later releases of the AR System (you don't need 8.1 apps, just 8.1 AR System). NOTE: Before 8.1, if you have the right DB, and all the right settings (you can override things using triggers or the ardb.conf file, and you build all the indexes right and do all the maintenance of them (since we don't do that until 8.1), you may be able to get this to work. Best to upgrade to 8.1 server as it is a lot of hassle and work to do it all yourself. I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Friday, January 17, 2014 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle to MSSQL ** There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Do I request those scripts from BMC or is in the docs and installation package already? On Fri, Jan 17, 2014 at 12:19 PM, Mueller, Doug <doug_muel...@bmc.com<mailto:doug_muel...@bmc.com>> wrote: ** Fred, The 8.1 release of the AR System requires Oracle 11g. So, 11g and later has everything. Now, Oracle has been doing things for years and closing in on this issue. They have added partial support and some conditions. But, until now, we have not had success with finding all the right settings and configuration and options to make the capability completely work. There are special indexes to build (we do that for you for all new indexes and you have to do a cleanup script to convert any existing indexes to the new type) for indexed searches to work and with the right settings of options all other comparison operations work. Doug From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>] On Behalf Of Grooms, Frederick W Sent: Friday, January 17, 2014 9:16 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Oracle to MSSQL ** Doug, When you say "final completion of the work by Oracle has solved the case insensitive difference", which Oracle version/patch level are you referring to (so I know what version we need to get Oracle up to)? Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Friday, January 17, 2014 10:52 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Oracle to MSSQL ** Tommy, BMC has customers on both Oracle and MS SQL in significant numbers. UNAUDITED but from what we see, the most used database is MS SQL (maybe 60% and then Oracle in the say 30% or a bit more range and others in the less than 10%). Smaller customers are much higher on the MS SQL side. Enterprise customers tend to be more heavily on the Oracle side. The Remedy On Demand (the SaaS offering) system runs on MS SQL for all customers. The capabilities of the database are in the same ballpark - the 8.1 release of the AR System and the final completion of the work by Oracle has solved the case insensitive difference and Oracle finally has full case insensitivity option like SQL Server has had for years which closes the main functional difference between the databases. In general, decisions are made based on in house expertise with a database - a lot based on what other products they are using use as the database. Hardware things are on is an issue of course given that MS SQL runs only on Windows. Either database will do a good job for you. BMC has large customers on both databases with large data volumes (millions of records) and large number of users (thousands of concurrent users). I hope this is useful, Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Tommy Morris Sent: Friday, January 17, 2014 8:25 AM To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Oracle to MSSQL ** AR 7.6.4 I am looking to switch from Oracle to MSSQL and when I asked my DBA manager what the cost of the SQL license would be he fires back this. "My first concern is when we talk to Remedy what is their breakdown of what % of people use what database? Secondly what is the expected size of the db and the expected usage?" Has anyone else had to perform research on the global database preference of Remedy implementations? As far as the expected size and usage I'm just going to tell him to look at the current Oracle db. This guy is not going to budge on a move or even a discussion of getting Remedy off of Oracle until I can tell him that other companies use MSSQL. The data doesn't even have to be real current. Tommy Morris _ARSlist: "Where the Answers Are" and have been for 20 years_ _ARSlist: "Where the Answers Are" and have been for 20 years_ -- Patrick Zandi _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
