×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

*
*
*
*

Thanks. We have received your request and will respond promptly.

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Upgrading Oracle Database & Remedy's Action Request System

thread773-289139

Upgrading Oracle Database & Remedy's Action Request System

Upgrading Oracle Database & Remedy's Action Request System

(OP)
Any tips on upgrading Remedy's Action Request System from
4.1.5??? to 5.0, and simultaneously upgrading Oracle from 8.1.6 to 8.1.7 would be appreciated. Can the data be migrated at the Oracle level only (ie. install 8.1.7 Oracle binaries, create new database, full export of production data, full import into new database) or do we have to use the Remedy export/import tools. If so, why is upgrading an Oracle database (running ARS) / migrating the data etc,
different to upgrading a non Remedy database ?

All assistance greatly appreciated.

staussno1

RE: Upgrading Oracle Database & Remedy's Action Request System

I would recommend looking at it as two separate operations, even if you perform them at the same time.  Upgrading Oracle should have no impact on Remedy (assuming you keep the same names in tnsnames, etc).  Bring Remedy down, then perform the Oracle upgrade.  When that's all done, bring Remedy up and check it all out.  After you're sure that's all fine, then do the Remedy upgrade.

RE: Upgrading Oracle Database & Remedy's Action Request System

Have you performed you upgrade yet?

Each upgrade should be handled separately.

Check out this link for compatibility of Remedy versions
with ORACLE versions:
http://supportweb.remedy.com/supportweb/CompatibilityMatrix/index.html

ORACLE:
Upgrading ORACLE from 8.1.6 to 8.1.7 will not require a dump and reload of data - it is a binary upgrade.  This is not considered a major upgrade.

REMEDY:
Depending on your server, ARS 5.0.1 supports ORACLE 8.1.7.  It doesnt say if 8.1.6 is supported so assume it does not.
If you are running ARS 4.5.1, I also assume you cannot use ORACLE 8.1.7 (at least it doesnt say you can, or cannot)
Given this, it looks like you would have to upgrade simultaneously, which I like to avoid becuase if something goes wrong, you have no idea what is going on and backing-out is a nightmare.

One possibility around all this is upgrading to ARS4.5.2, which supports ORACLE 8.1.7.  This should cause little/no impact to your users.  Next, upgrade to ORACLE 8.1.7 (perhaps a week later) which should also cause no user impact.

After some period of time (weeks ?) consider upgrade to ARS5.0.1, which will most likely cause user impact

Don't forget to judge if the client tools have toalso be upgraded when you upgrade ARS (see compatibility matrix)

Tom

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login
Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close