Oracle DBA

Oracle DBA

Using Oracle 21c

Useful Oracle commands:

shell> sqlplus SYS@XE as SYSDBA
shell> sqlplus wenchen@XE

SQL> create user C##user_id identified by password container=all;
SQL> grant connect to C##wenchen container=all;

SQL> grant create table, create sequence, create session to C##user_id;
SQL> grant alter user, create procedure, create type to C##user_id;
SQL> grant create trigger, create view to C##user_id; 

SQL> alter user C##user_id quota unlimited on users;

SQL> drop user C##user_id;
SQL> grant sysdba to C##user_id;

SQL> grant select any table to C##user_id;
SQL> grant create session to C##user_id with admin option;

// for not common user name like user.id but with limited functions
SQL> alter session set "_ORACLE_SCRIPT"=true;

SQL> drop user C##user_id cascade;
SQL> alter user C##jemilatu_razak identified by jemilatu6385 account unlock;

  How to Create Users, Grant Them Privileges, and Remove Them in Oracle Database

Using Oracle Enterprise Manager Database Express 12c

Delete the old versions of Flash before install the following flash player and choose never update during the installation:

Also, install this 64-bit version of Pale Moon browser:

Create users by using the Oracle Enterprise Manager Database Express 12c at
as a SYSDBA (account ID: sys) and using the options

Basic credentials include:
- Hostname: 65.52.222.73
- Port: 1521
- SID: cdb1

To re-activate an account:

To unlock an account because of too many sign-in:

Privileges include:
- Required: table, sequence, session (for connection), alter user (change password), dictionary
- ORDBMS: type, procedure
- Common: index, transaction, trigger, view

Don’t forget using SQLDeveloper to alter user when creating an account as below:
```
   alter user "C##CHASE.DAVIS" quota unlimited on system;
```
If the account expired, just change the password, and it will grant about a half more year.

Using SQL Developer (account ID: sys)

Use the SQL Developer (not Enterprise Manager; account ID: sys) to assign the space to the users via the following command:
where the user name must be uppercase letters and if the name includes special characters, the name must be quoted.

Basic credentials include:
- Hostname: 65.52.222.73
- Port: 1521
- SID: cdb1

To kill a session:
1. In SQL Developer, click Tools, then Monitor Sessions.
2. In the Select Connection dialog box, select a connection to SYSTEM (or another account with full DBA privileges)
3. Right-click in the row for the session to be terminated, and select Kill Session.

To extend the connection time of SQL Developer:
You could turn DBMS output (like collection types) on and setting the polling frequency (refresh) to once 2 minutes or so.
To re-activate an account: