假定原来的oracle目录/export/home/oracle
新的目录为/opt/oracle
1.把/export/home/oracle目录下所有内容mv到/opt/oracle
2.修改pfile文件(admin/全局数据库名/pfile/initSID.ora.12220061741)
/export/home/oracle替换为/opt/oracle
3.启动实例
sqlplus "/ as sysdba"
startup pfile='/opt/oracle/OraHome1/admin/全局数据库名/pfile/initSID.ora.12220061741'
然后修改数据文件,日志文件,控制文件参数,其文件在/opt/oracle/OraHome1/oradata/全局数据库名/目录下,比如
alter database rename file '/export/home/oracle/OraHome1/oradata/全局数据库名/BPM_INDEX.dbf' to '/opt/oracle/OraHome1/oradata/全局数据库名/BPM_INDEX.dbf';
4.创建spfile文件
create spfile from pfile='/opt/oracle/OraHome1/admin/全局数据库名/pfile/initSID.ora.12220061741'
5.其他重要文件目录
/opt/oracle/OraHome1/dbs
/var/opt/oracle