2 weeks ago - last edited yesterday
Hi, ALL,
A long time ago I downloaded and successfully installed SAP ASE 16.0 SP3 on one of my Linux boxes.
Now since that install becomes unusable, I removed the directory and trying to install it again from scratch.
I rerun the setup.bin and went through the wizard and then I went thru the configuration wizard. And then it just stays there.
I tried to run the installer in the console mode and it turns out that it is stuck in the server build procedure.
What could be the issue? I can post a log file from the install - just tell me which one.
Thank you for the help and any pointer.
EDIT:
Logs attached.
The archive can not be attached. It checks the MIME-type of the file.
Which other file I should attach?
Thank you.
The sap_error.txt is the result of running "grep -ri error *" inside Sybase/log folder.
Request clarification before answering.
Your latest comment and attachments point at a smattering of issues ...
-----------------------------
We're not told the series of steps, options and arguments you provided to the installer so I'm going to assume you did something like the following:
1) When asked to choose from the following ASE installation steps:
From what you've posted it appears you chose to install the Typical SAP ASE, database always-on option. (Since you don't know what HADR is, and assuming you just want the barebones basic ASE software installed, you should have chosen the Typical option.)
2) After the software (ASE and HADR in this case) is installed the installer will ask if you want the installer to create some instances of various components (eg, ASE dataserver, backupserver , etc). I'm guessing you requested to create a basic HADR environment; during the creation of the HADR components you received the error message (attached image) stating there was a problem starting the RMA). (Again, choosing the Typical option should not install the HADR components, which in turn means the RMA would not be installed/configured, which in turn would eliminate the RMA error message).
3) I'm guessing you also asked the installer to create an ASE instance (named REINCLOUD); since you don't mention any other installer-related error messages I'm going to assume this ASE instance was in fact a) created and b) successfully started since ...
4) After the installer finished (albeit with errors) you chose to manually start the ASE instance (startserver -f RUN_REINCLOUD), but because the installer has already started this ASE instance you were provided with the errorlog message "'/opt/sap/data/master.dat' already in use by an ASE".
-----------------------------
Suggested next steps ...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@MarkAParsons,
thank you for the reply. See my answers below.
1. So what log file(s) should I check?
Basically all I need is to install the server in order to test my C++ code.
I have a laptop with Linux where I want to install it.
I have a home network, but I will be running and testing it locally on the same laptop.
I also have a Windows laptop and another Linux laptop.
2. Yes - I really do. Maybe there is something here that needs to be updated, like kernel or some system utility? I presume that the installer is run on multiple different machines and is successfully finishes up. So this makes me very curious.
3. Yes, that is correct. I don't know what the HADR is and I probably don't need it. But I also know that there was no issue with 16.0. And so I do want to find out what the issue is.
Sybase was the very first DBMS I got familiar with and so I really want to make sure that everything is great.
4. Yes - I rechecked and the server was already running. Thx for that.
5. I did not choose Typical. I chose Custom when I did the install And then I selected Trial License.
I then selected the thing to install. I unchecked the Perl/Python client software and chose the License Server.
After the installation I selected to configure everything.
I pretty much chose everything as default. The only thing I did was I set the server name passwords.
Everything was done successfully except the error messages in the screenshots.
6. I can try to re-install the server, but as stated I'd really like to find out what the problem is with the HADR (or its components).
Thank you.
Reinstall issues in SAP ASE usually happen because the previous installation was not fully cleaned up.
Most common causes are:
In most cases, a clean removal + fresh install resolves the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@MikeAParsons, I just tried to get a newer version.
However, I got the following message:
You are signed in with a P-user ID. Visitors with an S-user ID will benefit from more tools and enhanced functionality. If you are an SAP customer, contact a user administratior in your company to request such an ID. Your SAP Local Support Center can help you identify your administrators. If you already own an S-user ID, log out now and log in with your S-user ID.
2 things
1. I'm not part of the company. Just a solo developer.
2. In the past that login gave me an ability to get the software.
What do I do at that time?
Thank you.
It's not clear (to me) what you are doing, or what URL/link you are using, when you receive that message re: S-user vs P-user.
I have a P-user login.
With my P-user login I just verified:
=> However, I wonder - how come the initial install went thru without any issues?
The 'Snap::VAlidate' issue is linked to Linux compiler version. It started appearing after Linux OS patch level / minor version upgrade.
So, you would have run with a different (lower) OS patch level when it worked.
=> Express Edition
This was discontinued, I believe. There is this trial option :
https://www.sap.com/products/data-cloud/sybase-ase/trial.html?url_id=text-us-sapcom-ase-trial-softwa...
Bart
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1. As stated - this particular laptop was just lying somewhere in my safe place. I know better for updating OS when the software not from the repo is installed. 😉
2. Express is not trial. Trial will have to be removed after the trial period. And my development will be much longer than 3 month.
Any suggestions?
Thank you.
The trial license (aka EValutation license) can be updated/extended in 1-year intervals @ https://go.support.sap.com/minisap/#/minisap. I have a pair of ASE installations that are a few years old and they run just fine on my (annually updated) EV license.
As for the express (XE) license, the license file has a generic key that should work on any host (ie, HOSTID=ANY). In the past I've been able to copy the express license file (*XE.lic) to newer ASE installations and ASE successfully started up on said license (ie, the newer ASE software still recognized the XE license). [NOTE: It's been a couple years since I tested this workaround so I don't know if it still works with the latest ASE distributions.]
We really need to see the actual error message and any related stack traces.
During the dataserver creation an errorlog should be generated for the new dataserver ($SYBASE/$SYBASE_ASE/install/<dataserver_name>.log).
The file size should be relatively small so you should be able to upload it as an attachment (either edit your original question, or start a new 'Answer' to your question)
If the file has grown sufficiently large (eg, trying to build the dataserver several times) then consider renaming the file, running the install/build again, and then upload the new *.log file.
In the meantime, if you are running into the snap:validate stack trace issue (as alluded to by Bart), this has been addressed a couple times in this community (eg, this Q&A). The workaround in that linked Q&A (assuming you're experiencing the same exact issue) does not require going to a newer version of the ASE product. [As for why you were able to successfully install the product before ... *shrug* ... hard to say without knowing more about the old vs new environments; could be a difference in the OS/kernel, a different ASE PL## version, ????]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As you reference SP03 and that the install gets stuck, it is very likely you are hitting a known issue. SP03 is an older code line and I assume you may be using an older PL level as well. Does the ASE startup log show signal 11 error with no function in Address:
Current process (0x1d000f) infected with signal 11 (SIGSEGV)
Address 0x0x00007efda8089360 () ...
followed by a stack trace that includes the function Snap::Validate:
()
Snap::Validate
SnapValidation
dsinit
followed by
Warning: The internal timer is not progressing. If this message is generated multiple times, report to SAP Technical Support and restart the server (alarminterval=0).
If so, you are hitting an issue because of an incompatibility between ASE compiler and Linux OS (patch) versions. You need to use at least :
- ASE 16.0 SP03 PL11 or
- ASE 16.0 SP04 PL01
If you are starting out again, I would not recommend to go with SP03 but install latest, which is SP04 PL08.
Kind regards
Bart
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@bart_van_kuijk, yes, I think I saw something like this in the log.
However, I wonder - how come the initial install went thru without any issues?
In regards to installing newer version - this allows me to install Express Edition. Will it be available in the versions you referenced?
| User | Count |
|---|---|
| 15 | |
| 9 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.