Problems encountered during installation of oracle11g R2 under Linux

Linux installed oracle11g R2 process encountered a few problems, I hope to help you.

1. How do I install Oracle on Linux graphically??

   
   

   Workaround and ideas: 1) can be installed by VNC service.

   
   

2) If you are close to your server, you can install it directly from the desktop. (Provided that Linux has a graphical desktop program installed)

3) Install via Xmanager Enterprise Direct Remote Call desktop. I use the third type of

2. Oracle interface garbled, there are various square lattice??

Causes and Solutions: System language environment and font problems.

Can be installed in the song 18030, can solve garbled problems, or directly set lang for the English environment, installed in English can also

Install the font library to the appropriate location by executing the following command under Linux
Mkdir-p/USR/SHARE/FONTS/ZH_CN/TRUETYPECP zysong.ttf/usr/share/fonts/zh_cn/truetype/
So at the time of installation. Oracle will display Chinese instead of Chinese characters.

3. Connection Database error ora-12162:tns:net Service name is incorrectly specified??

Reason and solution: ORACLE_SID not specified! in the/home/oracle/.bash_profile file, add

Export oracle_sid=ora10g and use the source command to take effect immediately.

4. During the installation process, when the prerequisite check is performed, the memory swap space is not enough, the hint needs to be less than m, already how many M.??

Causes and solutions:

1)
grep memtotal/proc/meminfo
Swap partition size
grep swaptotal/proc/meminfo
Add Swap partition
Create/home/swap such a partition file. The size of the file is 5.12 million blocks, normally 1 blocks are 1 K, so the space here is 5G.
DD If=/dev/zero Of=/home/swap bs=1024 count=5120000
Then turn the partition into a swap partition.
Mkswap/home/swap
and add it to the fstab.
echo "/home/swap swap swap defaults 0 0" >>/etc/fstab

5. During the installation process, when performing prerequisite checks, there are many missing packages.??

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/59/A6/wKiom1TaPXqBlHiwAAIVP1hNVIQ467.jpg "title=" QQ picture 20150211011737.png "alt=" Wkiom1tapxqblhiwaaivp1hnviq467.jpg "/>

Cause and Resolution: Is missing the package, to install the appropriate package, both 32-bit and 64-bit are installed.

Note: Some packages are not installed and may be forced to install

I played a package to share to everyone: http://down.51cto.com/data/1979796

6. Oracle self-initiated script creation, reproduced from other places??

Configure Oracle to boot from

Although Oracle does not often shut down as a server, but occasionally reboots, it is too troublesome to manually start Oracle each time, hopefully, as in Windows, to automatically start Oracle every time you turn on the computer, You only need to configure Oracle as a service for Linux. The operation is as follows:

1, create the/etc/rc.d/init.d/oracle11g script file with the root user, the content is as follows (environment variable setting changes according to the actual situation):

#!/bin/bash
#
# CHKCONFIG:35 95 1
# description:init script to Start/stop Oracle database 11g, TNS Listener, EM
#
#
#
# Match these values to your environment:

Oracle_base=/home/oracle_11/app
Oracle_home= $ORACLE _base/oracle/product/11.2.0/db_1
Oracle_sid=brdwdev
Oracle_unqname=brdwdev
Path= $PATH: $HOME/bin: $ORACLE _home/bin
Ld_library_path= $ORACLE _home/lib:/usr/lib
Lang=c

Export oracle_base oracle_home oracle_sid oracle_unqname PATH ld_library_path LANG

# See how we are called:
Case $ in
Start
Su-oracle<<eoo
Lsnrctl start
Sqlplus/nolog<<eos
Connect/as SYSDBA
Startup
Eos
Emctl Start Dbconsole
Eoo
;;

Stop
Su-oracle<<eoo
Lsnrctl stop
Sqlplus/nolog<<eos
Connect/as SYSDBA
Shutdown immediate
Eos
Emctl Stop Dbconsole
Eoo
;;

*)
echo "Usage: $ {start|stop}"
;;
Esac

2, execute the following command as root user

chmod 755/etc/rc.d/init.d/oracle11g

Chkconfig--add oracle11g

3, restart the service

Service oracle11g Stop

Service oracle11g Start

This allows Oracle to start and stop automatically when switching machines.

This article is from the "Technical Achievement Dream" blog, please be sure to keep this source http://pizibaidu.blog.51cto.com/1361909/1613524

Problems encountered during installation of oracle11g R2 under Linux