|
| Changing the ODS schema password in OAS !!!!! |
| Monday, September 7, 2009 |
OID Database Schema Owner
The Oracle Internet Directory runs on an Oracle database and creates two database users: ODS and ODSCOMMON. ODS is the schema owner that contains all of the database objects (tables, views, objects, etc.) used for OID functionality and directory storage. When the OID needs to login to the database, it uses the ODS database account which has a default password of ODS. You should secure this database user account before putting the LDAP directory into production.
1. Change the ODS password to the desired value, and create the new wallet:
oidpasswd connect= change_oiddb_pwd=true
oidpasswd connect= create_wallet=true
2. Restart OID:
opmnctl stopproc process-type=OID
opmnctl status
opmnctl startproc process-type=OID
3. Change the password in Enterprise Manager:
1. Login to EM
2. Click Targets tab > Click All Targets tab
3. Find the Name reported in the emagent.trc file (e.g., 10_1_2_portoidd.libby.oracle.com_LDAP) > click on it
4. Click Monitoring Configuration at the bottom right
5. Enter:
Username = ods
Password =
Using the OID Database Password Utility
The DBA can change this password by using the OID Database Password Utility (included with the OID installation). The following example uses this utility to change the database password for ODS:
# $ORACLE_HOME/bin/oidpasswd
current password: ods
new password: new_secret_password
confirm password: new_secret_password
password set.
How oidpasswd Works
The oidpasswd utility connects as the ODSCOMMON user and uses the role ODS_SERVER with the original password to perform the following:
1. Changes the password for the ODS user for the OID schema database.
2. Updates the SYSTEM.ODSINSTANCES table with the new, encrypted password for ODS.
3. Changes the password for the ODS_SERVER role to the new password.
4. Updates the $ORACLE_HOME/ldap/admin/oidpwdr file with the encrypted password.
NOTE: Some Oracle OID patches and scripts may assume the user ODS/ODS. It is advised to change the password for ODS back to its default of ODS during application of patches or when running OID scripts.
But what about ODSCOMMON?
When connecting to the database schema, the OID executables, such as oidctl or oidldapd servers connect as the database user ODSCOMMON. The password for ODSCOMMON is ODSCOMMON, and that password cannot be changed. It is hardcoded in the executables and changing it on the database level will cause an ORA-01017 error. There is no security risk, however, not being able to change the ODSCOMMON password, as it has only CONNECT privilege. Once connected as ODSCOMMON, the executable will obtain the privileges it needs via the role ODS_SERVER, which is protected by the ODS password. The password is obtained by the executable from the SYSTEM.ODSINSTANCES table. This is the password encrypted and set by the oidpasswd utility.
Reference :
Note 316177.1 |
posted by Jaswinder Singh @ 7:52 PM   |
|
|
|
| Find Component Version In Oracle Application Server !!!!!!!!!!!!!! |
| Friday, September 4, 2009 |
Q1. To check the database version?
A. Logon to SQLPLUS as sysdba :
SQL> SELECT * FROM v$version;
BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
PL/SQL Release 9.2.0.7.0 - Production
CORE 9.2.0.7.0 Production
TNS for Linux: Version 9.2.0.7.0 - Production
NLSRTL Version 9.2.0.7.0 - Production
Q2. Check the installed component of Oracle Application Server and their Versions.
A. Logon to SQLPLUS as sysdba
SQL> SELECT COMP_NAME,VERSION,STATUS,SCHEMA FROM dba_registry;
COMP_NAME VERSION STATUS SCHEMA
------------------------------ ------------------------------ ----------- ------------------------------
Oracle9i Catalog Views 9.2.0.7.0 VALID SYS
Oracle9i Packages and Types 9.2.0.7.0 VALID SYS
Oracle Workspace Manager 9.2.0.1.0 VALID WMSYS
JServer JAVA Virtual Machine 9.2.0.7.0 VALID SYS
Oracle XDK for Java 9.2.0.9.0 VALID SYS
Oracle9i Java Packages 9.2.0.7.0 VALID SYS
Oracle interMedia 9.2.0.7.0 VALID SYS
Spatial 9.2.0.7.0 VALID MDSYS
Oracle Text 9.2.0.7.0 VALID SYS
Oracle XML Database 9.2.0.7.0 VALID XDB
Oracle Data Mining 9.2.0.7.0 VALID ODM
COMP_NAME VERSION STATUS SCHEMA
------------------------------ ------------------------------ ----------- ------------------------------
OLAP Analytic Workspace 9.2.0.7.0 UPGRADED SYS
Oracle OLAP API 9.2.0.7.0 UPGRADED SYS
OLAP Catalog 9.2.0.7.0 VALID OLAPSYS
14 rows selected.
Q3. How to checkthe Oracle Application Server Version?
A. Login to Mid Tier OS user and check the following :
[mid@oas04 install ~]$ cat $ORACLE_HOME/config/ias.properties | grep Version
Version=9.0.4.2.0
=> also login to database and check the mid tier components:
SQL> select * from ias_versions;
COMPONENT_NAME ID VERSION
-------------------------------------------------- ------------------------------ ------------------------------------------------------------------------------------------
Metadata Repository Container mrc 9.0.4.0.0
Oracle Ultrasearch ultrasearch 9.0.4
Oracle9i workflow workflow 2.6.3
Oracle9iAS Discoverer discoverer 5.1.0.0.0
Oracle9iAS Independent Platform ip 9.0.4.0.0
Oracle9iAS Internet Directory oid OID 9.0.4.0.0
Oracle9iAS Portal portal 9.0.4.3.0
Oracle9iAS Single Sign-On sso 9.0.4.0.99
Oracle9iAS Syndication Server syndication 9.0.4
Oracle9iAS UDDI uddi 9.0.4
Oracle9iAS Wireless wireless 9.0.4.2.0
11 rows selected.
Q4. How to find the Oracle Portal Version?
A. Login to SQLPLUS as portal user or as sysdba:
SQL> select version from portal.wwc_version$;
VERSION
------------------------------------------------------------------------------------------
9.0.4.3.0
Q5. How to detemine the Oracle Single Sign On Version?
A. Login to SQLPLUS as sysdba and check the following query:
SQL> select version from orasso.wwc_version$;
VERSION
------------------------------------------------------------------------------------------
9.0.4.3.0
Q6. To check the Oracle Internet Directory Version?
A. Login to Infra Tier OS user:
[infra@oas04 install]$ $ORACLE_HOME/bin/oidldapd -version
oidldapd: Release 9.0.4.3.0 - Production on Thu Sep 3 21:50:32 2009
(c) Copyright 2001 Oracle Corporation. All rights reserved.
=> At database level :
SQL> select attrval from ods.ds_attrstore where entryid = 1 and attrname = 'orcldirectoryversion';
ATTRVAL
----------------------------------------
OID 9.0.4.3.0
Q7. How do know the Ports?
A. Check the following to know the ports:
[infra@oas04 install]cat $ORACLE_HOME/install/portlist.ini |
| posted by Jaswinder Singh @ 5:15 AM |
|
|
|
|
|
