用户现有环境：
[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的过程省略，可参考
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
检查问题是否解决
参考链接
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
参考链接
问题解决可以在里面建立新的表空间，新的用户，链接数据库正常，数据库目录重新挂载成功
|
