- 论坛徽章:
- 0
|
"/home/oracle/product/10g/bin" $ >./dbstart
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 5 03:51:08 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 134217728 bytes
Fixed Size 777776 bytes
Variable Size 74457552 bytes
Database Buffers 58720256 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
Database "ORA10G" warm started.
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 05-AUG-2009 03:51:25
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting /home/oracle/product/10g/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.1.0.2.0 - Production
System parameter file is /home/oracle/product/10g/network/admin/listener.ora
Log messages written to /home/oracle/product/10g/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.1.0.2.0 - Production
Start Date 05-AUG-2009 03:51:25
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/oracle/product/10g/network/admin/listener.ora
Listener Log File /home/oracle/product/10g/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Services Summary...
Service "ORA10G" has 1 instance(s).
Instance "ORA10G", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
这回我倒腾了一会敲dbstart没反应了
"/home/oracle" $ >dbshut
LSNRCTL for Linux: Version 10.1.0.2.0 - Production on 05-AUG-2009 05:37:52
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 2: No such file or directory
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Aug 5 05:37:52 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
SQL> Disconnected
Database "ORA10G" shut down.
"/home/oracle" $ >ps ux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 6149 0.0 2.7 48396 7072 ? Ss 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6151 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6152 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6153 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6154 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6155 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6156 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6157 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6158 0.0 2.7 48396 7072 ? S 03:58 0:01 /home/oracle/product/10g/bin/ocssd.bin
oracle 6160 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6161 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6162 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6163 0.0 2.7 48396 7072 ? S 03:58 0:01 /home/oracle/product/10g/bin/ocssd.bin
oracle 6164 0.0 2.7 48396 7072 ? S 03:58 0:00 /home/oracle/product/10g/bin/ocssd.bin
oracle 6165 0.0 2.7 48396 7072 ? S 03:58 0:01 /home/oracle/product/10g/bin/ocssd.bin
oracle 7014 0.3 0.5 5856 1424 pts/1 S 05:37 0:00 -bash
oracle 7075 0.0 0.3 3836 768 pts/1 R+ 05:37 0:00 ps ux
"/home/oracle" $ >
问题可能很菜,发到新手里面有位大哥说这里解决的可能性要大点,懂的指点一下喽 |
|