ORA-12514 error troubleshooting when connecting to Oracle

ORA-12514 error troubleshooting when connecting to Oracle

Recently, Oracle 11 GB in windows has been used for testing.

ORA-12514: TNS: The Listener currently cannot identify the Service requested in the connection Descriptor

I searched the internet and found that the listener. ora configuration file is mostly involved, but my system has been running normally. This should not happen suddenly. Later, I accidentally found that Oracle 11g in Windows had such a problem. Oracle 11g writes audit logs by default and writes them to the "application" logs of the operating system. When the application logs are full. It is equivalent to the user login audit can not be recorded, the opportunity to log on, and report the ORA-12514 this error.

Installing Oracle 12C in Linux-6-64

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Temporary solution: Clear logs

Control Panel-> Administrative Tools-> Event Viewer-> Applications-> right-click-> clear all events

In this way, you can log on to oracle normally.

The other solution is to disable oracle audit.

1. log on to the database server as an oracle user and execute:

Sqlplus/as sysdba

2. Cancel audit and set the initialization parameter audit_trail to NONE.

Alter system set audit_trail = none scope = spfile;

3. Restart the database.

Shutdown immediate;

Sqlplus/as sysdba

Startup;

4. Delete the authorization data. The oracle user logs on to the database server:

Sqlplus/as sysdba

Truncate table SYS. AUD $;

Later, after testing, it was found that the normal log is full, and the prompt that the log cannot be logged on should be as follows:

ERROR:

ORA-28056: failed to write audit records to Windows Event Logs

OSD-748745664: Message 748745664 not found; product = RDBMS; facility = SOSD

O/S-Error: (OS 1502) the event log file is full.

ORA-02002: An error occurred while writing audit leads

ORA-28056: failed to write audit records to Windows Event Logs

OSD-748746736: Message 748746736 not found; product = RDBMS; facility = SOSD

O/S-Error: (OS 1502) the event log file is full.

If such a prompt appears, the cause of the problem is clear. The above method can be used.