First, my SQL Server R2 and oracle11g are installed on the same computer.
Let's take a look at the configuration method:1. After configuring the ODBC installation to complete Oracle in the driver, there will be Oracle in ORADB11G_HOME1 this driver such as:Then add the d
registry key, all the keys that contain Oracle.11. My Computer----high-level----environment variables, delete environment variables classpath and path for Oracle settings.12. Remove all Oracle-related groups and icons from the desktop, startup Group, and Programs menu.13. Delete all Oracle-related directories (if not
machine is: d:/instantclient_11_2/network/admin4, set the language of Oracle, add the environment variable Nls_lang, the value is simplified Chinese_china. Zhs16gbkAssuming that the Oracle language of the remote database is unclear, SSH or telnet to the remote machine, enter in the command interface, and connect to the database with the command line.SELECT * from Nls_instance_parameters;View the value of N
other high-speed network (such as IB), it is very fastidious, of course, and take the serial line to achieve heartbeat information transmission. In addition, what network parameters are used to the overall performance and robustness of the cluster have a great relationship.Case:XX City, 4 node Oracle 10g RACThe operating system uses RHEL 4, according to the default installation documentation, set the network parameters to the following values:Net.cor
/cn/software/tech/oci/instantclient/index.htmlInclude the following:Instant client Package-basic runs OCI, OCCI, and jdbc-oci all files required by the application.Instant client Package-basic Lite: contains only English error messages and supports Unicode, ASCII, and Western European character sets only.The Instant client package-jdbc Supplement adds Xa, internationalization, and rowset to JDBC.Instant Client package-sql *plus contains sqlplus and required library filesInstant client PACKAGE-SD
Oracle 11g Release 1: http://www.oracle.com/technology/software/products/database/index.html RHEL5 under the ASMLib2.0: http://www.oracle.com/groovy/global/cn/tech/linux/asmlib/index.htmlopen the page, will find a Red Hat Enterprise Linux 4 AS (x86) Link, click it, the new page contains the Red Hat Enterprise Linux 5 AS download link. Read more: Install Oracle
the registry, as follows. ★ Delete Hkey_local_machine/software/oracle directory. ★ Delete all keys in hkey_local_machine/system/currentcontrolset/services that start with Oracle or Oraweb. ★ Delete all keys in hkey_local_machine/system/currentcontrolset/services/eventlog/application that start with Oracle. ★ Delete all keys prefixed with Ora,
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
\system\controlset001\services "Down" all Oracle DeleteHkey_local_machine\system\controlset002\services "Down" all Oracle DeleteHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services "Down" all Oracle Delete 5. Run regedit,Hkey_local_machine\system\currentcontrolset\services\eventlog\application "Down" All Oracle deletes
/jdbc_111060.html
This address can be downloaded from each version of the Oracle driver. Directly download a not just OK. But the download also wants the user name and the password, you said oralce so the Cow X's company also really is the fucking ah, does not download a 1M many drive. You want ye to log in, I will log in, but not on board, two Deng also did not board, and a few log also not on, retrieve t
Oracle's JDBC driver three main categories:
1. JDBC OCI:OCI is an abbreviation for Oracle call interface, which is similar to the traditional ODBC driver. Because it requires Oracle call Interface and NET8, it needs to install the client software on a machine that is runnin
July 2014, wrote an article about EF5 with Visual Studio, Oracle 11g, the original address: http://www.cnblogs.com/HouZhiHouJueBlogs/p/ 3844028.html, Oracle is now supported to EF6. Technical update fast, some details such as not recorded, it is easy to be forgotten, so there is this blog post. Some basic knowledge of. NET support from
Tags: blog http os io strong file data forNothing to do, want to re-install Oracle 11g, recorded as follows:(1) First stop all Oracle services in the service;(2) Start, oracle-oradb11g_home1, Oracle installation products, Universal Installer, click "Uninstall Product"-"Expan
Label:When using the Oracle JDBC driver, are there some problems that you can solve by replacing different versions of the Oracle JDBC driver? There are multiple versions of the most commonly used ojdbc14.jar, and there are multiple versions of Classes12.jar, do you understand? In a single deployment, always do not co
Oracle 11g InstallationFirst, the Environment preparation
Dividing area
/15000M/tmp 4096M/boot 100MSwap 4096M/u01 remaining space2. Change host name, IP address3. Install the PackageThen the Linux system needs to prepare the environment for Oralce to end here, the following is installed after the system installation of Oracle4. Turn off SendMail to speed up system startup5. Modify the Host tab
Oracle's official SQL Developer comes with Oracle migration Workbench.
What is Oracle SQL Developer? On the official page, this is how it is presented:
Oracle SQL Developer is a free and fully supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug
In a new environment, the company needs to install RHEL (Red Hat Enterprise Linux, the same below) 5.5 64-bit and Oracle 11G 64-bit in a virtual machine environment, so it has been tossing for three days, the pain, only the person who knows. Here, let's keep a note of the process, hoping that others will take less detours.
First, on the virtual machine selection, the options are as follows:
(1) The adva
Tags: Oracle 11gTesting the importance of OLR in Oracle 11g clusterCalled an Oracle local Registry (OLR): All node in a cluster have a Local Registry for node-specific ResourcesTest one: Simulate the OLR abnormal loss situation:Here first will OLR Renam[Email protected] cdata]# MV VMRAC2.OLR Vmrac2.olr.bakThen try to s
to make it easier for project team developers to use the oracle11g RAC database, install a client and configure Plsql to access the database server. Download The following three packages from Oracle official: Instantclient-basic-win32-11.2.0.1.0.zip This is the core package. Instantclient-jdbc-win32-11.2.0.1.0.zip contains the JDBC driver package Instantclient-sqlplus-win32-11.2.0.1.0.zip The simplest sqlpl
database files, and disk groups need to be consistent with the RAC Disk group for easy restore#磁盘分区fdisk/dev/sd*N-p-1-w#安装asmYum install-y kmod-oracleasm-2.0.8-13.el6_8.x86_64.rpm oracleasmlib-2.0.4-1.el6.x86_64.rpm oracleasm-support-2.1.8-1.el6.x86_64.rpm#创建asm磁盘--------------------------------------------------------------------------------------------------------------- -------------# oracleasm Status# oracleasm Configure-iConfiguring the Oracle A
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.