I am trying to install Oracle 11g XE on VPS from Vultur, I tried both Ubuntu 18 and CentOS 8,
After showing success message, i tried loging into SQL PLus> sys/password as sysdba, and I am getting below output...
SQL*Plus: Release 11.2.0.2.0 Production on Thu Mar 26 13:10:14 2020
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01031: insufficient privileges
I am getting same error on both the OS, searched over the internet all the day and tried all i read,
added root to dba group.....no use
checke $ORACLE_HOME point sthe /XE folder
checked the permissions the the folder all most all the files have below permisions
drwxr-xr-x. 2 oracle dba 4096 Mar 26 11:40 bin
created sqlnet.ora file, its not created by default and changed SQLNET.AUTHENTICATION_SERVICES = (NTS) value to NTS, ALL, and also commented on it and no use.....
can anyone please give me a solution for this?
Thanks and regards,
Pratap N