注意:此处可能会有错误 oracle 需要的软件包不全。
请根据 1 中列出的软件包,确保所有的软件包都已经正确安装( 2 ) 6 中对 gennttab 文件的修改不正确,本人就是没有去掉 n 后的空格导致了该错误。
如下报的缺少libXtst包
Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i386/libawt.so: libXtst.so.6: cannot open shared object file:
用yum下载安装即可解决
[root@oraclebk ~]# yum install libXp
14、修改 dbstart
vi $ORACLE_HOME/bin/dbstart
ORACLE_HOME_LISTNER=/ade/vikrkuma_new/oracle
改为:
ORACLE_HOME_LISTNER=$ORACLE_HOME
确保数据库启动时,网络监听器同时启动。
15、增加数据实例
vi /home/oracle/database/response/dbca.rsp
根据数据库建立方式的不同编辑不同的数据库库选项。
比如在本次安装过程中设置了下列参数:( 注意下面参数视情况而定啦不要照抄该选项原文件都有说明的)
RESPONSEFILE_VERSION = "10.0.0"
OPERATION_TYPE = "createDatabase"
GDBNAME = "orcl" # 数据库全局名称
SID = "TSH1" #这个sid 必须要和前面的/home/oracle/.bash_profile文件中的sid相同
# 注意:一定要注意上面两个变量设置的两个值是不同的,但大多数情况下设置是相同的,相同值我没有测试,感兴趣的可以试一下(相同值会更容易理解)
TEMPLATENAME = "New_Database.dbt"
SYSPASSWORD = "system" # SYS 用户的初始密码
SYSTEMPASSWORD = "system" #SYSTEM 用户的初始密码
DATAFILEDESTINATION ="/u01/app/oracle/oradata/"
RECOVERYAREADESTINATION="/u01/app/oracle/flash_recovery_area"
STORAGETYPE=FS
CHARACTERSET = "ZHS16GBK" #数据库字符集(中文为 ZHS16GBK )
MEMORYPERCENTAGE = "40"
SCRIPTDESTINATION ="/u01/app/oracle/admin/ora10g/scripts"
EMCONFIGURATION=”LOCAL”
SYSMANPASSWORD = "system"
DBSNMPPASSWORD = "system"
su – oracle
$ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/database/response/dbca.rsp
执行结果:
Creating and starting Oracle instance
1% complete
4% complete
Creating database files
8% complete
Creating data dictionary views
9% complete
10% complete
12% complete
13% complete
14% complete
15% complete
17% complete
18% complete
20% complete
21% complete
Adding Oracle JVM
22% complete
28% complete
34% complete
40% complete
42% complete
Adding Oracle Data Mining
43% complete
44% complete
46% complete
Adding Oracle Text
47% complete
49% complete
50% complete
Adding Oracle XML DB
52% complete
53% complete
54% complete
58% complete
Adding Oracle Intermedia
59% complete
60% complete
71% complete
Adding Oracle OLAP
72% complete
73% complete
74% complete
75% complete
Adding Oracle Spatial
76% complete
77% complete
78% complete
83% complete
Adding Enterprise Manager Repository
84% complete
86% complete
88% complete
Completing Database Creation
89% complete
90% complete
91% complete
95% complete
99% complete
100% complete
Look at the log file
"/u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/dbca/orcl/orcl.log" for further details.
最后提示创建成功后
数据库创建成功后需要修改一些信息:
vi /etc/oratab
THS1:/ u01/app/oracle/product/10.2.0/db_1:N
改为:
TSH1:/u01/app/oracle/product/10.2.0/db_1:Y
保证数据库实例能自动启动。
16、创建数据库和监听器自启动的服务
su - root
cd /etc/rc.d/init.d/
touch oradbstart
vi oradbstart
脚本内容如下:
#!/bin/bash
# chkconfig: 345 99 10
# description: Startup Script for Oracle Databases
# /etc/rc.d/init.d/oradbstart
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=TSH1
export PATH=$ORACLE_HOME/bin:$PATH
case "$1" in
start)
su oracle -c $ORACLE_HOME/bin/dbstart
touch /var/lock/oracle
echo "OK"
;;
stop)
echo -n "Shutdown Oracle: "
su oracle -c $ORACLE_HOME/bin/dbshut
rm -f /var/lock/oracle
echo "OK"
;;
*)
echo "Usage: 'basename $0' start|stop"
exit 1
esac
exit 0
17、修改数据脚本的权限
su - root
chown oracle.oinstall /etc/rc.d/init.d/oradbstart
chmod 775