oracle安裝簡要筆記

1|配置用戶環境

vi /home/oracle/.bash_profile #在最后添加以下代碼

export ORACLE_BASE=/data/oracle #oracle數據庫安裝目錄

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #oracle數據庫路徑

export ORACLE_SID=orcl #oracle啟動數據庫實例名

export ORACLE_TERM=xterm #xterm窗口模式安裝

export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH #添加系統環境變量

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib #添加系統環境變量

export LANG=C #防止安裝過程出現亂碼

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK  #設置Oracle客戶端字符集，必須與Oracle安裝時設置的字符集保持一致，如：ZHS16GBK，否則出現數據導入導出中文亂碼問題


2|netca啟動不了：
切換到root下，運行xhost +



3|啟動監聽失敗：
[oracle@oracle ~]$ lsnrctl start since01

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 09-JUN-2014 21:24:23

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /data/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /data/oracle/product/11.2.0/db_1/network/admin/listener.ora
Log messages written to /data/oracle/diag/tnslsnr/oracle/since01/alert/log.xml
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.102.110.203)(PORT=1529)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist
   Linux Error: 99: Cannot assign requested address

Listener failed to start. See the error message(s) above...
修改配置文件：/data/oracle/product/11.2.0/db_1/network/admin/listener.ora，將ip修改為本地地址或者，127.0.0.1

4|enterprise manager configuration failed due to the following error
配置dbca的時候不要勾選企業配置