Oct 9, 2021
6 min read
[PL/SQL] Install/Uninstall Oracle 19c
How to install/uninstall Oracle database, enable HR schema, PL/SQL Developer 14, TNS listener, …
1. Install Oracle database
- Download Oracle 19c at Oracle homepage
- Create manually directory as below
D:\app\oracle\product\19.3\db_home1Then extract the zip file downloaded in the 1st step into “db_home1” folder
- Setup
Let’s take a coffee, and wait…😎😎 until it’s done as below
- 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.0Copyright (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.0SQL> 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-0527 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 88D8364765FCE6AF27 rows selected.
- Now we can connect database with account “hr” and password “admin”
2. Uninstall Oracle database
There are 2 ways to uninstall Oralce database :
- Use Oracle “Universal Installer”
- Manual
In this topic, I’ll introduce a manual way
Step 1 : Delete Oracle servcies
- Stop Oracle services which are running
- Delete all oracle services by command line
sc delete service_name
Step 2 : Delete shorcuts in Startup menu
Step 3 : Delete the installation and inventory folder of Oracle
Step 4: Delete registry
3. Install PL/SQL Developer
- Download PL/SQL Developer on homepage
- 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
