Debian4.0 installation of Oracle 10g XE

Source: Internet
Author: User
Tags ssh access
Originally, I only wanted to install an Oracle client with the imp/exp command. However, instantclient does not have these two commands and does not want to download 10 Gb client software of over 600 mb, which is also troublesome to install. The 10g express edition is found, and the Deb installation package for Debian is also available.
I am from Hangzhou. Because it is necessary to support Chinese characters, it is natural to use the universal version.
Use dpkg-I after the download and follow the prompts to handle the installation. Everything went smoothly. It saves a lot of trouble for oracle users who have automatically created the installation package and modified the sysctl. conf file.
Then configure the environment variables, due to the installation of the system Lang default value, generally set to zh_CN.UTF-8, installed 10g XE, character set fixed to al32utf8, nls_lang is determined based on the locale of the system. The configuration here is simplified chinese_china.
The environment variables of Oracle are as follows:
Export ORACLE_HOME =/usr/lib/Oracle/Xe/APP/Oracle/product/10.2.0/Server
Export oracle_sid = XE
Export nls_lang = "simplified chinese_china.al32utf8"
Export LD_LIBRARY_PATH = $ LD_LIBRARY_PATH: $ ORACLE_HOME/lib
Export Path = $ path: $ ORACLE_HOME/bin

Through remote SSH access, you can correctly display and read and write Chinese information. Commands such as imp/exp can be used freely.

Allow Remote Access to Oracle Application Express and run with sqlplus
Exec dbms_xdb.setlistenerlocalaccess (false );
Then restart LSNRCTL
 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.