转自:

陈晓东的专栏

http://blog.csdn.net/chxd99/archive/2010/07/16/5739543.aspx

[root@bt bin]# ./sqlplus

./sqlplus: error while loading shared libraries: /home/mnum/app/mnum/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

先解决libclntsh.so的问题：

[root@bt bin]# semanage fcontext -a -t textrel_shlib_t /home/mnum/app/mnum/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1

csvn homedir /opt/CollabNet_Subversion or its parent directory conflicts with a defined context in /etc/selinux/targeted/contexts/files/file_contexts, /usr/sbin/genhomedircon will not create a new context. This usually indicates an incorrectly defined system account. If it is a system account please make sure its login shell is /sbin/nologin.

[root@bt bin]# restorecon -R -v /home/mnum/app/mnum/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1

restorecon reset /home/mnum/app/mnum/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1 context user_u:object_r:user_home_t:s0->system_u:object_r:textrel_shlib_t:s0

[root@bt bin]# ./sqlplus

Error 6 initializing SQL*Plus

SP2-0667: Message file sp1.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

解决上边的问题，添加环境变量：

[root@bt bin]# vi /etc/profile

ORACLE_HOME=/home/mnum/app/mnum/product/11.2.0/dbhome_1

ORACLE_SID=ORCL

PATH=:$ORACLE_HOME/bin

[root@bt bin]# source /etc/profile        (使变量生效)

[root@bt ~]# sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 16 13:34:08 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12546: TNS:permission denied

要指定用户名/密码@SID:

[root@bt ~]# sqlplus SYSTEM/Oracle11@ORCL

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 16 13:35:29 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

OK!!