Chinaunix

标题: 求助: ORA-12549: TNS:operating system resource quota exceeded [打印本页]

作者: Chinese_Dragon 时间: 2008-03-18 21:19
标题: 求助: ORA-12549: TNS:operating system resource quota exceeded
C:\Documents and Settings\Eric Zhang>sqlplus / as sysdba
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 3月 18 21:15:05 2008

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

ERROR:
ORA-12549: TNS:operating system resource quota exceeded

Enter user-name:

C:\Documents and Settings\Eric Zhang>tnsping ora10g

TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-3月 -
2008 21:12:41

Copyright (c) 1997, 2003, Oracle.  All rights reserved.

Used parameter files:
D:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = localhost)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ora10g)))
OK (110 msec)

C:\Documents and Settings\Eric Zhang>sqlplus /nolog
SQL*Plus: Release 10.1.0.2.0 - Production on 星期二 3月 18 21:17:35 2008

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

SQL> connect system/oracle@ora10g
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

SQL>

请问这是怎么回事 ??

作者: blue_stone 时间: 2008-03-19 08:33
lsnrctl status 看看
tnsping只检测端口是否被监听, 不检测listener是否监听了这个服务.

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)