on 12-12-2018 2:10 PM
Dear all,
My DB got some space problem as I could see the following error message in the sybase\SID\ASE-16_0\install\SID.log file:
00:0006:00000:00054:2018/12/12 14:05:35.01 server Can't allocate space for object 'syslogs' in database 'SOP' because 'logsegment' segment is full/has no free extents
So I wanted to logon via ISQL to extend the available space.
However I'm unable to logon as I always get the following error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found
However, I think I knew the password of sa or sapsso user, I couldn't get in.
So I followed the sap note: 2008256 - How to reset sapsso password - SAP ASE for Business Suite and SAP BW to reset the password of sapsso and try to get in.
But even with the new temp password generated, I'm unable to log in with sapsso.
Do you have any idea what could be the cause and how could I finally get in my ASE DB to extend the space of logsegment?
Thanks in advance.
Regards,
David
Hello Victoria,
I changed my sql.ini file as per your recommendations but unfortunately it is not working better... But thanks to workaround of using the host name, I could now manage to enter my DB.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello all, Victoria,
Indeed the workaround provided by Jongsun works.
This is what i have the sql.ini file:
[SOP]
[SOP] master=NLWNSCK,VM-SM-PRD01,4901
query=NLWNSCK,VM-SM-PRD01,4901
So this is seems correct to me.
Is there any other suggestion to fix this ?
Thanks in advance for your help.
Best regards,
David Etienne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello David,
Please remove the "[SOP]" just before "master" keyword, in order to have this:
[SOP]
master=NLWNSCK,VM-SM-PRD01,4901
query=NLWNSCK,VM-SM-PRD01,4901
If you have that (and the additional [SOP] was just a copy-paste issue), I would guess that when you do isql using the workaround, you are using same hostname and port that is: "-SVM-SM-PRD01:4901" , can you confirm ?
Best regards,
Victoria.
Thank you Jongun, that indeed worked as I could now log in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
The DB is on Windows.
Thanks for your reply. But I'm sure of my SID and DBSID (which are the same) : SOP
This the error I got when trying to logon:
C:\Windows\system32>isql -SSOP -Usapsa -X Password: CT-LIBRARY error: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Yes indeed I could also extend from DBACOCKPIT if the system is available which is not the case 😞
But actually, the SAP system is Solman 7.2 and two ASE DB of ABAP (SOP) + JAVA (SOJ) are the same host.
Could this cause the confusion in the interfaces files ?
where are the inferfaces files ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi David,
Instead of interface name for the ASE, try to use hostname(ipa ddress): port# with isql utility.
isql -Usapsa -Smyhostname:5000 -X
Regards,
Jongun
Hi David,
As mentioned Bart, "normally" the only way that message can be returned is because the server name (SID) is not correct (in your case 'SOP'). You may have a quick check on interface file which under Windows is called "sql.ini" located on "%SYBASE%\<SID>\ini" folder. You should have in the sql.ini an entry like this one for your SID "SOP":
[SOP]
master=NLWNSCK,<hostname>,<port>
query=NLWNSCK,<hostname>,<port>
If it has the correct information, then we have an issue.
Workaround is to specify the <hostname>:<port> that Jongun mentioned, but as stated, it is a "workaround" 🙂
Best regards,
Victoria.
Hello David,
The error from isql is indicating "Requested server name not found" , not about login failed.
I would say if you were able to apply steps from KBA 2008256 you shouldn't have connection issue.
Are you using isql in this way ? isql -S<SID> -Usapsa -X (where you should replace <SID> by your SID) .
You can also extend from DBACockpit > menu Spaces > Databases > select your database and click in the SID and click on button "Extend DB Space".
HTH,
Kind regards,
Victoria.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The error states "Requested server name not found" . That does not indicate a login / password issue.
It means that the servername you provide in the isql string (-S) is not found in the interfaces file. So, check -S value against the entires is in your interfaces files in $SYBASE.
Note that Unix is case sensitive. That is a common mistake, using wrong caps.
For example, in interfaces file server name is in CAPS
$ cat interfaces
SP02_PL07
master tcp ether myhost 1234
query tcp ether myhost 1234
Logging in with lower caps
$ isql -Usa -Ssp02_pl07
Password:
CT-LIBRARY error:
ct_connect(): directory service layer: internal directory control layer error: Requested server name not found.
Logging in with CAPS
$ isql -Usa -SSP02_PL07
Password:
1>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.