The Incident Archive

Had a few issues when trying to connect to oracle xe installed by another user Getting sqlplus to work set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server set ORACLE_SID=XE set PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin;%PATH% Connecting as sysdba to change password (ORA-01031: insufficient privileges)  Type Edit local users in your start menu search bar (Select the first one in the Control panel group)  Click Groups  Select ORA_DBA  Add your user here  sqlplus / as sysdba from the command prompt with all above variables set   alter user SYS identified by "newpassword";