Apparently, I am experiencing issues due to a bug in Oracle.
To summarize for anyone else that is interested, I was attempting to run ARS
7.0.1 on Win2003 64 bit and Oracle 10g (10.2) 64 bit with a 32 bit Oracle
client installed separately since the 64 bit database did not install lib32. The ARS install connected and created the database and some arsystem
tables, but failed to load forms and data, and the server subsequently failing to start, giving an ORA-06413 error.
The Oracle bug is that the networking layer cannot interpret parenthesis in a directory name. AR Server, by default, goes into 'Program Files (x86)'.
Details are here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=159581&SiteID=1
My workaround, since I don't have a metalink account to get a patch, was to
install AR Server under a directory without parenthesis in the name,
'D:\ARServer'. This worked.
Also, during the install do not forget to indicate that the Oracle database is
on a remote machine, a requirement for connecting to a database with a
different version of the client. I had to do this even though the client,
database, and AR Server were on the same box. The Oracle connection string
I used was the following format:
//servername:1521/dbSID
This gets set as the Oracle-Two-Task in ar.conf. I did not have to set any
Windows environment variables, as one typically has to do on a UNIX/Linux
install.
Hope this helps with anyone else running a similar configuration and choses to
do an arslist search on this problem rather than Remedy's KB
Russell
Jarl Grøneng wrote:
Be sure to add TNSADMIN environment variable if tnsnames.ora is not in default
directory.
-- Jarl
On 1/26/07, Russell Wurth <[EMAIL PROTECTED]> wrote:
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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
