@import url(http://www.blogjava.net/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.blogjava.net/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.blogjava.net/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.blogjava.net/CuteSoft_Client/CuteEditor/Load.ashx?type=style&file=SyntaxHighlighter.css);@import url(/css/cuteeditor.css);
@import url(http://www.blogjava.net/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.重建的数据库文件不能和第一次文件相同