Error while trying-retrieve text for error ORA-01019 workaround

For a long time, this article helped me, thanks.

Original address: https://www.cnblogs.com/zhenfei/p/4425874.html

This issue involves 64-bit Oracle services, and 32-bit client-side problems.

The environment is as follows: win8.1 + 64-bit Oracle 11.1 server, the client because of 32-bit programs, does not support the 64-bit Oracle client, so the 32-bit 10.2-instantclient package is used.

Problem phenomenon: Unable to connect to Oracle server, Plsql, sqlplus are connected normally, the program connection times error error while trying to retrieve text for Error ORA-01019.

This error is described on the Oracle documentation as:

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.

Solve:

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. Obviously not a memory issue. So solve the first step:

1. Add Oracle_home to the environment variable to point to the 64-bit installation directory instead of the Instantclient directory. I think this step will allow Windows to use matching files to drive

After making the first step, the connection again, the error message becomes, cannot allocate memory error. And then the second step.

2. Replace 10.2 instantclinet packet with 11.1 matched 32-bit instantclient package

After the change, the connection is normal.

The tns_admin and path in the environment variable can point to the 32-bit Instantclient packet location path.

Alibaba Cloud Hot Products
Elastic Compute Service (ECS)	Dedicated Host (DDH)	ApsaraDB RDS for MySQL (RDS)	ApsaraDB for PolarDB(PolarDB)	AnalyticDB for PostgreSQL (ADB for PG)
AnalyticDB for MySQL(ADB for MySQL)	Data Transmission Service (DTS)	Server Load Balancer (SLB)	Global Accelerator (GA)	Cloud Enterprise Network (CEN)
Object Storage Service (OSS)	Content Delivery Network (CDN)	Short Message Service (SMS)	Container Service for Kubernetes (ACK)	Data Lake Analytics (DLA)
ApsaraDB for Redis (Redis)	ApsaraDB for MongoDB (MongoDB)	NAT Gateway	VPN Gateway	Cloud Firewall
Anti-DDoS	Web Application Firewall (WAF)	Log Service	DataWorks	MaxCompute
Elastic MapReduce (EMR)	Elasticsearch