Shulou(Shulou.com)06/01 Report--

There are several problems encountered in the process of installing Oracle11G R2 under Linux. I hope it will be helpful to you.

1. How to install oracle?? graphically in linux

Solutions and ideas:

1) you can install the VNC service.

2) if you are close to you on the server, you can install it directly under the desktop. (if linux has a graphical desktop program installed)

3) install it by calling the desktop directly through Xmanager Enterprise. I use the third one.

2. The Oracle interface is garbled and various squares appear.

Reasons and solutions: system language environment and font problems.

You can install Zhongyi Song style 18030 to solve the problem of garbled code, or directly set LANG to the English environment, or install it in English.

Execute the following command under Linux to install the font library to the appropriate location

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 garbled code.

3. Connection to the database reported an error ORA-12162: TNS:net service name is incorrectly specified?

Reason and solution: ORACLE_SID is not specified! Add to the / home/oracle/.bash_profile file

Export ORACLE_SID=ora10g and the source command will take effect immediately.

4. During installation, when performing a prerequisite check, there is not enough swap space for memory. There is a prompt for at least how much m is needed and how much m is already available.??

Reasons and solutions:

1)

Grep MemTotal / proc/meminfo

Swap partition size

Grep SwapTotal / proc/meminfo

Add switching Partition

Create a partition file like / home/swap. The size of the file is 5120000 block, and normally 1 block is 1K, so the space here is 5G.

Dd if=/dev/zero of=/home/swap bs=1024 count=5120000

Then change this partition to the swap partition.

Mkswap / home/swap

And then add it to fstab.

Echo "/ home/swap swap swap defaults 0" > > / etc/fstab

5. During installation, when performing a prerequisite check, it is indicated that there are many missing packages. As shown in the picture

Reason and solution: the lack of packages, to install the corresponding packages, 32-bit and 64-bit installation.

Note: some packages cannot be installed and may be forced to install

I packed a package and shared it with you. Download address: http://down.51cto.com/data/1979796

6. Oracle is created by self-startup script and reproduced from somewhere else.

Configure Oracle to boot automatically

Although Oracle, as a server, does not shut down frequently, it is still too troublesome to restart Oracle manually every time it is rebooted. The hope is to start Oracle automatically every time you boot, as in Windows, and you only need to configure Oracle as a Linux service. Do the following:

6.1 create / etc/rc.d/init.d/oracle11g script file as root user, with the following contents (the environment variable settings are modified 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 $1 in

Start)

Su-oracle

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.