Oracle Client Connection times ORA-01019 Error Summary

In. Net+oracle development, when you publish a Web program, you 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 error, the context cannot be obtained from the process.

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

Workaround:

One: For the Oracle_home directory, add access to the network Services user group and inherit permissions to subdirectories. Restart the machine.

Two: Increase the virtual path corresponding to the application pool, execute the user's permissions. (This method I think to bring unsafe factors)

This error is sometimes prompted by the need to install the oracle7.13 version of the client above. Workaround above.

Question Two

In the WIN8 Enterprise Edition 64-bit environment, connect oracle11g service side, engaged in a full two days, special will process to share out, for the needs of the classmate reference.

Native Environment:

1, server: 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

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

The first: Oracle comes with the SQL Deveploer tool, basically no problem! Nor does it require any client configuration.

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

The second, with PL/SQL 9.0 to connect, You need to copy the Xxapporacleproduct11.2.0servernetworkadmintnsnames.ora file from the server to the client (1) networkadmin, and delete the unwanted parts, as follows:

Code to copy code as follows
ORCL =
(DESCRIPTION =
(Address_list =
(ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))
)
(Connect_data =
(SID =ORCL)
)
)

Start PL/SQL using the following method

Code to copy code 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 at this time OK.

(www.111cn.net)

This problem has long been found online, there are many solutions to try, but in the end my plan is:

1, delete the Oracle server, the method can be searched on the Internet, to be deleted;

2, delete Odac and all components;

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

4. Re-install Oracle server;

All client connections are completely normal at this point!

Summary:

1, the first suspect is a 64-bit Oracle Drive path (x86) caused by the bug, the conclusion is the same machine, it is best not to install two Oracle client, the service side + client is not recommended, will cause some potential problems, unexplained.

2, 64-bit Oracle Server + 32-bit Oracle client, there will be some potential problems, preferably 32-bit to 32-bit.

3. When installing Oracle 11g R2 EX, add "e:org12apporacleproduct11.2.0serverbin;;" in front of the environment variable path, note that it is two semicolons, you must delete one; this is not known as the installer bug?

Question Three

The colleague who developed today met with 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-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 error description, it seems to be a memory allocation problem, but the memory on the client server is 2G, and does not start any program, obviously not a simple memory shortage problem.

However, most of the problem is on the client program, check the Metalink, found that the problem mentioned in document ID 91906.1 may be similar to the current. The cause of this problem seems to be that ODBC does not use a driver provided by Oracle, but rather uses a system-provided driver outside of Oracle_home.
Google search again, found an article, which contains the following description:
You must set the following environment variables:
Oracle_home
Specifies the top-level directory in which Oracle is installed.

Tns_admin
Specifies the location of the 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 is in the This directory, you 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 first time you attempt To connect. For information on error handling,

It seems that the problem is probably caused by not setting the ORACLE_HOME environment variable correctly.

Solutions

Setting system environment variables in windows, after rebooting the system, the problem disappears
From:http://www.111cn.net/database/oracle/43838.htm

Oracle Client Connection times ORA-01019 Error Summary