[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
Solve the Problem of libclntsh. so first:
[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: Weight: 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
To solve the problem above, add the environment variable:
[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 (make the variable take effect)
[Root @ bt ~] # Sqlplus
SQL * Plus: Release 11.2.0.1.0 Production on Fri Jul 16 13:34:08 2010
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
ERROR:
ORA-12546: TNS: permission denied
To specify the username/password @ 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,200 9, Oracle. All rights reserved.
Connected:
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 !!
[Supplement]
Connect sqlplus to a remote database
[Root @ bt ~] # Sqlplus Oracle11 @ ip: port/ORCL "> SYSTEM/Oracle11 @ ip: port/ORCL
Author 447214075