欢迎来到博达网站群学习网!
设为首页 | 加入收藏
当前位置: 首页 >> 知识库 >> 部署类 >> 数据库 >> 正文

linux下ORACLE目录重新挂载到一块新的硬盘上

发布时间:2016-08-03    浏览次数:

用户现有环境:

[root@vs9db ~]# df -h

Filesystem            Size  Used Avail Use% Mounted on

/dev/sda3             245G  144G   89G  62% /

/dev/sda1              99M   14M   81M  15% /boot

none                  4.0G     0  4.0G   0% /dev/shm

[root@vs9db opt]# ll /opt/

total 16

drwxr-xr-x   3 root   root 4096 Oct  8  2011 ORCLfmap

drwxr-xr-x  63 oracle dba  4096 Feb 24  2013 ora10

drwxr-xr-x   2 root   root 4096 Jan 11  2013 temp

drwxrwxr-x   2 root   root 4096 May 21  2012 vs9db_bak

目的:

当时装操作系统没有给/opt单独挂载磁盘,现在要扩大磁盘空间,新增一块磁盘600G单独给/opt挂载

创建sdb1的过程省略,可参考http://allenyu.blog.51cto.com/193668/156256/

mount /dev/sdb1 /mnt

停掉ORACLE服务,将/opt所有目录下的东西拷贝至/mnt,  /dev/sdb1中就要有跟/opt相同的目录结构,然后挂载 mount /dev/sdb1 /opt。

给/etc/fstab中写入

让其开机自动挂载,挂载成功后

1.然后启动oracle数据库监听,报错。

进入/opt/ora10/lib文件夹,检查libclntsh.so.10.1是否存在
文件确实存在,

此文件的路径为 /opt/ora10/lib

2.root用户登录,修改该/etc/ld.so.conf添加/opt/ora10/lib路径

~
~运行ldconfig
[root@vs9db etc]# ldconfig
ldconfig: File /opt/ora10/lib/libnmeoci.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmadbg.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefud.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefvr.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmarl.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefsql.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmuc.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmuk.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmevq.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmalk.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefut.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefos.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmadm.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmemso.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmefw.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmasf.so.0 is empty, not checked.
ldconfig: File /opt/ora10/lib/libordim10.soO is empty, not checked.
ldconfig: File /opt/ora10/lib/libnmastk.so.0 is empty, not checked.
ldconfig: /opt/ora10/lib/libexpat.so.0 is not a symbolic link

检查问题是否解决

参考链接http://iefniqpl.blog.163.com/blog/static/7940617920113110815980/

3.未解决,再持行chmod -R 755 /opt/ora10/lsnctrl start启动成功

su - oracle

4.sqlplus / as sysdba登录报出错误ORA-09925: Unable to create audit trail filev

登不进去

chown R  oracle.oinstall   /opt/ora10g  

参考链接http://blog.sina.com.cn/s/blog_61c006ea0100lxpb.html

问题解决可以在里面建立新的表空间,新的用户,链接数据库正常,数据库目录重新挂载成功