Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.Hi All,
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
Potential options:
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...
Upgrade from ASE 12.5.0.3 to ASE 12.5.1This is a multi-part message in MIME format.
---=_forums-2-dub3ff97039
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Hi,
I've just upgraded from ASE 12.5.0.3 to ASE 12.5.1. I tried
to start the server, but it won't startup.
Here is the message:
sybase(ASE1250)328 /app/sybase/ASE-12_5/install -->
startserver -f RUN_AMXDB
sybase(ASE1250)329 /app/sybase/ASE-12_5/install -->
00:00000:00000:2004/01/05 21:37:44.10 kernel Use license
file /app/sybase/SYSAM-1_0/licenses/license.dat.
00:00000:00000:2004/01/05 21:37:44.10 ker...
Upgrade to ASE 15..0.3 from ASE 12.5.4I'm currently planning to do an upgrade in place from ASE
12.5.4 to ASE 15.0.3 using sqlupgrade(res) utility.
Does it just run the installmaster and instmsgs.ebf scripts
?
Will I have to manually run the rest of the scripts i.e.
installsecurity, installdbccdb etc.?
Also in ran the preupgrade program against my old server -
the main errors it came up with were:
Stored Procedure '' uses deprecated builtin functions as:
'rowcnt', which should be changed to 'row_count'.
It doesn't show the stored procedures name - has anyone had
this problem ?
Re...
ASE 12.5.0.3 to ASE 12.5.4 upgrade pathI would like to know if the migration from ASE 12.5.0.3 to
12.5.4 a direct migration or is there an intermediate
upgrade to be performed in between?
Take a look at the release bulletins and installation guides for your
platform. These are the first steps to any upgrade.
http://sybooks.sybase.com/nav/detail.do?docset=1287
<passerby> wrote in message news:484e9ca8.3f0d.1681692777@sybase.com...
>I would like to know if the migration from ASE 12.5.0.3 to
> 12.5.4 a direct migration or is there an intermediate
> upgrade to be performed in between?
...
Upgrade ASE 12.0/64 bit on AIX 4.3.3 to ASE 12.5.x/64 bit on AIX 5.2Trying to find what is the supported upgrade path for the above. Going from
12.0/64bit on AIX 4.3.3 to 12.5 (or 12.5.x) 64bit on AIX 5.2.
If I put AIX 5.2 , the dataserver binary of 12.0 will not work which is used
during the upgrade.
If I put 12.5.x on 4.3.3, the dataserver binary will not work beacuse it is
new binary for 5.2.
Other than backup the databases and load them to the new server, is there a
supported how to upgrade?
Thanks!
...
ASE 12.5.0.3 to ASE 15.02 EBF2 upgradeHello All,
I'm testing my upgrade from
Adaptive Server Enterprise/12.5.3/EBF 12600 ESD#3/P/Linux
Intel/Enterprise Linux/ase1253/1911/32-bit/
to
Adaptive Server Enterprise/15.0.2/EBF 15101 ESD#2/P/x86_64/Enterprise
Linux/ase1502/2516/64-bit/FBO/Thu Dec 20 01:26:11 2007
OS: RHEL 5
so far some db are been upgraded nice some I have issues , here is one
of my error: ( mentioned this db has replicated tables from other site)
Any tips ?
1>online database hstspss
2> go
Started estimating recovery log boundaries for database 'hstspss'.
Database 'hst...
upgrade from ASE 12.5.3 to ASE 15.0.2 ESD#4What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4?
1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4
or
2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4
Thanks,
liyp
liy wrote:
> What are the correct steps to upgrade from ASE 12.5.3 to 15.0.2#4?
>
> 1. Upgrade ASE 12.5.3 to ASE 15.0, then from ASE 15.0 to ASE 15.0.2#4
>
> or
>
> 2. Upgrade ASE 12.5.3 to ASE 15.0.2 ESD#4
>
I did #2. At one point I considered upgrading to 15.0.2 GA
and then to ESD#4, but the $SYBASE/ASE/upgrade/upgrade program
looks to b...
Migration from ASE-64 bits 12.5.0.2 to ASE 64 bits 12.5.3 for AIX 5.3Here there someone to indicate me the road tasks in order to
migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64
bits)
Thank you
kamel wrote:
> Here there someone to indicate me the road tasks in order to
> migrate an ASE 12.5.0.2 to ASE 12.5.3 on unix 5.3 ? (64
> bits)
>
> Thank you
Apply 12.5.2 IR then 12.5.3 esd 5.
--
Jason L. Froebe
http://jfroebe.livejournal.com
http://www.propsmart.com
Team Sybase
On Tue, 31 Jan 2006 07:18:22 -0800, kamel wrote:
> Here there someone to indicate me the road tasks in order to migrate an
> ASE 12.5.0.2 ...
ASE 12.5.2 to ASE 12.5.0.3Hello,
I have to return to ASE 12.5.0.3 from ASE 12.5.2.
I created a new server and did a dump/load of a user database and
that seems to be fine.
Is this a safe way to downgrade ?
Is it necessary to create a new server (master database) or should it
also be possible to shutdown the 12.5.2 server and start it again with
the 12.5.0.3 binary ?
Thanks,
Luc.
...
ASE 12.5 32bit to ASE 15.0 64bit upgradeWhat are the steps to upgrade from 12.5 32bit to 15.0 64bit
on AIX 5.3? The 15.0.1 Installation Guide describes the
normal 15.0 upgrade process but then has a terse section
towards the end, "Migrating from 32-bit to 64-bit version",
that describes other steps. Are these steps in addition to
the normal upgrade process (sqlupgrade) or are they in place
of sqlupgrade? Do I really have to drop and re-create all
compiled objects (step 12 under Method #3: Replacing the
binary)?
Keith Wonderly wrote:
>
> What are the steps to upgrade from 12.5 32bit to 15.0 64bit
>...
ASE 12.5.0.3 -> 12.5.3 UpgradeHi,
I may have to upgrade my ASE 12.5.0.3 64-bit Solaris server to ASE
12.5.3. I am curious if I can download the latest EBF for ASE 12.5.3
and do a srvupgrade or what do I do exactly?
Thanks in advance,
Shahryar
--
Shahryar G. Hashemi | Sr. DBA Consultant
InfoSpace, Inc.
601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA
Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150
shashem@infospace.com | www.infospaceinc.com
This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s); any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. Thank you.
> Hi,
>
> I may have to upgrade my ASE 12.5.0.3 64-bit Solaris
> server to ASE 12.5.3. I am curious if I can download the
> latest EBF for ASE 12.5.3 and do a srvupgrade or what do
> I do exactly?
The current EBFs (12.5.3) can only be applied on top of the
12.5.2 IR release.
So what you need to do is:
Download the 12.5.2 IR distribution (that's a full distro -
from sybase.subscribenet.com).
Download the appropriate 12.5.3 EBF from www.sybase.com
(current ESD # is 5).
Make a backup copy of your 12.5.0.3 installation (i.e. tar
up the $SYBASE directory).
Install the 12.5.2 IR (r...
Upgrading from ASE 12.5.x to ASE 15.0.2Hello all,
I have been writing some checklists regarding the Upgrade from ASE12.5.x
version to ASE15.0.2 version, and I have to cover some different sceneries.
I would like to confirm with you guys, If my thoughts are correct
regarding the methods for each situation, and if not, would like some advice
from you please. Correct me please if I am wrong.
Follow the sceneries and the possible methods for each situation that I need
to cover:
A) Migrating from ASE 12.5.x 32-bit to ASE 15.0.2 64-bit version of
Adaptive Server Enterprise (in this case the page size ...
Upgrading from ASE 12.0 to ASE 12.5.2Hi everyone,
I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
How would the migration process be. Is it straight dump and load or
otherwise ??
regards
Paresh.
Paresh wrote:
> Hi everyone,
>
> I am basically thinking of upgrading ASE 12.0.x to ASE 12.5.2.
>
> How would the migration process be. Is it straight dump and load or
> otherwise ??
>
> regards
>
> Paresh.
>
>
see the upgrade/installation guide
joop
--
Senior Consultant Sybase Professional Services
New address per 21 November 2005:
Zo...
ASE 12.5 to ASE 12.5.3One of our client is having 3 no license for ASE 12.5 on Win2K (running 3
production servers) and not in the support/AMC with Sybase.. is client
eligible to use ASE 12.5.3 ?
Thanks
KRV
...
Problems after upgrade from ASE 12.5.0.2IR to 12.5.0.3
After running anywhere from several hours to 1 day, CPU utilization goes to 100%. Running "reorg rebuild <tablename>" on the three busiest tables seems to fix, but only temporarily.
I'm not sure what to do. Sybase tech support didn't offer much help. I was sent a document stating that 100% cpu utilization didn't necessarily indicate a problem. I'm not convinced that this is true, because the machine never acted this way before, and a quick perusal of the two outputs doesn't look kosher.
Hardware info:
Adaptive Server Enterprise/12.5.0.3/EBF 1...
RepServer error after upgrading ASE 12.5.0.3 to 12.5.3Hello,
I have running an ASE 12.5.0.3 and a RepServer 12.5 on the same box.
After upgrading the ASE to 12.5.2 EBF11942 the RepServer doesn't start
anymore. Following error occurs: repserver:fatal:relocation error:
file $SYBASE/OCS-12_5/lib/libsrv_r.so: symbol syb_net_property not found.
Can anybody help ?
Thanks in advance,
Bernd
On Fri, 13 Aug 2004 04:47:37 -0700, Hirsteiner wrote:
> Hello,
>
> I have running an ASE 12.5.0.3 and a RepServer 12.5 on the same box.
> After upgrading the ASE to 12.5.2 EBF11942 the RepServer doesn't start
> an...
Performance Degradation after ASE 12.0 upgrade to ASE 12.5Hello,
There was a issue posted on 08/06/2002 by 'Bob' related to performance
degradation after upgrade of ASE 11.9.2 to ASE 12.5. I would like to know
whether anyone has found any solution/workaround
to resolve those issues without making any changes in the application code.
We are also facing the same problems here after upgrade of ASE 12.0 to ASE
12.5. The program which takes 10 mins. on ASE 12.0 is taking more than 3
hrs to finish on ASE 12.5 despite of using the same indexes and the program
which takes 3 hrs on ASE 12.0 is taking more than 24 hours on ASE 12.5. ...
ASE 11.9.2 to ASE 12.5.0.3, inplace upgrade issuesHi
We have migrated one of the Sun boxes running ASE 11.9.2 on
Solaris 2.8 to ASE 12.5.0.3 ESD#3 .
We did a inplace upgrade. The "sqlupgrade" utility did all
pre-checks and came out clean and did the migration and it
came out with a "Done" message.But it gave a message saying
that
the server couldnt be brought up, and seeing the error log
we have seen the shared memory was a problem and we chaged
the
value and the server came up fine when we brought it up
manually using the 12.5.0.3 binaries.
Few issues which are stopping us to proceed further..
Issue 1)
T...
Does the secondary truncation point in the Adaptive Server need to be disabled when upgrading ASE 12.5.03 to ASE 12.5.3Does the secondary truncation point in the Adaptive Server need to be
disabled when upgrading ASE 12.5.03 to ASE 12.5.3?
Thanks
Hi,
No. just stop replication before the upgrade and restart it after the
upgrade. Nothing special :)
Jason L. Froebe
Team Sybase
http://jfroebe.livejournal.com
liy wrote:
> Does the secondary truncation point in the Adaptive Server need to be
> disabled when upgrading ASE 12.5.03 to ASE 12.5.3?
>
> Thanks
>
>
>
...
Does the secondary truncation point in the Adaptive Server need to be dsiable when upgrading ASE 12.5.03 to ASE 12.5.3This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C5C408.CA053AD0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Does the secondary truncation point in the Adaptive Server need to be =
disabled when upgrading ASE 12.5.03 to ASE 12.5.3?
Thanks
------=_NextPart_000_0006_01C5C408.CA053AD0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<...
Upgrade from ASE 12.5 to 12.5.0.3Can someone help me,please?
I have upgraded my Ase 12.5, on Windows Nt 4 whith service pack 6, to Ase
12.5.0.3 with EBF #10979.
I have rewrite the binary file with xcopy (from CD) and i have unzip
diagsrvr.exe and i have launch the scripts
instmstr,instcomm,instsecu,instmsgs.ebf,installdbccdb.
When i reboot Ase the error log said:
////////////////
Adaptive Server Enterprise/12.5.0.3/EBF 10979 ESD#1/P/NT (IX86)/OS
4.0/rel12503/1919/32-bit/OPT/Mon Mar 24 22:39:53 2003
kernel Confidential property of Sybase, Inc.
kernel Copyright 1987, 2003
kernel Sybase, Inc. All rights...
Vulnerability of ASE 12.5.2 vs ASE 12.5.3 ESD#3Recently, Application Security, Inc. has run a vulnerability test on our
ASE12.5.2. The program gave a 'high risk' on the ASE12.5.2 and suggested we
install the latest Sybase patch 12.5.3 ESD#3.
I have some question on the recommendation.
1. The latest patch is definitely not 12.5.3 ESD#3. Why did the program
recommend 12.5.3 ESD#3? Isn't 12.5.4 better than 12.5.3?
2. Is it practical to keep up with the latest releases or patches? Now if we
upgrade to 12.5.4 and then rerun the vulnerability test, will the program
suggest that newer version is better with respect to s...
Migration from ASE 12.5.3 (Win 32bit) to ASE 15.0.2 (Unix 64 bit) questionHi,
I would like to migrate an ASE 12.5.3 on a Microsoft 32-bit
server to an ASE 15.0.2 on Linux (or Solaris) 64-bit server.
What steps must I follow?
Is it a good idea to use a Replication Server 15 as
intermediate task (consultant advice)?
Thanks,
Lorenzo
My current ASE has a total size of 350Gb , 2400 connections,
2.6 Gb of memory...
With ASE 12.5.3 you're suppose to be able to perform cross platform dump-n-loads (XPDL), where 'cross platform'
basically means different OS's and/or different endian hardware. This (obviously?) assumes you'll be using ...
When upgrading from ASE 12.5.x to ASE 15.x, what is the best version to upgrade too?When upgrading from ASE 12.5.x to ASE 15.x, what is the best
version to upgrade too?
Dear All,
I'm currently working on a ASE 15 upgrade project (upgrading
from ASE 12.5.x). I'm trying to decide what version of ASE
15 we should upgrade to.
What are your thoughts? Which version is the safest bet
(ASE 15.0, ASE 15.0.1, ASE 15.0.2, ASE 15.0.3 or ASE 15.5)?
Which ASE version is considered, at this time, the most
mature and reliable version (i.e. with the least amount of
known bugs, least amount of upgrade issues, etc.)?
If applicable, please also give the most recomm...