Dear coders,
!!!
NOTE: The described procedure steps were done on Sybase ASE [login to view URL] hundreds of times and everything workd out perfectly
!!!
I have beet stuck in the following situation. I'm running a databese with my diploma data on Sybase ASE [login to view URL] but I need to upgrade it to ASE 12.5.3 or at least ASE 12.5.2.
The OS is CentOS/ASP Linux 11/RedHat - I have tried all of them.
My steps:
1) Dump master database, dump all of the databases I need to be transferred to new version.
2) I have the ddl script that performs all the necessary adjustments for the new database like (creating the new devices, extending the database space... all the history of changes.
I install the new ASE 12.5.3 on the computer. Create the server with all the configuration 100% equal to the previous version (you may be sure in it - I have done this hundreds of times before and It worked successfully)
When the server is created I run the script to prepare the server structure. - SUCCESSFUL.
All databases are online, no errors.
Now the final step I need to change master database. I do it as usual in single mode. No errors occure while uploading the [login to view URL] file.
AND FINALY I go
/etc/init.d/sybase start
And I see the following error in the log file:
server Opening Master Database ...
server Loading SQL Server's default sort order and character setserver Error: 7114, Severity: 22, State: 1
server Page 2223 is not a valid text page.
Log is attached.
## Deliverables
I HAVE TRIED TWO CODERS BEFORE AND THEY WERE UNSUCCESSFUL TO COMPLETE THIS TASK.
I want a coder to state the price he would like to get for this and if I succeed in migrating I will accept the bid and send payment immediately along with the bonus and exellent rating.
I know it is easy for a person who had such problems before.
## Platform
LINUX, SYBASE ASE 12.5.X