Install the Oracle client in Linux

With the advent of ArcGIS10.1, especially after the default direct connection to ArcSDE10.1, a requirement for direct connection is to install the database client software. For example, we use ArcGISServer10.1 to connect to the data source of ArcSDE10.1, the installation of the database client is very important. Next we will briefly describe how to install Oracle in a Linux environment

With the advent of ArcGIS10.1, especially after the default direct connection to ArcSDE10.1, a requirement for direct connection is to install the database client software. For example, we use ArcGIS Server10.1 to connect to the data source of ArcSDE10.1, the installation of the database client is very important. Next we will briefly describe how to install Oracle in a Linux environment

With the advent of ArcGIS10.1, especially after the default direct connection to ArcSDE10.1, a requirement for direct connection is to install the database client software. For example, we use ArcGIS Server10.1 to connect to the data source of ArcSDE10.1, the installation of the database client is very important.

The following describes how to install the Oracle client in Linux.

Operating System: Redhat 6.1 64Bit

Database: Oracle11.2.0.1 client 64Bit

1: Create an operating system account for the database, such as ora.

2: Use SSH to transmit the database client software to the ora user

Before executing the installation, we need to have 775 permissions on the install Folder and runInstaller.

[ora@redhat6 client]$ lltotal 24drwxr-xr-x.  8 ora oinstall 4096 Jul 19  2012 docdrwxrwxrwx.  4 ora oinstall 4096 Jul 19  2012 installdrwxr-xr-x.  2 ora oinstall 4096 Jul 19  2012 response-rwxrwxrwx.  1 ora oinstall 3230 Aug 15  2009 runInstallerdrwxr-xr-x. 14 ora oinstall 4096 Jul 19  2012 stage-rw-r--r--.  1 ora oinstall 3924 Aug 17  2009 welcome.html

3: Execute xhost + under the root user to bring up the graphical interface.

4: the installation is relatively simple. In fact, there is a system dependency package check installed. In fact, this can be skipped. Many packages have actually been installed (but be careful)

5: at the end of the installation process, use the root user to execute two scripts. The system will prompt

[root@redhat6 app]# cd oraInventory/[root@redhat6 oraInventory]# lsContentsXML       logs                     oraInst.loc     ouiinstall.platform  oraInstaller.properties  orainstRoot.sh[root@redhat6 oraInventory]# ./orainstRoot.shChanging permissions of /home/ora/app/oraInventory.Adding read,write permissions for group.Removing read,write,execute permissions for world.Changing groupname of /home/ora/app/oraInventory to oinstall.The execution of the script is complete.

There is another

[root@redhat6 client_1]# lsassistants   dc_ocm            javavm   odbc         perl          sqljbin          deinstall         jdbc     olap         plsql         sqlpluscdata        diagnostics       jdk      OPatch       precomp       srvmcfgtoollogs  has               jlib     opmn         racg          sysmanclone        hs                jpub     oracore      rdbms         ucpcrs          install           ldap     oraInst.loc  relnotes      uixcsmig        install.platform  lib      ord          root.sh       utlcss          instantclient     network  oui          slax          wwgcv           inventory         nls      owm          sqldeveloper  xdk[root@redhat6 client_1]# ./root.shRunning Oracle 11g root.sh script...The following environment variables are set as:    ORACLE_OWNER= ora    ORACLE_HOME=  /home/ora/app/ora/product/11.2.0/client_1Enter the full pathname of the local bin directory: [/usr/local/bin]:   Copying dbhome to /usr/local/bin ...   Copying oraenv to /usr/local/bin ...   Copying coraenv to /usr/local/bin ...Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.

After the execution, write the relevant environment variables.

PATH=$PATH:$HOME/binexport PATHexport  ORACLE_OWNER= oraexport  ORACLE_HOME=/home/ora/app/ora/product/11.2.0/client_1export PATH=$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:usr/libexport CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport LANG=en_US

Then run netca under the ora user to configure netservicename. After the configuration is complete, you can use it.

[ora@redhat6 ~]$ sqlplus system/oracle@orclSQL*Plus: Release 11.2.0.1.0 Production on Sat Jun 16 03:38:24 2012Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>

In addition, we need to pay attention to the fact that we need to use ArcGIS Server users to publish services. Therefore, if ArcGIS Server users can use Sqlplus for execution, we need

1: either our oracle is installed in the/opt directory

2: either Oracle is installed in another directory, and ArcGIS Server users can have related permissions on this directory.

In the future, ArcGIS Server10.1 will be connected to the SDE data source directly by default, so you will often encounter a client that installs the database in the Linux environment, for your reference only!

Bytes -------------------------------------------------------------------------------------------------------

Bytes -------------------------------------------------------------------------------------------------------