手动启动oracle数据库用oracle用户身份登陆su - oraclepassword:
sqlplus "/ as sysdba"sql>startupsql>quit
lsnrctl start
具体屏幕显示如下：
[oracle@myxinnet-2 bin]$ su - oraclePassword: [oracle@myxinnet-2 oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 1 16:27:08 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startupORACLE instance started.
Total System Global Area 1241513984 bytesFixed Size 1219136 bytesVariable Size 268436928 bytesDatabase Buffers 956301312 bytesRedo Buffers 15556608 bytesDatabase mounted.Database opened.
SQL> quitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining options[oracle@myxinnet-2 oracle]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 01-FEB-2007 16:27:58
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /home/database/product/10.2.1//bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionSystem parameter file is /home/database/product/10.2.1/network/admin/listener.oraLog messages written to /home/database/product/10.2.1/network/log/listener.logListening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myxinnet-2)(PORT=1521)))Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myxinnet-2)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 10.2.0.1.0 - ProductionStart Date 01-FEB-2007 16:28:00Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File /home/database/product/10.2.1/network/admin/listener.oraListener Log File /home/database/product/10.2.1/network/log/listener.logListening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myxinnet-2)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))Services Summary...Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...The command completed successfully
