ORA-01017: Invalid Username Password; login denied, SP2-0157: Unable to connect to ORACLE after 3 attempts, exit SQL * Plus
ORA-01017: invalid username/password; login denied, SP2-0157: Unable to connect to ORACLE after 3 attempts, exit SQL * Plus
System: Windows XP
Oracle version
SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production
Log on to the database with SQL * plus and receive a ora-28056 error;
Microsoft Windows XP [version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C: \ Documents ents and Settings \ Administrator> sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Wednesday August 7 17:05:19 2013
Copyright (c) 1982,201 0, Oracle. All rights reserved.
ERROR:
ORA-28056: Writing audit records to Windows Event Log failed
ORA-28056: Writing audit records to Windows Event Log failed
Enter the User Name:
ERROR:
ORA-01017: invalid username/password; login denied
Enter the User Name:
ERROR:
ORA-01017: invalid username/password; login denied
SP2-0157: Unable to connect to ORACLE after 3 attempts, exit SQL * Plus
Check whether the oracle service exists and has started. Therefore, check the official website for an error:
ORA-28056: Writing audit records to Windows Event Log failed
Cause: Unable to write an audit entry to the Windows event log used as the audit trail.
Action: Check the error number for a possible operating system error. if there is no error, contact Oracle Support Services. so the system's "Event Viewer" log is cleared, OK, and done;
Recommended reading:
Oracle DML Process
PL/SQL ORA-14551: cannot perform DML operations in queries solved
Common MySQL DDL, DML, and DCL languages (example)
Execute batch DML exercises for Oracle basic transactions and ForAll
Oracle DML Statement (insert, update, delete) rollback Estimation