There are a whole series of changes to the schema going from 6.3 to 7.1 (new tables, altered tables, data changes, etc.). You need to run the installer against the 6.3 schema so that the installer can make those schema changes. There's really no other way (short of reverse engineering what the db upgrader does and manually applying it to your 6.3 schema).
Axton Grams On Wed, Apr 23, 2008 at 10:47 AM, Meenakshinathan <[EMAIL PROTECTED]> wrote: > Hi All, > > Thanks for the response. > > Let me clearly explain once again. > > Previously the remedy server 6.3 connects the remote database oracle > 9i. In the same OS , i have uninstalled the remedy server 6.3 and then > i have installed oracle 10gR2 and installed the remedy server 7.1. > This was considered as a fresh install. I didn't touch my old > database. > > I have few forms in my old database and i forgot to take a export .DEF > file. For this only i have made the changes in conf and tnsnames.ora > file to connect it. i think it is required to update some file in DB > to make a connection as mentioned by Axton. anyway if any body knows > how to modify some file in the DB for the successful connection and > make the server up, i will be very thnakful to them. > > Thanks for your support, > Meenakshinathan > > > > Axton wrote: > > > It probably failed when the installer attempted to connect to the db. > > It's a bit tricky getting the upgrade installer to work properly when > > the oracle client version changes. In this case, the server needs to > > be started using the 9i client, but the installer needs to the 10g > > client. > > > > As an informational tidbit, the db version is stored in the db at > > control.dbversion. > > dbv ars ver > > 22 7.0.1 > > 23 7.1 > > > > Axton Grams > > > > On Wed, Apr 23, 2008 at 6:19 AM, Misi Mladoniczky <[EMAIL PROTECTED]> > wrote: > > > Hi, > > > > > > The upgrade seems to have failed. The binaries are installed, but the > > > databas upgrade failed. I would suggest that you run your upgrade again. > > > > > > I do not know how the upgrade works, but it may have failed somewhere in > > > the middle. If that is the case, you should restore your old database > > > before attempting a new upgrade. > > > > > > You should also check your installation logs to find out what part whent > > > wrong. It is quite possible that you will experince the same problem > > > again... > > > > > > Best Regards - Misi, RRR AB, http://rrr.se/sv/ > > > > > > > > > > > > > Hi All, > > > > > > > > Please help me on the following issue... > > > > > > > > I have installed remedy server 7.1 in a solaris 9 OS and it is having > > > > it's own oracle 10gR2 database and client libraries. Now the server is > > > > up and running. > > > > > > > > Previously in the same solaris OS, I had Remedy 6.3 server connected > > > > the remote oracle 9i database. After the above new installation, I was > > > > updated the tnsnames.ora file to connect the remote database and also > > > > modified the ar.conf file which includes the oracle two_task variable. > > > > I restarted the server and it throws the following error > > > > > ********************************************************************************************************* > > > > Action Request System initializing. > > > > Starting AR System Server > > > > > > > > (ARNOTE 0) > > > > AR Monitor version 7.1.00 Build 200708221849 started. > > > > > > > > (ARNOTE 0) > > > > AR Monitor started. > > > > > > > > (ARNOTE 0) > > > > ARMonitor child process (pid:19262) started. > > > > ./arserverd > > > > server: locale=[[ C ]], > > > > LANG=[[ C ]] NLS_LANG=[[ NULL ]] > > > > > > > > Action Request System(R) Server Version 7.1.00 Build 200708221849 > > > > (c) Copyright 1991-2007 BMC Software, Inc. > > > > > > > > 390600 : The database is not the expected version (may need to run > > > > upgrade program) (ARERR 36) > > > > > > > > 390600 : AR System server terminated -- fatal error encountered > > > > (ARNOTE 21) > > > > > > > > (ARNOTE 0) > > > > Unable to receive indication that server is up. > > > > > ******************************************************************************************************************************* > > > > My question is, Is it possible to connect the old datbase using new > > > > remedy server using the above set up? Also let me know how to fix > > > > this... > > > > Note: my tablespace name , schema user name, password is same as > > > > mentioned in ar.conf file. > > > > > > > > Please let me know if you have any questions. > > > > > > > > Thanks, > > > > Meenakshinathan > > > > > > > > > _______________________________________________________________________________ > > > > 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" > > > > > > > > _______________________________________________________________________________ > > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
