织梦CMS - 轻松建站从此开始!

文档之家-IT技术文档共享平台

当前位置: 文档之家 > 数据库 > Oracle >

Oracle 10g errors message troubleshooting 170 (ORA-28001 to

时间:2010-12-03 06:09来源:docfans.net 作者:admin 点击:
Oracle 10g errors message troubleshooting 170 (ORA-28001 to
ORA-28001: the password has expired
Cause: The user's account has expired and the password needs to be changed
Action: change the password or contact the DBA
ORA-28002: the password will expire within string days
Cause: The user's account is about to about to expire and the password needs to be changed
Action: change the password or contact the DBA
ORA-28003: password verification for the specified password failed
Cause: The new password did not meet the necessary complexity specifications and the password_verify_function failed
Action: Enter a different password. Contact the DBA to know the rules for choosing the new password
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
Cause: The password verification function does not have the required number and type of input/output arguments and/or the return argument
Action: Check the manual to find out the format of the password verification function
ORA-28005: invalid logon flags
Cause: The flags are not properly set or conflicting flags are set in making calls
Action: Call the function with appropriate flags set.
ORA-28006: conflicting values for parameters string and string
Cause: The parameters PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX cannot both be set. One parameter should be unlimited while other is set
Action: Set one value to UNLIMITED explicitly
ORA-28007: the password cannot be reused
Cause: The password cannot be reused for the specified number of days or for the specified nunmber of password changes
Action: Try the password that you have not used for the specified number of days or the specified number of password changes Refer to the password parameters in the CREATE PROFILE statement
ORA-28008: invalid old password
Cause: old password supplied is wrong; Hence user cannot be authenticated using old password
Action: Supply the correct old password for authentication
ORA-28009: connection to sys should be as sysdba or sysoper
Cause: connect sys/<password> is no longer a valid syntax
Action: Try connect sys/<password> as sysdba or connect sys/<password> as sysoper
ORA-28010: cannot expire external or global accounts
Cause: If a user account is created as IDENTIFIED EXTERNALLY, or IDENTIFIED GLOBALLY, this account cannot be expired
Action: Try to expire the password of the user that has database password
ORA-28011: the account will expire soon; change your password now
Cause: The user's account is marked for expir; the expiry period is unlimited.
Action: Change the password or contact the DBA.
ORA-28012: Manual commit not allowed here
Cause: An attempt was made to commit a non-autonomous transaction from within a change password trigger or password verification routine
Action: Remove the COMMIT from the password trigger or password verification routine
ORA-28020: IDENTIFIED GLOBALLY already specified
Cause: The IDENTIFIED GLOBALLY clause was specified twice.
Action: Use only one IDENTIFIED GLOBALLY clause.
ORA-28021: cannot grant global roles
Cause: A role granted was IDENTIFIED GLOBALLY. Global roles can only be granted via a central authority for the domain.
Action: Use ALTER ROLE to change the type of role (from IDENTIFIED GLOBALLY to other, such as IDENTIFIED BY password), or allocate it to a global user via the central authority.
ORA-28022: cannot grant external roles to global user or role
Cause: A role granted was IDENTIFIED EXTERNALLY. External roles cannot be granted to global users or global roles.
Action: Use ALTER ROLE to change the type of the role being granted (from IDENTIFIED EXTERNALLY to other, such as IDENTIFIED BY password), or use ALTER ROLE or ALTER USER to change the type of the user or role that is the grantee.
ORA-28023: must revoke grants of this role to other user(s) first
Cause: The role altered to IDENTIFIED GLOBALLY was granted to one or more other users and/or roles. Global roles cannot be granted to any user or role.
Action: Use REVOKE to revoke the role from other users or roles first.
ORA-28024: must revoke grants of external roles to this role/user
Cause: The user or role altered to IDENTIFIED GLOBALLY has external roles directly granted - these must be revoked, since external roles cannot be granted to global users or roles.
Action: Use REVOKE to revoke the external roles from the user or role to be ALTERed.
ORA-28025: missing or null external name
Cause: The IDENTIFIED EXTERNALLY AS or IDENTIFIED GLOBALLY AS clause was specified with a valid external name.
Action: Provide a valid external name.
ORA-28026: user with same external name already exists
Cause: The external name specified for the user being created or altered already exists for another user.
Action: External names must be unique among users. Specify another.
ORA-28027: privileged database links may be used by global users
Cause: Only users IDENTIFIED GLOBALLY may use a privileged database link.
Action: Either change the user to a global user or try to use a different database link.
ORA-28028: could not authenticate remote server
Cause: During the course of opening a privileged database link, the remote server was not securely identified using the network security service. Additional errors should follow.
Action: Consult the network security service documentation on how to properly configure the remote server.
ORA-28029: could not authorize remote server for user string
Cause: During the course of opening a privileged database link, the remote server was found to lack the necessary authorizations to connect as the current global user. This may be because the server was not authorized by the network security service. Or it may be because the local server is restricting access by the remote server using the DBMS_SECURITY_DOMAINS_ADMIN package.
Action: Grant the remote server the proper authorization to connect as the given global user, and check that the local server is not restricting access.
ORA-28030: Server encountered problems accessing LDAP directory service
Cause: Unable to access LDAP directory service
Action: Please contact your system administrator
ORA-28031: maximum of string enabled roles exceeded
Cause: The user attempted to enable too many roles.
Action: Enable fewer roles.
ORA-28035: Cannot Get Session Key for Authentication
Cause: Client and server cannot negotiate shared secret during logon
Action: User should not see this error. Please contact your system administrator
ORA-28037: Cannot Get Session Key for RACF Authentication
Cause: Client and server cannot negotiate shared secret during logon
Action: User should not see this error. Please contact your system administrator
ORA-28038: disallow O2LOGON
Cause: turn off O2LOGON
Action: none
ORA-28039: cannot validate Kerberos service ticket
Cause: The Kerberos service ticket provided was invalid or expired
Action: Provide a valid, unexpired service ticket.
ORA-28040: No matching authentication protocol
Cause: No acceptible authentication protocol for both client and server
Action: Administrator should set SQLNET_ALLOWED_LOGON_VERSION parameter on both client and servers to values that matches the minimum version supported in the system.
ORA-28041: Authentication protocol internal error
Cause: Authentication protocol failed with an internal error
Action: none
ORA-28042: Server authentication failed
Cause: Server failed to authenticate itself to the client
Action: Confirm that the server is a valid database server.
ORA-28043: invalid bind credentials for DB-OID connection
Cause: The Database password stored in the wallet did not match the one in OID .
Action: Use DBCA to reset the database password so that it is the same in database wallet and in OID.
ORA-28044: unsupported directory type
Cause: The database tried to work with a directory which is not OID.
Action: Enterprise User Security works only with Oracle Internet Directory. Update the ldap.ora file to reflect an appropriate OID.
ORA-28045: SSL authentication between database and OID failed
Cause: Server failed to authenticate itself to the Directory.
Action: Make sure the sqlnet.ora used is pointing to the wallet with the right certificate.
ORA-28046: Password change for SYS disallowed
Cause: REMOTE_LOGIN_PASSWORDFILE is set to SHARED, prohibiting SYS password changes.
Action: Change setting of REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE or NONE.
ORA-28047: database is not a member of any enterprise domain in OID
Cause: An enterprise user login was attempted on a database that is not a member of any enterprise domain in OID.
Action: An administrator should put the database into an enterprise domain in OID, and then the user should reconnect.
ORA-28100: policy function schema string is invalid
Cause: The schema was dropped after the policy associated with the function had been added to the object.
Action: Drop the policy and re-create it with a policy function owned by a valid user. Or re-create the user and the policy function under the new user.
(责任编辑:eric)
织梦二维码生成器
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
发表评论
请自觉遵守互联网相关的政策法规,严禁发布色情、暴力、反动的言论。
评价:
表情:
用户名: 验证码:点击我更换图片
栏目列表
推荐内容