cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase 16.0 logging on issue with Isql - sapsso reset didn't work

davide1706
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (6)

Answers (6)

davide1706
Explorer
0 Kudos

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.

davide1706
Explorer
0 Kudos

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

victoria_normand
Contributor

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.

davide1706
Explorer
0 Kudos

Thank you Jongun, that indeed worked as I could now log in.

davide1706
Explorer
0 Kudos

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 ?

jong-un_seo
Participant

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

victoria_normand
Contributor
0 Kudos

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.

victoria_normand
Contributor
0 Kudos

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.

bart_van_kuijk
Participant
0 Kudos

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>