用户现有环境:
[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
问题解决可以在里面建立新的表空间,新的用户,链接数据库正常,数据库目录重新挂载成功