Oracle 10g R2 管理（RHEL 5.4）

[edgen@rhel54 ~]$ su - oracle
口令： 

[oracle@rhel54 ~]$ lsnrctl
LSNRCTL> service
LSNRCTL> start
Starting /app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /app/oracle/product/10.2.0/db_1/network/log/listener.log
...
The command completed successfully
LSNRCTL> help
LSNRCTL> exit

 

[oracle@rhel54 ~]$ export ORACLE_SID=DB_INSTANCE_ID

[oracle@rhel54 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 31 20:24:50 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  557842432 bytes
Fixed Size      1220532 bytes
Variable Size    159383628 bytes
Database Buffers   390070272 bytes
Redo Buffers      7168000 bytes
Database mounted.
Database opened.
SQL> select * from dual;

D
-
X

SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

[oracle@rhel54 ~]$ lsnrctl stop

 

 

[oracle@rhel54 ~]$ vi $ORACLE_HOME/network/admin/listener.ora
[oracle@rhel54 ~]$ cat $ORACLE_HOME/network/admin/listener.ora

[oracle@rhel54 ~]$ netca

 

[oracle@rhel54 ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora

[oracle@rhel54 ~]$ cat $ORACLE_HOME/network/admin/tnsnames.ora

 

 

[oracle@rhel54 ~]$ emctl start dbconsole

[oracle@rhel54 ~]$ emctl stop dbconsole

 

[oracle@rhel54 ~]$ emca -config dbcontrol db

 

[oracle@rhel54 ~]$ dbca