直接上现象,相信大家都看得懂:
C:\Documents and Settings\user>lsnrctl statusLSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-7月 -2009 16:4
6:15Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=162.16.1.75)(PORT=1521))
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 13-7月 -2009 16:44:02
Uptime 0 days 0 hr. 2 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=162.16.1.75)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", 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 successfullyC:\Documents and Settings\user>lsnrctl serviceLSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-7月 -2009 16:5
2:54Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=162.16.1.75)(PORT=1521))
)
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfullyC:\Documents and Settings\user>sqlplus /nologSQL*Plus: Release 10.1.0.2.0 - Production on 星期一 7月 13 16:54:10 2009Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn /@orcl as sysdba
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process
SQL>
C:\Documents and Settings\user>lsnrctl statusLSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-7月 -2009 16:4
6:15Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=162.16.1.75)(PORT=1521))
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 13-7月 -2009 16:44:02
Uptime 0 days 0 hr. 2 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=162.16.1.75)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", 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 successfullyC:\Documents and Settings\user>lsnrctl serviceLSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 13-7月 -2009 16:5
2:54Copyright (c) 1991, 2004, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=162.16.1.75)(PORT=1521))
)
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfullyC:\Documents and Settings\user>sqlplus /nologSQL*Plus: Release 10.1.0.2.0 - Production on 星期一 7月 13 16:54:10 2009Copyright (c) 1982, 2004, Oracle. All rights reserved.SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn /@orcl as sysdba
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process
SQL>
确认一下。
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error
SQL> conn /@orcl as sysdba
ERROR:
ORA-12500: TNS:listener failed to start a dedicated server process 这是让我最奇怪的,小弟刚学ORACL没多久,不熟悉,希望各位大侠指点指点啊!!
SQL> startup
ORA-12560: TNS:protocol adapter error
SQL>
或者在cmd下输入net start
看有没有oracleserviceorcl
我的电脑-管理-服务与应用程序-服务,查看 OracleServiceSID 启动了没
command:
oradim -new -sid orcl
如果我不通过创建服务的方式来启动OracleServiceSID ,我又应该通过什么方式来启动OracleServiceSID 呢?
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 145488364 bytes
Database Buffers 25165824 bytes
Redo Buffers 524288 bytes
Database mounted.
Database opened.
SQL> select table_name from all_tables;TABLE_NAME
------------------------------
REGIONS
ICOL$
如果已经存在服务的话,可以通过net start oracleserviceorcl来启动。
如果有,就能找到。
以前我都是在服务里面启动的,前段时间杀木马,不小心把关于ORACLE的一些东西给删了!!
今天按照上面那个人的在服务里面添加了一个服务就可以了!!