John,
Did you also see: DLL function call crashed:UPORACL.UpgradeDatabaseOR ?
I had exactly that problem when I upgraded from ARS 5.1.2 on a
Windows 2000 box to ARS 6.3 on Windows 2003 box. The Oracle
9.2.0.4.0 64 bit was on an AIX box. Remedy Support was pretty sure
that it had something to do with the Oracle client. Recently I
noticed a note on the compatibility matrix that may provide a clue:
"Requires 32-bit Oracle 9iR2 database client for connecting to the
Oracle database". I'm not sure what I have.
I ended up upgrading the database from the old Win 2000 box, then
connecting to the upgraded database from the 2003 box. I then tested
everything and have now been in production with it since May with no
problems.
I do not know if I'll have a problem when it comes time to upgrade
again, so I would love to hear if you find out what causes it.
Julie
At 09:30 AM 9/1/2006, you wrote:
Hi List: First time emailer. Long time reader.
I'm trying to setup our Dev Box(Windows 2003sp1) with AR 6.3. Having
errors upgrading an existing DB.
We took a copy of production DB, and placed it on a different oracle
Server. Oracle 9.2.0.4.0 64bit.
My tnsnames is set correctly to Dev Server and connection to remedb
listener.
The name of the DB is the same for Production and Dev. Which is OK. They
are on different servers.
When I'm setting up the Dev server running server.exe, Its asks for SID
name and what type of install. Upgrade, Overwrite or Shared. I select
Upgrade because the DB out there is an exact copy of the Production having
all the Data - I want the data in tact just to install the Server.
Here is the Error
15:40:39 An error was encountered during the upgrade of the AR System
database.
15:40:39 Installation terminating ... Original database server is intact
and accessible
15:40:39 Resolve the problem that causes the error (contact Technical
Support, if necessary)
15:40:40 ****->[ShowMsg]: Setup is rolling back directories....
15:40:40 Setup is rolling back the directories.
15:40:41 ServiceName not found. Using Default: Remedy Action Request System
Server
15:40:41 ****->[ERROR]: AR System Database upgrade error. The original
database is intact and accessible.
Anyboby have something similar. Or suggestion.
John Kelley
Help Desk Analyst
130 Royall Street
Canton, MA 02021
Mail Center 1W
781-737-3564
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
-------------------------------------------------------
Julie Rockwood
Los Alamos National Laboratory
IST-AUBAD Remedy Technical Lead
(505) 667-9846
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
