Solve all kinds of problems in the process of installing oracle11g R2 in Linux

How do I install Oracle in Linux graphics??

Solutions and ideas:

1 The VNC service can be installed.

2 If you are near the server, you can install it directly under the desktop. (If Linux has a graphical desktop program installed)

3) by Xmanager Enterprise Direct Remote Call to the desktop to install. I use the Third Kind

2. Oracle interface garbled, appear various square lattice??

Reasons and Solutions: System language environment and font problems.

Can be installed in the song body 18030, can solve the garbled problem, or directly set Lang for English environment, installed in English can also

Under Linux execute the following command 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, not Chinese garbled. Nanjing Oracle Certification Training

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

Reason and solution: Oracle_sid did not specify! In the/home/oracle/.bash_profile file, add

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

4. During the installation process, when performing the prerequisite check, the memory Exchange space is not enough, have the prompt need at least how many m, already have how many M.??

Reasons and Solutions:

1)

grep memtotal/proc/meminfo

Swap partition size

grep swaptotal/proc/meminfo

Increase the Swap partition

Create a/home/swap such a partition file. The size of the file is 5.12 million blocks, typically 1 blocks to 1 K, so the space here is 5G. Nanjing Oracle Certification Training

DD If=/dev/zero Of=/home/swap bs=1024 count=5120000

Then turn this partition into a swap partition.

Mkswap/home/swap

and add it to the fstab.

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

5. During the installation process, when performing the prerequisite check, the prompt has a lot of missing packages??? As shown in figure

The reason and solution: Is missing the package, to install the appropriate package, 32-bit and 64-bit are installed.

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


6. Oracle from start script creation, reproduced from other places??

Configure Oracle for power-on self-boot

Although Oracle as a server does not often shutdown, but occasionally restart, each time to manually start Oracle is too much trouble, I hope to be able to be like in Windows, each time the boot of the automatic launch of Oracle, It is only necessary to configure Oracle as a service for Linux. The operation is as follows:

1, create the/etc/rc.d/init.d/oracle11g script file as root user, the content is as follows (environment variable setting is 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 Nanjing ORACLE Certification Training

# How we are called:

Case is 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 the 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 on the switch.