Oracle 数据库 11g 中的错误 ORA-12638

2021-12-30 00:00:00 oracle11g windows-7-x64 oracle

我是一名使用 Oracle Database 11g Express 的大初学者,今天第一次尝试.我只获得了数据库的理论知识(学习了 SQL 但从未使用过).所以,我今天安装了 Oracle 11g(在需要时给了他们系统密码).然后我继续启动启动数据库",然后是 SQL 命令行.我输入了 connect SYSTEM/password 但收到:

错误:ORA-12638 : 凭证检索失败

根据各种论坛的建议,我更改了我的 sqlnet.ora 文件,将 SQLNET.AUTHENTICATION_SERVICES = (NTS) 替换为 SQLNET.AUTHENTICATION_SERVICES = (NONE)

>

没有改变任何其他东西.但现在我收到以下错误:

<代码>错误:ORA-01034: ORACLE 不可用ORA-27101: 共享内存领域不存在进程 ID: 0会话 ID:0 序列号:0

除了安装此软件和启动启动数据库之外,我没有做任何其他事情.

顺便说一句,实在找不到深入的教程.

我按照@vercelli 的评论和 .

但是当我以用户域身份重新登录时,我遇到了与以前相同的问题:错误:ORA-12638

像以前那样更改 sqlnet.ora 文件后,作为域用户工作.(请参阅我的回答)可能不是最佳选择.

解决方案

我按照@vercelli 的评论和 .

但是当我以用户域的身份重新登录时,我遇到了与以前相同的问题:ERROR: ORA-12638

因此,我像以前尝试过的那样更改了域用户上的 sqlnet.ora 文件(在收到此 ORA 错误的不同论坛的建议之后):

SQLNET.AUTHENTICATION_SERVICES = (NTS)

SQLNET.AUTHENTICATION_SERVICES = (NONE)

现在它似乎也可以作为域用户使用:我能够连接.

I am a big beginner using Oracle Database 11g Express and tried it for the first time today. I only got theorical knowledge on databases (learned SQL but never used it). So, I installed Oracle 11g today (gave them the password for system when needed). I then proceeded to launch 'Start Database' followed by the SQL command line. I entered connect SYSTEM/password but received :

ERROR: 
ORA-12638 : Credential retrieval failed

Following advices of various forums, I changed my sqlnet.ora file, replacing SQLNET.AUTHENTICATION_SERVICES = (NTS) by SQLNET.AUTHENTICATION_SERVICES = (NONE)

Didn't change anything else. But now I get the following errors :

ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0 Serial number: 0

I did nothing else besides installing this software and launching Start Database.

Can't really find an in-depth tutorial for it by the way.

EDIT : I followed @vercelli 's comment and this topic. Seems like you can't install Oracle 11g XE with an user account connected to the entreprise domain (installation process can't connect to the database). So, I followed these advices : I uninstalled Oracle XE, logged as a local user, installed Oracle XE there and it worked :

.

But when I logged back as an user domain, I had the same issues as before : ERROR: ORA-12638

EDIT : Works as a domain user after changing the sqlnet.ora file as attempted before. (see my answer) Might not be optimal.

解决方案

I followed @vercelli 's comment and this topic. Seems like you can't install Oracle 11g XE with an user account connected to the entreprise domain (installation process can't connect to the database). So, I followed these advices : I uninstalled Oracle XE, logged as a local user with administrator privileges , installed Oracle XE there and it worked on the local user:

.

But when I logged back as an user domain, I had the same issues as before : ERROR: ORA-12638

So, I changed my sqlnet.ora file on the domain user as I had tried before (after advices from different forums who had this ORA error) :

SQLNET.AUTHENTICATION_SERVICES = (NTS)

to

SQLNET.AUTHENTICATION_SERVICES = (NONE)

And now It seems to work as a domain user too : I was able to connect.

相关文章