Blackboard - Avoiding java.sql.SQLException: ORA-01031: insufficient privileges Issue

sqlplus "/as sysdba"

SQL> @$ORACLE_HOME/rdbms/admin/rstrconn.sql
SQL> GRANT create session, create table TO CONNECT;
SQL> commit;
SQL> grant sysoper to system;
SQL> grant sysdba to sys;
SQL> commit;

SQL> select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP
------------------------------ ----- -----
SYS                            TRUE  TRUE
SYSTEM                         FALSE TRUE

SQL> show parameter password;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
remote_login_passwordfile            string      EXCLUSIVE

Also check LOCKED accounts.

SQL> SELECT username, account_status FROM dba_users;
SQL> ALTER USER the_username ACCOUNT UNLOCK;


sqlplus “sys/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databasehostname)(PORT=1521))(CONNECT_DATA=(SID=$ORACLE_SID))) AS SYSDBA”

sqlplus
“system/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=databasehostname)(PORT=1521))(CONNECT_DATA=(SID=$ORACLE_SID))) AS SYSOPER”