User`s guide

Chapter 14: Database Administration 229
Figure 105: SQLPlus connection
Check that the output is something like the example output below:
C:\>sqlplus pilot/pilot@viz-xw4300/xe
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 20 12:17:19 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL>
The example output above shows that the database is placed on a remote
machine, named
viz-xw4300 , thus the connection string @viz-xw4300/xe is
needed (
hostname/SID ) or just the TNS name.
C:\>sqlplus pilot/pilot@VIZRTDB
Note: The above screenshot and output example use the SID XE . This is the default
SID for Oracle 10g XE, which is an Oracle ‘test database’.