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, 11.2.0.3.0

 

Procedure

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.

 

Result

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>.

 

Example

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 11.2.0.3.0 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 11.2.0.3.0 - 64bit Production

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

SQL>