First Steps after Oracle Installation

In this story, we are going to see what are the first steps after Installing Oracle in your computer.

Assumptions:

I assume that you have installed Oracle Express Edition & SQLDeveloper on your Windows 10 machine.

[Optional] Set environment variable ORACLE_XE_HOME

SET Environment Variable

You should be able to connect with Oracle as SYSTEM user on SQL Developer

Connect as SYSTEM

You may want to see all the USERS automatically created by the Installer.

List all USERS

How to create a new user (without using C## prefix)

ALTER SESSION SET “_ORACLE_SCRIPT” = TRUE;

CREATE USER Anil IDENTIFIED BY anil123;

Alter Session & Create User

By default, newly created users will not be allowed to establish a connection with database.

If you try connect as Anil .. You will an error

User lacks creating a session with database engine

GRANT the user to connect, play with resources (table, schema, etc) and DBA (administrator activities)

Grant to connect

Connect as Anil

Connected as Anil — Success

CREATE a Table called PRODUCT

Model

Table created

As first steps after installing Oracle, now you have

1. Created a New User
2. Connected as the New User
3. Created a Table

Note:

Oracle User: is a database account

Oracle Schema: is the User + User’s objects

User’s Objects: Table, View, Index, etc.

Reference:

• create_user_12c_without_c_prefix
• oracle-user-schema-difference
• create-user-and-grant-permissions

Thank you for reading this story !! … See you in Next Story :-)