Atul Kumar

 You have applications (E-Business Suite 11i/R12, Portal, Discoverer, BI Publisher) integrated with Oracle Single sign-On (SSO) and users complain that they receive message ”Your Account is Locked“. Here are few things which can help you in understanding this

-

First thing to do in case “User account is locked”
You should know how to unlock SSO account.  These are various ways using which you can unlock account
1. Using OIDDAS : OIADDAS (Delegated Administrative Services) Login as superuser orcladmin (or Account with access to unlock/Change Password) >> select Directory Tab >> enter User Name >> Select Unlock Account
 

2. Using ODM : Oracle Directory Manager is java based tool to manage users . More can be found here . Go to User’s entry and on right pane reset user password. (Resetting password will unlock account)
 

3. Using ldapmodify : add attribute “orclpwdaccountunlock” to user account and set its value to 1 usign ldapmodify.
 

4. Using Portal: If you are using Oracle Portal with SSO, then reset password using Portal User Account portlet (Resetting password will unlock account)

-

Where are account locking rules defined
Next thing to identify is that where account lock rules defined
– Account lock rules are defined in Password Policy in OID (Did you know that you can use different password policy at leaf level in OID from 10.1.4.1 OID)
– To check your password policy, login to OIDADMINusing orcladmin and go to
Password Policy Management -> Password Policy for Realm ..<Your Realm Name>.. >> click on Account Lockout tab on right pan

- User Account can be locked only if “Global Lockout” is enabled and user try wrong password for number of times defined in “Password Maximum Failure” within “Password Failure Count Internal”
To understand it, lets assume
A) If ”Password Maximum Failure” set to 10 and “Password Failure Count Internal” set to 0, then 10 consecutive wrong password will lock user account.

B) If “Password Maximum Failure” set to 10 and “Password Failure Count Internal” set to 20 then 10 consecutive wrong password within 20 seconds will lock user account.

- Another reason for account lock is “Password Expiry Time” defined in Password Policy. User Account can lock after password expiry time.

Note *

Account will remain locked for time specified by “Global Lockout Duration” (default is 86400 Sec i.e. 1 day) unless unlocked by Admin.

-

How to prevent Administrative Accounts getting locked

You can create another password policy (possible only from OID 10.1.4 and higher) with “No Global Lockout” and attach new password policy to administrative accounts.

-
Finally if your superuser “orcladmin” itself is locked
A) If super user account like “orcladmin” is locked you can unlock it like
oidpasswd [connect=<OID schema database connect string>] unlock_su_acct=true

P.S. There are two orcladmin account one cn=orcladmin and other cn=orcladmin,cn=users, dc= <your domain>  (oidpasswd is required to reset password for cn=orcladmin)
B) If ods schema password (this schema holds OID data) is locked then you can unlock this using
SQL> alter user ods account unlock;

C) If for some reason you forgot ods(default password is same as orcladmin or ias_admin) password then you can reset it using metalink note # 472752.1 How to Unlock/Reset Super User cn=orcladmin When the ODS’s Password Has Been Forgotten ?

-

How to track Failed Login Attempts

If you are are getting too many accounts locked and you would like to know if these are from users or some one else (hacker) 
1. You can track failed login attempts from ias console

Login to iAS Console of SSO server like http://hostname:<em_port>/emd (ias_admin/<passwd>)
Click on “Single Sign-On:orasso”

Check failed logins under “Login Failures During The Last 24 Hours”
2. Use below query to list failed Login attempts in last 7 days including client IP address on your Single Sign-On Server

select USER_NAME||’ - ‘||MESSAGE||’ - ‘||to_char(LOG_DATE,’dd.mm.yyyy hh24:mi:ss’)||’ - ‘||IP_ADDRESS “Login Failures”
from ORASSO.WWSSO_AUDIT_LOG_TABLE$
where log_date > (sysdate - 7)
and MESSAGE = ‘Login failed’
order by log_date;

- 

Related

Password Policy in OID/SSO 
275104.1 - How To Unlock User Accounts in Portal
251354.1 -OID Superuser Password Locked: How to Unlock the orcladmin Password
204900.1 -What oidpasswd Utility Does and the Objects it Modifies (ODS and ODSCOMMON)
472752.1 -How to Unlock/Reset Super User cn=orcladmin When the ODS’s Password Has Been Forgotten ?

1. Session Timeout for Oracle Single Sign-On Server
2. SSO : How to deal with “Your Account is Locked”
3. Integrate Oracle SSO with third party SSO Server
4. Configure SSO authentication Schemes in Apex

Share This

On one of Oracle Applications 11i cloned instance, OAM (Oracle Application Manager) was showing  ”Application System Name” as source Instance.

like http://<url>/oa_servlets/weboam/oam/oamApps$target=source

1. My first thought was to look at FND_NODES to see if any node entry still pointing to source instance. All records in this table were pointing to target instance.

If FND_NODES contain entry to source instance, I could have cleaned it using below methods
a)Login to sqlplus as user APPS
b) EXEC FND_CONC_CLONE.SETUP_CLEAN;  (This procedure will delete all nodes from FND_NODES and related data in other tables)
c)Repopulate FND_NODES by running Autoconfig on all middle tier nodes (CM, Web Forms)

2. Next obvious thought was to look at profile option at Server, Responsibility level (During cloning only site level profile options are updated to target instance).

SQL> select PO.PROFILE_OPTION_NAME,PV.PROFILE_OPTION_VALUE, PV.LEVEL_ID
from fnd_profile_option_values pv, fnd_profile_options po
where upper(PROFILE_OPTION_VALUE) like ‘%&enter_source_in_UPPERCASE%’
and pv.PROFILE_OPTION_ID=po.PROFILE_OPTION_ID;

In above query level_id represents following level
10001 - SITE
10002 - APP
10003 - RESP
10004 - USER
10005 - SERVER
10006 - ORG
10007 - ServerResponsibility

No profile option was pointing to source instance (I already changed workflow related profile options mentioned in post clone steps)

3. Googled to check if others encountered similar issue and I got one hit here but solution was to clone again and I wasn’t convinced

4. Next Step was to identify table and column name from where OAM (Oracle Application Manager) was populating “Application System Name” in Applications Dashboard & Site Map

SELECT table_name, column_name
FROM all_tab_columns
–WHERE column_name LIKE ‘%’

After some permutations & combinations I reached to below query

SELECT table_name, column_name
FROM all_tab_columns
WHERE column_name LIKE ‘APPLICATION%SYSTEM%NAME%’;

and output was

TABLE_NAME                     COLUMN_NAME
—————————— ——————————
AD_APPL_TOPS                   APPLICATIONS_SYSTEM_NAME
FND_PRODUCT_GROUPS             APPLICATIONS_SYSTEM_NAME
BIN$TQikJhLucVHgRAADuqIcxA==%content APPLICATIONS_SYSTEM_NAME

My immediate focus was on table AD_APPL_TOPS & FND_PRODUCT_GROUPS
Checked and found that APPLICATIONS_SYSTEM_NAME in FND_PRODUCT_GROUPS was pointing to source instance where as it should be same as SID.

Fix was simply to update table FND_PRODUCT_GROUPS like

Backup existing table as
SQL>create table FND_PRODUCT_GROUPS_BAK as select * from FND_PRODUCT_GROUPS;

Update table with target name
SQL> update FND_PRODUCT_GROUPS
set APPLICATIONS_SYSTEM_NAME = ‘<NEW DATABASE NAME>’ ;
commit;
5. Final hard thing to find was which step in cloning update this table so I started digging cloning log file.

- At one step cloning runs Autoconfig on target instance which runs script

$OAD_TOP/admin/install/$CONTEXT_NAME/adadmprf.sh  (This script set profiles in database) and calls adadmprf.sql

This script does same as we did above and for some reason it failed during Autocnfig phase of Rapid Clone

REMREM Update FND_PRODUCT_GROUPS, if needed  

REM

declare  statement varchar2(200);  

  l_new_asn varchar2(30);  

begin  

  if :fpg_has_column = 'TRUE' then  

    l_new_asn := :new_apps_system_name;

    statement := 'update fnd_product_groups '||     

       'set applications_system_name = :new_asn '||  

      'where product_group_id = 1';

    execute immediate statement    using l_new_asn;  

  end if;  

-- end if applications_system_name column

exists in fnd_product_groups  

end;  

/

6. Finally to ensure that every thing is correct I executed $OAD_TOP/admin/install/$CONTEXT_NAME/adadmprf.sh again,

Bounced Apache and Application System Name pointing to target insatnce this time.

Related
230672.1 Cloning Oracle Applications Release 11i with Rapid Clone
165195.1Using AutoConfig to Manage System Configurations with Oracle Applications 11i
564112.1 A Number of Managers Show the Wrong Node Post Clone
213339.1 Adpatch Fails : ‘The Applications System names per the APPL_TOP and the database are different’

1. Cloning : Difference in Oracle 11i and R12/12i
2. Oracle Apps DBA Preparation Cloning 11i
3. Oracle Apps 11i Cloning part II
4. Clone Apps 11i Instance
5. Cloning : OAM System Name pointing to Source Instance

Share This

If you wish to connect to a machine by hostname (which is not registered in DNS (Domain Name Server)) you need to add <IP> <Fully Qualified Hostname> <Hostname> in Hosts file.
   Adding an entry in Non Vista (Microsoft O.S. XP, 2000, NT) is pretty simple. Open hosts file (using text editor like notepad, wordpad..) and hostname entry in above format like

192.168.0.1  myMachine.myDomain  myMachine

• Location of hosts file in windows is C:\Windows\System32\drivers\etc  (where C is drive in which you installed operating system)
• Location of hosts file in Unix/Linux is /etc

Change hosts file in Windows Vista

If your O.S. is windows vista, it won’t let you save your hosts file if you don’t open file editor (like notepad) with Administrator Privileges

• Click Start -> All Programs -> Accessories
• Right click Notepad and select “Run as Administrator“
• On Notepad click on File -> Open
• Browse to “C:\Windows\System32\Drivers\etc“
• Change the file filter drop down box from “Text Documents (*.txt)” to “All Files (*.*)“
• Select file hosts and click on Open
• Add entry of host which you wish to connect in format
  <IP Address> <Machine Name> <Machine Alias>  like
  192.168.1.1    myMachine.myDomainName  myMachine

Note : If you can’t find Accessories under All Programs then to identify Program (Notepad) type notepad in Start Search box after clicking on Start menu at bottom left of your laptop

* Ensure you don’t savefile as type text (hosts.txt),  file name should be just hosts

1. Linux Common Queries
2. IPTABLES : Linux based firewall
3. Change “hosts” file in Windows Vista

Share This

Oracle Content Server provide Repository and Core Services required for Oracle Universal Content Management (UCM, Content Management product from Stellent)

This post covers key points for Content Server Installation and documentation related to Content Server and UCM

-

-
Installation Requirement

Apart from operating system you need following software to install content server

1) JVM 1.5 (This comes by default with content server or you can use JVM of your choice)
2) Web Server - Sun Web Server (6.1 or Higher) or Apache (2.0.55 and Higher or 2.2.x) or IBM HTTP Server (2.0.42 or higher) or Oracle HTTP Server (1013 or higher built on Apache2)
3) Database - MS SQL Server (2000, 2005) or Oracle Database (10g R1 & R2 or 9.2.X) or IBM DB2 (8.1, 8.2) or Sybase (ASE 15)  )

Things to note

1. Usually Web Server and content server are on same machine but they can be on different machine (for extra security)
* Site Studio is not compatible in setup where Web Server and Content Server are on different server

2. Identify where you wish to store Native file repository (Vault) and web-viewable file repository (Web Layout)  -  more on Vault & Web Layout coming soon ..

3.You can configure database for Content Server during content server installation (automatically) or can configure later manually using scripts at  /UCM/ContentServer/database/<db_name>

4. You can configure web server for Content Server during content server installation (automatically) or can configure later manually.

5. Software for content server is in directory UCM/ContentServer/[operating_system]like for linux its in UCM/ContentServer/linux  (where UCM is directory created by unzipping Content Server Software)

6. To start installation run ./setup.sh from above directory

7.Security filter is used to restrict access to content server, only IP listed in security filter can access content server. Multiple IP’s can be added to Security Filter during installation and can be modified later.

* Security Filter does not restrict access to Content Server via browser, it only restrict access for technologies like Report Parser, Content Integration Suite …..

8. If Web Server and Content Server are on different machine then IP address of Machine hosting web server should be in Security Filter list

9. If there are multiple content server then assign different URL prefix for each content Server.

Related

1. Oracle Universal Content Management Architecture
2. Oracle Content Server (UCM) installation overview

Share This

           Hi Friends, I want to start posting Unix/Linux Administration concepts, as we are gettting lot of requests in the Forum. Since most of the Oracle Databases runs on Unix/Linux Platforms, as an Oracle DBA we need to have some Unix/Linux Knowledge, which we can not entirely depend on Unix/Linux Administrators. Here in coming posts, i will cover the basic concepts of Unix/Linux Administration, which compares each concept/commands in all Unix(HP-UX,Sun Solaris, IBM AIX) and Linux Distributions.

For an Overview, here I am listing out the Concepts, which i want to cover

(1) Introduction/Sysadmin Basics

(2) System startup and Shutdown

(3) User Management

(4) File System and Disk Management

(5) Processes

(6) Kernel Configuration

(7) Printer Configuration

(8) Job Scheduling

(9) Packages and Patches Management

(10) Networking

(11) Network File System(NFs)

(12) Backup and Recovery

(13) Pefromance Monitoring

Share This

We are back with the bang !!! After receiving great response and readers demand we are announcing Oracle Apps DBA online training from 17th May-08. Course contents for the training

Oracle Apps DBA Training

Day 1
-Oracle Applications Background
Oracle Applications E-business Suite Current,Logical, physical and functional components
-Operating System Configuration
E-Business Suite specific configuration of Oracle Enterprise Linux
-Release 11i Installation
Hands-on installation of E-Business Suite 11.5.10
-Walk-Through
Walk through of the structure of the installed Oracle Application.

Day 2
-Release 11i Patching
Details of Oracle Application Patching. Explaining Adpatch utilities.
- Release 11i Patching Lab
How to apply Patch ? Practical session.
- Patch Troubleshooting Tips
How to rectify the issues while patching ?

Day 3
-Release 11i AD Utilities
Details of various Ad utilities which can make DBA life easier.
- Release 11i AD Utilities Lab
Actually using and performing hands-on of Utilities.

Day 4
- Release 11i Autoconfig
Details of Autoconfig. What exactly happens while running autoconfig
- Release 11i Autoconfig Lab
Running Autoconfig on the existing Oracle Application.

Day 5
-Release 11i Cloning
Task which Apps DBA perform very frequently. Details and in depth understanding of Rapid Clone utility and process.
- Release 11i Cloning Lab
Actually Performing Cloning operation for the existing Oracle Application

Day 6

-Basics of Concurrent Manager 

-Troubleshooting Concurrent Manager

- Miscellaneous Utilities and Concepts
OATM, Shared APPL_TOP, Some downtime reducing Techniques.
-Questions

Other benefits
- Remote unix access to server to practice at your leisure for two months (with prior appointment)
- Support for next two months for technical issues

Some FAQ’s:

How will the training work?
Instructor will explain and demo Oracle 11i Apps tutorials over a web conferencing software.
You will be given a VPN Connection, to connect to Oracle Apps instance and can practice at your leisure.

How about Audio?
You will listen to the instructor using Skype Software.

What will you learn in this training course?
Everything that you need to know about oracle 11i Apps as DBA. This course will cover day to day task performed by Apps DBA’s like patching/cloning.

How much of the class will be practical?

Trainer will be conducting all sessions practically which you can see remotely at your place & will connect to you through skype, where you can discuss each & every thing with him at the time of session itself

Will R12 features be covered in training?

Though the main focus will be on 11i but trainer will mention new features/differences of R12 as the topic goes on.

What is the schedule for training?
Training is scheduled for 17h,18th ,24th,25th,30th May & 1st June 2008 . We’ll provide support for next 2 months for any issues, doubts.

What will be the timings of training?

Indian Standard Time (IST)- 5:30 pm

Eastern Standard Time (EST) -8:00 am
Greenwich Mean Time ( GMT)- 12:00 pm

What is the availability of seats?
To keep quality of training to be optimal, we are restricting the capacity to 5 Learners only.

What is the cost of the training course?
625 $ (Six twenty five US Dollars) for entire course including support for next two months.

How do I get enrolled for the training?

Interested users can send email at training @ onlineappsdba.com to get bank details.

For any queries mail us at training @ onlineappsdba.com

Share This

Oracle SOA Suite 11g technical preview 4 is now available

• SOA Suite 11g Tech. Preview 4 is part of Jdeveloper 11g Tech Preview 4 which can be downloaded from here  
• Product documentation is available via Patch 7009059
• BAM (Business Activity Monitoring) and B2B (Business 2 Business) are available via Patch 7009057

Related
New Fatures in SOA Suite 11g Tech Preview 4 

1. Install Oracle SOA Suite : 10.1.3.1.0
2. Upgrade Oracle Database to 10.2.0.2 : SOA Suite Install Part II
3. Oracle SOA Suite Installation Part I : Database Installation
4. Upgrade SOA / OAS to 10.1.3.3.0
5. Integrate SSO with SOA Suite
6. Oracle SOA Suite Overview
7. 11g SOA / Jdeveloper / Webcenter - Technical Preview
8. Step by Step Install of Oracle 11g SOA/JDeveloper/Webcenter
9. Install Oracle 11g Jdeveloper/SOA/Webcenter part II
10. Oracle Application Server Service Registry : Installation
11. Oracle SOA Suite 11g Tech. Preview 4

Share This

 This is last post for Installation of Oracle Role Manager deployed on JBOSS (Open Source J2EE Server) and using Oracle Database as repository.

For previous related posts visit related post section at bottom of this page.

Prereq. for Deploying Oracle Role Manager Application on JBOSS

Ensure that-
1. You have already installed JBOSS Server   More Here
2. Installed Oracle Database
3. Created tablespace, schema and user in database
4. Installed Oracle Role Manager  More Here

Configure/Deploy ORM with JBOSS

1. Copy the orm-ds.xml and orm-service.xml files from <ORM_install>/samples/jboss/4.0.5  to the JBoss directory at <JBossHome>/server/default/deploy

2. Edit orm-ds.xml file like
A)  Change the two occurrences of connection-url to match database environment

<connection-url>jdbc:oracle:thin:@SERVER_NAME:PORT:SID</connection-url>
like

<connection-url>jdbc:oracle:thin:@localhost:1521:orcl</connection-url>

(Note* My Database is on same machine as ORM & JBOSS with SID as ORCL and listening on port 1521)

B) Change the two occurrences of user-name and password to match the credentials of the Oracle Role Manager application user defined while installing role manager

<user-name>USER_NAME</user-name>
<password>PASSWORD</password>
like

<user-name>orm_app</user-name>
<password>welcome1</password>

3. Copy the server.ear file from <ORM_install>/lib to <JBossHome>/server/default/deploy
4. Copy the webui.war file from <ORM_install>/webui/jboss/4.0.5 to <JBossHome>/server/default/deploy

server.ear & webui.war are applications and once you copy them to deploy directory, JBOSS will deploy it automatically to JBOSS server 

Log file to this deployment will be in $JBOSS_HOME/server/default/log/server.log

5. Start JBOSS if not already up
cd %JOSS_HOME%/bin
run.bat

6. Access Oracle Role Manager

JBOSS URL                                                 -    http://localhost:8080
Role Manager Administrative Console    -    http://localhost:8080/ormconsole
Role Manager Web UI                               -    http://localhost:8080/webui

Related Docs

Oracle’s Role Manager Configuration with JBOSS & IBM Websphere

1. Oracle Role Manager : Installation Overview
2. Install JBoss : Open Source J2EE Server
3. Install Oracle Role Manager ORM on Windows Vista
4. Configure/Deploy Oracle Role Manager with JBOSS

Share This

Here are few more interview Questions targeted for Apps DBA’s with work exp. ranging from 1 to 3 years. 
   For answers to these question and many more Interview questions for Apps DBA’s visit http://teachmeoracle.com/forum  

If you wish to share interview questions drop me a mail or leave them as comment on this post

Q. How you will troubleshoot if concurrent request is taking long time ?

Q. If you are applying a patch.It was started successfully. In the middle you realise nothing happening and no update in patch log file,worker log file (No updates & no error message). What to do & How to troubleshoot ?

Q. Why there are three ORACLE_HOMEs in 11i or R12 ?

Q.What is difference between shared appltop and staged appltop ?

Q. what are the request incompatibilities ? how conflict resolution manager solve them?

Q.Where and how you update workflow notification mailer configuration setting ? (This depends on which workflow mailer you are running C Mailer or Java Mailer )

Q. If you want to change Concurrent Manager log and out file location , Is it possible ? If Yes, How ? If No, why not ?

Q. What are conflict resolution managers in CM ?

Q. What are interoperability patches ?

Q. How frequent you run Gather Schema Statistics program & with what option ? Why you need to run it ? What is cost based optimizer ?

Q. Name few common issues you encountered recently related to Web Server, Forms Server, Concurrent Manager (CM), Jinitiator, Database, Cloning, Patching .

Q. What all things you will check after cloning and before handing over instance to end users ?

Q. If users complain that reports are not running, what you will do to troubleshoot ?

Q. What is Rep-300 toolkit error ? Did you ever encounter this ?

Q. Share configuration/setup you have done w.r.t. Apps (expect some questions on that setup) ?

Related

http://teachmeoracle.com/interview.html

1. Oracle Apps DBA Interview Questions - Install
2. Oracle Apps DBA Interview Questions
3. Oracle Apps DBA 11i Interview Questions
4. 1Z0-233 Dump or Interview Questions for Oracle Apps DBA
5. Apps technical 11i DBA Interview questions
6. Oracle Apps DBA Interview Question : Apps / SSO / OID integration
7. Practical Interview Question for Oracle Apps 11i DBA
8. Oracle Apps DBA Training now available online
9. Oracle Apps DBA Interview/Technical Question : 10g AS with Apps 11i/R12/12i
10. Oracle Apps (E-Business Suite) DBA Interview Questions

Share This

Oracle Role Manager is part of Oracle Identity Management Suite to manage various user roles across enterprise. ORM is product from Bridgestream acquired by Oracle in 2007.

For overview of Role Manager visit my previous post under related at bottom or Visit Here 

Quick Installation Steps for ORM
1) Install Application Server(IBM Websphere or JBoss). This Application Server will host ORM application.
2) Install Oracle Database 10.2.0.3 or higher (This database will be used to store ORM data)
3) Create tablespace, schema, application user in database installed above
4) Install ORM Software
5) Deploy ORM application on Application Server installed in step 1 (ormconsole & webui)

* Note ORM software and Application Server should be installed on same machine.

-

Prepare Database for Oracle Role Manager

– Install Database 10.2.0.3 or higher on same machine as ORM or on different machine

– Machine hosting ORM should be able to connect to database

– Download Oracle Database From here  depending on your windows version from here

– Install Oracle Database

–Download Role Manager from here

– Extract  ORM software as_windows_x86_orm_10140.zip

– Go to directory where you unzipped rolemanager software and then samples\sqlscripts\oracle like

cd c:\atul\role_manager\Disk1\samples\sqlscripts\oracle

– If database is on other machine (than ORM) then copy samples directory to database

– Connect to database as sysdba sqlplus “/as sysdba”

Create Tablespace
– Create tablespace like  SQL>@create-tablespace.sql <data_dir> <index_dir> <temp_dir>
—–SQL>@create-tablespace.sql “C:\oracle\product.2.0\oradata\orcl” “C:\oracle\product.2.0\oradata\orcl” ”C:\oracle\product.2.0\oradata\orcl”  

 (**My datafile location was above hence I gave that location change this location as per your installation)

Create Schema
SQL>@create-schema-owner.sql <owner_username> <owner_password>
SQL>@create-schema-owner.sql orm welcome1

Create ORM Apps User 
SQL>@create-app-user.sql <app_username> <app_password>
SQL>@create-app-user.sql orm_app welcome1                

(**Database User and Application User can’t be same)
 

This completes database preparation for Oracle Role Manager (ORM). Next Step is to install Oracle Role Manager Software

Install Oracle Role Manager Software

Check Prereqs
- Ensure database 10.2.0.3 or higher is installed
- Ensure tablespace, schema and ORM application user are created on database
- Download ORM software from here  if not done already

Start Installation
- Start installer by running executable in Disk1 (from directory where you unzipped ORM software)

- Enter ORM Home Name and Installation Directory

– Select Installation Type (Install Software only or Install & Configure)
You can install first and configure with database later or install and configure both at same time

- Select from available configuration options

- Provide database connection details as shown in diagram ( *Note application user and schema name can’t be same)

- Specify ORM administrator username and password

– Finally you should see Successful Installation

This installs ORM software, finally we need to deploy ORM application on Application Server (JBOSS or IBM Websphere)

How to deploy application ORM application in JBOSS coming soon ……

1. Oracle Role Manager : Installation Overview
2. Install JBoss : Open Source J2EE Server
3. Install Oracle Role Manager ORM on Windows Vista
4. Configure/Deploy Oracle Role Manager with JBOSS

Share This

 Oracle Support team has given face lift (via Ajax) to http://metalink.oracle.com and this new look can be accessed via http://csm.oracle.com  

You can customize your dashboard and add/remove region on page by clicking “Customize Page ….” on top right.

Interesting thing I noticed is “System Health” region which displays any configuration/security related issues but in my opinion there is scope of improvement for system health messages/warnings.

For more on how to customize your CSM page visit http://blogs.oracle.com/supportportal/

More on Oracle Configuration Manager coming soon ….

Share This

If you are planning to migrate your application server to different machine or changing existing machine’s hostname, domainname or IP address here is list of things you should know in advance.

Discussion on this post if for 10.1.2.X and lower (Changing hostname on 10.1.3 and higher coming soon..)

Oracle Application Server components

Middle Tier- J2EE, Webcache, Portal, Wireless, BI, Forms
Infrastructure Tier- Identity Management(OID/SSO) & Metadata Repository

-
-
Things you should know before changing hostname, domainname, IP

1. Changing hostname, domainname of Metadata Repository is not supported (MR holds product data as well as OID/SSO data).

2. Use chgiphost.sh (unix) or chgiphost.bat (windows) in $OH/chgip/scripts directory to change hostname, domainname, IP address. 3. For changing middle tier hostname/domainname use option “-mid” with chgiphost.sh|.bat command

4. For changing Identity Management tier hostname/domainname use option “-idm” with chgiphost.sh|.bat command

5. You need orcladmin password for infra tier and any middle tier registered with OID/Infra Tier

6. If you change hostanme/domainname of instance hosting portal/sso, you need to reconfigure portal (using ptlconfig) and reregister with SSO (ssoreg)

7. Instance name doesn’t change by changing hostname or domainname. (When instance is initially created during installation name of instance is configured as <instance_name_you_provide> . <hostname>.<domainname> If instance name before host/domain name change was myinstance.oldhost.olddomain then it will remain same)

8. If instance (for which you wish to change hostname/domainname/ip) is part of OarcleAs cluster, you first have to remove it from cluster and add it later to cluster using “dcmctl” command

9. If instance (for which you wish to change hostname/domainname/ip) is part of OarcleAs Web Cache cluster, you first have to remove it from Web Cache cluster and add it later to cluster using “webcacheadmin” screen

10. If you are changing hostname/domainname for instance hosting OID, then change ldap.ora on all middle tier using this OID

11. Finally if anything goes wrong check logs in $OH/chgip/log

Related
http://download.oracle.com/docs

Changing hostname, domainname, ip address of machine SOA Suite (BPEL, ESB, OWSM) coming soon !!!

Share This

Universal Content Management (UCM) : is Oracle Solution for Enterprise Content Management ( from Stellent  )

Oracle Universal Content Management Consist of
– Content Server( Offers Repository and Coreservices)
– Application Modules which further extend capabilities of Content Server
—— Web Content Management
—— Document Management
—— Records Management
—— Digital Asset Management
—— Imaging and BPM

Content Server
— There are two components of Content Server a) Repository & b) Core Services
— Content Server is foundation of UCM .
— All content (irrespective of type) is stored in repository that makes content server e.g. (email, discussion, documents, reports, spreadsheets, images, multimedia)
— Core Services provided by content server are Library Services, Security, Personalization, Workflow, Conversion, User Input, Search, Administration
 

UCM Application Modules
1. Web Content Management - Extends Content Server and offer additional feature for creating managing and publishing websites and Portal content. Web Content Management include Content Server, Site Studio, Dynamic Converter, Content Publisher

2. Document Management - Extends Content Server and offer additional feature to capture, secure, share and distribute digital and paper-based documents and reports. Document Management includes Content Server, PDF Converter, Dynamic Converter, Desktop

3. Record Management - Extends Content Server and offer functionality to create, declare, classify, retain and destroy records. Record Management Includes Content Server, Records Manager, Physical Content Manager, Desktop

4. Digital Asset Management - Extends Content Server and offer functionality to manage rich media files. Digital Asset Management includes Content Server, Image Manager, Oracle Video Manager
 

Related

http://www.oracle.com/products/middleware/content-management/index.html
 

1. Oracle Universal Content Management Architecture
2. Oracle Content Server (UCM) installation overview

Share This

This post covers installation of Oracle TimesTen In-Memory Database.  I am going to use this TimesTen Database as repository for Oracle Communication and Mobility Server (OCMS ) installation in my future post.

What is TimesTen In-Memory Database ?
TimesTen is memory resident relational database for fast response and high throughput. TimesTen database is used by applications/industry which require very quick turn around time from database like Telecommunication, Defence.

Prepare for TimesTen Installation

1. Add timesten operating system user like
useradd timesten
2. Create directory/etc/TimesTen owned by user timesten
(This directory is used as Instance Registry by TimesTen Database)
mkdir /etc/TimesTen (from root user)
chown timesten:timesten /etc/TimesTen (from root User)

3. Download software TimesTen In-Memory database
from here

TimeTen Installation on Linux

1. Unzip software (tar file)  like tar -cvf timesten70400.linux86.tar and change directory to linux86

2. Start Installation by running setup.sh and choose default product 1. to install i.e.  Oracle TimeTen In-Memory database (This is requirement for OCMS - Oracle Communication and Mobility Server)

3.  When prompted for component select default 1 i.e. Client/Server and Data Manager 4.  When prompted for installation directory either change directory of your preference or choose default location i.e. $HOME

5. When prompted for Would you like to enable datastore access control select NO (Ensure you choose No for OCMS usages)

6. Choose default options for rest of installation

Verifying that Times Ten Database is up and running

$TimesTen_Home/bin/ttStatus

Starting / Stopping Times Ten

$DatabaseTimesTen_Home/bin/ttdaemonadmin -start
$TimesTen_Home/bin/ttdaemonadmin -stop

Related

–Oracle TimesTen Documentation Library

–Download TimeTen Database from here

–Oracle TimesTen In-Memory Database Homepage

Installation of Oracle Communication and Mobile Server using Oracle TimesTen In-Memory database coming soon !!!!!

1. Install Oracle TimesTen In-Memory Database 7.0.4 on Linux

Share This

JBOSS is open source enterprise level J2EE Server (similar to Oracle Application Server).

                This post covers installation of JBOSS (Open Source J2EE Application Server) on Linux and Windows. I am going to use this JBOSS as application Server for  Oracle Role Manager Installation in my next port.  

Download JBoss Software

Download JBoss 4.2.2.GA  from here  (This is platform indepedent software so you can install this software on windows, Linux, solaris or any other operating sytem )

Save file  jboss-4.2.2.GA.zip  to Linux/windows

Installation on Windows
1. Download and Install JDK, if not already installed on windows machine.

2. Unzip  jboss-4.2.2.GA.zip

3. Set following environment variables according to your server. In my case they are set to following directory
JAVA_HOME=C:\Program Files\Java\jdk1.5.0_15
JBOSS_HOME=C:\atul\role_manager\jboss-4.2.2.GA

4. Ensure these two environment variable are set by typing following on command prompt
echo %JAVA_HOME%
echo %JBOSS_HOME%

5. Installation on windows is complete
 

Installation ion Linux
 
1. If JDK is not already installed on linux machine; download jdk-1_5_0_15-linux-i586.bin from sun site and install it on Linux by executing bin file. This will create directory like  jdk1.5.0_15, I installed it under /stage/JDK/ so my JAVA_HOME is /stage/JDK/jdk1.5.0_15 

2. Unzip jboss-4.2.2.GA.zip on linux. This will create directory like  jboss-4.2.2.GA

3. Create environment file like  jboss.env like
export JAVA_HOME=/stage/JDK/jdk1.5.0_15
export JBOSS_HOME=/stage/JBOSS/jboss-4.2.2.GA
export PATH=$JAVA_HOME/bin:$JBOSS_HOME/bin:$PATH

4. execute like  . jboss.env

Start/Stop JBOSS

1. On Windows
1.1 Ensure environment variable JBOSS_HOME and JAVA_HOME are set
1.2 Go to command prompt
1.3 cd %JBOSS_HOME%\bin
1.4 run.bat    (To Start)
1.5 shutdown.bat  (To Stop)

2. On Linux
2.1 Execute jboss.env file created above
2.2 cd $JBOSS_HOME/bin
2.3 ./run.sh  (To Start)
2.4 ./shutdown.s (To Stop)
 

 Accessing JBOSS server
Open browser and type URL      http://localhost:8080

Related Docs

JBoss Installation Doc
 Download JBoss Software from here

Installation of Role Manager coming soon …..

1. Oracle Role Manager : Installation Overview
2. Install JBoss : Open Source J2EE Server
3. Install Oracle Role Manager ORM on Windows Vista
4. Configure/Deploy Oracle Role Manager with JBOSS

Share This

###  Read Normal Post in black font ### 

Our expert team is providing online Oracle Apps DBA training via Web Conferencing, here is link for course content and Fee  ->  Oracle Apps DBA 11i course content - 26th April to 11th May

###  Read Normal Post from here ###

Here are key points If you have to integrate Oracle Applications 11i/R12 with OID (for Single Sign-on access) and migrate users across two user repository (Apps and OID)

Users are migrated   
1. From OID to Apps (FND_USER) - In this scenario users already exist in OID and you wish to move them to Apps
2. From Apps to OID  - Users already exist in Apps 11i/R12 and you wish to move then to OID
3. Some users from Apps to OID and others from OID to Apps

Tools/Command to migrate users

1. AppsUserExport- To export account from Oracle E-Business Suite 11i/R12 to intermediate LDIF (Lightweight Directory Interchange Format) file. This is command line tool available in Apps. This is Java class file available under $JAVA_TOP/oracle/apps/fnd/oid

*Required to migrate data from Apps to OID

2. LDAPUserImport- Command line utility to read LDIF file (this file comes from OID containing users and their attribute).  This is Java class file available under $JAVA_TOP/oracle/apps/fnd/oid

*Required to migrate data from OID to Apps

3. ldifmigrator- Command line tool in OID to migrate application specific data or from other directory (AD, iPlanet) to format which OID can understand. This tool is under $ORACLE_HOME/bin on OID node. For syntax of OID click here

*Required to migrate data from Apps to OID

4. bulkload- Command line tool to load OID data in bulk. This tool is available in ORACLE_HOME/ldap/bin on OID node. Limitation with this tool is that you have to shutdown OID (database and listener should be up and running during bulkload). For syntax of bulkload Click Here

*Required to migrate data from Apps to OID and large number of users (else use ldapadd)

5. ldapadd- Command line tool to add an entry in OID. Advantage over bulkload is that no need to shutdown OID. Disadvantage is that this can be used only if number of users to add is small.
For more on ldapadd Click Here

*Required to migrate data from Apps to OID and small number of users (else use bulkload)

6. ldifwrite- Command line utility to create LDIF file from OID data so that LDIF file can later be importaed to Apps using LDAPUserImport.
For more on ldifwrite Click Here

*Required to migrate data from OID to Apps

7. oidprovtool - This is OID command line tool to add/delete/modify provisioning profile. This tool is available under ORACLE_HOME/bin on OID node.

*Required to migrate data from Apps to OID only if “Two Way” or “OID to Apps” provisioning profile is enabled

8. provsubtool.orc- This is command line utility in OID($OH/ldap/odi/bin) to manage application specific subscription list.

Things you should know before user export/import

1. Profile option “Application SSO Login Types” at user level should not be set to Local, else that user will not come to intermediate LDIF file when “AppsUserExport” is executed.

2. Profile option “Application SSO LDAP synchronization” should not be set to NO, else user will not be migrated.

3. If no value is set for above two profile option at user level, then site level value will take effect.

4. Apps users whose user_id < 10 in FND_USER (like SYSADMIN, GUEST, CONCURRENT MANAGER, APPSMGR) should not be synchronized with OID Users.

5. There is limitation to attributes of users migrated from Apps to OID (Full list of supported attributes migrated check page 88-89 of guide mentioned below)

6. $APPL_TOP/java should be in CLASSPATH before executing “java oracle.apps.fnd.oid.AppsUserExport” or “java oracle.apps.fnd.oid.LDAPUserImport”

7. If your provisioning profile (This instructs what user attributes to sync and which way) is configured to synch user data from OID to Apps or Both (OID to Apps and Apps to OID) and you are migrating initial data from Apps to OID (using AppsUserExport, ldifmigrator, bulkload.sh/ldapadd) then DISABLE you provisioning profile during migration process. Enable provisioning profile again after user load from apps to OID.

8. You should know your OID realm where you are going to/from migrate user data.

9. If multiple apps instances are registered with single OID then remove duplicate user data while loading from multiple apps instances to OID.

10. When users are bulk loaded in to OID, the password policy at OID is not enforced as passwords are encrypted in LDIF file.

11. Bulkload coomand to migrate users from Apps to OID does not automatically subscribe users to Apps. You have to manually subscribe them using provsubtool

12. LDAPUserImport command line utility to import data from OID to Apps updates both FND (Foundation) & TCA (Trading Community Architecture) data.
 

Migrating Users between Apps & OID

OID to Apps
1. Export Users from OID using ldifwrite (OID Node)
2. Import user to Apps using LDAPUserImport (Apps Node)

Apps to OID
1. Export user from Apps using LDAPUserExport (Apps Node)
2. Change file created in above step to ldif file using ldifmigrator (OID Node)
3. Import user to OID using bulkload/ldapadd (OID Node)
 

Related Doc

Apps 11i / OID Integration Guide    Page 69 to 76
Apps R12/OID Integration Guide    Chapter 6

1. 25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO
2. Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO
3. Oracle Single Sign-On Server for Apps DBA
4. Clone Apps 11i/R12/12i integrated with SSO
5. Notes/Docs to integrate Apps 11i with 10g AS Portal/OID/SSO
6. Migrate Users to/from OID and Oracle Apps 11i/R12

Share This

Start/Stop Oracle Apps Instance.
This looks very simple, hah I know this is just run adstrtal.sh/adstpall.sh, addbctl.sh and addlnctl.sh. I used to think like this, then after gaining experience I came with my own steps.

In previous approach, Did I took adequate step for checking any running concurrent requests .. did I took enough precaution to check what critical happenings going on in database like hot backup.. Now we shall take care

I assume you know the script location, I shall cover, if you still suggest me to include.

Starting is Simple.

1. addbctl.sh start
2. addlnctl.sh start SID
3. adstrtal.sh apps/password

Stoping is also fairly simple but “small care” needs to be taken to avoid critical issues.

I start my preparation sometime before the downtime scheduled, to let the concurrent request finish. Following are the steps to bring down middle-tier services

1. Bring down the concurrent manager before maintenance say 20 mins before.
   adcmctl.sh stop apps/Password
2. Check if any concurrent reqeust is running. if running, check what it is doing, like sql, session is active.
3. Check previous execution of similar program took how much time.Is it worth to wait or cancel the request
4. If it is affecting downtime then login from front-end and terminate the concurrent program, and make a note of request id(communicate to user who submitted this request so they can submit again)
5. Check the OS process id, whether it got terminated or not. If running then its a runaway process kill it. I dont like killings but…
   SQL> select oracle_process_id from fnd_concurrent_requests where request_id=&Request_id;

For bringing down database tier.

1. Check if hot backup is going on or not..
   To check, go to alert log file $ORACLE_HOME/admin/CONTEXT_NAME/bdump/alert_sid.log
   and also from sqlplus
   SQL> select distinct status from v$backup;
   If it returns row containing “ACTIVE” then hot back is in progress.
   Wait till it gets over.
   Otherwise next startup shall create problem. Though we have ways and means to overcome but why do that.
2. Conditional - If you are using DR, pls take care of following steps
   1. Check which archive dest state refer for DR, enable it .
      From show parameter log_archive_dest.. you may come to know..
      say if you are using 3rd then run the sql
      SQL>alter system set log_archive_dest_state_3=enable;
   2. Check if standby is performing managed recovery.
      SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;PROCESS STATUS
      ——- ————
      ARCH CLOSING
      ARCH CONNECTED
      MRP0 WAIT_FOR_LOG
      RFS WRITING
      RFS RECEIVING
      RFS RECEIVING
   3. Cancel managed recovery operations.
      SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
   4. Shut down the standby database.
      SQL> SHUTDOWN IMMEDIATE;
3. Stop database
4. Now stop the listener
5. If still database is not going down, check in alert log , what exactly is going on.
6. Check if any processes are running having local=NO is running. If yes, kill..

Share This

Key Points about Oracle Role Manager (ORM)
–Oracle Role Manager (ORM) is Product from Bridgestream
–Oracle Role manager is component of Oracle’s Identity Management product stack.
–Oracle Role Manager can be installed interactively or in silent mode (using response file)
–There are two options available with role manager installation
a) Install Software and configure
—- Require two database schemas and connectivity to those schemas
b) Install Software
– only copy software, configure later (load data model after customization are in place)

Broad level Installation steps : Oracle Role Manager

1. Install/Configure database for Role Manager schema
– You can use existing database or install new database for role manager schema
– Host from which you are installing role manager should be able to connect to database using sqlplus (TNS)
– Create tablespace using create-tablespace.sql
– Create Oracle Role Manager database users using create-app-user.sql and create-schema-owner.sql

2. Run installer for Role Manager installation and configuration
– For windows use setup.exe and for Linux use runInstaller
– Select “Install Software and Configure” or “Install Software Only”
– If you selected Configure option then select from “Primary Data Model” or “Standard Data Model” or “Oracle identity Manager Integration”
– Select database connection values
– Create administrative account for role manager

3. Configure Oracle Application Server with Role manager
– You can configure Oracle Role manager with “JBoss” or “IBM Websphere”

4. Load sample data for Oracle Role manager
– create db.properties file on Oracle Role Manager (ORM) server
– Deploy configuration and data model using deploy

Related Docs

Download Role Manager from here
Oracle Role Manager installation Guide
Nishant Kaushik post on Role Manager

Step by step installation of Oracle Role Manager with JBoss on Linux coming soon …

1. Oracle Role Manager : Installation Overview
2. Install JBoss : Open Source J2EE Server
3. Install Oracle Role Manager ORM on Windows Vista

Share This

If you are Apps DBA, I assume you never have to do this but if you are in situation like me (Apps Server running IPTABLES firewall and you handling both Linux server and Apps) then here is quick way to open port from linux based software firewall IPTABLES.

1. Identify Port which you need to open on firewall (For Apps 11i/R12 with port pool zero, open port 8000/web & 8100/forms )

 2. Open port in firewall with below command
iptables -I INPUT -p tcp –dport <port_number> -j ACCEPT   (replace port_number) like

iptables -I INPUT -p tcp –dport 8000 -j ACCEPT
iptables -I INPUT -p tcp –dport 8100 -j ACCEPT

3. Save IPTABLES like configuration 
service iptables save

4. Restart service IPTABLES like
service iptables restart

Related
Linux for newbie

1. Linux Common Queries
2. IPTABLES : Linux based firewall

Share This

Hello all, As per the request and with experience I am again returing to Cloning of Oracle Application. I know most of them know what exactly happens in cloning but still here I am trying to touch the depths.

Before starting I want to ask question. Why you need to do cloning ? Why we need to duplicate Oracle Application.

We need cloning for various of reasons. suppose I have got production instance and want to test some application. Now here I want to test the application, need to apply some product specific patches which might affect whole application then I have to give downtime which will affect business. So if I had the same this on whic hI can play and test my application or code or say I can apply some patches and at the same time business also run then nothing like it. This can be achieved by cloning or duplicating the application.

Duplicating the application is not easy or its just not simply copy the application, it wont work in any case. Logically it sounds fine just to copy the filesystem and relink it and start the application but its not that easy.

Basically for cloning Oracle Application it can be categorised into three major categories.

-Preparing the Source System
-Copy the file System
-Preparing or say Configuring the Target System

You can achive first and third steps using a Rapid Clone utility which Oracle provides for cloning

There can be many ways and methods to clone Oracle Application which many organisations follows but the only supported method provided by Oracle is using Rapid clone.

Rapid Clone is the new cloning utility introduced in Release 11.5.8. Rapid Clone leverages the new installation and configuration technology utilized by Rapid Install.

Basically there are two cloning methodology using Autoconfig and without using autoconfig. First one that is using autoconfig is completely replaced by Rapidclone.

Non-autocofig cloning methodology was generally used before 11.5.5 that is non autoconfig enabled system.

Here I will discuss Rapid Clone method of cloning and also throw some light on cloning 11.0.3 oracle application as some users are still using that.

So first about the Rapid clone method.

In Category 1 that is first you need to make source for clone. You need to dress up Source system so that only configuration files and not the whole file system is copied.

Pre-requiste Steps

To start with cloning you need to first check about some pre-requisites some utilities should be of required version

Here are they,

Oracle Universal Installer should be of 2.2.0.19 version
Perl should be of 5.005 version minimum
JRE 1.1.8 and 1.3.1
JDK 1.3.1
Zip utility of version 2.3 minimum
Latest Autoconfig Templates patches are applied. TXK-O is the latest till date.
Latest Rapid Clone patches should be applied. Latest is ADX.F till date.

After check ing the pre-requisites now your system is ready to clone.

Preparing the Source system:

After checking the above mentioned pre-requisites now you have to prepare the source system which need to be cloned.

In a broad way what this step will do is this will create the staged clone directory which will be having the driver files and configuration file of the source.

So what exactly is going to happen in this step. Lets get in more details

Basically you have to run the adpreclone.pl script once for Application tier and one for the datbase (even if you are on single node ! )

Lets first check for the Database tier

On Source system, run following as ORACLE user

cd RDBMS Oracle_Home/appsutil/scripts/_perl ./adpreclone.pl dbTier

After running this it goes in two stages

dbTechstack and Database

What exactly it will do is
It will create stage cloned area at $ORACLE_HOME/appsutil/clone This clone directory has got following main directories
data,jre,bin,db,html,context

It will prepare datbase techstack at dbTechStack stage. Major activities it will take care of at this stage.

-Creates template files at $ORACLE_HOME/appsutil/template
-Creates driver files at $ORACLE_HOME/appsutil/driver/instconf.drv
-Converts inventory from binary to xml

It will prepare datbase at the database stage. Major activities includes

-Create datbase control file script
$Oracle_Home/appsutil/clone/context/data/stage/addbhomsrc.xml
$Oracle_Home/appsutil/clone/context/data/stage/adcrdb.zip
adcrdbclone.sql

-Generates database creation driver file
$Oracle_Home/appsutil/clone/context/data/driver/data.drv

-Copy JDBC Libraries
$Oracle_Home/appsutil/clone /clone/jlib/classes111.zip

So all this happens on database side

Now lets concentrate on Application tier side. Again it goes almost in the same way that is in two stages.

As a APPLMGR user on application tier this script is run
cd $COMMON_TOP/admin/scripts/_perl ./adpreclone.pl appsTier

It will also create the staged clone directory at $COMMON_TOP/clone
It goes in two stages. Lets see one by one

atTechStack that is Application tier techstack.

- Creates template files for
Oracle_iAS_Home/appsutil/template
Oracle_806_Home/appsutil/template

-Creates Techstack driver files for
Oracle_iAS_Home/appsutil/driver/instconf.drv
Oracle_806_Home/appsutil/driver/instconf.drv

appltop preparation

-It will create application top driver file
$COMMON_TOP/clone/appl/driver/appl.drv

-Copy JDBC libraries
$COMMON_TOP/clone/jlib/classes111.zip

So this all happens in dressing the source system

After then we need to copy the files.

Copy following files

APPL_TOP
OA_HTML ($COMMON_TOP/html)
JAVA_TOP
COMMON_TOP/util
COMMON_TOP/clone
8.0.6 ORACLE_HOME
iAS ORACLE_HOME
DB ORACLE_HOME
dbf files

After this stage now you need to configure the Target node. Basically you will run adcfgclone.pl same for databse tier and for application tier.
Let go in bit more detail:

First we will see for the database tier

On the target node you will run
ORACLE_DB_HOME/appsutil/clone/bin/perl adcfgclone.pl dbTier

Again there are two stages :

First will look at dbTechstack
It will use the driver files and templates which were created at source and has been copied to target.

Following scripts are run
-adchkutl.sh
-adclonectx.pl
-runInstallConfigDriver —- located in $Oracle_Home/appsutil/driver/instconf.drv
-Relinking $Oracle_Home/appsutil/install/adlnkoh.sh

Now for database
-Driver file
$Oracle_Home/appsutil/clone/context/data/driver/data.drv
-Create database adcrdb.zip
-Autoconfig is run
-Control file creation adcrdbclone.sql

Now on application tier
from COMMON_TOP/clone/bin/perl adcfgclone.pl appsTier

Stage at TechStack
-Creates context file for target adclonectx.pl
-Run driver files
$Oracle_806_Home/appsutil/driver/instconf.drv
$Oracle_iAS_Home/appsutil/driver/instconf.drv

Relinking of Oracle Home
$Oracle_806_Home/bin/adlnk806.sh
$Oracle_iAS_Home/bin/adlnkiAS.sh

at the end for ApplTop stage
It runs driver and then autoconfig

So this will totally configure your application which has been copied.

At the end you have to some finishing tasks

-Update Printer settings
-Update Workflow Configuration settings
-Update Profile options

This completes you application cloning completely.

So Happy reading folks !!!!

Share This