After Oracle installation is done, it’s time to learn how to verify Oracle installation on windows 10. Following the below mentioned steps you can verify your installation and unlocking of the databases.

How to verify Oracle Installation

  1. Go to your windows start program and type Oracle – HOME_NAME and select Open file location. This will take you to the Oracle home directory in your windows folder. This is where Oracle software is installed.

Location of Oracle Home

2. In the same folder, navigate to \product\11.2.0\dbhome_4\NETWORK\ADMIN. This path will contain three important files required by Oracle for connection listener.ora, Sqlnet.ora and tnsnames.ora

Open tnsnames.ora and verify the last entry, it should be:

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

orcl is the name of the SID specified during Oracle installation. If you provided a different name, use that name.

3. Go to your windows start program again and type Services. This will take you to the Windows Services. Verify Oracle services and make sure they are running. You can modify these services to start automatic (when you restart your laptop) or manual. Anytime you have a problem connecting to your database, check the services.

Oracle Services running on Windows
Oracle Services running on Windows

Connect to installed databases to verify Oracle Installation

4. Start command prompt on your laptop. Go to windows start program and type cmd.

In the command prompt window, type the following command to logon as user system  with password oca. I created this administrative password during installation. If you used a different password, then use your password.

CMD Command

This will connect you to Sqlplus.

5. Use the following command, if you want to know the details about the Oracle version installed.

oracle-installation-on-windows-10

6. Now connect to one of the users you have unlocked during installation. I will connect to user hr. You can check other users in the same way.

Sql-Ohio Computer

7. Check the tables owned by this user hr.

Structured Query Language

8. Now you have the list of tables, write a simple Select statement to view the data

Structured Query Language

Following the above mentioned steps, you can verify that the installation was done successfully and you can connect to your sample databases.

2 thoughts on “How to verify Oracle installation on windows 10”

  1. Anonymous

    Nice article…

  2. Vidya Sanjivi

    Oracle Installation explained easily

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.