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.

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.

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.

This will connect you to Sqlplus.

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

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.

7. Check the tables owned by this user hr.

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

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