database PL/SQL

Install Oracle 12c on Windows 10 64-bit Version

1. Go to oracle website https://www.oracle.com/database/technologies/oracle-database-software-

downloads.html and choose the right version of Oracle Database 12c Standard Edition for

your computer

2. Accept the license agreement

3. Download 12c and extract zipped files to a folder (example, C:\database)

4. Once all files are extracted successfully, go to the folder where files are extracted. Double

click setup.exe to start the installation process and accept the warning, and this will start

your Oracle Universal Installer.

5. On the First Screen you need to provide your email address if you want to receive all the

notifications and news alerts from oracle. If you do not want it then simply leave these

fields empty and move to next. Accept the warning shown as below as it’s just reminding

you that you didn’t provide the email id.

Just click OK and then Next.

6. Select Create and configure a database for installation option.

7. Select Desktop class for System Class.

8. Select Use Window’s Built-in Account for Oracle Home User.

 Selecting the Built-in Account may bring up this warning:

 Select Yes to continue.

9. Select Standard Edition 2 for Database Edition

 Do not modify the character set.

 Choose orcl for your global database name. (Don’t use the domain.name Global

Database Name format unless you have a domain controller and static IP)

 Type in and confirm an administrative password that you will remember. You will

need this password later to create your user login. So please write down the

password.

 Make sure to uncheck Create as Container database option.

 Click Next (Oracle will now perform prerequisite checks to ensure that your system is compliant with its requirements)

My pass: DbsecFall19

10. Click Save Response File to save the summary to a local file, and then click Install.

 You may see this window during the installation. Once the installation is done, go to

the next step.

11. Database Configuration Assistant:

1. You can skip this step or set the passwords as follows:

o Click Password Management, then set passwords for System and Sys

accounts. For simplicity but not security, use the same password as the one

set in step 9.

o Once passwords are set, click OK to proceed to the next step.

But I did set System and SYS pass: DbsecFall19

12. Finish.

Connect to the Database

1. Go to the Window’s start menu, click the oracle-oraDB12home1, and then double click

SQL Developer. If you see the window below, click No

2. Once the SQL developer starts, create a new connection by clicking shown below:

3. Then configure the connection.

Here are some of the settings:

Connection Name: (You can give any connection name (for example, Dbsec))

Username: system

Password: (It should be the password you set in step 9 or step 11 of the previous

section.)

SID: orcl (or the Global Database Name you set in step 9.

4. If SID, username, and password are correct, you should be able to connect to the

database as SYSTEM user. From there, you can do a lot more things such as creating

users, set privileges, and etc.

Create Users

1. Start SQL Developer and log on as SYSTEM user.

2. Double click the connection name to expend it. Right click Other Users, then click Create

User. Then you need to

o set the User Name and password

o select Default Tablespace as Users and Temporary Tablespace as Temp

o assign the following systems privileges: create trigger, create tablespace, create

table, create sequence, create procedure, create session, create view, create type.

o Set quotas to unlimited to all space.

o Open a different connection and test if the new created user can login to database.

d