install odbc driver for oracle 11g

The concept of SCAN (Single Client Access Name) is introduced in the Oracle 11g RAC cluster, that is, the Single Client Access Name of the cluster. SCAN provides a single host name for the client to access the Oracle database running in the cluster. If you add or delete nodes in a cluster, you do not need to change the TNS configuration of the client that uses SC

Finally, we have installed Oracle 11g in RedHat. First, we will write a summary, and I will repeat it over the weekend. 1. Download oracle11g for linux Http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_database_1of2.zip;Http://download.oracle.com/otn/linux/oracle11g/r2/linux.x64_11gr2_databasesilicate f2.zip; 2. Check and install the installation

Install Oracle 11g R2 and windows711g in 64-bit Windows 7Win7 bit64 is installed with a 64-bit client. 1. Connect PLSql to the database(1) download the instantclient-basic-win32-11.2.0.1.0.zip to extract to the current Oracle project, and create a new network/admin/tnsnames. ora (2) Configure plsql

Tags: dbca root user also needs to manually complete after SID change account Pos1. Understanding Database Management Tools1.2 OUI (Oracle Universal Installer)· Oui Product List (inventory) locationWindows:%systemroot\program files\oracle\inventoryHkey_local_machine\software\oracle\inst_locLiunx:/etc/orainst.locSolaris/var/opt/

Install Oracle 11g on CenOS1. System check 1.1 memory requirements:Memory I set 1.5 GB (unit: 4 GB memory)# Cat/proc/meminfo // view memory size1.2 requirements for swap partitions:Swap partition is 1.5 times the memory, which can be adjusted according to the actual situation# GrepSwapTotal/proc/meminfo // view swap partition size1.3 hard disk space requirementsH

Decided to install Oracle for fun. This time, RedHat Enterprise Linux 4 + Oracle 11g R2 is used. Some problems have been encountered during the installation process. We will summarize the issues for future use.Before the installation, install Linux first. Due to the previous

This article describes the process of installing Oracle 11g on RHEL 6.3. You can download RHEL from many image sites, such as Oracle 11g, note that the version 11.2.0.3 is used in this article. Currently, this version is not available for download only for paid accounts, if you need this version, you can contact me by

Install Oracle 11G notes in Ubuntu 12.04. 1. First, update the system to the latest version.Sudo apt-get updateSudo apt-get dist-upgrade2. Install the dependency packageSudo apt-get install alien binutils build-essential cpp-4.4 debhelper g + +-4.4 gawk gcc-4.4 gcc-4.4-base

Error codes and explanations:When you install the Oracle 11G R2 64-bit version in a Windows Server 2008 64-bit operating system, you are prompted to create an item on the Windows Start menu or on the desktopWorkaround:This is because Windows Server 2008 default language is English, and when you install

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"> "Control Panel"> "Administrative Tools"> "services" to stop all

for Oracle and grant write permissions to the Oracle user to execute permissions to the DBA group. 8 , and system environment configuration. 1) Add the following line to the/etc/sysctl.conf file:Execute the sudo gedit/etc/sysctl.conf command to edit the file.Kernel.shmall = 2097152Kernel.shmmax = 2147483648Kernel.shmmni = 4096Kernel.sem = 250 32000 100 128Fs.file-max = 65536Net.ipv4.ip_local_port_range = 1

1. Preparations for configuration in Linux Environment: Linux: RedHat Enterprise 5.4, DB: Oracle 11g R2 X64, Oracle installed in the/home/oralce_11 directory. The configuration process is as follows: (most of the content is online, and individuals follow the online steps) 1) Check the basic requirements (this must meet the requirements for the awesome server and

Oracle 11g has been installed in your Ubuntu environment. We hereby record the installation process and keep it as a memorandum. Prerequisites: 1. system update sudo Sudo apt-get updateSudo apt-get upgrade 2. packagesudo required for system installation Sudo su-Apt-get install build-essentialApt-get install libaio1Apt-

Export ORACLE_HOME = $ ORACLE_BASE/product/11g Export ORACLE_SID = msgplus Export LANG = en_US.UTF-8 Export NLS_LANG = AMERICAN_AMERICA.AL32UTF8 Export PATH = $ ORACLE_HOME/bin: $ PATH 4. Modify the Shell restrictions of oracle users. Modify the "limits. conf" file under "/etc/security/" and add the following four lines: Oracle soft nproc 2047 Hard nproc

Disclaimer: The system commands described in this article are "#", which indicates the root permission, and "$" indicates the Oracle permission.1. Install the systemFirst install the Linux system. According to the recommendations in the official Oracle documentation, when the machine memory is smaller than 1 GB, the sw

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 the Network Configuration and Database Upgrade

startup programsExport ORACLE_SID=ORCLExport oracle_base=/home/oracle/Export Ld_library_path= $LD _library_path:oracle_home/libExport Oracle_home=/home/oracle/product/11.2.0/dbhome_1Export oracle_home_listner= $ORACLE _homePath= $PATH: $HOME/bin: $ORACLE _home/binUmask 022Export PATHSh/home/

I have never summarized the installation process of Oracle11g. Today, the company is not busy. Please make a good arrangement and record it so that you can refer to it during re-installation. OS: CentOS5.8 Oracle: 11g2 The process is as follows: 1: Upload Oracle to the server, for example: -Rw-r -- 1 root 1239269270 08-17 12:.x64_11gr2_database_1of2.zip-Rw-r -- 1 root 1111416131 08-17 linux.x64_11gr2_databa

=ORCLExport oracle_base=/home/oracle/Export Ld_library_path= $LD _library_path:oracle_home/libExport Oracle_home=/home/oracle/product/11.2.0/dbhome_1Export oracle_home_listner= $ORACLE _homePath= $PATH: $HOME/bin: $ORACLE _home/binUmask 022Export PATHSh/home/oracle/.bash_pro

After Windows 7 is installed, an error occurred while installing oracle11g. Windows 7 is incompatible with Oracle 11g. modify OracleYou can continue to install the configuration file. The details are as follows: Decompress the Oracle 11g installation image on the hard disk