Hi,
You need the oracle binary/executable. You can get those from the patch
download site.
Why not do a new installation and then use the AR API to copy your data
over between your servers? You can even install the two instances on the
same server. Move your license from the old to the new server and then do
the transfer.
You can use the RRR|Chive tool to copy your data over. You can do
incremental data transfers with RRR|Chive if you have lot's of data and
want to avoid downtime. For the incremental transfer you will need to get
temporary licenses to allow both servers to be active simultaneously.
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia:
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
* RRR|Translator - Manage and automate your language translations.
Find these products, and many free tools and utilities, at http://rrr.se.
> I think you missed the biggest piece ... you need the Oracle version
> of ARS installed.
>
> On Jan 29, 2008 9:21 AM, Model, Igor [ITSUS Non J&J] <[EMAIL PROTECTED]>
> wrote:
>> Hi Listers,
>>
>> I wonder if someone out here has done this before:
>>
>> We need to switch ARSystem application server connection from the local
>> SQL Server to Oracle dB running on the remote box.
>> To accomplish this we've done the following:
>> - installed Oracle client on the w2003 sever that hosts ARS
>> - added environment variables:
>> ORACLE_HOME
>> TWO_TASK
>> TNS_ADMIN
>> ORACLE_SID
>> -added ORACLE_HOME\bin directory path to the PATH variable
>> -modified ar.cfg file by removing SQL references and adding Oracle
>> references as following:
>> Db-Character-Set: UTF-8
>> Dbhome-directory: =path to local Oracle_Home
>> Oracle-SID: =dB instance name
>> Oracle-Two-Task: =dB instance name
>>
>> I can tnsping Oracle dB from the application server that hosts ARS as
>> well as SQLPlus Oracle dB directly from the ARS box, however, can't
>> start the ARSystem process - getting error 551 "Cannot initialize
>> contact with SQL database (ARERR 551)"
>> Something is definitely missing, but can't figure out exactly what is
>> it.
>>
>> Environment:
>> Windows Server 2003
>> Oracle 10g Unicode
>> ARS 7.0.1 Patch 5
>>
>>
>> Thanks in advance for all your advises.
>>
>> Igor Model
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
>
> --
> This message was scanned by ESVA and is believed to be clean.
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
