这篇博客介绍了如何让非Oracle用户在Linux环境下执行SQL*Plus。首先，通过`chmod`命令修改sqlplus的权限，然后设置Oracle的相关环境变量，包括ORACLE_BASE、ORACLE_HOME、ORACLE_SID、PATH和LD_LIBRARY_PATH，最后成功运行SQL*Plus。
[oracle@ser02 ~]$ which sqlplus
/u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ ll /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
-rwxr-x--x 1 oracle oinstall 7137 Oct 31 13:18 /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ chmod u+s /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ ll /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ chmod 755 /u01/app/oracle/product/10.2.0/client_x64/network/admin/
-rwsr-x--x 1 oracle oinstall 7137 Oct 31 13:18 /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ exit
logout
[root@ser02 ~]# exit
logout
[hadoop@ser02 ~]$ export ORACLE_BASE=/u01/app/oracle
[hadoop@ser02 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_x64
[hadoop@ser02 ~]$ export ORACLE_SID=
/u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ ll /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
-rwxr-x--x 1 oracle oinstall 7137 Oct 31 13:18 /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ chmod u+s /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ ll /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ chmod 755 /u01/app/oracle/product/10.2.0/client_x64/network/admin/
-rwsr-x--x 1 oracle oinstall 7137 Oct 31 13:18 /u01/app/oracle/product/10.2.0/client_x64/bin/sqlplus
[oracle@ser02 ~]$ exit
logout
[root@ser02 ~]# exit
logout
[hadoop@ser02 ~]$ export ORACLE_BASE=/u01/app/oracle
[hadoop@ser02 ~]$ export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/client_x64
[hadoop@ser02 ~]$ export ORACLE_SID=
最低0.47元/天 解锁文章
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
