Here are some commonly requested customizations...

Connection Rate Limiter

Modify $ORACLE_BASE/network/admin/listener.ora

# listener.ora Network Configuration File: $ORACLE_BASE/network/admin/listener.ora
# Generated by Oracle configuration tools.

CONNECTION_RATE_LISTENER=40

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = gesaasora1.localdomain)(PORT = 1521)(RATE_LIMIT=yes))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

Password Management

Password lockouts can be really frustrating!

The DEFAULT profile sets FAILED_LOGIN_ATTEMPTS at 10 and PASSWORD_LIFE_TIME at 180.

SQL> alter profile DEFAULT limit password_life_time unlimited;
Profile created.

SQL> alter profile DEFAULT limit failed_login_attempts unlimited;
Profile altered.

Bigfile Tablespace

Nothing beats a big file!

create bigfile tablespace TRILNT_DATA
datafile '/ora/app/oracle/oradata/ABERTEST/trilnt_data_01.dbf'
size 32G
autoextend on
maxsize unlimited
extent management local autoallocate;

Bigfile Temporary Tablespace

Nothing beats a big file!

create bigfile temporary tablespace TRILNT_TEMP
tempfile '/ora/app/oracle/oradata/ABERTEST/trilnt_temp_01.dbf'
size 16G
autoextend on next 1G
extent management local uniform size 1M;

Create User

It's addicting!

create user TRILNT_KM identified by "P455W0RD"
default tablespace TRILNT_DATA
temporary tablespace TRILNT_TEMP
profile DEFAULT
account unlock;

Grant Privileges

With great privileges comes great responsibility...

grant all privileges to TRILNT_KM;