ssh 连接下服务器,
一:启动oracle
[root@localhost ~]# su -l oracle
[oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 19 08:51:22
2010
Copyright (c) 1982, 2005, Oracle. All rights
reserved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1.0100E+10 bytes
Fixed
Size 2037376 bytes
Variable
Size 1979713920 bytes
Database
Buffers 8103395328 bytes
Redo
Buffers 14737408 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release
10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
二:启动oracle监听
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on
19-JUL-2010 08:54:06
Copyright (c) 1991, 2005, Oracle. All rights
reserved.
Starting /home/oracle/db/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is
/home/oracle/db/network/admin/listener.ora
Log messages written to
/home/oracle/db/network/log/listener.log
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start
Date 19-JUL-2010 08:54:07
Uptime 0 days 0 hr. 0 min. 0 sec
Trace
Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/db/network/admin/listener.ora
Listener Log
File /home/oracle/db/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1
handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$
[oracle@localhost ~]$
三:查看oracle 服务
ps -ef
oracle 5776 1 0 08:54
? 00:00:00 /home/oracle/db/bin/tnslsnr LISTENER -inherit
oracle 5791 1 0 08:56
? 00:00:00 ora_j000_orcl
看到两个服务,oracle 即正常启动