日期:2014-05-16  浏览次数:20943 次

linux 安装oracle错误解决方法
    [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!!

    【补充】

    sqlplus连接远程数据库

    [root@bt ~]# sqlplus Oracle11@ip:port/ORCL">SYSTEM/Oracle11@ip:port/ORCL