[PL/SQL] Install/Uninstall Oracle 19c

1. Install Oracle database

  • Download Oracle 19c at Oracle homepage
https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
  • Create manually directory as below
D:\app\oracle\product\19.3\db_home1
  • Setup
  • You can check if it was successfully via sql*plus tool
  • Login sql*plus as system dba and enable “HR” schema
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Oct 9 12:45:51 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> ALTER USER HR IDENTIFIED BY HR ACCOUNT UNLOCK;User altered.SQL> GRANT DBA TO HR;Grant succeeded.SQL> ALTER USER hr IDENTIFIED BY admin;User altered.SQL>--List all users
SQL> SELECT username, user_id, created, password FROM ALL_USERS ORDER BY username ASC;
USERNAME USER_ID CREATED
------------------------------ ---------- ---------
ANONYMOUS 39 30-AUG-05
BI 60 14-AUG-21
CTXSYS 36 30-AUG-05
DBSNMP 24 30-AUG-05
DIP 19 30-AUG-05
DMSYS 35 30-AUG-05
EXFSYS 34 30-AUG-05
HR 55 14-AUG-21
IX 57 14-AUG-21
MDDATA 50 30-AUG-05
MDSYS 46 30-AUG-05
MGMT_VIEW 53 30-AUG-05
OE 56 14-AUG-21
OLAPSYS 47 30-AUG-05
ORDPLUGINS 44 30-AUG-05
ORDSYS 43 30-AUG-05
OUTLN 11 30-AUG-05
PM 59 14-AUG-21
SCOTT 54 30-AUG-05
SH 58 14-AUG-21
SI_INFORMTN_SCHEMA 45 30-AUG-05
SYS 0 30-AUG-05
SYSMAN 51 30-AUG-05
SYSTEM 5 30-AUG-05
TSMSYS 21 30-AUG-05
WMSYS 25 30-AUG-05
XDB 38 30-AUG-05
27 rows selected.--List all users + password (encoded)
SQL> SELECT username, user_id, password FROM dba_users ORDER BY username ASC;
USERNAME PASSWORD
------------------------------ ------------------------------
ANONYMOUS anonymous
BI FA1D2B85B70213F3
CTXSYS 71E687F036AD56E5
DBSNMP FF056FB0C18D2BDA
DIP CE4A36B8E06CA59C
DMSYS BFBA5A553FD9E28A
EXFSYS 66F4EF5650C20355
HR 6D437D82F773AA29
IX 2BE6F80744E08FEB
MDDATA DF02A496267DEE66
MDSYS 72979A94BAD2AF80
MGMT_VIEW F25A184809D6458D
OE 9C30855E7E0CB02D
OLAPSYS 3FB8EF9DB538647C
ORDPLUGINS 88A2B2C183431F00
ORDSYS 7EFA02EC7EA6B86F
OUTLN 4A3BA55E08595C81
PM 72E382A52E89575A
SCOTT 8FAFBD2CDA90EF88
SH 9793B3777CD3BD1A
SI_INFORMTN_SCHEMA 84B8CBCA4D477FA3
SYS 9F5DC8AABBB6AA51
SYSMAN 41B4B9C2A82FA6A2
SYSTEM 7E8D839514B8F38B
TSMSYS 3DF26A8B17D0F29F
WMSYS 7C9BA362F8314299
XDB 88D8364765FCE6AF
27 rows selected.
  • Now we can connect database with account “hr” and password “admin”

2. Uninstall Oracle database

  • Use Oracle “Universal Installer”
  • Manual
  • Stop Oracle services which are running
  • Delete all oracle services by command line
sc delete service_name

3. Install PL/SQL Developer

  • Download PL/SQL Developer on homepage
https://www.allroundautomations.com/try-it-free/
  • In case of connecting directly from localhost by sql*plus, then we don’t need listener. Else we need to install listener (i.e : for using in PL/SQL Developer).
  • If we don’t install listener, we’ll face error “ORA-12541: TNS:no listener” due to there is no listener service.
  • We can install Listener by “Net Configurayion Assistant”
  • Now, if we go to Services, we’ll see a new Listener service is running. If it is not running, we can’t connect database
  • Retry and then we can connect successfully

--

--

--

“Developer never die” 😎🇻🇳

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

What is SQL?

The Cycle All Great Software Engineering Teams Avoid

What is a nightly build in Solidity?

How to solve the singleton problem in Django ModelAdmin.

Automating LVM Partition using Python-Script

Is front-end development having a identity crisis? — Part II

MongooseIM 2.1.1 — More than a patch!

How to Learn Effectively

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
binh12A3

binh12A3

“Developer never die” 😎🇻🇳

More from Medium

Cinchoo ETL — CSV Lite Reader

How I cleared Microsoft Azure AZ-204 in 30 days

Extending the SQL and PL/SQL with custom external functions and procedures

Local and Global variables