ebs r12.1 使用作業系統認證問題

sxitsxit發表於2012-06-15
作業系統
安裝完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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章