@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.aygfsteel.com/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
安裝完成后無法啟動問題
1.沒有etc/oratab文件
解決辦法：
[oracle@xiongwei2 db_1]$ pwd
/home/oracle/product/10.2.0/db_1
[oracle@xiongwei2 db_1]$ sh root.sh
2.錯誤：ORACLE_HOME_LISTNER is not SET, unable to auto-start Oracle Net Listener
解決辦法：vi dbstart
#ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
export ORACLE_HOME_LISTNER=$ORACLE_HOME
3.啟動dbstart沒有反應
解決辦法：vi etc/oratab
GZBOSS:/home/oracle/product/10.2.0/db_1:Y 將N改成Y
4.啟動dbstart沒有權限 ：將db_1目錄改成 chmod -R 777 *
5.
將/var/tmp目錄下.oracle權限改成777
6.
oracle自啟動腳本。在etc/init.d目錄下創建oracle文件
1 #!/bin/sh
2
3 #chkconfig: 2345 99 01
4
5 #description: ORACLE 10g Server
6 ORACLE_HOME=/home/oracle/product/10.2.0/db_1
7
8 if [ ! -f $ORACLE_HOME/bin/dbstart ]
9
10 then
11
12 echo "ORACLE cannot start"
13
14 exit
15
16 fi
17
18 case "$1" in
19
20 'start')
21
22 echo "Starting Oracle Database
"
23
24 su - oracle -c "$ORACLE_HOME/bin/dbstart"
25
26 su - oracle -c "$ORACLE_HOME/bin/emctl start dbconsole"
27
28 ;;
29
30 'stop')
31
32 echo "Stoping Oracle Database"
33
34 su - oracle -c "$ORACLE_HOME/bin/emctl stop dbconsole"
35
36 su - oracle -c "$ORACLE_HOME/bin/dbshut"
37
38 ;;
39 'reload'|'restart')
40 $0 stop
41 $0 start
42 ;;
43
44 *)
45 echo "Usage: {start|stop|reload|restart}"
46 exit 1
47 esac
48 exit 0
8、查看字符集
select userenv('language') from dual
9.啟動相關文件
su - oracle -c lsnrctl start
su - oracle -c sqlplus /nolog
connect / as sysdba
system
startup
/etc/init.d/oracle start
export DISPLAY=:0.0
xhost +
10.環境變量設置 oracle用戶主目錄下的.bash_profile文件
PATH=$PATH:$HOME/bin
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=GZBOSS
export ORACLE_TERM=xterm
export TMP=/tmp
export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PATH
11.編輯文件/etc/sysctl.conf 配置相關內核參數
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 262144
12.欺騙oracle對系統的檢查 /etc/redhat-release
#CentOS release 5.5 (Final)
13.
[oracle@localhost database]$ ./runInstaller
You do not have sufficient permissions to access the inventory '/oracle/oraInventory'. Installation cannot continue. Make sure that you have read/write permissions to
the inventory directory and restart the installer.: No such file or directory
錯誤說沒有權限。實際是之前安裝未卸載干凈
解決辦法：find / -name "oraInst.loc" 。將相關文件刪掉
14.[oracle@localhost database]$ ./runInstaller
Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-09-19_02-21-32PM. Please wait ...[oracle@localhost database]$ Xlib: connection to ":0.0" refused by server
Xlib: No protocol specified
Exception in thread "main" java.lang.InternalError: Can't connect to X11 window server using ':0.0' as the value of the DISPLAY variable.
解決辦法：[root@localhost database]# who
root pts/8 2011-09-19 11:57 (192.168.0.32)
root pts/3 2011-09-19 14:11 (:2.0)
root pts/4 2011-09-19 14:14 (:2.0)
[root@localhost database]# export DISPLAY=192.168.0.32
[root@localhost database]# xhost +
xhost: unable to open display "192.168.0.32"
[root@localhost database]# who
root pts/8 2011-09-19 11:57 (192.168.0.32)
root pts/3 2011-09-19 14:11 (:2.0)
root pts/4 2011-09-19 14:14 (:2.0)
[root@localhost database]# export DISPLAY=:2.0
[root@localhost database]# xhost +
access control disabled, clients can connect from any host
15.查看server端字符集：select userenv('language') from dual;
16.dbca時報ora-12546;TNS:permission denied
解決辦法。第一次建庫時的文件全部刪除，并將oracle目錄權限改成777.重建的數據庫文件不能和第一次文件相同