Database Reference
In-Depth Information
Before you begin the following steps, you will need these two pieces of
information about your database:
The database name or network name
. If you are running the
database on your own computer, this is the name you gave the data-
base when it was created. If you are not sure what you named it, go
to a command prompt (see step 1 to learn how) and then type this
command:
lsnrctl status
Look for a line that begins like this. The word in quotation marks
is your database name. In this example, the database SID name is
OLTP.
Instance "oltp", status READY, ...
If you are running from a client computer and using a remote
database on the network, you must use the network name defined in
your local Oracle Net configuration. The configuration file named
TNSNAMES.ORA has all of the network names available to you.
The file is located in $ORACLE_HOME/network/admin directory.
Here is an example of the text found in the TNSNAMES.ORA file
for the OLTP network name:
OLTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 1300server)
(PORT = 1521)))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oltp)))
