Downloading & Installing
Oracle Software
Downloading Oracle Database Software :-
Open www.oracle.com
Click On “Products” Menu
Select “Oracle Database”
Click on “Download Oracle Database 19c”
[OR] Click on this link
https://www.oracle.com/database/technologies/oracle-database-
software-downloads.html#19c
Select “Windows 64 bit ZIP” File.
Accept the Licence Agreement .
Click on “ Download ”.
You will be redirected to the login Screen in order to download the file.
Enter “Sign in” details if you have oracle account .if don’t have
Oracle account create it by clicking on “Create Account” and ✏️
Enter “Sign in” Details
Oracle Software ZIP FILE will be Downloaded.
Installing Oracle Database Software :-
Create a new Folder with the name “Oracle” in “C:” Drive.
Double Click On “Oracle “ Folder.In this crete another Folder With the name
“db_home”.
Extract Zip File to “db_home”.
Extract zip file to “db_home” Location.
Enter into “db_home” folder .right click on last File “setup” seclect “run As
Administrator.
Select “Create and configure a single instance database”
Click on Next Button
Select “Desktop Class” Option
Click on Next Button
Select “Create New window User .Enter Username,Password and
confirm password
Click on “Next “ Button
Enter Password and Confirm password
[ Remember this password.it is DBA Password ] .
Select “Create as container Database “if not selected
Click on “Next” Button.
Performs Prerequisites check .After 100% click on “ install “ Button.
Click on Install Button
Now Software will be installed
Opening SQLPLUS & Creating User :-
Press “Windows + R “.It displays “Run” Dialog Box.
Type “Sqlplus”
Log in as DBA
Enter User name as “system”.
Enter password which you have given at the time of installation.
Password:-techbuzzit
Create User as Following:-
Syntax to Create the user [ Schema ]:-
Syntax :- Example :-
Create User <user_name> Create user c##techbuzz
Identified by <password> Identified by tb
Default tablespace <tablespace_name> Default tablespace users
Quota<memory> on <tablespace_name>; Quota unlimited on users; //5G //3G
Note:-
While Installing we can find check box (create as container database)
If we De select we can acesss as local user.
If u select we can acesss as 2 users
( Local and Comman User(global) )
C## => Common user( global ) :-can access any database
Local user:- can access only this local database.
Grant permissions to user as following :-
· Grant connect to c##techbuzz;
· Grant resource to c##techbuzz;
( Grant connect ,resource to c##techbuzz ;)
connect ->permission for login
resource->permission for creating table
unlimited tablespace->permission for inserting records permission
for creating table
Modifying Password:
Syntax:
ALTER USER <user_name>
IDENTIFIED BY< new_password > ;
NOTE: give password in alphanumerics only
Example:
Login as DBA
ALTER USER c##batch11pm IDENTIFIED BY shashi;
Dropping User:
Syntax:
DROP USER <user_name>CASCADE ;
Example:
DROP USER c##batch11pm CASCADE;
TO see current username:
SQL> SHOW USER
To Login from SQL command prompt:
SQL> Conn <user_name>/<password>
Conn[ect]: It is used to login from SQL command prompt
Changing Password of DBA :-
Log in as Following:
Username : sys as sysdba
Password- .............................. [don’t enter any password.press enter key]
SQL> Alter user system identified by techbuzzit ;
“techbuzz” is new password.
It is a client program with which you can access Oracle Database.
Both SQL*PLUS and SQL developer are Oracle client tools.
The difference between them is that SQL*PLUS is a command-line
tool but SQL developer is a GUI tool.
Techbuzz IT Solutions -Software Training & Development
[ Bnreddy Nagar -Branch ,Hyderabad ]
