异常1
sqlplus /nolog
sqlplus: error while loading shared libraries: /myoracle/app/product/11.2.0/db_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied
解决:
1 /etc/selinux/config
SELINUX=disabled (重启后生效)
2 sentenforce 0 (立即生效,重启后失效)
================================================
异常2
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.1.0 Production on Sat Sep 15 23:38:24 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/myoracle/app/product/11.2.0/db_1/dbs/initzdb.ora'
解决:
1 *oracle的环境变量和库的名字不一致,删掉库后重新建立同名的库,故障排除。
以下两个方法是整理网友的办法:
2 *把/myoracle/app/admin/zdb/pfile下的init.ora.816201201149文件拷贝到/myoracle/app/product/11.2.0/db_1/dbs/initzdb.ora即可
3 *在ORACLE_BASE环境变量后面多了"/"。