Start Oracle 10 Gb Enterprise Manager and ISQLPLUS and sqlplus in Linux

After installing Oracle 10 Gb last time, I started to try to remotely use and manage Oracle, but the road was uneven. The following are the records about starting and using EM, sqlplus, and ISQLPLUS:

First, remotely log on to the Linux server through telnet, and then start sqlplus to complete most DML operations.

1. Start sqlplus

After successful logon, enter sqlplus at the terminal prompt, as shown below:

[Oracle @ graduate ~] $ Sqlplus

SQL * Plus: Release 10.2.0.1.0-production on Thursday October 5 20:25:03 2006

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Enter the User name: Scott
Enter the password:

Connect:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-Production
With the partitioning, OLAP and Data Mining options

SQL>

2. Start EM (Enterprise Management)

Enter the following command at the terminal prompt:

For emctl usage, you can enter emctl directly at the prompt without adding any other options.

[Oracle @ graduate ~] $ Emctl start dbconsole

TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996,200 5 Oracle Corporation. All rights reserved.
Http: // % E4 % BD % A0 % E7 % 9A % 84ip: 1158/EM/console/aboutapplication

3. Start ISQLPLUS (ISQLPLUS is the sqlplus available in the browser. The specific usage will be discussed later)

[Oracle @ graduate ~] $ Isqlplusctl start
ISQL * Plus 10.2.0.1.0
Copyright (c) 2003,200 5, Oracle. All rights reserved.
Warning, got duplicate TCP line.
Starting iSQL * Plus...
ISQL * Plus started.

------------------------------------------

The following information is used by the user for recording and is irrelevant to the above description.

Modify. bash_profile in the Oracle user's home directory

Change to the approximate way

#. Bash_profile

# Get the aliases and functions
If [-f ~ /. Bashrc]; then
.~ /. Bashrc
Fi

# User specific environment and startup programs

Path = $ path: $ home/bin

Export oracle_base =/u01/APP/Oracle
Export ORACLE_HOME = $ oracle_base/product/10.2.0/db_1
Export ora_crs_home = $ oracle_base/product/CRS
Export oracle_sid = orcl1

Export Path =. :$ {path }:$ home/bin: $ ORACLE_HOME/bin
Export path =$ {path }:/ usr/bin:/usr/bin/X11:/usr/local/bin
Export path =$ {path}: $ oracle_base/common/Oracle/bin
Export oracle_term = xterm
Export tns_admin = $ ORACLE_HOME/Network/admin
Export ora_nls10 = $ ORACLE_HOME/NLS/Data
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib
Export LD_LIBRARY_PATH =$ {LD_LIBRARY_PATH}: $ ORACLE_HOME/mongom/lib
Export LD_LIBRARY_PATH =$ {LD_LIBRARY_PATH}:/lib:/usr/local/lib
Export classpath = $ ORACLE_HOME/JRE
Export classpath =$ {classpath}: $ ORACLE_HOME/jlib
Export classpath =$ {classpath}: $ ORACLE_HOME/rdbms/jlib
Export classpath =$ {classpath}: $ ORACLE_HOME/Network/jlib
Export threads_flag = native
Export temp =/tmp
Export tmpdir =/tmp