cancel
Showing results for 
Search instead for 
Did you mean: 

Uninstalling Sql anywhere patch on linux

Former Member
1,819

Hello,

I have applied a patch and upgraded sql anywhere server from Version 12.0.1.4110 to Version 12.0.1.4294 on RHEL. How do I uninstall just the patch and not the full sql anywhere.

Accepted Solutions (0)

Answers (1)

Answers (1)

MarkCulp
Participant

There is no way to uninstall a patch since the upgrade process overwrites the software that existed prior to running the upgrade. To get back to the version prior to applying the patch, you need to:

  • restore the software from a backup (if you have one)
  • uninstall the current version (or just delete it) and then reinstall SQL Anywhere using the install package from the previous version.

HTH

Former Member
0 Kudos

Thank you for the reply. When I uninstall the 12.0.1.4294 (new version) and install the old version, would the databases still function correctly? Since the patch install ran on the old version server and databases, would the databases get updated as well?

Vlad
Product and Topic Expert
Product and Topic Expert
0 Kudos

did you upgrade the DB explicitly? E.g. http://dcx.sybase.com/1200/en/dbadmin/dbupgrad.html

Former Member
0 Kudos

Thanks for the reply. I haven't upgraded the databases. Just installed the patch on the server. Is upgrading the database recommended? If I upgrade the databases, would I be able to downgrade it to the old version if need be or would I need to use the database backups pre-upgrade?

Former Member
0 Kudos

when I do "select version from SYSHISTORY" it outputs the below: version 1 12.0.1.4110 2 12.0.1.4294

So it does look like the database is upgraded right?

VolkerBarth
Contributor

Just look for the rows with operation = 'INIT' or 'UPGRADE', these tell the version the database file was created with resp. was upgraded to. Rows relating to the (last) start or backup just tell which database engine version was used to do so.

In general, the database file should be able to be run with every database engine with at least the same version, i.e. if the database was INITed with 12.0.1.4110 and not upgraded, every version >= 12.0.1.4110 should successfully run your database.

Former Member
0 Kudos

Thanks Volker. This is good information. The last Operation START says the version is 12.0.1.4294. This would mean that my database version is 12.0.1.4294 right?

VolkerBarth
Contributor

No, as stated, just check the rows with INIT or UPGRADE.

Former Member
0 Kudos

Thanks again.