Software:
Application Server:
1. Oracle Identity Management 10g (10.1.4.0.1)
Download URL http://www.oracle.com/technology/software/products/ias/htdocs/101401.html
2. Oracle Application Server 10g Release 2 (10.1.2.0.2)
Download URL
http://www.oracle.com/technology/software/products/ias/htdocs/101202.html
What is Discoverer
http://www.epa.gov/ttn/airs/airsaqs/manuals/AQSDiscManDraftChapters1-3-29May07.pdf
Enivironment:
AIX Version 5.3 - EBIZ 11i
AIX Version 5.3 - Application Server(Separate Machine)
Index
• Feasible Architectures
• Installation
• Configuration
• Connectivity to Apps DB
• Post Installation Tasks
• EUL Migration
• Discoverer clients on Windows PC
• JInitiator upgradation
Steps
• Application Unix Account
• Oracle Unix account
• 10gAS Server Installation with Discoverer Component on separate ORACLE_HOME on existing 11i environment on application tier or separate server.
• Installation of Infra metadata database (If required) on separate server
• Configuration of Portal setup (If required)
Change ownership on application user like oracle or applmgr, etc …
chown -R applmgr:dba /etc/oraInventory
Configuration
1. Establish Connectivity between Discoverer 10g and Apps Database
2. Discoverer integration with 11i through changes in XML.
3. Discoverer Profile changes in 11i to point new Discoverer 10g
Connectivity to Apps DB
• Update tnsnames.ora file to connect Oracle Apps 11i
• Enable sqlnet access
• Connectivity check through Discoverer Home
Post Installation Tasks
• Configuring Oracle 11i to use Discoverer 10g and to load Application specific content and workbooks into discoverer 10g EUL
• Latest AutoConfig patch
• AD Patch application
• ICX Patch application
EUL Migration
• Schema creation for EUL
• EUL Creation
• Database Parameter setting (Rollback segment)
• DBA setup to migrate $AU_TOP to 10gAS server
• Import Discoverer Content for release 11i
• Refresh Discoverer 10g EUL
• Check grant privileges (Responsibility, Users, Workbooks )
Discoverer clients on Windows PC
Install Internet Developer Suit 10g, this will install Admin edition
• Edit Microsoft windows registry
• FTP DBC file from 11i to D:\secure on Windows PC
• TNS Connectivity to 11i Database
• Install Discoverer Desktop
JInitiator Upgradation
• Change in config.xml on 10gAS env.
• JVM setting for JInitiator 1.3.1.24
• JInitiator upgrade on 11i env.
• Application JInitiator patches
Oracle Application Server 10g 10.1.4.0.1
Installation Screenshots
The following information is available in:
/u01/applmgr/disco10g/OraHome_10/install/setupinfo.txt
Oracle Application Server 10g 10.1.4.0.1 Usernames and Default password information:
Please refer to Oracle Application Server 10g Administrator Guide for more information.
Install Type: Identity Management and Metadata Repository
Configured Components: Oracle Application Server Metadata Repository Oracle HTTP Server Oracle Application Server Containers for J2EE Oracle Internet D
irectory Oracle Application Server Single Sign-On Oracle Application Server Delegated Administration Services Oracle Directory Integration Platform
New Database created with these properties:
Database File Location: /u01/applmgr/disco10g/oradata/
Database Global Name: bldisco.doyen-sys.com
Database SID:bldisco
Database Name:bldisco
Character Set: -characterset AL32UTF8
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://doyen.doyen-sys.com:7777
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys.com:1156
Instance Name: infra.doyen.doyen-sys.com
Oracle Application server 10g 10.1.2.0.2
Give the OID(10g Infra hostname and OID Port) hostname and port.
Provide the 10g Infra username (ias_admin) password : welcome1
Provide the below details
User Name : ias_admin
Instance name : disco
Password : welcome1
Oracle Application Server 10g 10.1.2.0.2 Usernames and Default password information:
Please refer to the Oracle Application Server 10g Administrator Guide for more information.
Install Type: All Services
Configured Components: Oracle HTTP Server, Oracle Application Server 10g Containers for J2EE, Oracle Application Server 10g Web Cache, Oracle Application Ser
ver 10g Portal, Oracle Application Server 10g Discoverer, Oracle Application Server 10g Personalization, Oracle Application Server 10g Reports Services, Orac
le Application Server 10g Forms Services,
Registered with Oracle Internet Directory: apollo:389
Use only SSL connections with this Oracle Internet Directory:No
Database Connection String: doyen.doyen-sys:1521:bldisco.doyen-sys:bldisco.doyen-sys
Use the following URL to access the Oracle HTTP Server and the Welcome Page:
http://doyen.doyen-sys:7778/
Use the following URL to access the Oracle Enterprise Manager Application Server Control:
http://doyen.doyen-sys:1810/
Instance Name: disco.doyen.doyen-sys.com
END OF INSTALLATION
1.1 Copy dbc file from 11i ebiz to 10g Discoverer Server
Oracle E-Business Suite 11.5.10 customers :
The default naming convention for the .dbc file for Oracle E-Business Suite Release 11.5.10 is .dbc.
Please copy the dbc file
$copy $FND_SECURE(11i) TO $ORACLE_HOME/discoverer/secure(10g Disco)
$cp $FND_SECURE $ORACLE_HOME/discoverer/secure
1.2 Update tnsnames.ora file
Copy $TNS_ADMIN/tnsnames.ora (11i) to ORACLE_HOME/network/admin/tnsnames.ora(Disco 10g)
dev=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=apollo.fti-intra.com)(PORT=1535))
(CONNECT_DATA=
(SID=dev)
)
)
Migrate your existing Discoverer End User Layers to Discoverer 10.1.2.
Upgrade your existing Discoverer 4i or Discoverer 9.0.4 End User Layer to Discoverer 10.1.2 by using the following command on the standalone application server where Oracle Business Intelligence Server 10g Release 2
Pre Upgrade steps
1. export ORACLE_HOME=/progs/scr/disco10g/OraHome_11
2. export TNS_ADMIN=/progs/scr/disco10g/OraHome_11/network/ADMIN
3. tnsping uat
4. export eul_us schema in 11i instance(Just backup)
Backup 11i ebiz eul_us schema
oracle doyen> exp EUL_US/EUL_US file=pre_10g_upgrade_eul_backup.dmp
Run the following command to migrate 4i disco to 10g disco
10g Disco oracle home (not infra oracle home)
bash-2.05b$ pwd
/u01/applmgr/disco10g/OraHome_11/bin
bash-2.05b$ eulapi -CONNECT EUL_US/EUL_US@uat -AUTO_UPGRADE
-connect <**********>
-auto_upgrade
Command completed.
Now try to open Discoverer viewer
End Of the Installation
If need any query, please post your comments
12 comments:
Hi..
I would like to say Thanks to you for creating such a nice infomatic blog
for apps dba's.
I am working in steria formally its xansa india in chennai...actully if u
can post some discoverer related information as well then it will be a g8
help.
Thanks and Regards
Nikhil Jain
DBA Shared Services
Steria (India) Limited
C: 838-4406
M:09953304801
Hi,
I have some issues in connecting disco 10 with EBS 11.5.10.2.
I've already installed Oracle Application Server 10g Release 2 (10.1.2.0.2) that includes Identity Management Infrastructure 10g (10.1.4.0.1) and Application Server 10g Release 2 (10.1.2.0.2) type Business Intelligence and Forms on different Homes in a single server. The EBS (11.5.10.2) also installed on the same server with different home.
While opening "http://servername:7780/discoverer/viewer"
I got the following error.
" - Unable to retrieve the Schema password for base Schema ORASSO_DS from Oracle Internet Directory Server for the repository null. Please verify that the correct Oracle Internet Directory Server parameters are specified in /d03/oracle/BI_Home/config/ias.properties. Make sure that the Oracle Internet Directory Server specified in OIDhost, OIDsslport is up and running. Base Exception : oracle.ias.repository.schema.SchemaException: Unable to retrieve Attributes for orclResourceName=ORASSO_DS,orclReferenceName=ORCL.COM,cn=IAS Infrastructure Databases, cn=IAS, cn=Products, cn=OracleContext from Oracle Internet Directory Server ldap://192.168.2.1:636/. Base Exception : javax.naming.NoPermissionException: [LDAP: error code 50 - Insufficient Access Rights]; remaining name 'orclResourceName=ORASSO_DS,orclReferenceName=ORCL.COM,cn=IAS Infrastructure Databases, cn=IAS, cn=Products, cn=OracleContext'
Unable to retrieve connection list
- The connection list could not be retrieved. See other error messages for details. "
Kindly help.
Waiting for your answer.
Hi,
Please change this schema password.
ORASSO_DS.
Alter user ORASSO_DS identified by password;
Then follow this steps.
Click this URL.
http://beginapps.blogspot.com/2008/09/changing-schema-passwords-using.html
You need to change this schema ORASSO_DS password here also.
then try.
If you any quer please let me know.
Regards,
Ramesh Mani
Hi,
Thanks for the update.
I'm not clear about changing ORASSO_DS password in OIDADMIN. I couldn't understand the screen shots and the update given along.
Can you pls update ?
Thanks in Advance.
Sundar K
acctually problem is Unable to retrieve the Schema password for base Schema ORASSO_DS. So you need to change the ORASSO_DS passoword.
First you change database level. Then change to 10g AS level, use OIDADMIN tool. IF tou need any clarification pls call me. I will let you know, How to do that.
If possible send mail me that error screen shot.
Regards,
Ramesh Mani
Hi Ramesh,
Thank you for the support.
I'm having trouble in changing orasso_ds password in OIDADMIN. Since, I'm a newbe to AS10g, I couldn't understand what is what.
I just sent you the error screenshot to ur gmail id.
Sorry for disturbing your sleep.
Regards,
Sundar K
Cause
After metadata database problems, the iAS related passwords for ORASSO, ORASSO_PS and ORASSO_DS
were locked.
Since the ORASSO, ORASSO_PS and ORASSO_DS were locked, Discoverer logins failed with error:
SOLUTIONS
To implement the solution, please execute the following steps:
1. Reset ORASSO, ORASSO_PS and ORASSO_DS passwords in Oracle database and unlock accounts.
2. Then reset passwords in OID by doing the following:
a. Use oidadmin to change the ORASSO password:
(1) Start oidadmin
(2) Go to Entry Management
(3) Go to oraclecontext/Products/IAS/IAS Infrastructure
Databases/ORASSO/orclReferenceName=your_DB_name
(4) Click on the right panel -> click on the attribute orclpasswordattribute and type in the new ORASSO password
4. Restart the SSO server
$ORACLE_HOME/opmn/bin/opmnctl restartrpoc process-type=HTTP_Server
$ORACLE_HOME/opmn/bin/opmnctl restartrpoc process-type=OC4J_SECURITY
Please find the following metalink note id: 271044.1, 427959.1
Regards,
Ramesh Mani
This was very helpful tips for a similar problem I was having.
Thank you Mr. Mani.
Regards,
Mohammed Rahman
I have been visiting various blogs for my term papers writing research. I have found your blog to be quite useful. Keep updating your blog with valuable information... Regards
New to Oracle Internet Directory, previous DBA left and changed passwords but I cannot get into cn=orcladmin - unlocked the OID DB account and reset it to the password of what should work for cn=orcladmin, but now getting a credentials error for the cn=orcladmin, how do I get around that? I'm trying to check or update the ORASSO_DS specification in the Directory, because we have a service OC4J_BI_Forms not coming up.. Thanks My email is debor19071@aol.com
hai, do anyone have "Oracle Application Server 10g Release 2 (10.1.2.0.2)" linux based software?
please i need a copy of this version!
hai, do anyone have "Oracle Application Server 10g Release 2 (10.1.2.0.2)" linux based software?
Post a Comment