Tip of the Week: Testing an Oracle Server Installation

Blog Post created by JoyM on Oct 19, 2014

Testing an Oracle Server Installation

Use SQL Plus to verify that the database connection with the Oracle Server is okay.


The Oracle version installed is 11gR2,



In Services, check that the Oracle listener is started.

In Services, check that the Oracle database service is started.

Open a command prompt and use the cd command to navigate to <oracle_home>\BIN:

For example: C:\app\myuser\product\11.2.0\dbhome_1\BIN

Enter this command:

sqlplus system/<password>@<instance>

<password> is the password entered for the SYSTEM user when Oracle was installed

<instance> is the database instance.



If the database can be accessed using the credentials you have entered, sqlplus
lists information about the Oracle version and about the database, and displays
the prompt SQL>.



C:\app\myuser\product\11.2.0\dbhome_1>cd bin

C:\app\myuser\product\11.2.0\dbhome_1\BIN>sqlplus system/mypassword@mydb


Successful output:

SQL*Plus: Release Production on Tue Dec 18 15:11:32 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options