Operations required after the installation of Oracle in Linux

Oracle in Linux is running after installation. Run ps-ef or top-uoracle. You can see the processes run as Oracle users. In the graphical interface

Oracle in Linux is running after installation. Run ps-ef or top-u oracle. You can see the processes run as Oracle users. In the graphical interface

Oracle in Linux is running after installation. Run ps-ef or top-u oracle. You can see the processes run as Oracle users. On the graphic interface, run $/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/sqldeveloper. sh to display the free Oracle management client SQL Developer that comes with Oracle. Connect to the just-installed Oracle. The connection is successful.

Open in a browser: https://localhost.localdomain: 1158/em

FAQs and Solutions

1. 11gR2 output the "patch" displayed in Chinese"

(1) Use the system's font library

# Mkdir-p/usr/share/fonts/zh_CN/TrueType

Download zysong. ttf and put it under/usr/share/fonts/zh_CN/TrueType/(download it to the USB flash drive in windows, decompress it, or directly download it from the windows Font Library. copy the ttf font to the USB flash drive, and then cp/media/disk/zysong. ttf/usr/share/fonts/zh_CN/TrueType), and then execute:

# Mkfontscale

# Mkfontdir

Or

(2) install oracle products (databases are not installed only when the software is installed)

When the installation is completed, the Chinese language is "zookeeper". Enter/home/oracle/database/stage/Components/oracle. jdk/1.5.0.20./ 1/DataFiles/all. jar is JDK. in/tmp/, create a new folder named fallback/and find a zysong. put the ttf Chinese font in it. Open it with the archive manager to enter/jdk/jre/lib/fonts/(all. jar package directory) drag and drop the fallback folder created on the desktop. The directory structure should be/jdk/jre/lib/fonts/fallback/zysong. ttf.

# Mkdir/tmp/fallback

# Cp/home/oracle/database/stage/Components/oracle. jdk/1.5.0.20./ 1/DataFiles/all. jar

/Tmp/jdk

#

(3) install the database

When you install the database (that is, step 1 to install the product), you can install the database again because the oracle product (software) has been installed, it does not use the JDK in the oracle Installation File, but uses the jdk under the Environment Variable ORACLE_HOME (that is, the ORACLE_HOME you configured = $ ORACLE_BASE/product/11.2.0/dbhome_1 ;) /usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk. However, this JDK does not contain/jre/lib/fonts/fallback/zysong. the ttf file has been released.

① There is a solution when you install oracle, when it generates the/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk directory, You put zysong. copy the ttf font to the jdk/jre/lib/fonts/fallback/directory. When it is executed to install the database, it should be in Chinese.
Note: Make sure to copy the jdk In the ORACLE_HOME/directory with its own environment variable before installing the database. After the copy file is successfully executed during step 1 of the product installation, the zysong should be manually copied before the Oracle Database configuration is executed. ttf to your environment variable ORACLE_HOME/jdk's jre/lib/fonts/fallback/(that is,/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk/jre/ lib/fonts/fallback/in this directory ).

# Mkdir/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk/jre/lib/fonts/fallback

# Cp/usr/share/fonts/zh_CN/TrueType/zysong. ttf/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk/jre/lib/fonts/fallback/

Or # ln-s/usr/share/fonts/zh_CN/TureType/zysong. ttf/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk/jre/lib/fonts/fallback

# Cd/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/jdk/jre/lib/fonts/fallback/

# Mkfontscale

# Mkfontdir

If your system is in Chinese, you need to copy it after installation, so that the Chinese interface can be displayed only when you configure oracle and use SQL Developer.
② The easiest way is to delete the jdk that comes with oracle directly, and connect the local jdk to the past!
Sudo mv/opt/oracle11g/server/jdk/opt/oracle11g/server/jdk. bak
Sudo ln-s/usr/local/lib/jdk1.6.0 _ 20 jdk

(4) Solve the Problem of garbled Chinese characters in the terminal

Check whether the SQL> conn/as sysdba displays '??? '

In the terminal menu, choose terminal> character encoding> Simplified Chinese (BGK )"

(5) Solve the Problem of garbled Secure CRT Display

Options> session Options> appearance> character encoding> uft-8

(6) Solve the Problem of garbled characters when using the backspace key in the Environment sqlplus.

When using sqlplus, a string of garbled characters occurs during backspace deletion. The garbled characters are caused by oracle sqlplus's absence of the gnu readline library.

There are two solutions:

1. When you want to use the backspace, press and hold the ctrl key;

2. Set the environment variable to add stty erase ^ H to. bash_profile.

2. Solution to the emergence of agent nmhs (required only in Fedora but not in RHE)

Because of the C library issue, after fedora13, you are not allowed to use the original two libraries at the same time. If you ignore the issue of the agent nmhs and continue the installation, the em can only be used for about 15 minutes and cannot be connected again. The solution is to manually specify the C library location. Find the $ ORACLE_HOME/sysman/lib/ins_emagent.mk file after the agent nmhs problem occurs, find the $ (MK_EMAGENT_NMECTL) string in the file, and add-lnnz11 to the end. And $ (MK_EMAGENT_NMECTL) have a space. Then click Retry to solve the problem.

# Vi/usr/share/oracle/oracle11gR2/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk

3. EM startup page ERROR: Failed agent connection status to instance detail ORA-12505: TNS: The Listener currently cannot recognize the SID (dbd error: OCIServerAttach) given in the connection Descriptor and

$ Sqlplus/nolog

SQL> conn/as sysdba

SQL> startup

ORA-00845: MEMORY_TARGET not supported on this system

These two problems are actually the same thing. MEMORY_TARGET is a new memory parameter added only when 11 GB is used. It is a 10 Gb ASMM extension ,, because the size of SGA exceeds the size of the Operating System/dev/shm, if no size is set, it is half the size of the system RAM.

There are three solutions to this problem:

(1) modify the initialization parameter so that the SGA setting in the initialization parameter is smaller than/dev/shm,

# Vi/etc/fstab

LABEL = // ext3 defaults 1 1
LABEL =/boot ext3 defaults 1 2
LABEL =/data ext3 defaults 1 2
Devpts/dev/pts devpts gid = 5, mode = 620 0 0
# Tmpfs/dev/shm tmpfs defaults 0 0
Tmpfs/dev/shm tmpfs ults, size = 1024 M 0 0
LABEL =/home ext3 defaults 1 2
LABEL =/opt ext3 defaults 1 2
Proc/proc defaults 0 0
Sysfs/sys sysfs defaults 0 0
LABEL =/usr ext3 defaults 1 2
LABEL =/var ext3 defaults 1 2
LABEL = SWAP-sda8 swap defaults 0 0

............

# Umount/dev/shm
# Mount/dev/shm
# Df-k/dev/shm

(2) Adjust the size of/dev/shm.

# Mount-o remount, size = 1G/dev/shm // use this command every time you start oracle

(3) Adjust MEMORY_TARGET Parameters

SQL> alter system set memory_target = 1024 M; // use