Skip to Content
author's profile photo Sunil Roy
0
Sunil Roy

SAP Sysbase sybsid user deleted

Posted on Jun 29, 2016 at 06:21 AM 205 Views

Hi Experts,

I need urgent help on the following problem we are facing on Sybase user

one of the user syb<SID> user was deleted from the operating system now we are not able to do the db configuration on it

mainly DB log clearing when we type ISQL command in the powersell we are getting following error

how to reconfigure the sybda1 user so that i can perform the DB transcation

or is there any way to clear the log without login to the sybsid user

Urgent help needed

Regards

SROY

ISQL.jpg (76.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2016 at 06:35 AM
    0

    Dear Sunil,

    Try executing isql from the path where is resides.

    ie :

    C:\sybase\<SID>\OCS-15_0\bin\isql

    Does it work?

    Also please cross check if the sybsid user have given/reverted with all the necessary privileges as before/

    Regards,

    Ajith Prabhakaran

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Sunil Roy
    Sunil Roy
    Posted on Jun 29, 2016 at 06:48 AM
    0

    Hi Ajith,

    Thank you very much . But when i run it from the folder it gives me error as below

    how to fix it

    Regards

    SROY


    ISQLERROR.jpg (25.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jun 29, 2016 at 08:48 AM

      Well, I think, it is not only about removing the sybid user, somehow few of the files are also deleted. Can you tell me if you see in SYBASE%\%SYBASE_OCS%\dll directory?

      Check if these library files are exisiting? Else ask the Windows Adminstor to restore each and everything, rather than partial scenes.

      Regards,

      Ajith Prabhakaran

  • author's profile photo Sunil Roy
    Sunil Roy
    Posted on Jun 29, 2016 at 09:15 AM
    0

    Hi Ajith,

    Thank you very much for your help

    I just reentered the env variables in the system and it worked

    thank you

    Regards

    SROY

    Add a comment
    10|10000 characters needed characters exceeded

    • Nicolaas Johannes Van Zyl
      Jun 29, 2016 at 09:31 AM

      Hi Sunil,

      The environment variables will resolve your current error.

      But take into account that your backup team needs to restore the system otherwise you will run into problems in the future with the user having been deleted. Remember during installation the user is created in the registry with unique key entries e.t.c. so you cannot just recreate the user as such.

      Kind Regards,

  • author's profile photo Sunil Roy
    Sunil Roy
    Posted on Jun 29, 2016 at 10:25 AM
    0

    Hi Nicolaas,

    thank you ,

    yes we inform the client to take Imge BKs

    All the registry key has to be created for the new user

    thank you

    Regards

    SROY

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.