sqlplus libclntsh.so.11.1 Permission denied 解决方法
来源:互联网 发布:女友是韩国人知乎 编辑:程序博客网 时间:2024/06/04 23:22
[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 adefined 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 SYSTEM/Oracle11@ip:port/ORCL
- sqlplus libclntsh.so.11.1 Permission denied 解决方法
- sqlplus libclntsh.so.11.1 Permission denied 解决方法
- sqlplus:Permission Denied
- sqlplus: error while loading shared libraries: /var/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1
- sqlplus: error while loading shared libraries: /opt/oracle/product/OraHome/lib/libclntsh.so.11.1: ca
- dbca后报错libclntsh.so.11.1
- permission denied (publickey)解决方法
- Permission denied (publickey) 解决方法
- linux permission denied解决方法
- 用sqlplus myuser/mypwd出现permission denied的linux错误时解决方法
- libclntsh.so.11.1不能识别,解决办法
- shmat permission denied 的解决方法
- sh运行Permission denied解决方法
- shell脚本 Permission denied,解决方法
- jupyter notebook, permission denied 解决方法
- bash: /etc/ld.so.conf: Permission denied
- Permission denied 与 553 Permission denied 错误解决方法
- Permission denied 与 553 Permission denied 错误解决方法
- AJAX+jquery+PHP
- webservice安全性
- 系统引导前奏
- asp.net2.0操作web.config(增,删,改,查)
- C#:获取所有SQL Server的数据库名称
- sqlplus libclntsh.so.11.1 Permission denied 解决方法
- FTP设置
- 《裂变》作者爆料:欺世盗名者绝非唐骏一人
- 使用J2ME技术实现手机触摸屏开发的方法
- ASP.NET页面的CheckBoxList组件
- 更改“我的文档”文件夹的默认位置
- PVFS2源代码分析之用户系统接口src/client/sysin/sys-get-eattr.sm状态机描述
- DOS命令大全(经典收藏)
- AVI audio frame duration