ebs r12.1 使用操作系统认证问题

安装完oracle ebs以后，oracle用户的ORACLE_HOME 目录为

-bash-3.2$ env |grep ORACLE_HOME
ORACLE_HOME=/export/home2/oracle/VIS/db/tech_st/11.1.0

注意： 如何使用os认证登录

bash-3.2$ pwd
/export/home2/oracle/VIS/db/tech_st/11.1.0
-bash-3.2$ ls *.env
VIS_text.env
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jun 14 17:34:13 2012

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

ERROR:
ORA-01031: insufficient privileges

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

-bash-3.2$
-bash-3.2$ . *env
-bash-3.2$        
-bash-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jun 14 17:35:16 2012

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

 

查看当前目录下的 VIS_text.env  ，里面保存了oracle的一些实例及路径信息

 

启动应用的一些设置路径：

-bash-3.2$
-bash-3.2$ cd
-bash-3.2$
-bash-3.2$ cd VIS/
-bash-3.2$ ls
apps  db    inst
-bash-3.2$ cd apps/
-bash-3.2$ ls
apps_st  tech_st
-bash-3.2$ cd apps_st/
-bash-3.2$ ls
appl  comn
-bash-3.2$ cd appl/
-bash-3.2$ ls *env
APPSVIS_text.env  VIS_text.env
-bash-3.2$
-bash-3.2$ pwd
/export/home2/oracle/VIS/apps/apps_st/appl

-bash-3.2$ . APPSVIS_text.env
-bash-3.2$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Thu Jun 14 17:52:57 2012

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24862808/viewspace-732882/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24862808/viewspace-732882/