今年(2009)上班的第一件事:学习了linux下启动oracle数据库

教程的内容:
1. linux下启动oracle

su - oracle
sqlplus /nolog
conn /as sysdba
startup               停止数据库shutdown 
exit
lsnrctl start
exit
实际启动时的整过过程

Last login: Tue Jan  3 17:54:13 2006 from 222.18.139.67
[root@localhost ~]# su - oracle              ===oracle是环境变量    
-bash-3.00$ sqlplus /nolog                      ===
 
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jan 3 18:14:20 2006
 
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
 
SQL> conn sys/syl6413 as sysdba             ===sys是用户名  syl413是密码      
Connected to an idle instance.
SQL> startup                                         ===                    
ORACLE instance started.
 
Total System Global Area  608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             192941868 bytes
Database Buffers          406847488 bytes
Redo Buffers                7163904 bytes
exitDatabase mounted.
 
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
-bash-3.00$ lsnrctl start     ====监听端口
 
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 03-JAN-2006 18:16:03
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
 
Starting /oracle/oracle/bin/tnslsnr: please wait...
 
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/oracle/network/admin/listener.ora
Log messages written to /oracle/oracle/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=222.18.139.70)(PORT=1521)))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date                03-JAN-2006 18:16:04
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/oracle/network/admin/listener.ora
Listener Log File         /oracle/oracle/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=222.18.139.70)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "qhqx" has 1 instance(s).
  Instance "qhqx", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
-bash-3.00$ exit
logout
[root@localhost ~]#

原文地址:https://www.cnblogs.com/jifeng/p/1700582.html