Oracle Client Connection times ORA-01019 Error Summary

When you publish a Web program in. Net+oracle development, you will encounter this error ora-01019

ORA-01019 Unable to allocate memory in the user side
Cause:the user side memory allocator returned an error.

Action:increase the size of the process heap or switch to the old set of calls.

Or an error, the context cannot be obtained from the process.

This error is caused by an oracle or Microsoft bug. (In fact, IIS has too much control over access rights).

Workaround:

One: For the Oracle_home directory, add access rights to the network Services user group and inherit permissions to the subdirectory. Reboot the machine.

Two: Improve the virtual path of the application pool, execute the user's permissions. (This method, in my opinion, poses an unsafe factor)

Order, this error is sometimes prompted to install the oracle7.13 version of the client. The solution is the same as above.

Question Two

In the WIN8 Enterprise version of the 64-bit environment, the connection oracle11g service end, engaged in a full two days, the process of sharing out, for the needs of the students for reference.

Native Environment:

1, service side: Oracle 11g R2 64-bit, installation path E:/ORG12

Official Download: http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

2. Client:

(1) Instant Client, lightweight, installation path e:/oracle11/client
Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

(2) 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio, installation path e:/org12/product/11.2.0/c Lient_1

Http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html?ssSourceSiteId=otncn

With client three tools to connect to Oracle server, the result:

The first: Oracle with the SQL Deveploer tools, basically no problem! There is no client configuration required.

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The second, with Pl/sql 9.0 to connect, The Xxapporacleproduct11.2.0servernetworkadmintnsnames.ora file on the copy server is required to be under the networkadmin of the client (1) and the unwanted parts are deleted, and the contents are roughly as follows:

The code is as follows
ORCL = (DESCRIPTION = (Address_list = (address = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) ) (Connect_data = (SID =ORCL) ) )

Start the Pl/sql using the following method

The code is as follows
Set Path=e:/oracle11/client REM Service-side path: E:org12product11.2.0dbhome_1bin Set Oracle_home=e:/oracle11/client Set Tns_admin=e:/oracle11/client Set Nls_lang=american_america. Al32utf8 Start E:/oracle11/pl_sql/plsqldev.exe OK at this time.

This problem is found on the internet for a long time, try a lot of solutions, but in the end my plan is:

1, delete Oracle server; methods can be searched online, to delete clean;

2, delete Odac and all components;

3, retain instant client and its installation directory, mainly Networkadmintnsnames.ora

4, reinstall Oracle Server;

All client connections are completely normal at this time!

Summary:

1, just start to suspect that the 64-bit Oracle Drive path (x86) caused by the bug, the final conclusion is the same machine, it is best not to install two Oracle clients, Server + client is not recommended, will cause some potential problems, unexplained.

2, 64-bit Oracle Server + 32-bit Oracle client, there are potential problems, preferably 32-bit 32-bit.

3. When installing Oracle 11g R2 EX, add "E:org12apporacleproduct11.2.0serverbin;" in front of the environment variable path, note that the two semicolon must be deleted; This is not known as a bug in the installer?

Question Three

Today's development colleagues came across this ORA-1019 error.

The detailed error message is:

Microsoft OLE DB Provider for ODBC drivers error ' 80004005 '
[Microsoft] [ODBC driver for Oracle] [Oracle] Error while trying to retrieve text for error ORA-01019
/includes/data_func.asp, Line 12

The description of this error on the Oracle documentation is:

Ora-01019:unable to allocate memory in the user
Cause:the user side memory allocator returned error.

Action:increase the processes heap size or switch to the old set of calls.

From the description of the error, it seems to be a memory allocation problem, but the client server has 2G of memory, and does not start any programs, obviously not a simple memory problem.

However, most of the problems are on the client side, check the Metalink, and find that the problem mentioned in document ID 91906.1 may be similar to the current one. The reason for this problem seems to be that ODBC does not use Oracle-supplied drivers, but instead uses a system-supplied drive outside of Oracle_home.
Google Googled it and found an article that contained the following description:
You must set the following environment variables:
Oracle_home
Specifies the top-level directory which Oracle is installed.

Tns_admin
Specifies the location of configuration files, for example, $ORACLE _home/network/admin. After installation Oracle creates the configuration files under/var/opt/oracle. If Listener.ora and Tnsnames.ora are in this directory, you are might not need to set tns_admin, because by default Oracle use S/var/opt/oracle.

If you don't set these environment variables properly, ORACLE returns the ORA-1019 error code the "I" you attempt To connect. For information on error handling,

It seems likely that the problem is due to the improper setting of the ORACLE_HOME environment variable,

Solutions

Setting system environment variables in windows, and restarting the system, the problem disappears.