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