|
| We are moving to "On Line Apps DBA" |
| Saturday, September 29, 2007 |
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
I think image and Heading of this post says it all.
Yes we are moving to "On Line Apps DBA . Com" and currently in migration process putting all your posts, comments and categories from blogspot to On Line Apps DBA . COM and building some really nice look and feel and pages
Why are we moving to OnLineAppsDBA.com ?
Main reason for moving to OnLineAppsDBA.com is that
-- BlogSpot is blocked in some countries and few offices in india
-- Lot of my readers complain about slow performance at BecomeAppsDBA which is on free server from blogspot.com where as Apps DBA Online . com is on paid dedicated server and we are expecting better performance
-- Our new site On Line Apps DBA is on wordpress with some really good features and easy to maintain for administrators so we thought its good idea to invest in dedicated servers On LineApps DBA will officially be launched next month (Adding some new pages and tools to make it more user friendly) but you can have a look at site at http://OnLineAppsDBA.com and send us your feedback and features you want to see on this site by writing to me at atul @ onlineappsdba.comLabels: others |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 5:29 PM
  |
|
|
|
| Oracle Internet Directory - Basics II |
| Thursday, September 20, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Few years ago, When I started learning Oracle Internet Directory I jumped directly on administration of OID (including start/stop and debugging) without understanding basics of OID. My suggestion is to go through basics first which I am going to cover in this post.
For my first post on OID visit OID from Apps DBA's eye
Need of Oracle Internet Directory ?
Use of Oracle Internet Directory (Oracle's LDAP) is much bigger and can't be explained in this post but here is few bits which you is enough for time being (to get you started on OID).
--OID is repository for enterprise users, groups data.
--Information about various applications (Portal, BI, E-Business Suite, Collaboration Suite) registered to OID (You can register E-Business Suite or Database in OID).
--Password policy for Single Sign-On Partner Applications
What are different Daemon/Server in OID ?
There are three servers/daemon in OID
---OIDLDAPD - This is the main server/daemon waiting for ldap request (ldapsearch, ldapadd, ldapmodify, ldapdelete..). When any application want to do any ldap operation(add, modify, delete, search..) on OID object (user, group, application..), that request is fulfilled by this server/daemon.
---ODISRV - also called as Oracle Directory Integration Server, this is used for integration of Various Application (Portal, BI, E-Business Suite/Apps) with OID for user/group data. If any user/group is added/deleted in Portal/BI synchronization of that user to OID is done by this Daemon (Vice Versa). If you have Integrated Apps(11i/R12) with OID/SSO then users is provisioned/de-provisioned using this daemon of OID.
---OIDREPLD - Also called as OID Replication Daemon is used if you have replicated OID. By default this daemon is disabled.
For OID Replication Overview Click Here and to know more about Multi Master Replication click here
How to Start/Stop OID ?
OID Data including status of OID Servers (OIDLAPD, ODISRV OIDREPLD) is stored in Oracle Database so in order to start OID first start Database and Database Listener. Then
To Start OID - opmnctl startproc ias-component=OID
To Stop OID - opmnctl stopproc ias-component=OID
OPMNCTL will first start OIDMON (OID Monitoring Process) and then instruct OIDCTL (OID Control) to start OIDLDAPD and ODISRV daemons.
Where to find log files related to OID ?
Logs related to OIDMON, OIDCTL, OIDLDAPD should be in $ORACLE_HOME/ldap/log directory , ODISRV related logs should be in $ORACLE_HOME/ldap/ODI/log
More on OID common tasks (including frequently used scripts) and New Features on OID 10.1.4 coming soon ...Labels: oid |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 7:44 PM
|
|
|
|
| 25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO |
| Thursday, September 13, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Check below 25 points which Apps DBA should know for Apps(11i/R12) integration with SSO/OID (Single Sign-On/Oracle Internet Directory)
1. If you change APPS password using FNDCPASS utility, update provisioning profile with new password using OIDPROVTOOL. (More on OID Scripts & Tools coming soon). This is required as APPS password is stored in provisioning profile in OID.
2. If you clone E-Business Suite Instance,
------2.1 Deregister old E-Business Suite details from target OID Instance,
------2.2 Deregister Integration details from cloned target E-Business Suite instance
------2.3 Reregister target E-Business Suite Instance to target OID and SSO instance
(More on cloning Oracle Apps instance integrated with OID/SSO coming soon)
3. Session Idle Timeout value in E-Business/Apps is set to 30 minute by default but there is NO Session Idle timeout value set on SSO (There is Global Timeout value set to 8 hours in Oracle SSO which is different from Idle Timeout). If session is Idle for more than 30 minutes in Apps/E-Business suite, users will be redirected to SSO and user can get back to Apps "without" entering username password as user session cookie is still valid on SSO Server .
For global Idle Session time out to work properly set Idle timeout value to required value in Oracle SSO server and match that with E-Business Suite Instance.
4. User with Name USER1 in FND_USERS can be linked to username USER2 in OID , so username need not to be same. Users in E-Business Suite/Apps are linked to Users in OID/SSO via GUID.
5. User mapping between OID & E-Business/Apps -> Login name in OID is identified by attribute "orclcommonnicknameattribute" which by default is "uid". To understand this better, think of user User "Atul Kumar" in OID with various attribute like first name, lastname, phonenumber, cn, sn, uid .... If for "Atul Kumar" value of attribute uid is set to "akumar" then user should use "akumar" to login.
This "akumar" (value of attribute "uid") is mapped to USER_NAME column of table FND_USER and "orclguid" attribute in OID should have same value as USER_GUID column value in FND_USER table. As mentioned in point 4, users in OID & Apps are linked via GUID and this value should be same. (More on user mapping and authentication flow with SSO coming soon )
6. Currently supported nickname attribute to be mapped to FND_USER table are "uid" and "mail"
7. If naming convention of your users in OID is different from users in E-Business/Apps (like atul.kumar in OID but kumaratul in apps/E-Business Suite) then disable profile "Applications SSO Auto Link User"
8. Not all attributes for users can be integrated/synchronized from OID to E-Business Suite or Vice Versa. For list of attributes supported currently (as of build 5) check Appendix C on Page 88 of Integration guide.
9. Updates to email ID in Oracle Internet Directory are not correctly reflected in the E-Business Suite HZ_CONTACT_POINTS in TCA unless the PERSON_PARTY_ID foreign key in the FND_USER table has been defined. Furthermore, if PERSON_PARTY_ID is changed i.e. user is linked to another person in TCA, information stored in OID can overwrite this other person’s information during provisioning.
10. As of build 5, logout from OAM (Oracle Application Manager) results in page not found, though users can logout successfully from professional forms and self service web applications.
11. Users can be provisioned from E-Business/11i/R12 (FND_USER) to OID, OID to E-Business Suite, and two way. (How to find current user provisioning direction coming soon in OID Scripts post)
12. User Provisioning from TCA (Trading Community Architecture) to OID is not yet supported (as of build 5). Provisioning of HR to OID, FND_USER to OID or from OID to FND_USER is supported.
13. If provisioning profile includes password to be provisioned from E-Business Suite/Apps to OID, password policy in E-Business Suite should be atleast as restrictive as OID else when you create user in E-Business Suite/Apps without password not not in line with password policy, you will get non descriptive error message.
14. User can login to E-Business Suite Locally (NO SSO, directly from FND_USER) or to SSO (authentication via SSO) or BOTH. Set profile option "Applications SSO Login Types" to LOCAL or BOTH at userlevel and use
http(s)://(hostname).(domainname):(port)/ OA_HTML/ AppsLocalLogin.jsp
For SSO authentication use URL
http(s)://(hostname).(domainname):(port)/oa_servlets/AppsLogin
15. It is possible to register multiple E-Buisness Suite Instance (Test, Dev, UAT) to single OID/SSO Instance. (How to find list of E-Business Suite instance registered against OID, coming soon in OID Scripts)
16. If you have OID with multiple Realm (How to find default and all available realms in OID, coming soon in OID scripts), E-Business Suite/11i/R12 can be registered against default OID realm only (As of SSO build 5).
17. It is possible to link multiple E-Business Suite accounts to single SSO account but vice versa is not possible/supported. i.e. User1 and User2 in E-Business account can be linked to user3 in OID/SSO (For more
information Check Profile Option "Applications SSO Allow Multiple Accounts" )
18. It is possible to synch User Password from E-Business Suite to OID but vice versa is not allowed. This is because passwords in E-Buisness Suite/Apps/11i/R12 are encrypted but are hashed in OID.
19. If you are palnning to implement SSO Integration with E-Business /11i/R12 in enterprise where E-Business Suite and OID are already implemented and working independently, it is possible to bulkload user from OID to E-Business(Users which are already in OID but not in E-Business Suite) or from E-Busienss to OID (Users which are already in E-Business Suite but not in OID) and map common users.
20. For bulk migrating users from E-Business Suite to OID or from OID to E-Business Suite, check AppsUserExport, LDAPUserImport, ldifmigrator, bulkload.sh utility
21. When users are imported (initial load) from OID to E-Business/Apps 11i/R12 using LDAPUserImport, all user "attributes" can't be imported.
22. If hashing method in OID is not MD5, bulkload of users to OID (initial set of users migrated from Apps/E-Business Suite) . (How to find default hasing method in OID, coming soon in OID Scripts..)
23. During initial load of users from E-Business Suite to OID (using bulkload.sh), password policy in OID is not verified . This is because E-Business Suite passwords are encrypted in dump file and bulk load tool can't check passwords.
24. Oracle Application Server (SSO/OID) & Apps/E-Business Suite database server system clocks should be in synch else users will face issue during login/logoff
25.
Leave your comments on what you think is important for Apps/11i/R12 integration with OID/SSO to fill point no. 25
Related:
Management Questions for Apps Integration with OID/SSO
More on OID/SSO Integration with authentication & user provisioning flow coming soon...
Labels: appsASintegration, integration |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 6:40 PM
|
|
|
|
| Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO |
| Saturday, September 01, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Here are few questions which you should think/ask/discuss for Oracle Applications 11i & R12 Integration with 10g Application Server (Portal, Discoverer, SSO, OID)
Do you need 10g Portal component of 10g AS with Oracle Applications 11i & R12 ?
(*Integration of 10g AS can be without portal and dicoverer as well i.e. OID & SSO only. For 10g portal Integration you must have SSO and OID)
Do you need 10g Discoverer component of 10g AS with Oracle Application 11i ?
(* You can have discoverer with or without SSO access)
Do you need SSO and OID component of 10g AS with Oracle Applications 11i / R12 ?
(*You can configure only SSO/OID for Single Sign-On access with or without Portal and Discoverer)
Do you need 10g Web Cache component of 10g AS with Oracle Applications 11i ?
(*You can configure webcache with or without Portal/OID/SSO. With Portal webcache is default)
Do you have third party access management (Netegrity SiteMinder, Oblix COREid) for Single Sign-On ?
(* You can configure 10g SSO with third party access management via Oracle SSO) Source of Authentication in Oracle Apps 11i / R12?
(* --You can configure authentication at E-Business Suite, Oracle SSO, Third party SSO or combination of above.
--Configuring authentication, local to E-Business for some users and for others SSO is also supported)
--Do you have third party LDAP directory (Microsoft Active Directory, Sun iPlanet) which you want to synch with OID and E-Business Suite ?
(* You can use third party ldap server for user store integrated with OID and then synched to E-Business Suite Users)
----- If third party LDAP Server is in place check following things for OID to third party integration (DIT, Default Realm, nickname attribute)
-----As of Integration build 5 synching users from E-Business to OID is supported with default realm only. Take special care if you have multiple realms in LDAP Server
--One SSO User account can be mapped to Multiple Users in E-Business Suite (other way is not supported), Do you need this ?
--Multiple E-Business Suite can use Single OID/SSO Instance or each E-Business Suite Instance can be registered with its own OID/SSO. For Dev & Test E-Business Suite you may be interested in registering them to single OID/SSO Instance.
--User Creation/Management/Updates : From OID to Apps, Apps to OID or bidirectional
-- Attributes to synch during ongoing Updates
* All user attribute sync can't be updated between OID & E-Business Suite. Check provisioning profile used for synch between Apps & OID
* Check if TCA tables are updated as required with User Updates in OID
-- Decide on how Users will be loaded Initially :
----From OID to E-Business (Users are already in OID but E-Business Suite is new implementation)
---- E-Business Suite to OID (Users are already in E-Business Suite but OID is new implementation)
---- In both E-Business Suite & OID (OID and E-Business both has user base but not in sync) You can reconcile user base in Apps & OID
-- E-Business Suite Home Page (Portal or Framework)
-- Is Password Policy in E-Business Suite different from Password policy in SSO ? Things like
----User should change password on first time login
----Password Strength, minimum number of characters & at least few some number
----Password will expire after n number of days
--Idle Session Time out for SSO
* By default there is no Idle Session timeout in Oracle SSO Server (There is default Global Session Time Out set at SSO with value 8 hours) but E-Business Suite is configured with Idle Session time out of 30 minutes. To set Idle Session time out value to desired value in SSO Server check http://download.oracle.com/docs/cd/B28196_01/idmanage.1014/b15988/ssoadmin.htm#i1012213
More on 10g Application Server (OID/SSO) integration with E-Business Suite coming soon..
--------User creation/update/synch flow in OID-Apps(E-Business Suite) Integrated instances and troubleshooting user creation/update issues ?
-------User login flow in OID-Apps(E-Business Suite) Integrated Instances and troubleshooting login issues ?
-------Common tasks for which Apps DBA's should take extra care in Apps/OID/SSO integrated instances (Cloning, changing apps password, patching...)Labels: appsASintegration |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:21 PM
|
|
|
|
| Oracle Apps DBA Training Institues in India |
| Tuesday, August 28, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
Looking at mails in my inbox from DBA's and freshers looking for Oracle Apps DBA training Institutes/courses, I decided to dedicate this post for Training Institutes providing Oracle Apps DBA Training.
Few things you should check before joining Training
--Formal Training is always good to quickly get an overview of product but not enough; to become good Oracle Apps DBA lot of practice & hands on experience is very important. Look for Institutes which provide lots of hands on and give enough time for practice
--Ask for previous students detail and Check with them about quality of training.
-- Check about Instructor and his/her expertise
-- For Oracle Apps DBA training; apart from basics look for at least Installation, Patching and Cloning.
**********************
Oracle University
**********************
http://education.oracle.com/ check for course "D17423GC51 11i Install, Patch, and Maintain Oracle Applications"
Institutes mentioned here are in alphabetical Order and I don't personally recommend any training Institute.
************
Bangalore
***********
Human Base India Inc.
Software Development Centre
Royal ArcadeNo.6, 4th Floor,
80 Ft RoadKoramangala, Industrial Layout
Bangalore – 560 095
Tel: 91- 80-25531221, 25532440, 25535429e-
MailFor sreeni@humanbaseindia.com
Q-Soft Systems & Solutions (P) Ltd.
#253/19, 1st & 2nd Floor,
Kanakapura Road,
Jayanagar 7th Block,
Bangalore-560082
Tel : +91 80 26639207, 26544135
Fax : +91 80 26637692
URL : http://www.qsoftindia.com/
E-Mail : shrivardhan@qsoftindia.com
************
Chennai
***********
Crest Of Technolgies
No. 64, A.R.R. Complex,
North Usman Road, T.Nagar,
Chennai - 600017.
Ph : +91 44 55634550, 55634551
URL http://www.crestsofttechnologies.com/
Ikon Infotech
II Avenue, II Floor,
Near Blue Star Signal Annanagar,
Chennai - 40
Ph : +91 44 26214127 , 42611909
Ora Solution
10th Main Road II Avenue,Annanagar,
Chennai - 600 040
Ph : +91 44 42612461 , 9841148256
***************************
Delhi/Noida/Gurgaon
***************************
Ducat India
A-52 & A-43 Sector-16,
Noida U.P : 201301, INDIA
Tell: +91-0120-4646400-430
Mob: +91-9999036441 9871055180-81
http://www.ducatindia.com/ITEDU/Coursecontent/erp/ODBA.pdf
*************
Hyderabad
************
APPWORLD
Above ICICI BANK
MIG :214 ,
ROAD NO 1 K.P.H.B COLONY
HYDERABAD
Applsys Solutions
1st Floor, Plot# 26,
Beside Lotus Lap School
HUDA Shopping Complex
Kothapet, Hyderabad-500035
Tel# +91-9949969953; +91-(40) 24050503
Email: applsys@yahoo.com
Trans Global Solutions
Near Harsha Mess,
Opp. Swarna Jayanthi Complex,
Ameerpet, Hyderabad
Vennela Technologies Pvt Ltd
24/A, 2CNandanavanam Complex
S.R. Nager
Hyderabad-500038
http://www.vennelatech.com/appsdba.php
Ph : +91-40-55982662
********
Pune
*******
Spider Systems Pvt. Ltd.
Lunkas Towers , Ganpati Chowk
Vamman Nagar, Pune
If you know any other Oracle Apps DBA training institutes kindly leave Institute details here as commentsLabels: trainings |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:57 PM
|
|
|
|
| Staging/Cloning 10g AS Prod to Test |
| Sunday, August 19, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
This is second post w.r.t. cloning Oracle 10g Application Server. For first post on overview of 10g Application Server Middle Tier cloning visit http://becomeappsdba.blogspot.com/2007/08/cloning-staging-oracle-10g-application.html
This post covers basic understanding of staging (cloning) 10g Application Server both infrastructure and middle tier.
Assumptions with this cloning
---------------------------------------------
1. You have 10g Application Server Middle Tier (Portal or BI type) and Infrastructure tier (OID, SSO, MR)
2. You have source instance (PROD) which you wish to clone to target instance (DEV/Test)
Broad Level Steps
--------------------------
A. Export Data from source Instance
1. Install Target Instance (Dev/Test) Infrastructure tier (Try to keep same OID realm as source instance prod)
2. Export User data from source OID Instance (using ldifwrite)
3. Export Group data from source OID Instance (using ldifwrite)
4. Export DAS data from source OID Instance (using ldifwrite )
5. Copy password file from source OID using ldap search command (Do this step if you want to retain similar password policy on target instance as source)
6. Export portal, portal_app, portal_public, discoverer5 and various other custom schemas from source instance
7. Export SSO data using ssomig utility from source instance
8. Export EUL (End User Layer) discoverer data from source using eulapi
B. Install Target Instance
1. Install Infrastructure tier (Keep OID realm similar to source instance)
2. Install Middle Tier
C. Clean/Clear/Delete Target Instance Data
1. Delete Users/Groups from target Instance using bulkdelete.sh (OID script)
2. Drop portal, portal_public, discoverer5 and various other schemas
D. Load data from source to target Instance
1. Load User/Groups from source to target using bulkload.sh (OID script)
2. Import SSO data using ssomig utility with option -import
3. Create portal & portal_public user using script wdbisys.sql & cruser.sql resp.
4. Create discoverer5, portal_app and various other custom schema
5. Import portal and other schema data using database IMP
6. Create any custom OC4J and deploy application from source to target instance
7. Import EUL data using eulapi
For step by step procedure on creating replica / clone of 10g Application Server Production Instance to Test Instance visit
http://download.oracle.com/docs/cd/B14099_19/core.1012/b13995/prodtest.htm#CHDHBJCH
Issue in Documentation : Oracle Document mentioned above doesn't cover discoverer5 schema import/export so if you hit any issues with discoverer import discoverer5 schema
Cloning E-Business Instance integrated with 10g AS Portal,Discoverer, OID and SSO coming soon ...
Labels: 10gAS |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 10:15 PM
|
|
|
|
| Cloning / Staging Oracle 10g Application Server |
| Friday, August 17, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
This post is useful for those who are using 10g Application Server and want to clone 10g Application Server (Portal, BI or Forms and Reports) from Production to Test or Vice Versa.
Key points for cloning 10g Application Server (as of 19 August 2007) -------------------------------------------------------------------
-You can clone middle tier installation of 10g AS (J2EE & Webcache, Portal & Wireless and BI & Forms) -You CANNOT clone ----i)Infrastructure Tier (MR & IM) ----ii)OAS Integration, BPEL Process Anaytics or BPEL process manager ----iii) Developer kit and SDK ----iv) Installation that includes workflow
There is manual method to create replica of source instance in to target instance; called as Staging source infrastructure instance to target infrastructure instance.
- Middle tier cloned instance must have different Instance Name than source instance name. - You can clone MT (Middle Tier) that is member of OracleAS Cluster or Farm but you must remove instance from OracleAS Cluster before beginning cloning operation. - Middle tier Cloning process does not configure Load Balancer. If you use one, you have to configure it manually including invalidation port
- If in source instance, webcache is member of cache cluster, then target webcahe should be manually added in to cache cluster (or delete other cache cluster member info manually if you don't wish to target cloned instance as cache cluster)
-During 10g AS middle tier cloning, source ORACLE_HOME is copied to destination ORACLE_HOME , then a set of scripts is used to update information in key configuration files of oracle application server middle tier (like hostname).
Oracle 10g AS Middle Tier cloning process --------------------------------------------------------------
i) On source instance run prepare_clone.pl (in $OH/clone/bin) (This script parses files, create archives using DCM, backs up required files, and run wireless clone assistant if wireless is enabled)
ii) Copy ORACLE_HOME to destination location
iii) On target instance run clone.pl (this step invokes OUI which repeats all actions done during source instance installation)
iv) In post clone phase, clone.pl also does following post clone steps to make target cloned instance to a working state. These are ---a) setting new ORACLE_HOME in DCM ---b) update configuration file ---c) calls chgiphost command to change hostname and IP address in cloned instance ---d) If source instance was connected to OID (Portal/BI) then add information about clone in OID v) After cloning and starting services on target instance on unix you have to run root.sh (from root user)
I hope by now its clear to you that cloning of middle tier on 10g Application Server is still not as mature as cloning Apps/E-Business Suite (11i or R12). In coming post I'll cover creating replica or staging 10g Application Server (Portal or BI) production instance to test instance so that users/groups, portal, BI, SSO and DAS data can be migrated from source instance to target instance for as close as possible copy of production instance.
Related Labels: 10gAS |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 10:02 PM
|
|
|
|
| Blogoversary : One Year Journey of becomeAppsDBA Blog |
| Friday, August 03, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
436,268 Views, 171,067 hits, 1374 Comments, 744 email subscribers and 157 posts to finish one year Journey of this blog.
One Year ago on 30 July 2006, I posted first topic on this blog with a Vision to share my experience as an Oracle Applications DBA and to help other budding DBA's/administrator who want to explore Oracle Applications (E-Business Suite, Application Server, Collaboration Suite and Oracle Identity Management).
On this occasion I want to thank few people without whom this blog would not have been such a success.
Steven Chan whose post inspired me to start this blog (I admire his dedication for Apps Community), Harmeet Kocchar (Senior Manager @ Oracle, my mentor) who gave me direction to learn Apps, Khushi (My Wife) for her support and patience, Anil Passi (Famous blogger among Apps Techno Functional consultant) for his friendly advice and innovative ideas, Fadi Hasweh for nominating me for Oracle ACE, Subba Rao, Ramnik and other members answering budding apps dba's queries at forum http://TeachMeOracle.com/forum and finally to my readers for making this blog such a Success.Labels: others |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 1:38 AM
|
|
|
|
| Oracle RAC Part IV : Install Oracle Clusterware and Cluster Database |
| Sunday, July 22, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
This is fourth and last post for installing Oracle RAC Database on single machine using VMWare virtual machines. For previous posts visit
Are you scared of Oracle RAC Database
Install Oracle RAC Database I
Install Oracle RAC Database Part II
Install Oracle RAC Database Part III
In this part we will install oracle clusterware and rac database
Copy Oracle RAC and Oracle Database Software to RAC1
Create a directory software in $HOME and copy clusterware and database zip files downloaded
unzip 10201_clusterware_linux32.zip
unzip 10201_database_linux32.zip
This will create directory clusterware (for clusterware software) and database (for database software) Verify all prereq. for clusterware installation
------------------------------------------------------------
cd /home/oracle/softwar/clusterware/cluvfy
Make sure
--Second Machine/Node RAC2 is up
-- You have configured and changes hostname and network IP of RAC2
-- RAC1 can ping RAC2 and vice versa
-- User equivalency is set for user oracle on RAC1 and RAC2
-- You can connect to rac2 from rac1 as user oracle without prompting password and vice versa
./runcluvfy.sh stage –pre crsinst –n rac1,rac2
Make sure Node reachable and User Equivalency is met, rest other checks (related memory) can be ignored
Once RAC1 and RAC2 can ping each other and oracle user can connect to other machine's oracle user without prompting password then start clusterware installation from user oracle.
Change directory to location where you have unzipped clusterware software and start clusterware installation by running runInstaller
./runInstaller
Ignore memory related prereq.
Add second node rac2 by clicking on Add link
Change subnet as per your network configuration as you did while configuring network card.
 Make one public and another private (Private interconnect for clusterware)  Specify ocr location like /apps/oracle/oradata/ocr (or as per your naming convention)
Specify voting disk location like /apps/oracle/oradata/votingdisk (or as per your naming convention)
Click on Install to install clusterware. After clusterware installation, Install Database
Install RAC Database
Go to location where you unzipped database disks ./runInstaller –ignoreSysPrereqs (this is required as our memory is less (below 900MB) required, if your machine spec is higher you can ignore using ignoreSysPrereqs)
 Specify database oracle_home (make this different from clusterware oracle_home installed in previous step)
    Enter database name of your choice Select ASM
 Ignore any warnings and click on OK Define location of ASM as / dev/raw/raw3 and make redundancy as externalClick on Install Why number of voting disks should always be odd number only ? How to troubleshoot RAC database and clusterware issue ? .. Coming in future posts
Labels: database, RAC |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:33 PM
|
|
|
|
| Orcale RAC Part III - Clone RAC1 to RAC2 and User Equivalency |
| Sunday, July 15, 2007 |
|
|
We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
This is fourth post on step by step building Oracle RAC Database on your desktop / laptop using VMWare (Virtual Machine)
For previous three posts visit
Try installing Orcale RAC on your laptop
RAC Part I - Install Virtual Machine and Linux
RAC Part II - Install Virtual Disk and Network Card
In this post you will
--Clone RAC1 to RAC2 and change IP address of RAc2
--Configure User equivalency for Orale Clusterware installation
Clone RAC1 to RAC2
-------------------------------
- Make sure virtual linux machine is shutdown
-Copy folder rac1 to folder rac2 in c:\Atul\VMWARE (This is on windows laptop/machine)
--In both RAC1 and RAC2 folder open “Red Hat Enterprise Linux 3.vmx” (This is virtual machine configuration file) using notepad or wordpad
--Add following lines (This will avoid locking for shared files and two linux machines RAC1 and RAC2 can start together using shared files votingdisk, crs and asm)
disk.locking = "FALSE"
diskLib.dataCacheMaxSize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
--Now on vmx file of RAC2 “Red Hat Enterprise Linux 3.vmx” change following lines from displayName = "RAC1" to displayName = "RAC2"
--On VMWare Server Console, Click on File and Open or “Ctrl + O”
--Click on Browse and select “red hat enterprise linux 3.vmx” from RAC2 directory
--Now you should see two linux machines RAC1 and RAC2 on VMWare Console
Start RAC1 and RAC2 and when you get below warning on RAC2, select create and click OK
Make sure you can start both machine at same time, if you get message like unable to lock files, check you have added following lines in both machines vmx files mentioned above (regarding disk locking)
Change Network Settings (IP) on RAC2
-------------------------------------------------
Login as ROOT user in RAC2 machine and click System Setting -> Network
Select eth0 and click on Edit
Change Address from 192.168.1.101 to 192.168.1.102
Click on Hardware Device Tab and Click on Probe button
--Repeat steps for second network card eth1 and change its IP from 192.168.0.101 to 192.168.0.102
Make sure you clicked probe on eth1 as well as shown above
Activate both network cards by clicking on Activate as shown below
 If you get error message that eth0 has different MAC address expected as shown below; make sure you have clicked on probe on “Bind to Mac Address” on “Hardware Device” mentioned above.
 Make sure both network cards are active now, as shown below Add following entry in /etc/hosts file of both RAC1 and RAC2 ####
127.0.0.1 loalhost.localdomain localhost
192.168.1.102 rac2.focusthread.com rac2 rac2-vip.focusthread.com rac2-vip
192.168.0.102 rac2-priv.focusthread.com rac2-priv
192.168.1.101 rac1.focusthread.com rac1 rac1-vip.focusthread.com rac1-vip
192.168.0.101 rac1-priv.focusthread.com rac1-priv
###
Now trying to ping RAC2 machine from RAC1 and RAC1 machine from RAC2  Change Host Name of newly cloned RAC2 ------------------------------------------------- Follow below step on how to change hostname on RAC2 (newly cloned) Linux machine Open file /etc/sysconfig/network and edit line like : HOSTNAME=XXXXX i.e. from HOSTNAME rac1.focusthread.com To HOSTNAME rac2.focusthread.com
Configure User Equivalency
-----------------------------------
User equivalency for user oracle is required so that user oracle from RAC1 can communicate to user oracle on RAC2 machine without prompting for password for clusterware to work properly.
--Login as user oracle in machine RAC1
--Make sure sshd daemon is running (pgrep sshd), If not start it from root user like “service start sshd” --Create RSA and DSA key on each node -From oracle user go to user home directory by “cd $HOME” or type cd and press enter
-mkdir .ssh (note that there is dot before ssh which means this is hidden directory)
-chmod 700 .ssh
-ssh-keygen –t rsa
-ssh-keygen –t dsa
press enter when prompted for file to save the key and passphrase (check screenshot for more information)
“Repeat this on both the nodes i.e. RAC1 and RAC2”
Add keys to authorized key file (authorized_keys) ------------------------------------------------------------
-cd .ssh -touch authorized_keys
-ls (You should see authorized_keys, id_dsa, id_dsa.pub, id_rsa, id_rsa.pub. Here pub files are dsa and rsa public key file and id_dsa and id_rsa are private key files)
ssh rac1 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac1 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_rsa.pub >> authorized_keys
ssh rac2 cat /home/oracle/.ssh/id_dsa.pub >> authorized_keys Send authorized_keys from RAC1 to RAC2
scp authorized_keys rac2:/home/oracle/.ssh
From RAC1 machine as user oracle
exec /usr/bin/ssh-agent $SHELL
/usr/bin/ssh-add
 Test User Equivalency ( User oracle can login to other machine without password prompt) ---------------------------- ssh rac1 date ssh rac2 date
Test this from both nodes RAC1 and RAC2 (You should not be prompted for oracle user password)
For more information on User Equivalency visit chapter 2 (Page 51 to 53) of clusterware and rac installation guide
Coming Next :
Installing clusterware on RAC1 and RAC2 Installing RAC database on RAC1 and RAC2 linux machines using ASM Labels: database, RAC |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
|
del.icio.us
¦
Digg This
¦
My Yahoo
¦
Reddit
¦
BlinkList
¦
Furl It
¦
Email This
¦
Leave Your Comments
|
| posted by Atul Kumar @ 9:42 AM
|
|
|
|
|
|
