problem was finally resolved, but it was still not completely out of the configuration1. The connection statement is written like this to avoid relying on the Tnsnames.ora filePROVIDER=ORAOLEDB.ORACLE.1; password= password; Persist Security info=true; User id= username; \Data Source=\ "(DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP) (HOST = IP) (PORT = 1521))) (Connect_data = (SID = data (library))) \ "It can be the user name, password, database ID, IP, port these proposed to write t
Oracle server. The error is changed:
I have been searching for this problem online for a long time and tried many solutions, but my final solution is:
1. Delete the Oracle server. You can search for the server online and delete it;
2. Delete odac and all components;
3. Retain the Instant Client and its installation directory, mainly Network \ admin \ tnsnames. ora
4. reinstall the
nc_procsimoutgeneral, line 18thUnable to create OLE DB provider for linked server "NC " instance of OraOLEDB.Oracle ". Workaround:[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\mssql.1\providers\oraoledb.oracle.1]"AllowInProcess" =dword:00000001If there is no oraoledb.oracle below the providers, the new3. Error 3Error message: "OraOLEDB.Oracle" returned the message "ORA-12154:TNS: Unable to resolve the specified connection identifier the OLE DB provider for the link server" NC "Ora
Label:Recently took over a project where the server-side database is Oracle 11g 64-bit. Because the main job is not development, and do not want to install a large Oracle database on their own computers, it is thought that only through the database management tools to connect the database for some common query operatio
CentOS6.5x64 install 64-bit Oracle 11g in silent mode
1. Download the 64-bit Oracle11g source file and upload it to the Linux server.
2. Package installation check and installation:
Install the tool using yum:
Yum-y install binutils compat-libstdc ++-33 elfutils-libelf-devel
First, install the driverIf you are using a 32-bit win2003 operating system, there will be a system-brought Microsoft OLE DB Provider for Oracle driver, so no additional preparation is required, but if you are using a 64-bit system, this
Win8 64-bit connection to oracle Database Using plsql developer, win8plsql
Problem: When plsql developer is used on a 64-bit win8 system to connect to a local oracle database, an inexplicable problem may occur. The error prompt bo
SSIS has the ability to allow SSIS to access Oracle on a 64-bit machine, which requires an 64-bit Oracle Provider. But the biggest problem is that the BI Development studio that SSIS uses at the design stage has only 32-
The source of this article, in order to facilitate direct copy over. If there is infringement, please inform, thank youhttp://blog.csdn.net/chiclewu/article/details/14646687An Oracle 11g 64-bit version was installed in the virtual machine today, and when connected with PL/SQL developer, it was found that there was no database connection to TNS.It is considered th
(win32_11gr2_client.zip):When choosing an installation type, select Administrator, such as:the other steps are similar to the installation server side. B. PL/SQL Developer installation Note:before you install PL/SQL, you need to install the Oracle client first. My system environment:1, 64-bit Windows 7 Ultimate Edition2, 64
PLSQL has only 32-bit programs so far, and most desktop systems use 64-bit Windows operating systems. In 64-bit Windows
PLSQL has only 32-bit programs so far, and most desktop systems use 64
Win7-64 bit install oracle client-plsql Connection database 64-bit win7 flagship Edition sp1 system: www.2cto.com 1, installed oracle11gR2 64-bit server version (according to the Neusof
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/SQL Developer.Wonder why the database TNS is not chosen here? I installed the database first and then installed PL/SQL Developer. When the PL/SQL developer is installed,
1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/SQL Developer.Wonder why the database TNS is not chosen here? I installed the database first and then installed PL/SQL Developer. When the PL/SQL developer is installed,
database name. This service must be turned on or Oracle will not be able to use it at all.attached:Installation notes for a, 32-bit Oracle 11g Client (win32_11gr2_client.zip):When choosing an installation type, select Administrator, such as:The other steps are similar to the installation server side.B. PL/SQL Developer installation Note:before you install PL/SQL
CentOS 6.5_x64 Install Oracle 11g R2 installation Environment: Operating system: centos6.5_x64 Desktop Host Name: OracleDB Memory: 1G (official minimum requirements 1G) hard drive: 40G (4.29G and 1.7G data required for enterprise installation) File) Pre-installation System Preparation: #设置操作系统 system support Red Hat Enterprise Linux 6,centos 6 is actually RHEL6, but Oracle does not recognize, so to change t
Install Oracle 11gR2 Ubuntu Linux 11.04 (64-bit)Version C-update May 31,201 1Author: DudeNote:The following instructions work for Oracle 11gR2 11.2.0.1 (x86_64) and have also been tested with an Out-of-Place upgrade to 11.2.0.2. just select the "ignore all" button at the prerequisite checks. it worked fine, including t
Tags: get desc recognition note Mes According to the installation of Oracle cannot be the way1. Log in to PL/SQL DeveloperThis omits the installation steps for the Oracle database and PL/SQL Developer, and note that when you install the PL/SQL Developer software, do not install it under the program Files (x86) directory or you cannot start PL/SQL Developer.Wonder why the database TNS is not chosen here? I i
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.