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"
