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, 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, sqlplus
lists information about the Oracle version and about the database, and displays
the 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