Ora 12571 ошибка

My development team is experiencing numerous ORA-12571: TNS:packet writer failure errors using ASP.NET 3.5 and 4.0 against Oracle 11g. These errors are inconsistent as to when they occur, and are generated by numerous applications. This exception happens while calling random stored procedures, packets, and inline SQL statements. The Oracle 11 client is installed on the web server. Some applications use Microsoft System.Data.OracleClient to connect to Oracle, and some use the .NET components provided by oracle (ODP.NET). Both data access objects come up with the same error.

There are other non .NET applications that run on a different web server, but use the same database server. The apps do not have any such issues. My initial thinking is that there is something configured incorrectly on the web server with the Oracle client.

Has anyone else received this error? What did you do to fix it?

ORA-12571: TNS:packet writer failure

Stack Trace:

at System.Data.OracleClient.OracleConnection.CheckError(OciErrorHandle errorHandle, Int32 rc)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, Boolean needRowid, OciRowidDescriptor& rowidDescriptor, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.Execute(OciStatementHandle statementHandle, CommandBehavior behavior, ArrayList& resultParameterOrdinals)
   at System.Data.OracleClient.OracleCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.OracleClient.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)

Background: I’m calling a Web Service written in ASP.NET that queries an Oracle database. I know the Web Service itself works, because I’ve used it before other applications. So I have a web application in Visual Studio that I’ve been switching back and forth to point from a ‘DEV’ web service to a production configured version of the same web service for testing. Pointing to the ‘DEV’ configured web service is no problem, but calling the production version I always get an exception calling the service:

SoapException was unhandled by user code
Server was unable to process request. ---> could not execute query
[ SELECT this_.FIELD1 as FIELD1_18_0_, this_.FIELD2 as FIELD12_18_0_ FROM ABC.TABLE_A this_ WHERE this_.FIELD1 like :p0 ORDER BY this_.FIELD1 asc ]
Positional parameters:  #0>00073%
[SQL: SELECT this_.FIELD1 as FIELD1_18_0_, this_.FIELD2 as FIELD12_18_0_ FROM ABC.TABLE_A this_ WHERE this_.FIELD1 like :p0 ORDER BY this_.FIELD1] ---> ORA-12571: TNS:packet writer failure

I ran the SQL queries against the appropriate database (cut and pasted straight out of the exception message) and the query came back with the expected data. I’ve tried updating and re-adding the Web Service reference both as a «Service Reference» (.NET 3.0+ way) and as a «Web Reference» (Older .NET way), and both give the same error.

Question: So, what does a «ORA-12571: TNS:packet writer failure» error mean in the context of a Web Service? Looking up the Oracle Error number gives some very vague possible causes such as «loose cable connection» or «IP address conflict». I’m fairly certain it’s neither of these, since a different application is currently successfully using that Web Service. Possibly some kind of configuration error, or maybe something more subtle? Anyone else seen this vexing Oracle error number being attributed to something web-service related?

Step 1 – Solve Oracle Error Ora-12571 Encountered

Is Oracle Error Ora-12571 Encountered appearing? Would you like to safely and quickly eliminate packet writer failure which additionally can lead to a blue screen of death?

When you manually edit your Windows Registry trying to take away the invalid ora-12571 tns packet writer failure 11g keys you’re taking a authentic chance. Unless you’ve got been adequately trained and experienced you’re in danger of disabling your computer system from working at all. You could bring about irreversible injury to your whole operating system. As very little as just 1 misplaced comma can preserve your Pc from even booting every one of the way by!

Troubleshooting ora-12571 tns packet writer failure oracle 10g Windows XP, Vista, 7, 8 & 10

Simply because this chance is so higher, we hugely suggest that you make use of a trusted registry cleaner plan like CCleaner (Microsoft Gold Partner Licensed). This system will scan and then fix any Oracle Error Ora-12571 Encountered complications.

Registry cleaners automate the entire procedure of finding invalid registry entries and missing file references (including the Error error) likewise as any broken hyperlinks inside of your registry.

Issue with oracle ora-12571 packet writer failure

Backups are made immediately prior to each and every scan providing you with the choice of undoing any changes with just one click. This protects you against doable damaging your pc. Another advantage to these registry cleaners is that repaired registry errors will strengthen the speed and performance of one’s procedure drastically.

• http://www.dba-oracle.com/t_ora_12571_tns_packet_writer_failure.htm
• https://garethhooper.com/2011/12/11/ora-12571-tnspacket-writer-failure-one-of-the-hardest-problems-ive-had-to-resolve/
• http://searchoracle.techtarget.com/answer/Solutions-for-ORA-12571-TNS-Packet-writer-failure
• http://stackoverflow.com/questions/7151175/ora-12571-tnspacket-writer-failure-with-asp-net

Cautionary Note: Yet again, for those who are not an state-of-the-art consumer it’s very encouraged that you simply refrain from editing your Windows Registry manually. If you make even the smallest error within the Registry Editor it can result in you some serious issues that may even call for a brand new set up of Windows. Not all difficulties attributable to incorrect Registry Editor use are solvable.

Fixed: ora-12571 intermittent

Symptoms of Oracle Error Ora-12571 Encountered
“Oracle Error Ora-12571 Encountered” appears and crashes the energetic method window.
Your Personal computer routinely crashes with Oracle Error Ora-12571 Encountered when running the exact same system.
“Oracle Error Ora-12571 Encountered” is shown.
Windows operates sluggishly and responds little by little to mouse or keyboard input.
Your computer periodically “freezes” for the number of seconds in a time.

Will cause of Oracle Error Ora-12571 Encountered

Corrupt obtain or incomplete set up of Windows Operating System software program.

Corruption in Windows registry from a new Windows Operating System-related application adjust (install or uninstall).

Virus or malware infection which has corrupted Windows method documents or Windows Operating System-related application data files.

Another method maliciously or mistakenly deleted Windows Operating System-related files.

Mistakes this sort of as “Oracle Error Ora-12571 Encountered” can be brought about by several different elements, so it really is important that you troubleshoot every of the achievable brings about to forestall it from recurring.

Simply click the beginning button.
Variety “command” inside the lookup box… Will not hit ENTER nonetheless!
Although keeping CTRL-Shift in your keyboard, hit ENTER.
You’re going to be prompted that has a authorization dialog box.
Click on Of course.
A black box will open having a blinking cursor.
Variety “regedit” and hit ENTER.
Within the Registry Editor, choose the ora-12571 tns packet writer failure 11g connected key (eg. Windows Operating System) you wish to back again up.
Within the File menu, choose Export.
Inside the Preserve In list, pick out the folder in which you wish to save the Windows Operating System backup key.
Inside the File Title box, sort a reputation for the backup file, these types of as “Windows Operating System Backup”.
From the Export Vary box, ensure that “Selected branch” is selected.
Click on Help you save.
The file is then saved by using a .reg file extension.
You now use a backup within your ora-12571 tns packet writer failure oracle 10g related registry entry.

Solution to your ora-12751 problem

There are actually some manual registry editing measures that can not be talked about in this article due to the high chance involved for your laptop or computer method. If you want to understand more then check out the links below.

Additional Measures:

One. Conduct a Thorough Malware Scan

There’s a probability the Ora-12571 Error Oracle Encountered error is relevant to some variety of walware infection. These infections are malicious and ready to corrupt or damage and possibly even delete your ActiveX Control Error files. Also, it’s attainable that your Oracle Error Ora-12571 Encountered is actually connected to some element of that malicious plan itself.

2. Clean ora-03114: not connected to oracle Disk Cleanup

The a lot more you employ your computer the extra it accumulates junk files. This comes from surfing, downloading packages, and any sort of usual computer system use. When you don’t clean the junk out occasionally and keep your program clean, it could turn into clogged and respond slowly. That is when you can encounter an Error error because of possible conflicts or from overloading your hard drive.

Once you clean up these types of files using Disk Cleanup it could not just remedy Oracle Error Ora-12571 Encountered, but could also create a dramatic change in the computer’s efficiency.

Tip: While ‘Disk Cleanup’ is definitely an excellent built-in tool, it even now will not completely clean up packet writer discovered on your PC. There are numerous programs like Chrome, Firefox, Microsoft Office and more, that cannot be cleaned with ‘Disk Cleanup’.

Since the Disk Cleanup on Windows has its shortcomings it is extremely encouraged that you use a specialized sort of challenging drive cleanup and privacy safety application like CCleaner. This system can clean up your full pc. If you run this plan after each day (it could be set up to run instantly) you are able to be assured that your Pc is generally clean, often operating speedy, and always absolutely free of any Oracle error associated with your temporary files.

How Disk Cleanup can help ora-03113

1. Click your ‘Start’ Button.
2. Style ‘Command’ into your search box. (no ‘enter’ yet)
3. When holding down in your ‘CTRL-SHIFT’ important go ahead and hit ‘Enter’.
4. You will see a ‘permission dialogue’ box.
5. Click ‘Yes’
6. You will see a black box open up plus a blinking cursor.
7. Variety in ‘cleanmgr’. Hit ‘Enter’.
8. Now Disk Cleanup will start calculating the amount of occupied disk space you will be able to reclaim.
9. Now a ‘Disk Cleanup dialogue box’ seems. There will be a series of checkboxes for you personally to pick. Generally it will likely be the ‘Temporary Files’ that consider up the vast majority of your disk area.
10. Verify the boxes that you want cleaned. Click ‘OK’.

How to repair ora-12514

3. System Restore can also be a worthwhile device if you ever get stuck and just desire to get back to a time when your computer system was working ideal. It will work without affecting your pics, paperwork, or other crucial information. You can discover this option with your User interface.

packet writer

Manufacturer

Device

Operating System

Oracle Error Ora-12571 Encountered


5 out of
5

based on
49 ratings.

 

Следующее взято из Интернета и не было подтверждено.

Сегодня я вошел в базу данных и встретил ORA-12571. Многие друзья в Интернете подытожили, что большинство из них вызваны настройкой SQLNET.AUTHENTICATION_SERVICES в файле параметров на стороне сервера SQLNET.ORA.
Измените параметры SQLNET.AUTHENTICATION_SERVICES на стороне сервера.
Пример использования параметра: SQLNET.AUTHENTICATION_SERVICES = (NTS)
    Use the parameter SQLNET.AUTHENTICATION_SERVICES to enable one or more authentication services. If authentication has been installed, it is recommended that this parameter be set to either none or to one of the authentication methods.

Note:

Note:

Windows NT native authentication
An authentication method that enables a client single login access to a Windows NT server and a database running on the server.

Выдержка из: http://blog.itpub.net/23513450/viewspace-736617/

Причина ошибки

Решения

Измените файл sqlnet.ora в каталоге D: / oracle / ora92 / network / admin, закомментируйте строку «NAMES.DEFAULT_DOMAIN =» с помощью # и замените NTS в «SQLNET.AUTHENTICATION_SERVICES = (NTS)» на NONE. Повторно создайте базу данных вручную, успешно.

Замечания Справочный сайт: http://blog.csdn.net/sosdsh/article/details/2695271

ORA-12541: TNS: нет слушателя

Причина ошибки

Нет службы мониторинга

Решения

1. Проверьте, запущена ли служба оракула;

2. Введите имя пользователя и пароль для входа в систему, чтобы увидеть, может ли он работать бесперебойно;

ORA-12154: TNS: не удается разрешить указанный идентификатор соединения

Причина ошибки

По умолчанию для отладки используется веб-сервер: C: \ Program Files (x86) \ Common Files \ microsoft shared \ DevServer \ 9.0 \ WebDev.WebServer.EXE, проблема в скобках в пути для поиска.

Решения

1) Скопируйте файл WebDev.WebServer.exe в каталог C: \ dev

2) Запустите команду cmd внутри

«C:\dev\WebDev.WebServer.EXE» /port:5100 /path:»D:\program\NXDB\Web» /vpath:»/»

Замечания Формат команды: c: \ WebDev.WebServer.EXE Физический путь / порт: 8796 / путь: «Путь веб-приложения» / vpath: »/« Ссылочный URL: http://blog.sina.com.cn/s/ blog_6d0021460101545s.html

Тайм-аут соединения ORA-12170 TNS

Причина ошибки

Сервер не работает

Решение:

Перезагрузите сервер

Ссылочный URL:http://blog.csdn.net/fenglx871004/article/details/4071827

Ora-03114: база данных не подключена

Феномен: при компиляции с разработчиком pl / sql всегда сообщайте Ora-03114: нет соединения с базой данных.

Решение: удалите функцию cdc.

Операция:

DROP TRIGGER sys.cdc_alter_ctable_before; 
DROP TRIGGER sys.cdc_create_ctable_after; 
DROP TRIGGER sys.cdc_create_ctable_before ; 
DROP TRIGGER sys.cdc_drop_ctable_before; 

Вы можете выполнить компиляцию после выполнения вышеуказанных операций. Если вы все еще не можете скомпилировать, выполните следующую инструкцию

CALL sys.dbms_java.dropjava(‘-s rdbms/jlib/CDC.jar’);

Справочный сайт:

http://blog.csdn.net/wyzxg/article/details/4676909

Используйте pl / sql developer для подключения к базе данных и всегда подключайтесь нормально,
Неожиданно было невозможно подключиться,
Подсказки ORA-12571: сбой процедуры записи пакета TNS,
Запрашивать сетевые решения нелегко,
Некоторые позволяют перестроить мониторинг,
Некоторые позволяют изменять конфигурацию мониторинга,
Изменено, все неправильно,
Наконец-то нашли причину проблемы,
связано с настройкой нашего межсетевого экрана.
Итак, если вы столкнулись с этой проблемой, не спешите изменять конфигурацию базы данных,
Сначала проверьте сеть, изменили ли вы настройки брандмауэра,
В противном случае разочаровывающая депрессия не решит проблему.

Выдержка из: http://java-007.iteye.com/blog/1730526

TNS-12571 Не удалось написать программу TNS

Платформа системы: Windows 2003 EnterPrise

Сообщение об ошибке:

Анализ ошибок, обратитесь к Metalink ID 21497.1

Error: ORA-12571 / TNS-12571
Text: TNS:packet writer failure
---------------------------------------------------------------------------
Cause: An error occurred during a data send.
Action: Not normally visible to the user. For further details, turn on tracing
and reexecute the operation. If error persists, contact Oracle Customer
Support.

Также обратитесь кMetalink 1143523.1

Решение проблемы:

1. Проверьте брандмауэр

2. Отслеживать и контролировать пакеты данных, отправленные на анализ

3. Измените SQLNET.AUTHENTICATION_SERVICES на NONE

Ошибка устранена:

Измените $ ORACLE_HOME / network / admin / SQLNET.ORA, файл будет
SQLNET.AUTHENTICATION_SERVICES= (NTS)
 Изменено
SQLNET.AUTHENTICATION_SERVICES= (NONE)

Оригинальная статья:https://blog.csdn.net/yw1688/article/details/51995887

Резюме: Чтобы проверить проблему, вам нужно протестировать ее на сервере

ORA-12571: TNS:packet writer failure

i have oracle database 11g running on windows server 2008 release-2. Today morning our developer face ORA-12571 TNS: packet writer failure error while compile large store procedure in Toad and same error get while execute same store procedure through sql*plus. developers are not get this error while compile small store procedure and create table. this error only get when store procedure is large about more than 1000 lines.

As error in TNS Packet so i guess there is a problem in Network side or in sqlnet or tnsname file.

we try below step.

1. so first try to re-create the listener. delete and create the listener.

2. shutdown and startup the database. (if you get downtime from client) do not try this step on production.

3. check network cable connection. This error has been observed when there was a loose cable connection to the SCSI disk   Related errors were also subsequently noted in the NT event log. try all cable jack in jack out and check problem still persist.

4. this error may occur if ip conflict on windows server (but in our case there is no ip conflict).

5.edit the sqlnet.ora in path D:/app/oracle/network/admin/sqlnet.ora and change below line.

SQLNET.AUTHENTICATION_SERVICES= (NTS)
into
SQLNET.AUTHENTICATION_SERVICES= (NONE).
6. Try to de install antivirus if you have installed.

7. you may solve this error by modify below parameter using sysdba privileges.

alter system set shared_server_sessions=200 scope=spfile; (if it is null than set this value)
alter system set processes=300 scope=spfile;
alter system set sessions=500 scope=spfile;
restart the database.


If you resolve your error using above one of step than you are lucky but we not get solution and we still get ora-12571 error. so we log bug to oracle support.

oracle gives below solution.

1.1. Add the following parameters in the sqlnet.ora file on the CLIENT workstation:

TRACE_LEVEL_CLIENT=16
TRACE_DIRECTORY_CLIENT=<some_known_directory>
TRACE_FILE_CLIENT=client
TRACE_UNIQUE_CLIENT=ON
TRACE_TIMESTAMP_CLIENT=ON
DIAG_ADR_ENABLED =OFF          — add this in case of 11g client

The default directory for sqlnet.ora file is $ORACLE_HOME/network/admin , if not specified differently by TNS_ADMIN environment variable.

If you need to restrict the amount of disk space used by only  the long-term traces then you can also set the following:

TRACE_FILELEN_CLIENT=<file_size_in_Kbytes>
TRACE_FILENO_CLIENT=<number_of_files>

1.2. Reproduce the issue / error

1.3. Check if trace files were created.

1.4. Disable tracing by removing the TRACE lines from sqlnet.ora. 

We collect the sqlnet trace file and send it to oracle support but oracle support didnot find any error in this sqlnet log files. so oracle support recommend to check below things.

we get solution by below steps

Oracle Support ask below question to us.
>> do you have any firewall in the setup?? if yes, please try making a connection from inside the firewall to the sb server??

we reconfigure the firewall in data centre and tell to data centre to some issue in our 1521 listener port. after the data-centre network reconfiguration we solved our issue. so at last you have to check your network configuration and firewall configuration to solve ora-12571 error.

—please give your expert comments if any others.