Testing an Oracle Server Installation
Use SQL Plus to verify that the database connection with the Oracle Server is okay.
Note:The Oracle version installed is 11gR2, 220.127.116.11.0
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:
<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, sqlpluslists information about the Oracle version and about the database, and displaysthe prompt SQL>.
SQL*Plus: Release 18.104.22.168.0 Production on Tue Dec 18 15:11:32 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options