Patrick,
Thanks for the response. I had success in the past doing exactly what you did on a Solaris and Linux server. Windows is turning out to be quite a
different beast.
Anyone out there with any Windows/Oracle experience? Do I set ORACLE_HOME,
ORACLE_SID environment variables?
Other than my initial troubleshooting, I downloaded and installed the full
client in a separate directory.
Again, the install runs, creates ARSystem schema, but then I get the following
error when attempting to import workflow:
ORA-12154: TNS:could not resolve the connect identifier specified
The only thing in my ar.conf file that is DB related is the following:
Oracle-Two-Task: devdb01
Russell
patrick zandi wrote:
**
On my solaris installations, I always used an seperate oracle Full
Client install and into a different home.
Then I check and make sure the TNSNAMES.ora is the same as the oracle DB
home. so I can make connections.
Then I sqlplus from the client into the Oracle db, and check that..
Then I do an install..
Now I do not know your 64Bit env and how it fuction with the 32 Bit
Oracle client, or ARS 32 bit on the 64 Bit OS..
Check the Archives.. of the list.
Hope this helps some.
On 1/26/07, *Russell Wurth* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
**
All,
I am attempting to set up a Windows Server 2003 (64 bit) with Oracle
10g and ARS 7 on the same box. I am looking for any assistance from
anyone with a similar configuration. I have performed installations
on various UNIX platforms many times before, and a few Windows 32
bit ones, but never Win 64bit.
The 64bit Oracle installation did not create an ORACLE_HOME\lib32
directory, just a regular lib directory. The Remedy install would
not proceed, so I downloaded and installed the 32bit Oracle Instant
Client and installed it in the lib32 directory. The Remedy install
found this directory and proceeded successfully, creating the
ARSystem tablespace and ARAdmin user account, as well as necessary
tables. I had to use the following as my Oracle Connection String,
as the Remedy install did not connect to just the SID:
//servername:1521/dbsid. Again, the database is on the same server
that I am installing ARS, this suggestion comes from the
installation notes
The install failed during the importing of sample data and
workflow. I discovered the following in my arerror.log:
ORA-06413: Connection not open
Cannot initialize contact with SQL database (ARERR 551)
This error occurs any time I start and stop the server. I am able
to connect via SQL Plus (in ORACLE_HOME\bin) as ARAdmin and see the
arschema tables.
Do I need to install the 32bit Oracle full client with a 32bit
SQLPlus? Does this go in my ORACLE_HOME or another directory?
Thanks in advance for any assistance
Russell Wurth
__20060125_______________________This posting was submitted with
HTML in it___
--
Patrick Zandi __20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"