操作系统认证登录Oracle

按照视频学习一步步来，出现的错误

sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

SQL> show parameter auth

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
os_authent_prefix                    string      ops$
remote_os_authent                    boolean     FALSE
SQL> create user ops$bbker2009 identified externally
  2  default tablespace mytbs;     

User created.

SQL> grant create session to ops$bbker2009;

Grant succeeded.

 

[root@Oracle9iDemo ~]# su - bbker2009
[bbker2009@Oracle9iDemo ~]$ export ORACLE_SID=pitts     #换成我的正在运行的DB wade也不行
[bbker2009@Oracle9iDemo ~]$ export ORACLE_HOME=/u01/oracle
[bbker2009@Oracle9iDemo ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[bbker2009@Oracle9iDemo ~]$ sqlplus /
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

网上有人的建议：chmod -R a+rX $ORACLE_HOME

[oracle@Oracle9iDemo ~]$ chmod -R a+rX $ORACLE_HOME
chmod: changing permissions of `/u01/oracle/bin/extjob': Operation not permitted
chmod: changing permissions of `/u01/oracle/bin/nmb': Operation not permitted
chmod: changing permissions of `/u01/oracle/bin/oradism': Operation not permitted
chmod: changing permissions of `/u01/oracle/bin/nmo': Operation not permitted

还有的说是要装两个包才行，我发现其实我已经装过了，重新登录导入环境变量登入sqlplus可是不行：

[root@Oracle9iDemo ~]# rpm -vih libaio-0.3.105-2.i386.rpm
warning: libaio-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID 443e1821
Preparing...                                                            (########################################### [100%]
        package libaio-0.3.105-2 is already installed
[root@Oracle9iDemo ~]# rpm -ivh libaio-devel-0.3.105-2.i386.rpm
warning: libaio-devel-0.3.105-2.i386.rpm: V3 DSA signature: NOKEY, key ID 443e1821
Preparing...                                                            (########################################### [100%]
        package libaio-devel-0.3.105-2 is already installed

 

没办法只有按照教材上说的来了，环境变量我也不导入了，直接敲sqlplus /, 直接就登陆了，原因是什么，有待进一步学习。。。

[bbker2009@Oracle9iDemo ~]$ sqlplus /

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Dec 14 21:50:27 2009

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

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> show user
USER is "OPS$BBKER2009" 

[bbker2009@Oracle9iDemo ~]$ id
uid=502(bbker2009) gid=503(bbker2009) groups=503(bbker2009)

教材：

 Username for operating system authentication
The OS_AUTHENT_PREFIX initializationparameter is used to specify the format of the
usernames for operating system authentication. This value defaults to OPS$ to make it
backward compatible with earlier releases of the Oracle server. To set the prefix to a NULL
value, specify this initialization parameter as:
OS_AUTHENT_PREFIX = ““
The example in the slide shows how a user, aaron, is defined in the database. This
specifies that the operating system user aaron will be allowed access to the database
without being validated by the Oracle server. Thus, to use SQL*Plus to log on to the
system, the UNIX user aaron must enter the following command from the operating
system:
$ sqlplus /