我的8I是客户端没什么服务啊,看了一下就一个"OracleOraHome81ClientCache"服务,也没有启动! 对了,忘了说一下,SQL PLUS 报错是: ERROR: ORA-12154:TNS:无法处理服务名兄弟们吃饭还没回来吗:)
ORA-12154: TNS:could not resolve service nameCause: Oracle Net could not locate the net service name specified in the tnsnames.ora configuration file.Action: Perform these steps:Verify that a tnsnames.ora file exists. Verify that there are not multiple copies of the tnsnames.ora file. In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor. Verify that there are no duplicate copies of the sqlnet.ora file. If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string. If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out. If you are connecting from a login dialog box, verify that you are not placing an "@" symbol before your connect net service name. Activate client tracing and repeat the operation. Cause: Oracle Net could not locate the database service name or net service name specified in the directory server.Action: Perform these steps:Verify that the database service or net service name entry exists in the directory that this computer was configured to use. Verify that the sqlnet.ora file includes the following entry: NAMES.DIRECTORY_PATH=(ldap, other_naming_methods)
fact: Oracle Server - Enterprise Edition 8.1.6 fact: MS Windows 2000 fact: OS Authentication fact: Windows NT/2000 Domain Model symptom: Unable to connect to the database symptom: TNS-12638 / ORA-12638: Credential retrieval failed cause: Oracle's default Native Authentication Adapter on Windows 2000 is NTS, which uses Kerberos. When using OS authentication the client will try to contact the Kerberos Key Centre (KDC) server on the Windows 2000 Domain Controller. If the client cannot connect to that service the connections will fail with ORA-12638 Credentioal retrieval failed.<Bug:1318637> describes a similar problem on Windows NT/2000 machines not member of a domain. On standalone servers the required services for NTS is not installed. A permanent fix for this problem is in patchset exception 8.1.6.3.1. It should be applied on both the client and the server.fix:Make sure that the Windows 2000 Domain Controller is available and reachable from the client. Use PING in a DOS window to verify the network connection. Contact your network administrator if the network connection is unavailable.
Solution Description -------------------- - On the client side, edit sqlnet.ora (O_H\network\ADMIN) - Replace sqlnet.authentication_services = (NTS) with sqlnet.authentication_services = (BEQ,NONE) Also, verify the Ora_User goup settings..
9I就正常了,我也是这样的,呵呵.
对了,忘了说一下,SQL PLUS 报错是:
ERROR:
ORA-12154:TNS:无法处理服务名兄弟们吃饭还没回来吗:)
Verify that there are not multiple copies of the tnsnames.ora file.
In the tnsnames.ora file, verify that the net service name specified in your connect string is mapped to a connect descriptor.
Verify that there are no duplicate copies of the sqlnet.ora file. If you are using domain names, verify that your sqlnet.ora file contains a NAMES.DEFAULT_DOMAIN parameter. If this parameter does not exist, you must specify the domain name in your connect string. If you are not using domain names, and this parameter exists, delete it or disable it by commenting it out. If you are connecting from a login dialog box, verify that you are not placing an "@" symbol before your connect net service name. Activate client tracing and repeat the operation. Cause: Oracle Net could not locate the database service name or net service name specified in the directory server.Action: Perform these steps:Verify that the database service or net service name entry exists in the directory that this computer was configured to use. Verify that the sqlnet.ora file includes the following entry: NAMES.DIRECTORY_PATH=(ldap, other_naming_methods)
我的机器配置跟系统安装跟你的差不多,可是却安装不上oracle8i 企业版
我是参照以下进行安装的,可是在点击了安装界面的下一步后,鼠标显示忙了两分钟左右,然后就就什么都没了,连安装界面跟任何其他信息都没有,能请问下,我下面的安装有问题吗,或者是?
解决了,我开贴给你贴分,先谢了。1、将 硬盘目录文件\stage\Components\oracle.swd.jre\1.1.7.30/1
\DataFiles\Expanded\jre\win32\bin\symcjit.dll 的文件改名为
symcjit.old
2.从\install\win32 目录下运行SETUP.exe 文件进行安装。
我的8I是装的只是客户端,9I是选的SERVER企业版
不过安装的时候都没有问题啊你的问题不清楚,不好意思:)
8i的客户端连9i的数据库是可以的。
ERROR:
ORA-12638:凭证检索失败不明白问题出在哪儿?而且我自己的机器上也不能用8i的sqlplus连接我的9i server了,同样的ORA-12638错误!!!但是用9isqlplus连哪儿都还可以。这究竟是怎么回事啊???怎么样可以让我和同事的sqlplus既可以连数据中心也可以连我的server啊?
顺便再问一个问题:
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES这个键值下面的
DEFAULT_HOME和LAST_HOME对我的问题好像没有什么影响啊?
而且开始-》程序-》Oracle Installation Products->Home Selector选择8i和9i好像只对系统的path有影响的啊不知道是不是这样?
lsnrctl>status
看是不是有不止一个服务处理程序?
有时候有这种情况,刚启动数据库和监听器时,只有一个服务处理程序
这时候可以从别的客户端连接
可是过了一会儿,会发现多出了好几个,然后从别的客户端就在也连接不上了(但自己可以连接)1、
服务摘要..
服务 "ORCL" 包含 1 个例程。
例程 "ORCL", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
2、
服务 "ORCL" 包含 2 个例程。
例程 "ORCL", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
例程 "ORCL", 状态 BLOCKED, 包含此服务的 1 个处理程序...
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
3、
服务 "ORCL" 包含 2 个例程。
例程 "ORCL", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
例程 "ORCL", 状态 READY, 包含此服务的 2 个处理程序...
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...有时还出现什么"dispacher"之类的字样,这时就连接不上了解决办法,打开init{SID}.ora
找到 dispatchers="(PROTOCOL=……这样的行
如果没有被注释掉(前面没有#号),那么把它注释
我并不知道这一行代表什么意思,但是注释完后问题解决了(不知道是不是从此埋下了祸根)
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "test.erp168" 包含 2 个例程。
例程 "test", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
例程 "test", 状态 READY, 包含此服务的 1 个处理程序...
服务 "testXDB.erp168" 包含 1 个例程。
例程 "test", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功
LSNRCTL>
没有看到dispacher的信息啊
而且硬盘上就4个init*.ora文件:
inithsoledb.ora,inithsodbc.ora,initdw.ora,initsmpl.ora
而且也没有找到dispacher现在还是问题依旧!另外,我的服务启动的都是ORACLE缺省的(自动的,但是我改成了手动,然后,我开机以后,用到的时候才启动):
OracleMTSRecoveryService,OracleOraHome9iAgent,OracleOraHome9iTNSListener,OracleServiceTEST我现在重起一下试试,搞定的话,再开帖送你100分:)
服务 "PLSExtProc" 包含 1 个例程。
例程 "PLSExtProc", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
服务 "test.erp168" 包含 2 个例程。
例程 "test", 状态 UNKNOWN, 包含此服务的 1 个处理程序...
例程 "test", 状态 READY, 包含此服务的 1 个处理程序...
服务 "testXDB.erp168" 包含 1 个例程。
例程 "test", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功这个也没有变啊。
也还是那几个ora文件,没有和我的sid(test)对应的啊?WHY???
俺就纳闷了!!!
现在我的机器上可以了(8i sqlplus connect 9i server),让后在同事机器上也可以了!但是,我不知道什么时候是不是还会不可以连接!这和开心兄说的症状差不多,但是我有没有找到那些文件到底怎么回事啊???
用SQLPLUS时要:
SQLPLUS /NOLOG
CONNECT SYS/***@DBNAME AS SYSDBA
OR
CONN ***/***@DBNAME
也就是 dispatchers = 这一行要注意9i使用的 spfile
必须重新创建spfile或者启动的时候指定 startup pfile = .....init.ora
没有发现init.ora文件啊
我机器上就
inithsoledb.ora
inithsodbc.ora
initdw.ora
initsmpl.ora
init.ora.11172002205419
这几个文件,都在9i下SID时test
# Generated by Oracle configuration tools.NAMES.DEFAULT_DOMAIN = sepco-erpSQLNET.AUTHENTICATION_SERVICES= (NONE)NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)TNSNAMES.ORA# TNSNAMES.ORA Network Configuration File: e:\Oracle\Ora9i\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.TEST.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ERP-168)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
(SERVER = DEDICATED)
(SERVICE_NAME = test.erp168)
)
)FS8DEV.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.249)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8DEV)
)
)FS8PRT.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8PRT)
)
)FINSYS.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.209.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FINSYS)
)
)HR8CNV.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HR8CNV)
)
)HR8INT.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HR8INT)
)
)HRGBL.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.209.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HRGBL)
)
)HR8DEV.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.249)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HR8DEV)
)
)FS8TST.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8TST)
)
)HR8PRT.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HR8PRT)
)
)FS8DMO.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8DMO)
)
)##### PROTOTYPE - HRMS 8.3 ENGLISH #####INST1_HTTP.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ERP-168)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)##### DEVELOPMENT - HRMS 8.3 ENGLISH ########## TEST - FINANCIALS/SCM 8.4 ENGLISH ########## PROTOTYPE - FINANCIALS/SCM 8.4 ENGLISH ########## DEVELOPMENT - FINANCIALS/SCM 8.4 ENGLISH #####
EXTPROC_CONNECTION_DATA.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)FINDEMO.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.209.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FINDEMO)
)
)HRDEMO.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.140.209.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = HRDEMO)
)
)FS8CNV.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8CNV)
)
)FS8ING.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.200)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8ING)
)
)FS8INT.SEPCO-ERP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.158.35.253)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FS8INT)
)
)
该为SQLNET.AUTHENTICATION_SERVICES= (NONE)
以前可能是我没有说清楚,弄得大家想到其他方面去了,
特向biti兄表示歉意,请过来却没有说清楚:)还是书看得少啊,我只是装了个数据库,什么也还不懂呢!
揭贴了才看到你的回复。我刚才试了一下,又改成了SQLNET.AUTHENTICATION_SERVICES= (NTS)
然后在 运行-》CMD-》SQLPLUS /NOLOG
进入SQL>后,用conn user/pass@xxx
在9iSQLPLUS下可以,8iSQLPLUS下还是
ERROR:
ORA-12638: 凭证检索失败而且,SQLNET.AUTHENTICATION_SERVICES= (NTS)的时候
我也有成功连接过一次,只一次而已现在改成了(NONE)的时候倒是都可以NONE和NTS有什么区别啊,NTS基于系统认证具体什么机制啊?我的为什么会有这样的问题呢:有时候可以有时候不可以?
我再开帖给你分:)
以sysdba身份登陆数据库的时候采用操作系统认证
这样任意输入任何密码都可以登陆conn sys/fstfsr as sysdba
conn sys/heryreyur as sysdba这样都可以登陆但是不采用这种认证方式的时候
必须正确输入密码
SQLNET.AUTHENTICATION_SERVICES= (NTS)
改为
SQLNET.AUTHENTICATION_SERVICES= (NONE)都可以连接我的9i server,如果都是NTS的话,8i还是有ORA-12638错误biti兄说用conn user/pass@xxx 和这没有关系
可我现在这儿确实有关系的啊唉,不明白?
fact: MS Windows 2000
fact: OS Authentication
fact: Windows NT/2000 Domain Model
symptom: Unable to connect to the database
symptom: TNS-12638 / ORA-12638: Credential retrieval failed
cause: Oracle's default Native Authentication Adapter on Windows 2000 is
NTS, which uses Kerberos. When using OS authentication the client will try to
contact the Kerberos Key Centre (KDC) server on the Windows 2000 Domain
Controller. If the client cannot connect to that service the connections will
fail with ORA-12638 Credentioal retrieval failed.<Bug:1318637>
describes a similar problem on Windows NT/2000 machines not member
of a domain. On standalone servers the required services for NTS is not
installed. A permanent fix for this problem is in patchset exception 8.1.6.3.1.
It should be applied on both the client and the server.fix:Make sure that the Windows 2000 Domain Controller is available and reachable
from the client. Use PING in a DOS window to verify the network connection.
Contact your network administrator if the network connection is unavailable.