Database Reference
In-Depth Information
Figure 1.11
Win2K Registry
ORACLE_SID
Variable.
The password for the users named SYS and SYSTEM
. The Oracle
Database Configuration Assistant in Oracle Database 10
g
allows set-
ting of SYS and SYSTEM passwords to the same value.
If you are running a database on your own computer or on a database
server, you can reach the database directly by omitting the database name.
When you omit the name, Oracle uses the bequeth protocol and the cur-
rent $ORACLE_SID variable setting to access the database. In Windows
the $ORACLE_SID variable is set in the registry, and on UNIX or Linux
in a user or root profile. Figure 1.11 shows a Win2K registry location.
When you use the database name, Oracle uses the transmission control
protocol (TCP). Follow these steps to start up SQL*Plus Command Line
and run an SQL command:
Note:
The steps here, and throughout the topic, use the sample tables and
data created especially for this topic. Appendix A contains instructions for
locating and installing all of the sample tables.
1.
Go to a command-line prompt on your computer. If you are
using Windows, click on Start/Programs/Accessories/Command
Prompt. A window appears with a blinking cursor. This is your
