ORA-12631
Oracle 10G冒出的错误:
ORA-12631: Username retrieval failed
Cause: The authentication service failed to retrieve the name of a user.
Action: Enable tracing to determine which routine is failing.
Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-12631: Username retrieval failed
/apps/beta14a.asp, line 96
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; SBC; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Page:
GET /apps/beta14a.asp
Time:
Monday, July 12, 2004, 10:23:05 AM
对于这个错误 ,一般是由于使用域用户帐号登录导致的,如果换成本地用户则没有问题。
解决方案:
RESOLUTION on METALINK:
These errors are associated with remote authentication on NT under NTS (NT Transport Services). Essentially, the following parameter is set in the “sqlnet.ora”:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
As a result, if you are logged on as a domain user, and you don’t have a network connection (network cable temporary removed or laptop booted standalone), you will not be able to connect to the database because the authentication will try to reach the domain users database on the PDC (Primary Domain Controller) or BDC (Backup Domain Controller).
Solution Description:
There a 2 solutions to connect to the database when no network is present:
1. You can log in as a NT local user.
2. You can disable NTS in sqlnet.ora by setting the following parameter:
SQLNET.AUTHENTICATION_SERVICES = (NONE)
通过使用NONE,成功解决此问题。
ORA-15306
[oracle@testos:/home/oracle]$ oerr ora 15306
15306, 00000, "ASM password file update failed on at least one node"
// *Cause: A CREATE USER, ALTER USER, DROP USER, GRANT, or REVOKE
// command failed on at least one node of the Automatic Storage
// Management (ASM) cluster.
// *Action: Check the ASM alert logs for more information.
//
[oracle@testos:/home/oracle]$
现象
ASMCMD> orapwusr --modify --password sys
Enter password: ********
ORA-15306: ASM password file update failed on at least one node
ORA-15321: cannot set attribute with connected clients (DBD ERROR: error possibly near <*> indicator at char 41 in '/* ASMCMD */alter user sys identified by <*>adadadad')
ASMCMD> exit
sql内改
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 14 20:10:44 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter user sys identified by Oracle123;
alter user sys identified by Oracle123
*
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node
ORA-15321: cannot set attribute with connected clients
解决方法
#进入grid_home的dbs
[grid@rac1 dbs]$ pwd
/u01/app/11.2.0/grid/dbs
[grid@rac1 dbs]$ ls
ab_+ASM1.dat hc_+ASM1.dat init.ora
#创建秘钥文件
[grid@rac1 dbs]$ orapwd file='orapw+ASM1' entries=5 password=Oracle123
[grid@rac1 dbs]$ ls
ab_+ASM1.dat hc_+ASM1.dat init.ora orapw+ASM1
#复制到其它节点
[grid@rac1 dbs]$ scp orapw+ASM1 rac2:/u01/app/11.2.0/grid/dbs/orapw+ASM2
orapw+ASM1 100% 2048 2.0KB/s 00:00
[grid@rac1 dbs]$
#创建 asmsnmp 并赋予权
[grid@rac1 rac1]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Tue Apr 14 20:14:53 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> create user asmsnmp identified by Oracle123;
User created.
SQL> grant sysdba to asmsnmp;
Grant succeeded.
SQL> select * from v$pwfile_users;
USERNAME SYSDBA
------------------------------------------------------------ ----------
SYSOPER SYSASM
---------- ----------
SYS TRUE
TRUE FALSE
ASMSNMP TRUE
FALSE FALSE
SQL>
更改成功
[grid@rac1 rac1]$ asmcmd
ASMCMD> orapwusr --modify --password sys
Enter password: *********
ASMCMD>
ASMCMD>
ASMCMD>
2、Creating ASMSNMP User reports ORA-15306: ASM Password File Update Failed On At Least One Node. (文档 ID 1137504.1)
Applies to
Oracle Database - Enterprise Edition - Version 11.1.0.7 and later Information in this document applies to any platform.
Symptoms
Creating the ASMSNMP user on 11.2 ASM RAC reports the next error:
SQL> create user asmsnmp identified by test01;
create user asmsnmp identified by test01
*
ERROR at line 1:
ORA-15306: ASM password file update failed on at least one node
Cause
The ORA-15306 error demonstrates that the ASM password file is missing in one or several node(s) or it is corrupt.
Solution
-
Remove all the ASM password files from each node:
rm Grid Oracle Home/dbs/orapw+ASM rm Grid Oracle Home/dbs/orapw+ASM . . rm Grid Oracle Home/dbs/orapw+ASM
-
Create ASM password file manually on the first node as the OS user which owns the Grid Infrastructure:
$> orapwd file='orapw+ASM' entries=5 password=
-
Copy the password file to all nodes with the correct ASM instance name:
scp orapw+ASM to remote node #1 : Grid Oracle Home/dbs/orapw+ASM scp orapw+ASM to remote node #2 : Grid Oracle Home/dbs/orapw+ASM . . scp orapw+ASM to remote node # : Grid Oracle Home/dbs/orapw+ASM
-
Add the ASMSNMP user in ASM instance, and grant sysdba privilege to it:
SQL> create user asmsnmp identified by; SQL> grant sysdba to asmsnmp;
-
Verify the ASMSNMP user was created:
SQL> select * from v$pwfile_users; USERNAME SYSDB SYSOP SYSAS ------------------------------ ----- ----- ----- SYS TRUE TRUE TRUE ASMSNMP TRUE FALSE FALSE
Note: Pre 11gR2, each node in the cluster had ASM password file named as orapw. Starting 11gR2, password file in a RAC cluster is named using the format orapw<+’_asmsid’> .”_asmsid”
is an underscore parameter that defines default SID/Name of ASM instance:
Value Value
Underscore Parameter Session Instnc Description
------------------------------------------ ------- ------- ---------------------------------------------------------
_asmsid asm asm ASM instance id
Example
Pre 11gR2:
Password file on Node1: orapw+ASM1
Password file on Node2: orapw+ASM2
11gR2 and onwards:
Password file on Node1: orapw+ASM
Password file on Node2: orapw+ASM