Orasid user is missing

[Former Member]

Hi Experts,

I have one query, I lost my orasid user at AIX level by mistaken,

If i create a user again at OS level,

Will it work fine?

or

anymore settings are required?

Please advise..

Thanks & Regards,

Sundar.C

[Former Member · Accepted solution]

Yes, You can recreate the ORASID user id and assign the DBA and Administrator groups to fix the issue.

Thanks,

Sravanthi

[Former Member]

Hi,

Yes you can, re-create the user. Additionally, if you lost your environment settings, you can take a reference by the note 602843 - Environment settings for R/3/Oracle on UNIX

Best regards,

Orkun Gedik

[Former Member]

Hi All,

Thanks for your quick response.

We have restored the orasid user successfully with help from AIX team.

Restart was not required after restored the user.

Thanks & Regards,

Sundar.C

[former_member189725]

create the ora<sid> user with smitty and use /oracle/<SID> as the home directory. Assign the user to groups dba and oper. Also make sure you have the environment intact for the user. Also ensure the uid and gid are same as before.