学特效化妆:RedHat5.2下Linux Oracle 10g ASM 安装详细实录-第三篇-利用dbca创建oracle数据库

来源:百度文库 编辑:偶看新闻 时间:2024/04/28 13:12:37

六、利用dbca创建oracle数据库

1、执行DBCA    Oracle用户下命令行输入dbca,弹出图形界面 2、要点A.注意需要选择asm存放
此处需要考虑到有的时候找不到dgroup1组,需要输入密码创建,总是提示spfile正在使用,此时可以采用关闭+ASM实例(shutdown immediate),在重试就行了。 B.注意字符集选择
Simplified Chinese ZHS15GBK
 C.安装完成的最后操作步骤$ su root# /oracle/oralnventory/orainstRoot.sh# /oracle/product/10.2.0/db/root.sh示例:[root@L-DB-3-6 db_1]# cd /home/oracle/product/10.2.0/db_1/[root@L-DB-3-6 db_1]# ./root.shRunning Oracle10 root.sh script... The following environment variables are set as:    ORACLE_OWNER= oracle    ORACLE_HOME= /home/oracle/product/10.2.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]:   Copying dbhome to /usr/local/bin ...   Copying oraenv to /usr/local/bin ...   Copying coraenv to /usr/local/bin ... Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed. [root@L-DB-3-6 db_1]# cd /home/oracle/oraInventory/[root@L-DB-3-6 oraInventory]# ./orainstRoot.shChanging permissions of /home/oracle/oraInventory to 770.Changing groupname of /home/oracle/oraInventory to oinstall.The execution of the script is complete[root@L-DB-3-6 oraInventory]# 3、常见错误(检查dbcalog确认原因)A.输入dbca提示dbca Exception in thread "main"检查dbca的log如下:[oracle@centos ~]$ cd $ORACLE_HOME/cfgtoollogs/dbca[oracle@centos dbca]$ vi trace.logjava.lang.UnsatisfiedLinkError: /u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directoryat java.lang.ClassLoader$NativeLibrary.load(Native Method) 确认是缺少libXp.so,解决方法是找到Linux安装盘,安装libXp包,问题解决 安装过程如下:[root@oraclebk ~]# yum install libXpB.输入dbca提示dbca Exception in thread "main"[oracle@centos ~]$ cd $ORACLE_HOME/cfgtoollogs/dbca[oracle@centos dbca]$ vi trace.log提示IP错误,突然想起要export DISPLAY=172.16.4.41:0.0(连上去的客户机)示例:[oracle@L-DB-3-6 dbca]$ export DISPLAY=172.16.4.41:0.0[oracle@L-DB-3-6 dbca]$ dbca 七:设置自启动# vi /etc/oratabzjport:/home/oracle/product/10.2.0/db_1:Y 八、安装完成后,恢复 Oracle /etc/redhat-release 文件。# vi /etc/redhat-releaseRed Hat Enterprise Linux Server release 5.2 (Tikanga)