Development environment:
Os:⑥4 bit Win7
Development tools: VS2010
Database: Oracle11gr1 (⑥ 4-bit 澲 service end, 32-bit client)
VS2010 error message: The data connection is unsuccessful, please check 澲 to see if the database has started when attempting to load an Oracle
=2097152
kernel.shmmax=2147483648
kernel.shmmni=4096
kernel.sem=25032000100128
fs.file-max=65536
net.ipv4.ip_local_port_range=102465000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
Run the following command to make the kernel parameters take effect.
/Sbin/sysctl-p
3. Check the SElinux configuration. SElinux must be in the disabled status.
View or edit the/etc/selinux/config file and confirm that the following c
1. Download
A performance problem occurs in the customer system. The database version is 9.2.0.4 32-bit. Because the 32-bit database has a maximum memory limit of GB, physical memory cannot be fully used even if a new machine is used, we plan to use extended memory. However, after testing, we find that 9I memory usage is unstable, and sometimes OOM or even downtime occurs. The customer does not agree to upg
= (ADDRESS = (PROTOCOL =tcp) (HOST = Scan-rac) (port= 1521)) (Connect_data = (SERVER = dedicated) (service_name = prod) ) ) 3, in My Computer-attribute---Advanced system settings-environment variables, add an environment variable, named Tns_admin, the value of the Tnsnames.ora file is located in the path (such as: D:\oracleclient), This is to be able to find the Tnsnames.ora said above. If ORACLE is installed on this machine and the ORACLE_HOME en
The methods for uninstalling the Oracle 11g server and client and installing the Oracle 11g server and client have changed with those of the previous versions: 1. Preparations before uninstalling: choose "start"> "Settings"> "Cont
To configure the ORACLE 11g green client and PLSQL environment, you can use the lite version client officially provided by ORACLE, that is, the green installation-free client. (The official versions are provided here ):Clients use
This article was reproduced from: http://my.oschina.net/jang/blog/83009This approach is done by using the Oracle-provided lite client, which is a green, free-to-install client.(The official editions are available here):Clients used in Windows 32-bit systemsClients that are used in other system environmentsThere are man
Server A installs the Oracle 12c 64-bit database, and Machine B accesses the Oracle database.Get ready:1. Download Instantclient-basic-nt-12.1.0.2.0.zip,:http://pan.baidu.com/s/1c04lzso2. Download Plsql,:http://pan.baidu.com/s/1bnhkdojInstallation steps1. Installing the Orcle ClientUnzip the downloaded instantclient-ba
my Oracle 10g 64 bit no XP options, some people say that XP does not have 64-bit so there is no such option, it is recommended to install 32 for, I also know that 32-bit XP option Yes, but there is no way to demand must be orale1
installation file to the/oraapp directory (if not, create it yourself), unzip, installUpload command RZUnzip Command Zcat 10201_database_linux_x86_64.cpio.gz | Cpio-idmv11, using Xmanager remote connection linux,root user login, open terminal, switch to Oracle user, and then perform the installationcd/oraapp/database/./runinstaller performing the installation12, the installation, select Custom, select the Isql*plus components, choose to install only
Configure Oracle 11g Green client and PLSQL environmentThis approach is done by using the Oracle-provided lite client, which is a green, free-to-install client. There are many versions of the Instant
Label:At that time, the younger brother encountered this problem, also looked for a long answer, but the answer is ambiguous because () of the problem, but did not give a specific solution, here the younger brother with a relatively stupid method to solve the problem.The first: the use of a local iisweb server, as shown in:,However, I do not know whether it is my vs reason or itself vs there is this problem. After I set this up, I did not have a problem when I connected to the database, but when
PLSQL developer cannot connect to 64-bit Oracle solution 1
Date: Source: smallsilver shared:
Oracle10.2.0.4 but pLsQl cannot be connected.Cause:Oci. the dll is 64-bit, and the 32-bit application PLSQL Developer cannot load it,
Download and install Oracle Developer Tools for Visual Studio (http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html) in Oracle ),
This framework is designed for 32 bits. Therefore, when you create an object model in vs2012, the message"ORA-12154"Error, solution:
Download Oracle's 64-bit
Since the current notebook is mostly 64-bit window7 system, however plsql_developer no 64-bit, which caused the trouble of our connection, here teaches you how to connect win7_oracle11g_64 bit to 32 bit plsql_developer.I have prac
How to completely uninstall the oracle 11g Client
1. Disable oracle service: Go to computer management. In the service, find all services starting with oracle, right-click and choose stop.
2. In the Start Menu, find the Universal Installer, run
Installing oralce in windows is not difficult for most people. As long as the system hardware and software configurations meet the minimum requirements, the installation can be completed.
From the security point of view, the installation in Linux is a big trend. I found a lot of information on the Internet, analyzed various installation methods, and finally chose u01, u02 installs Oracle 10g for Linux 64-
Because Toad does not support 64-bit Oracle clients, you will uninstall the client that is already installed
Official website Uninstall Instructions:
Http://docs.oracle.com/cd/E11882_01/install.112/e10844/deinstall.htm#BABHIGFE
Website download Oracle Uninstall Tool:
Http:
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.