六、利用dbca创建oracle数据库
1、执行DBCA
Oracle用户下命令行输入dbca,弹出图形界面
2、要点
A.注意需要选择asm存放
此处需要考虑到有的时候找不到dgroup1组,需要输入密码创建,总是提示spfile正在使用,此时可以采用关闭+ASM实例(shutdown immediate),在重试就行了。
此处需要考虑到有的时候找不到dgroup1组,需要输入密码创建,总是提示spfile正在使用,此时可以采用关闭+ASM实例(shutdown immediate),在重试就行了。
B.注意字符集选择:
Simplified Chinese ZHS15GBK
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.sh
Running 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 by
Database Configuration Assistant when a database is created
Finished 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.sh
Changing 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、常见错误(检查dbca的log确认原因)
A.输入dbca提示dbca Exception in thread "main"
检查dbca的log如下:
[oracle@centos ~]$ cd $ORACLE_HOME/cfgtoollogs/dbca
[oracle@centos dbca]$ vi trace.log
java.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 directory
at java.lang.ClassLoader$NativeLibrary.load(Native Method)
确认是缺少libXp.so,解决方法是找到Linux安装盘,安装libXp包,问题解决
安装过程如下:
[root@oraclebk ~]# yum install libXp
B.输入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/oratab
zjport:/home/oracle/product/10.2.0/db_1:Y
八、安装完成后,恢复 Oracle /etc/redhat-release 文件。
# vi /etc/redhat-release
Red Hat Enterprise Linux Server release 5.2 (Tikanga)
本文转自zylhsy 51CTO博客,原文链接:http://blog.51cto.com/yunlongzheng/407564,如需转载请自行联系原作者