TECH SOLUTIONS: November 2012

Q. What type of repositories can be created using Informatica Repository Manager?
A. Informatica PowerCenter includeds following type of repositories :
•Standalone Repository : A repository that functions individually and this is unrelated to any other repositories.
•Global Repository : This is a centralized repository in a domain. This repository can contain shared objects across the repositories in a domain. The objects are shared through global shortcuts.
•Local Repository : Local repository is within a domain and it’s not a global repository. Local repository can connect to a global repository using global shortcuts and can use objects in it’s shared folders.
•Versioned Repository : This can either be local or global repository but it allows version control for the repository. A versioned repository can store multiple copies, or versions of an object. This features allows to efficiently develop, test and deploy metadata in the production environment.
Q. What is a code page?
A. A code page contains encoding to specify characters in a set of one or more languages. The code page is selected based on source of the data. For example if source contains Japanese text then the code page should be selected to support Japanese text.
When a code page is chosen, the program or application for which the code page is set, refers to a specific set of data that describes the characters the application recognizes. This influences the way that application stores, receives, and sends character data.
Q. Which all databases PowerCenter Server on Windows can connect to?
A. PowerCenter Server on Windows can connect to following databases:
•IBM DB2
•Informix
•Microsoft Access
•Microsoft Excel
•Microsoft SQL Server
•Oracle
•Sybase
•Teradata
Q. Which all databases PowerCenter Server on UNIX can connect to?
A. PowerCenter Server on UNIX can connect to following databases:
•IBM DB2
•Informix
•Oracle
•Sybase
•Teradata
Informatica Mapping Designer
Q. How to execute PL/SQL script from Informatica mapping?
A. Stored Procedure (SP) transformation can be used to execute PL/SQL Scripts. In SP Transformation PL/SQL procedure name can be specified. Whenever the session is executed, the session will call the pl/sql procedure.
Q. How can you define a transformation? What are different types of transformations available in Informatica?
A. A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data. Below are the various transformations available in Informatica:
•Aggregator
•Application Source Qualifier
•Custom
•Expression
•External Procedure
•Filter
•Input
•Joiner
•Lookup
•Normalizer
•Output
•Rank
•Router
•Sequence Generator
•Sorter
•Source Qualifier
•Stored Procedure
•Transaction Control
•Union
•Update Strategy
•XML Generator
•XML Parser
•XML Source Qualifier
Q. What is a source qualifier? What is meant by Query Override?
A. Source Qualifier represents the rows that the PowerCenter Server reads from a relational or flat file source when it runs a session. When a relational or a flat file source definition is added to a mapping, it is connected to a Source Qualifier transformation.
PowerCenter Server generates a query for each Source Qualifier Transformation whenever it runs the session. The default query is SELET statement containing all the source columns. Source Qualifier has capability to override this default query by changing the default settings of the transformation properties. The list of selected ports or the order they appear in the default query should not be changed in overridden query.
Q. What is aggregator transformation?
A. The Aggregator transformation allows performing aggregate calculations, such as averages and sums. Unlike Expression Transformation, the Aggregator transformation can only be used to perform calculations on groups. The Expression transformation permits calculations on a row-by-row basis only.
Aggregator Transformation contains group by ports that indicate how to group the data. While grouping the data, the aggregator transformation outputs the last row of each group unless otherwise specified in the transformation properties.
Various group by functions available in Informatica are : AVG, COUNT, FIRST, LAST, MAX, MEDIAN, MIN, PERCENTILE, STDDEV, SUM, VARIANCE.
Q. What is Incremental Aggregation?
A. Whenever a session is created for a mapping Aggregate Transformation, the session option for Incremental Aggregation can be enabled. When PowerCenter performs incremental aggregation, it passes new source data through the mapping and uses historical cache data to perform new aggregation calculations incrementally.
Q. How Union Transformation is used?
A. The union transformation is a multiple input group transformation that can be used to merge data from various sources (or pipelines). This transformation works just like UNION ALL statement in SQL, that is used to combine result set of two SELECT statements.
Q. Can two flat files be joined with Joiner Transformation?
A. Yes, joiner transformation can be used to join data from two flat file sources.
Q. What is a look up transformation?
A. This transformation is used to lookup data in a flat file or a relational table, view or synonym. It compares lookup transformation ports (input ports) to the source column values based on the lookup condition. Later returned values can be passed to other transformations.
Q. Can a lookup be done on Flat Files?
A. Yes.
Q. What is the difference between a connected look up and unconnected look up?
A. Connected lookup takes input values directly from other transformations in the pipleline.
Unconnected lookup doesn’t take inputs directly from any other transformation, but it can be used in any transformation (like expression) and can be invoked as a function using :LKP expression. So, an unconnected lookup can be called multiple times in a mapping.
Q. What is a mapplet?
A. A mapplet is a reusable object that is created using mapplet designer. The mapplet contains set of transformations and it allows us to reuse that transformation logic in multiple mappings.
Q. What does reusable transformation mean?
A. Reusable transformations can be used multiple times in a mapping. The reusable transformation is stored as a metadata separate from any other mapping that uses the transformation. Whenever any changes to a reusable transformation are made, all the mappings where the transformation is used will be invalidated.
Q. What is update strategy and what are the options for update strategy?
A. Informatica processes the source data row-by-row. By default every row is marked to be inserted in the target table. If the row has to be updated/inserted based on some logic Update Strategy transformation is used. The condition can be specified in Update Strategy to mark the processed row for update or insert.
Following options are available for update strategy :
•DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
•DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
•DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
•DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.

Comments (0)

Feb122011

Server Performance Data Collection – Collectl

Server Performance Data Collection
1. Disk
2. CPU
3. Network … Etc
There are a number of times in which you find yourself needing performance data. These can include benchmarking, monitoring a system’s general heath or trying to determine what your system was doing at some time in the past. Sometimes you just want to know what the system is doing right now. Depending on what you’re doing, you often end up using different tools, each designed to for that specific situation.
Unlike most monitoring tools that either focus on a small set of statistics, format their output in only one way, run either interatively or as a daemon but not both, collectl tries to do it all. You can choose to monitor any of a broad set of subsystems which currently include buddyinfo, cpu, disk, inodes, infiniband, lustre, memory, network, nfs, processes, quadrics, slabs, sockets and tcp.
By default it shows cpu, network and disk stats in brief format. The key point of this format is all output appears on a single line making it much easier to spot spikes or other anomalies in the output:
[oracle@Mudhalvan] collectl
while writing to an NFS mounted filesystem, collectl displays interrupts, memory usage and nfs activity with timestamps. Keep in mind that you can mix and match any data and in the case of brief format you simply need to have a window wide enough to accommodate your output.
[oracle@Mudhalvan] collectl -sjmf -oT
You can also display the same information in verbose format, in which case you get a single line for each type of data at the expense of more screen real estate, as can be seen in this example of network data during NFS writes. Note how you can actually see the network traffic stall while waiting for the server to physically write the data.
[oracle@Mudhalvan] collectl -sn –verbose -oT
[oracle@Mudhalvan] collectl -sJ -oTm
Output can also be saved in a rolling set of logs for later playback or displayed interactively in a variety of formats. If all that isn’t enough there are additional mechanisms for supplying data to external tools by generating output as s-expressions, a format of choice for some tools such as supermon or in another format called list-expressions. This output can be written to a file or sent over a socket. You can even create files in space-separated format for plotting with external packages like gnuplot or colplot, part of the collectl utilities project, which provides a web-based interface to gnuplot.
Collectl runs on all linux distros (it’s included as part of Fedora) and only requires perl. If the perl Time::Hires module is installed, you will be able to use fractional intervals and display timestamps in msecs. If the Compress::Zlib module is installed the recorded data will be compressed and therefore use on average 90% less storage when recording to a file. Also note that the above links are not for RPMs. If you’d rather work with RPMs there are far too many versions out there to link to and so I’m sorry to say you’re on your own.
Did you know there was an inconsistency in the way Linux reported disk metrics that wasn’t even noticed/fixed until the 2.6-14 kernel was released? Collectl did. Or how about the fact that network stats may not accurately reported by most network monitoring tools at one second intervals? See this page for a description of the problem and how you can get more accurate stats by simply running collectl at a sub-second interval.
You can have the updated version here

DataBase Monitoring, Oracle DBA Interview Questions, Performance, Unix-Linux Administration | mudhalvan |

Comments (0)

CPU, Disk, Disk Usage Monitoring, Linux Server Performance, Network Monitoring, Server Monitoring

Feb112011

Data Guard Background processes

Data Guard Background processes
DMON – The Data Guard Broker process.
SNP – The snapshot process.
MRP – Managed recovery process – For Data Guard, the background process that applies archived redo log to the standby database.
ORBn – performs the actual rebalance data extent movements in an Automatic Storage Management instance. There can be many of these at a time, called ORB0, ORB1, and so forth.
OSMB – is present in a database instance using an Automatic Storage Management disk group. It communicates with the Automatic Storage Management instance.
RFS – Remote File Server process – In Data Guard, the remote file server process on the standby database receives archived redo logs from the primary database.
QMN – Queue Monitor Process (QMNn) – Used to manage Oracle Streams Advanced Queuing.

DataGuard Administration, Oracle DBA Interview Questions | mudhalvan |

Comments (0)

Data Guard Background processes, DataGuard process, DataGuard Processes

Feb042011

How to set Data Protection Mode of a Primary Database

How to set Data Protection Mode of a Primary Database
Step 1 Select a data protection mode that meets your availability, performance and data protection requirements.
Step 2 Verify that redo transport is configured to at least one standby database The value of the LOG_ARCHIVE_DEST_n database initialization parameter that corresponds to the standby database must include the redo transport attributes listed for the data protection mode that you are moving to.
Maximum Protection, Availability – AFFIRM,SYNC, DB_UNIQUE_NAME
Maximum Performance – NOAFFIRM, ASYNC, DB_UNIQUE_NAME
Step 3 Verify that the DB_UNIQUE_NAME database initialization parameter has been set to a unique name on the primary and standby database.
Step 4 Verify that the LOG_ARCHIVE_CONFIG database initialization parameter has been defined on the primary and standby database and that its value includes a DG_CONFIG list that includes the DB_UNIQUE_NAME of the primary and standby database.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG=’DG_CONFIG=(MMPRY,MMSTB)’;
Step 5 Shut down the primary database and restart it in mounted mode if the protection mode is being set to Maximum Protection or being changed from Maximum Performance to Maximum Availability. If the primary database is an Oracle Real Applications Cluster, shut down all of the instances and then start and mount a single instance.
For example:
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
Step 6 Set the data protection mode.
Execute the following SQL statement on the primary database:
SQL> ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {AVAILABILITY | PERFORMANCE | PROTECTION};
Step 7 Open the primary database.
SQL> ALTER DATABASE OPEN;
Step 8 Confirm that the primary database is operating in the new protection mode.
SQL> SELECT PROTECTION_MODE FROM V$DATABASE;

DataGuard Administration, Oracle DBA Interview Questions | mudhalvan |

Comments (0)

Dataguard Mode, how to change the protection Mode, How to set Data Protection Mode of a Primary Database, What Parameter required for Max availability Mode, What Parameter required for Max Performance Mode, What Parameter required for Max Protection Mode

Dec302010

What are Oracle Clusterware processes for 10g on Unix and Linux

Cluster Synchronization Services (ocssd) — Manages cluster node membership and runs as the oracle user; failure of this process results in cluster restart.
Cluster Ready Services (crsd) — The crs process manages cluster resources (which could be a database, an instance, a service, a Listener, a virtual IP (VIP) address, an application process, and so on) based on the resource’s configuration information that is stored in the OCR. This includes start, stop, monitor and failover operations. This process runs as the root user
Event manager daemon (evmd) —A background process that publishes events that crs creates.
Process Monitor Daemon (OPROCD) —This process monitor the cluster and provide I/O fencing. OPROCD performs its check, stops running, and if the wake up is beyond the expected time, then OPROCD resets the processor and reboots the node. An OPROCD failure results in Oracle Clusterware restarting the node. OPROCD uses the hangcheck timer on Linux platforms.
RACG (racgmain, racgimon) —Extends clusterware to support Oracle-specific requirements and complex resources. Runs server callout scripts when FAN events occur.

Oracle DBA Interview Questions, RAC | mudhalvan |

Comments (0)

10g rac clusterware process, Clusterware Process

Dec252010

DBA Interview Questions – Part 2

1) Primary database scn is 22 and standby SCN is 24 how you will resolve this issue.
2) Archive log got deleted before shipped to standby location how you will resolve this issue.
3) 3 users running same select but one of them response time is 1hr and for other few minutes how u will diagnose this.
4) What is advantage of ASM over os storage and raw storage.
5) What is remastering in RAC
6) How you can see database version at OS level.
7) A job is running since long it was working fine earlier how you will check that
8) How you will suggest joins to developer
9) 3 databases sizes 10gb, 100gb, 1TB how which database will take more time.
10) You lost control file database is using RMAN backup with nocatalog. If you loose whole db as well same time how you recover database.
11) what is sync, and async in standby how it works.
12) Shut immediate is taking too much time how you diagnose what is the issue.
13) How you take backup of OCR.
14) What will happen if voting disk is down.
15) What will happen if virtual IP is down in RAC.
VIP – Virtual IP address in RAC
VIP is mainly used for fast connection in failover.
Until 9i RAC faileover we used physical IP address of another server. When the connection request come from a client to server, then failure of first server listener then RAC redirect the connection request to second available server using physical IP address. Hence it is physical IP address rediretion to second physical IP address is possible only after we get timeout error from First Physical IP address. So connection should wait a while for getting TCP connection timeout.
From RAC 10g we can use the VIP to save connection timeout wait, Because ONS (Oracle Notification Service) maintains communication between each nodes and listeners. Once ONS found any listener down or node down, it will notify another nodes and listeners. While new connection is trying to establish connection to failure node or listener, virtual IP of failure node automatically divert to surviving node. This Process will not wait for TCP/IP timeout event. So new connection will be faster even one listener/node failed.

Oracle DBA Interview Questions | aarthimudhalvan |

Comments (0)

DBA Interview Question, Oracle DBA Interview Question

Nov252010

RMAN Interview Questions

RMAN Interview Questions
1) if one archive deleted before applying on standby and u do not have backup how u resolve this issue?. Database size is in TB so recreating Standby is not good idea.
2) if block change tacking is enabled on production db will it be enabled on cloned db automatically?
3) You have assigned 3-4 channels in rman backup how u will identified whether all are utilized or not?
4) how u do performance tuning for rman backups?
5) can we register manual cold backup in rman?
6) can we recreate oracle inventory if we do not have any backup?
7) what is diff in imagecopy & normal backup in terms of performance
8) 10K blocks in ur db got corrupted how u will resolve this

Oracle DBA Interview Questions | mudhalvan |

Comments (0)

RMAN Interview Questions

Jul012010

Explain the relationship among database, tablespace, and datafile.

The database is logically divided into one or more tablespaces.
For each tablespace we explicitly create one or more datafiles.

Oracle DBA Interview Questions | aarthimudhalvan |

Comments (1)

Explain the relationship among database and tablespace and datafile., Oracle DBA Interview Questions

Jun282010

How to recover if we delete a data file at OS level no backup for that?

bring the database to the mount state
sql>alter database create datafile ;
sql>recover datafile ;
sql>alter database open;

Oracle DBA Interview Questions | aarthimudhalvan |

Comments (0)

how to recover if we delete a data file at OS level no backup for that?, Oracle DBA Interview Questions

Jun222010

How do you see how many instances are running?

In Linux, Unix the command: ps -ef|grep pmon
In Windows: services.msc

Oracle DBA Interview Questions | aarthimudhalvan |

Comments (0)

How do you see how many instances are running?, Oracle DBA Interview Questions

Friday, November 16, 2012

Test 2

Please register.

Posted by: akr14feb on 01/13/2009 04:25 AM

Guys,

Please do create a new account using "New Account Signup " to get latest updates and to access Oracle Forums, if it not working please send a mail to akr14feb@gmail.com

Thanks
A.Kishore

Volkswagen EOS - Video

Convertible Car

Today's Quote

I am not afraid of the one who know 1000 steps,but i am afraid of the one who practices a single step 10000 times

-Bruce Lee

"Take up one idea. Make that one idea your life - think of it, dream of it, live on that idea. Let the brain, muscles, nerves, every part of your body, be full of that idea, and just leave every other idea alone. This is the way to success, that is the way great spiritual giants are produced."

- Swami Vivekananda

Focus on one task at a time

In reality, you can only focus and place effort on one task at a time. It is better to have one task fully completed than have several uncompleted tasks. When you focus on several things at the same time, you simply don’t get alot achieved and you are creating hardly any room for error. Also your concentration becomes more scattered when you focus on too many things at once.

Welcome to the world of Oracle Apps!!

This is a humble initiative for providing self help to people who really want to enhance their skills in Oracle Apps DBA, with special emphasis to the Administration area. The main motive behind this initiative has been the difficulties which I had faced when I ventured out to try my hands at Oracle Apps DB Administration. Though there were lots of information available out there in the web, I didn't find most of them handy as they didn't give importance to the fact that many people will look for detailed step by step explanation of each activity. So, I had to go through many channels to finally get the hold on the subject and reach the level I am in today. This was a tough and tedious process, and especially due to this reason, I wanted to come up with a simple and straight forward set of articles which will serve as a kind of "do it yourself" guide for all those who want to venture out to the galaxy of Oracle Apps DB Administration..

Also, anybody wants to contribute any article on Oracle and follows the standards what I have followed, I shall publish the same and I shall mention the author name. I am man who goes by an example, any work done should be able to be used by any lay person that is the whole idea of this site.

Happy learning!!

This website is free for lifetime, and if you guys are happy with the articles and feel that it has given a value addition you can always donate to http://www.vedanta-edu.org without there encouragement I wouldn't have reached so peak.

This site is been hosted by znet India, I really appreciate them. The content management is done using PHP, MySQL and Apache, thanks to my manager at Cambridge Solutions who has helped me to learn web designing.

A.Kishore

Oracle 10g DBA Certified
Oracle R12/11i Apps DBA Cerified
Oracle 10g RAC Certified
"There is no better moment than the present, Be Present."

Created on 02/04/2003 10:24 AM by admin
Updated on 09/15/2012 07:04 PM by akr14feb

Comments

The comments are owned by the poster. We are not responsible for its content.

Excellent Idea
Posted on: 2008-04-10 07:16:51 By: Anonymous

Kishore,

Idea of starting the site for knowledge share was excellent. I hope this site will become popular and helpful to the oracle apps world.

I have gone through ur "My Seven days of experience in Virginia" and " Good Morning America – It works ". Good one. While reading these articles the first impression i got is you are the person who enjoys the work whatever u do whether it is oracle apps or cooking :-).. I must say u r the allrounder in all the areas of computeres - Hardare and S/W. I came to know by ur mail that you know almost every s/w and configuring hardware on ur own( I remember Which is our Guru Nekkanti's aspire) . Would like to write some articles in this site with your kind permission.

I hope this site will be helpful to ORACLE WORLD..

Regards,
Phani Varma
email: a_p_varma@yahoo.co.in

Re: Excellent Idea Posted on: 2008-04-10 20:54:44 By: Anonymous
Hi Phani, It was great to read your mail, you yourself are great motivator for the world, at very young age you have grown to the peak of success. Sure, you can surely send articles, I shall publish on your name. Regards Kishore

Re: Excellent Idea Posted on: 2012-01-09 12:29:20 By: joshipodili	Edited By: joshipodili On: 2012-01-09 12:29:43
hi Kishore Sir iworkd as a sql n plsql developer due to some reason i am job less now iam did my dba and apps dba course please guide me to set my life ihave 5 yras of gap please guide me REgards y

Re: Excellent Idea
Posted on: 2012-02-23 16:34:35 By: akr14feb

Honestly to get a job, prepare your resume with 3 to 4 years experience, have a system in you home, practise all the DBA/Apps DBA activities, Google is so cool, you get whatever you want.

Practise all the regular Oracle DBA activities like Installation, Backup, Recovery, upgrades, Cloning, Patching etc, Prepare for OCP Certification, Dream about it, and one day you will succeed, if possible work as faculty

Don't worry about experience certificates, there should be some company in world who may like your talent :)

A.Kishore

Re Posted on: 2008-06-04 17:24:03 By: Anonymous
Simply Its Excellent... Motivative

upgradation of R12.0.4 to R12.1.3 Posted on: 2010-11-17 13:12:54 By: nivas123
If any one has any doc on upgrading R12.0.4 to R12.1.3 please do send me or the note id or the link where I can download the doc.

Re: upgradation of R12.0.4 to R12.1.3 Posted on: 2012-05-12 00:32:36 By: soumya
please can you provide upgradation document to mymail..

UPGRADE DOCUMETTATION HELP Posted on: 2011-02-01 00:47:16 By: bhojsree2
HI KIshore, Am new to DB and APPS can you please help me am now in a project to upgrade 10GR2 RAC+ASM WITH 11i APPLICATIONS. i NEED TO UPGRADE IT TO 11GR2 RAC+ASM WITH 11i APPLICATIONS ON OEL5 OPERATING SYSTEM.CAN YOU PLEASE HELP ME WITH THE UPGRADE DOCUMENTATION.

Re: Excellent Idea Posted on: 2011-02-14 07:49:28 By: rajkumar
Kishore, I agree with Phani, I want send you thank you note to you for your efforts sharing knowledge, please send your email id. --Raj srdba1@yahoo.com

upgrade from 11.5.9 to 11.5.10.2 Posted on: 2011-11-04 21:59:59 By: zavi
Hi, this is first time am posting on any forum I have gone through some of your docs they are really excellent and very verbose. i would really appreciate if can send a doc related to oracle application upgrade 11.5.9 to 11.5.10.2 thanx zavi zavi07@gmail.com

Re: Excellent Idea Posted on: 2011-12-01 15:19:12 By: debabrata	Edited By: akr14feb On: 2012-01-22 23:14:33
Hello, Good afternoon sir.I m now doing the core DBA course and i want to go for the back end.So can you please suggest me which will be better for me i.e ORACLE APPS TECHNICAL or ORACLE RAC DBA ???. Please suggest me . Regards Debabrata padhi

Re: Excellent Idea Posted on: 2012-01-22 23:14:45 By: akr14feb
If you have done core DBA course, you have 2 choices to proceed, the first one is Oracle RAC or Oracle Apps DBA But first gain your confidence on Oracle DBA on Linux and Unix platform Kishore

amazing Idea Posted on: 2012-02-23 10:46:19 By: rstiwari
I think you are amazing . This is a best Idea to share our knowledge through online network. If it is possible to share knowledge with help of class room (workshop). I am from India and I think RAC and other oracle or other training is so costly. it is good idea for improving knowledge.

Re: Excellent Idea
Posted on: 2012-03-31 16:36:55 By: Shiva

Hi Kishore,

Thanks for sharing your experience and thoughts with us,this is really good site with great information. I was searching for orcale apps information , then i found this blog and its amazing.I have completed my masters in IT from Australian university and now i want to do specialization in any subject and start my career in IT.Through one of my friends suggestion i have started thinking of doing oracle apps but i really dont have an idea of what this is , how to start and where to start.can you please,guide me in a right direction and how to proceed further with this.

I have read your article Seven days of exp in Virginia it is really great and got to now your talent, determination and passion for the work.I got motivated by reading your article and thought of asking your suggestion in shaping up my carrer in oracle apps.

thanks
Shiva

Hi Kishore sir Posted on: 2012-04-17 16:55:25 By: akkapalli
im not able to open my login home page in r12 i installed on apps r12 on vmvare and all services are started apps as well as db pinging each other with linux and windows im not able to open my login page with internet explorer please provide solution

Great Mail - My Seven days of experience in Virginia
Posted on: 2008-04-15 21:08:35 By: Anonymous

Hi Kishore,
Gone through your 'My Seven days of experience in Virginia
Guys' mail completely.

Excellent. You are having a great narration talent. We could visuvalise the things from your mail.

Your mail conveys 'HARDWORK , THIRST TO LEARN', 'POSITIVE ATTITUDE' to reach the GOAL of success.

Your Mail is an Great Motiviation to us.

Wishes for every succees in your future endevours!!!
(I am also preparing for a driving test @UK :)

Cheers,
Rathinaganesh
arganesh4@yahoo.com

Re: Great Mail - My Seven days of experience in Virginia Posted on: 2008-04-15 21:11:29 By: Anonymous	Edited By: akr14feb On: 2008-05-04 11:26:24
I am blessed to read such a mail, I never thought I did such great achievement. I thought I had a jolly ride. Long back, I read somewhere that a blog closes if there is no proper response by the people but seeing the responses I am thrilled and shall do the best. Regards Kishore

Hello Boss
Posted on: 2008-04-22 04:50:15 By: Pavan

Edited By: Pavan
On: 2008-04-22 04:51:05

Hi Kishore,
Its really fantastic to see you after a long time coming up with this suprising gift,I conisder you as my guruji in oracleapps coz i started learning oracleapps from you in chennai . Your knowledge in apps and intrest towards the subjects was amazing. The days I spent with you are golden days for me where I have learnt much with in the short span of time.

Article My Seven days of experience in Virginia’ was excellent.

"The difference between the impossible and the possible lies in a person's determination" You have proved this once agin.

Pavan Kumar

Re: Hello Boss Posted on: 2008-04-26 15:44:37 By: akr14feb
Thanks Pavan, Well, I think you are in the right track, just keep upgrading your skills on Oracle Apps then things should be positive Let me know for any help Regards Kishore

No Subject
Posted on: 2008-04-28 10:03:50 By: Anonymous

Hi Kishore,

Well and hope the same.
Approximately I had taken one day to read your website.First , I Congrats for your New job .Kishore, As you are having a good/nice/motivated personal characters, you are doing all this things.So the credit goes to your parents.When I was working with you, I learned/watched/Observed your good characters.

If you have time to come to s'pore,please do come to my house..

Thanks&Regards
Subramanian
CitiGroup,TampinesJunction,Singapore.

Re: Posted on: 2008-04-29 05:56:29 By: Anonymous
I feel such a wonderful moments of this we are chatting one another with our Collegue[The Great Mr.Kishore]'s website. Am I right Subu? Kishore, really we have to thank you for all your support and Guidance for Learning. Thanks. Regards, Srivishnuhari S

Hi Kishore Posted on: 2008-05-07 05:25:01 By: Ramesh
Ur profile is very nice, i like ur positive thinking n guts. u r great. Ur website is very to useful to guide for us Regards, Ramesh

Re: Hi Kishore Posted on: 2008-05-08 14:41:13 By: akr14feb
Thanks Ramesh, You guys gave me opportunity to grow and same thing I am returning to you through my website. Regards Kishore

Upgradation doc Posted on: 2010-09-29 17:20:57 By: sandeep
Hi All, Can you please send me the document for upgradation for 11.5.10.2 to R12 the operating sytem we have is Enterprise Linux Enterprise Linux AS release 4 (October Update 6)

Re: Upgradation doc Posted on: 2011-02-04 18:41:54 By: akr14feb
http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36

No Subject Posted on: 2008-05-08 17:52:55 By: Anonymous
I loved the 7 days of exp in VA. Now I actually know why they loved you so much !!! lets connect and keep in touch...always! Chawla

No Subject Posted on: 2008-05-15 12:08:33 By: Anonymous
Kishore! My Man! Why didn't you buy that car when you were here in Virginia, we could have taken rides together and enjoyed the beautiful scenery. Anyway, great car for a great man like you Kishore, you and your family deserve it. Enjoy the beauty, the comfort, and the performance of a German engineering car (the best in the world). Regards, Nabil

No Subject Posted on: 2008-05-15 12:09:38 By: Anonymous
Hello Annaya Car COOOOL undhi.... very nice one....!!!! indeed you are becoming younger day by day.... :) thnx for the pictures bye Ashok

No Subject
Posted on: 2008-05-15 12:16:45 By: Anonymous

My Dear friend Kishore,

It was really nice working with you and getting to know you. We had a lots of fun in the past few weeks working together, I know it was tense but we had good times.
Congratulation on your new car “Volkswagen EOS”, I wish you are here in Virginia so we can take a ride together.
I wish you best of luck on your new assignment in SFO and don’t forget about us, you always have friends here. If you get an assignment here in Washington DC area, don’t forget to let us know. We can always get together and enjoy good times.

Good Luck to you and Best Regards,
Nabil

No Subject Posted on: 2008-05-15 12:19:06 By: Anonymous
Go get em Kishore!!!!!! J. We miss very much man J. Hope things alright with you in Cali. Please let us know if you need anything, ok? Take care my friend, Sam Solomon

Hats off !!! Posted on: 2008-05-16 04:18:57 By: Anonymous
Hi Kishore, Salutes to your effort.

hi kishore sir Posted on: 2012-03-19 20:06:20 By: sreekanthdba72
i complted my dba and apps dba course presently im job less im 2010 passed out can u advise how to move forward to get a job

No Subject Posted on: 2008-05-27 17:59:05 By: Anonymous
Dear Kishore Excellent work done man, may god bless you. Best regards, Iqbal…

Re: Posted on: 2008-05-30 01:39:43 By: Anonymous
Really very good site. I also would like to become APPS DBA - Presently working as an ORACLE DBA. Please Guide me Thanks Guru smvguru@yahoo.com

To make a comment Posted on: 2008-06-06 18:08:34 By: akr14feb
Please do use "Comments - Make a comment" - Button, for making comments Thanks

No Subject Posted on: 2008-06-11 04:07:18 By: Anonymous
Hello Kishore.. Hope you are doing very well.... I came across your artical, http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=13 when i was searching for some good job on oracle apps dba...I found your artical very interesting. Really, it needs initiative in our life from your eternal soul and any thing can be achieved.. Cheers.. Hitesh Mishra

Re: Posted on: 2008-06-11 04:13:27 By: Anonymous
Hi Hitesh, Thanks for your comments, All the Best to you. Its really good career plan to move into Oracle Apps 11i DBA and my full support will be there. Let me know if you need any help from me. Its always better if you can clear your 11i or R12 certification which will boost your confidence. R12 is now in beta which costs just $50. I can surely guide you. Regards Kishore

Oracle DBA & Oracle Apps DBA
Posted on: 2008-07-06 14:07:18 By: anoop

Edited By: anoop
On: 2008-07-07 12:44:40

Hello all.
My name is Anup. I want to learn Oracle Apps DBA. Some of my friends are working as Ora App DBAs and they suggested me to go for it. When I asked about that course in some institutions they are suggesting me to first learn Oracle DBA and then do Apps. But my friends have a basic knowledge of Oracle and they said to directly learn Apps. Please give me some suggestion whether I have to learn DBA first & then Apps or directly Apps is OK.

Re: Oracle DBA & Oracle Apps DBA Posted on: 2008-07-08 01:14:32 By: akr14feb
Hi, That's right, first we need to work as Oracle DBA then you will be comfortable working in Oracle Apps DBA that also u need to work in Linux/Unix environment. Its long way to go but you need to plan your career path accordingly and you will succeed. Regards Kishore

What is the difference between oracle DBA & oracle application? Posted on: 2008-07-29 14:18:23 By: Anonymous
What is the difference between oracle DBA & oracle application?

Re: What is the difference between oracle DBA & oracle application?
Posted on: 2008-07-29 23:28:55 By: akr14feb

Edited By: akr14feb
On: 2008-07-29 23:30:56

Well,
Oracle DBA is just maintaining the Oracle database alone, but Oracle Applications is step forward, you have to maintain the Oracle Applications and the Database. Most of the activities are same as Oracle DBA, like taking backups, But here as Oracle Apps DBA, you will be involved in cloning,patching, system adminstration etc. Also, the billing rates are much better then Oracle DBA.

Please go through the below link, what you need to know as a Oracle Applications DBA.

http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=33&MMN_position=28:28

Please do revert for more queries.

Regards
Kishore

Thank you.. Posted on: 2008-08-19 16:46:51 By: Anonymous
It's really motivating me... Thank you Kishore... You have done a great work through it... God Bless You...

Apps DBA
Posted on: 2008-09-14 12:13:52 By: salimka

Dear Kishore
Thank you very much for this wonderful site.
I am Salim , an Oracle Certifed DBA , working in Dubai for the last 9 years. Now ( too late) , I want to learn Oracle Apps DBA. I am not fluent in Linux/Unix , since my all servers were running on Windows ( My bad luck).
Next month I am planning to take my training on Oracle Apps DBA in Chennai ( Ikon Infotceh).Mean time I want to study Unix too. Please put your valuable comments on my career path , so that it will be a good motivation for me.

Best regards
Salim

Re: Apps DBA Posted on: 2008-09-18 08:51:21 By: Anonymous	Edited By: akr14feb On: 2008-11-19 03:52:53
Hi Kishore, Best of Luck for your career and family too.. Thanks Gurunathan

Re: Apps DBA
Posted on: 2011-05-30 16:34:08 By: Farhan

Dear Kishore,
I really appreciate your contribution to Apps Dba community.
I need help i have planned upgrade of R 12.1.1 to latest R 12.1.3 on solaris platform could you let me total no. of number of patches with their numbers required to upgrade from 12.1.1 to 12.1.3.
And one more help require from you i need to upgrade database also with oracle apps currently i have database release 11.1.0.7 to 11.2.0 kindly provide me the document.

Regards
Thanks for your Support
Farhan

Re: Apps DBA Posted on: 2011-06-01 13:38:37 By: Farhan
Dear Kishore i am waiting for your esteemed reply

Re: Apps DBA Posted on: 2011-06-19 22:18:45 By: akr14feb
Please follow the below notes http://www.appsdba.info/docs/oracle_apps/RAC/Install_11gR2_software_upgrade_to_11gR2.pdf http://www.appsdba.info/docs/oracle_apps/upgrades/upgrade_r12.1.1_r12.1.3.pdf

Hello Kishore Posted on: 2008-10-11 00:10:09 By: Sadikb	Edited By: Sadikb On: 2008-10-11 00:11:04
Hello Kishore, I reached your site through a friend and I am quite impressed. I also have an Oracle Forum God Bless and keep writing such wonderful stuff.

Re: Hello Kishore Posted on: 2008-10-11 12:28:48 By: yogeshbhutda
Dear Kishore Thank you very much for this greatefull site.

Re: Hello Kishore Posted on: 2008-10-14 01:11:35 By: Anonymous
Thanks dude

No Subject
Posted on: 2008-10-21 02:35:37 By: Anonymous

Dear Mr.Kishore,

First of all, I sincerely congratulate for maintaining a wonderful site with excellent updates about the e-business suite which provides a wealth of knowledge to the seekers.

I have been a regular visitor of your articles and also been working as an Apps dba in UK. I have a small request for you. I would like to write 11i Apps DBA exam so which one should i write? I am bit confused with the numbers. Is it IZO-233? Since i am a certified 10g OCP dba i think i can write oracle IZO-233 to become 11i ebusiness suite dba. Could you please let me know which exam should i appear for.

Thanks in advance
Raj

Re: Posted on: 2008-10-21 02:35:59 By: Anonymous
Hi Rajasekhar, Thanks for your comments. You can take 1Z0_233 (11i Certification) or you can take 1Z1-238 (R12 Certification - Beta). Which ever you are comfortable. Regards A.Kishore

not able to login ID Posted on: 2009-02-06 15:10:36 By: Anonymous
Hi , IT's really good portal for oracle apps dba. good to see this. but i'm facing the issue related to the login. I've tried to signup for new account. I have type my user name and email id. But still I coluldn't get any kind of mail bywhich i can login to this portal. Will u please help me on this. Thanks.

Re: not able to login ID Posted on: 2010-06-03 07:16:21 By: akr14feb
Let me know your login-id please Thanks Kishore

Strive for the Excellence, Success will chase you… Posted on: 2010-05-28 12:42:36 By: reenab_sai
Hello Kishore Sir, Actually i was googling for some materials on oracle when i came across this site of yours. Its really worth reading. Your's hard work gets reflected & it can be proven as a stepping stone for success for the one who are Oracle DBA's & Oracle Apps DBA's & striving in a quest for sunny days. Appreciating you a lot! Thnx & Rgds Reena Balwant Sangode OCP Certified.

Re: Strive for the Excellence, Success will chase you… Posted on: 2010-06-03 07:20:02 By: akr14feb
Thanks a lot. Regards Kishore

Re: Strive for the Excellence, Success will chase you… Posted on: 2010-06-13 19:58:34 By: neelam
hai kishore sir, Really its very good for apps dba's Thanks for sharing all this stuff Thanks a lot sir

Upgrade 11.5.9. to 11.5.10.2 Posted on: 2010-07-06 07:57:35 By: raammadala
Hi Kishore, I am new guy to apps dba.as per my knowledge this is good site for dba and apps dba's.please post the upgrade doc for me thanks Sreeram

Re: Upgrade 11.5.9. to 11.5.10.2 Posted on: 2010-07-11 14:18:52 By: akr14feb
Thanks, here is the link for the upgrade http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36

Hi Posted on: 2010-08-04 09:24:41 By: simmisahay
Hi Kishore, I was searching some oracle martial on Google and came across this site and seeing your photo I recognized you. I am really appreciating your achievement. Have you recognized me? I got experience on oracle 10g development side. I want to go for oracle DBA. Please suggest which is good oracle appa DBA or Oracle10g DBA. Simmi Sahay simmisahay@gmail.com

Re: Hi Posted on: 2010-09-01 16:12:57 By: akr14feb
Hi, Its always better to know Oracle 10g DBA then only u need to get trained on Oracle Apps DBA, Revert for further queries. Regards A.Kishore

kaleem pasha Posted on: 2010-09-23 11:02:18 By: kaleempasha
can anyone help me in learning different configuration files for oracle apps r12

No Subject Posted on: 2010-09-23 11:37:05 By: kumarsdba
Dear Kishore, I hope you are doing fine, your sites seems to be very nice and useful for everyone please try to send printer configuration (windows samba) details at the earliest

Nice document Posted on: 2010-09-23 11:40:15 By: kumarsdba
Hi, I never read this type of documents very nice you updating each and everything with screen shots also it's good

Re: Nice document Posted on: 2012-10-05 09:53:54 By: akr14feb
Thanks a lot Regards Kishore

oracle HRMS Posted on: 2010-10-13 00:27:31 By: shakir
Hey, Could plz tell me somethin about ORACLE HRMS..I'm new to this.

oracle application Posted on: 2010-11-03 15:33:23 By: raghavendrachari
hi, I am raghavendra , I just completed MS(IT) , i am interesting to learn Oracle Apps R12 Technical and looking my career in Oracle Stream. But some one suggest learn Oracle Apps DBA instead of R12 technical.which one is best for my career. Can u plz suggest. thank you

Re: oracle application Posted on: 2010-11-07 07:03:55 By: akr14feb
Hi, Both are different fields, you need to decide, one is developer path and second one is DBA path, for DBA path its better to learn Oracle DBA, Oracle Apps DBA, Oracle RAC DBA, Streams etc..... For Developer path, Developer forms, Oracle Apps Technical, OAF, XML/BI Publisher, SOA etc.... Thanks Kishore

Re: oracle application Posted on: 2010-11-08 10:14:00 By: raghavendrachari
thanks, can you suggest me which is having good career for freshers.In my masters program i did projects on Java, Web Technologies,MySQL, and Apache 2.X.

Re: oracle application Posted on: 2010-11-10 07:05:38 By: akr14feb
Both are good fields, whether to go development or adminstration our interest should match. I have seen MS students have selected either of the fields and are succesfull I have no idea about java technologies Revert for further queries. Kishore

Re: oracle application Posted on: 2011-06-22 14:08:29 By: syed_apps_dba
Hello kishor, My name is Syed, I am new to oracle DBA and oracle Apps. My total experience in IT is 7+ but I started working on oracle platform from past 3 months. I request you help me in getting more knowledge on Oracle Apps. I have registered in www.appsdba.info and my login name is syed_apps_dba Regard, Syed

wanted cvs Posted on: 2010-12-27 22:40:21 By: kasulananth
As i am working Oracle APPS, i want to add fusion middleware admin + 10g AS admin concepts in my cv, can u tell me /give me the roles & responsibilities of the above said roles i.e., FUSION MIDDLEWARE ADMIN + 10g AS ADMIN

Hi Welcome
Posted on: 2010-12-30 17:08:02 By: arief

Edited By: arief
On: 2010-12-30 17:11:21

wishing

Hi I am Arief. In an oraganization i am going to start my career as apps dba (currently under training) and i am confused abt apps dba .I heard abt Kishore sir . if i need any help can i consult u and acees ur site for getting info .pls help me to be a good apps dba . tHIS NEW yEAR WITH LOTS OF HOPES AND JOY. I am entering into a n New world of apps dba ...loking for ur support...

HAPPY NEW YEAR Sir and to all my collegues

Thanks & Regards
Arief

Re: Hi Welcome Posted on: 2011-01-12 13:21:33 By: akr14feb
Sure, All the Best for your New Job. Please post your queries me @ akr14feb@gmail.com Regards Kishore

printer tray selection with CUPS, PASTA, and postscript Posted on: 2010-12-31 04:27:19 By: 351c
I am trying to get information on best practices for printer tray selection with a Linux, CUPS, PASTA, postscript, and R12 configuration. I have read some information about solutions with CUPS and possibly BIP. Can anyone suggest a solution for printer tray selection for this type of configuration? Thanks.

its an inspiration Posted on: 2011-01-06 12:54:24 By: rajeshv
thanx a lot

career for Ora apps technical? Posted on: 2011-02-02 04:05:24 By: raghavendrachari
Hi kishore, How is the career in Oracle apps r12 technical? I heard Oracle is developing a standard Applications with Java as front-end and so in future no career for Ora-apps technical. Is this information correct? I am seeking my career in Oracle Apps developing.Could you please clarify my dought? regards, Raghavendrachari

Re: career for Ora apps technical? Posted on: 2011-02-02 08:31:00 By: akr14feb
Career in Oracle Apps technical is good, focus on OAF, SOA, XML/BI Publisher, Jdeveloper etc Please revert for further queries Regards Kishore

Required documents for adsplicing Posted on: 2011-04-03 22:28:44 By: sreenathareddyg
Hi kishore, Can u provide docs for adding a new product to oracle applications i.e adsplice.......

Re: Required documents for adsplicing Posted on: 2011-04-06 19:17:39 By: akr14feb
Here is the link - AD Splicer with example http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=18&MMN_position=8:8

Need Docs on Apps dba functional Posted on: 2011-05-02 01:33:53 By: sri
Hi Kishore, Your site is really informative. I need some info on regular DBA activities on functional side. And also some docs to learn - Performenance tunning / Indexes / Views and Adhoc reporting. I really need them very badly...appreciate your help...many thx

Re: Need Docs on Apps dba functional Posted on: 2011-05-16 23:14:26 By: sri
Hi Kishore, Did you get a chance to look at the info I requested. If possible would you please send me your phone number to my mail (sri.narayana11@gmail.com) id - I can call you and explain my problem am facing at my client place....really urgent....Appreciate your efforts...many thx

Re: Need Docs on Apps dba functional Posted on: 2011-06-02 07:11:52 By: akr14feb
I have a send mail, please check

Splendid and Greatly enriching website Posted on: 2011-05-12 13:14:48 By: satishmc
Great effort, thanks a Lot Kishore. Many folks out there like me will benifit a lot from your expertize shared.

ADS Sync with Oracle EBS r12 Posted on: 2011-05-31 18:00:13 By: krunal1986
HI, Is there any document which provide details about synching microsoft ads server with ebs r12. need ur help regarding it. Regards Krunal

Re: ADS Sync with Oracle EBS r12 Posted on: 2011-06-02 07:12:28 By: akr14feb
I have send a mail, please check

Is it good to start career in Oracle Apps DBA Posted on: 2011-06-30 16:13:26 By: Satyabrata_Behera101	Edited By: Satyabrata_Behera101 On: 2011-06-30 16:13:54
Hi Kishore, Thank you for your all effort. I hope this site will help all the Apps DBAs. Hey kishore I am fresher to the IT industry & now I am going to start my career with Oracle Apps DBA. Am I on my right path or not??? Can you give me some information as I am about to start my career in Oracle Apps DBA. Should I take this oppertunity or not??? Thanks & Regards, Satya

Re: Is it good to start career in Oracle Apps DBA Posted on: 2011-07-06 17:13:35 By: akr14feb
Yes, you are on the right path, but the path has many obstacles, step by step you need to follow to get success > Oracle DBA > Linux/Unix Adminstration > Oracle Apps DBA Shoot a mail at akr14feb@gmail.com for more any queries. All the Best !!! Regards Kishore

hi kishore
Posted on: 2011-07-08 09:44:27 By: srregatireddy

I am trying to install oracle apps R12(x32) on oracle EL 5 (X32).

After installation and during post installation checks "HTTP" failed

Here is the error message:

HTTP
checking URL = http://home.srihome.com:8000
RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Virtual Directory
RW-50015: Error: - Http Server Virtual Directories is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Login Page
RW-50015: Error: - Login Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

Help Page
checking URL = http://bronze.gateway.2wire.net:8003/OA_HTML/help
RW-50015: Error: - Help Page is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

JSP
checking URL = http://bronze.gateway.2wire.net:8003/OA_HTML/jtfTestCookie.jsp
RW-50015: Error: - JSP is not responding. The service might not have started on the port yet. Please check the service and use the
Can you please help me how to rectify this?

Re: hi kishore Posted on: 2011-07-08 14:46:00 By: akr14feb
This is known error in RHEL 5 or OEL5 connect as root - ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2 Now start the apache

Re: hi kishore Posted on: 2011-07-10 11:46:02 By: srregatireddy
Is that error related to RAM SIZE also?Because my friend told that RAM size is less..I am using 3GB RAM.

Re: hi kishore Posted on: 2011-07-10 11:48:41 By: srregatireddy
What is the minimum RAM size need to install oracle apss dba r12?

Re: hi kishore Posted on: 2011-07-13 10:12:13 By: srregatireddy
Same error is coming again!!!!!!!

Re: hi kishore Posted on: 2011-07-16 07:25:36 By: akr14feb
3 GB should be enough, send queries to akr14feb@gmail.com Will try to fix the issue. Kishore

Needed the steps involved in Demantra integration with EBS Posted on: 2011-07-26 21:57:32 By: raghu
Please help me in this, I want a step by step explanation for the integration process between EBS R12 and Demantra. Please take an example item information. This data has to pass to Demantra. Please explain me, that would helps me a lot. Thanks in Advance Raghu

Re: Needed the steps involved in Demantra integration with EBS Posted on: 2011-08-02 08:35:08 By: akr14feb
I can help with the Integration of EBS with Demantra but the data population is normally done by the technical guys Regards Kishore

Agile plm 6.0 installation. Posted on: 2011-08-05 16:59:12 By: anandkumar99
Hi Sir I am trying to install Agile plm 6.0 on windows server 2008.But I am getting some issues.could you please provide any documentation OR any screen shots. Thanks&regards ANAND

Re: Agile plm 6.0 installation. Posted on: 2011-08-11 15:59:14 By: akr14feb
Try the below, hope it helps http://www.appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=60&MMN_position=56:56

oracle apps dba R12 installation Posted on: 2011-08-23 08:37:24 By: rizwanappsdba
I need to install Oracle EBS R12. I have many Oracle EBS R12 Stages on Shared Storage disk. From which file I can know whether a particular Oracle EBS R12 Stage is for Windows, Linux , Solaris or HP-UX. I will be thankful for your if u could help me.

You are the MAN Posted on: 2011-08-31 01:05:37 By: bnikhil08
Seriously you are great motivator. You are the MAn for me.... and your website ROCKS... can i have your contact number. i would LOve to speak to you. Nikhil bnikhil08@gmail.com +91-9949521842

windows server and linux client connection by ADS Posted on: 2011-10-15 15:11:09 By: anoopkp	Edited By: kanagamanian81 On: 2011-11-02 07:44:03
HI Kishore we have plan to connected the linux client user to windows server 2008 ADS . you have any idea Pls help ....

OPP Error
Posted on: 2011-11-12 02:22:44 By: deepakkumar

Hi All,

We are a mid range Oracle EBS client running on R12.0.4. We have a major issue with OPP process. Any PDF/Excel reports are failing with the following error.
Executing request completion options...

+------------- 1) PUBLISH -------------+
Beginning post-processing of request 15383132 on node ERLOPD1 at 09-NOV-2011 14:50:55.
Post-processing of request 15383132 failed at 09-NOV-2011 14:51:52 with the error message:
One or more post-processing actions failed. Consult the OPP service log for details.
+--------------------------------------+

Here are our details...
we are on R12.0.4 -- x86 / Redhat Linux 64 bit.
We tried increasing the memory at Conc Prg level.
Our developer parameters J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m.
Jave heap size is set to 2GB.

Any sugesstion will be greately appreciated.
Thank you

Oracle dba & apps dba Posted on: 2011-11-23 12:34:43 By: ganeshdba
Hi I like this site and would like to join this forum.

adpreclone.pl error
Posted on: 2011-11-30 16:15:20 By: vnarasimharao11

Edited By: vnarasimharao11
On: 2011-11-30 16:17:12

Hi All,

I got this below error when i run adprclone.pl on database tier.

OS:RHL4.0
Application version:12.0.6
Database :10.2.0

RC-50208: Exception in method gen_SQL_script
Raised by oracle.apps.ad.tools.AdCreateCtlFile
RC-50208: Exception in method gen_crctrf_sql
RC-50208: Exception in Constructor AdCreateCtlFile
Raised by oracle.apps.ad.tools.AdCreateCtlFile

StackTrace:
java.lang.ArrayIndexOutOfBoundsException: 1 >= 1
at java.util.Vector.elementAt(Unknown Source)
at oracle.apps.ad.tools.AdCreateCtlFile.parse_file_list(AdCreateCtlFile.java:2006)
at oracle.apps.ad.tools.AdCreateCtlFile.gen_SQL_script(AdCreateCtlFile.java:1834)
at oracle.apps.ad.tools.AdCreateCtlFile.gen_crctrf_sql(AdCreateCtlFile.java:868)
at oracle.apps.ad.tools.AdCreateCtlFile.(AdCreateCtlFile.java:413)
at oracle.apps.ad.clone.StageDatabase.genRecreateScripts(StageDatabase.java:617)
at oracle.apps.ad.clone.StageDatabase.doStage(StageDatabase.java:332)
at oracle.apps.ad.clone.StageDatabase.(StageDatabase.java:292)
at oracle.apps.ad.clone.StageDBTier.(StageDBTier.java:153)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
at java.lang.Thread.run(Unknown Source)

RC-40001: Failed to create sql script adcrdbclone.sql for recreating control files at target
Raised by oracle.apps.ad.clone.StageDatabase

Pls help

Regards,
Narasimharao

Re: adpreclone.pl error Posted on: 2011-12-04 22:16:58 By: akr14feb
Is is cold cloning, if yes check whether the database was shutdown in normal mode

Contact information
Posted on: 2011-12-22 01:58:42 By: spavlovsky

Hi Kishore,

I was reading you post and I can tell you know a lot about Oracle. I'm a recruiter for a Steel company in the United States and we have many positions available that requires Oracle experience. I'm not an expert in this matter and I was wondering if you might be able to help me.

This is my email address sol.pavlovsky@myrecruitmentservices.com, if you have a couple of free minutes would you send me an email with your contact information so we can talk about it?

Thank you!

spavlovsky.

Upgrading EBS 11i to R12.1.1
Posted on: 2012-01-08 19:18:33 By: sameer_dba

Hello
Kishore sir

First of all i would like to congratulate you for providing the information to the people all over the world. You are doing a great job. sharing knowledge is not possible for everybody only great souls does.

Sir i am a fresh dba and i want to upgrade from EBS 11i to R12.1.1 and kindly can you send me the document with details and commands to operate the steps.
1. Pre-update steps (with commands)
2. update steps with commands
3. Post-update steps with commands
my email id: getsameer57@yahoo.com

basic info:
platform:oracle enterprise linux 4 update 4
database:9.2.0.6.0
application: 11.5.10.2

Thanks with anticipation

Re: Upgrading EBS 11i to R12.1.1 Posted on: 2012-02-23 16:55:02 By: akr14feb
Please go through this link http://appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=48&MMN_position=36:36

output post processor issue Posted on: 2012-01-14 18:47:42 By: sameer_dba
Hello sir After cloning on test server i found everything correct. then i executed FND_CONC_CLONE.SETUP_CLEAN; then i run autoconfig on database server and on application server both. after that i found output post processor actual=0 target=5 in apps 11.5.10.2

Oracle Identity Mangement Posted on: 2012-01-17 11:56:13 By: Farhan
Hello, Kishore i am very much excited by visiting your appsdbainfo blog's contribution for apps world. I need information regarding Oracle identity management. what contents it has,its benefits with oracle apps,its purpose for apps dba's Your prompt reply will be highly appreciated. Regards Ibrahim India

Hi kishor Posted on: 2012-01-21 19:20:42 By: amit_apps
well Kishor I'm working as a Sr. Principal consultant with Oracle corp. I want moved on Oracle apps technical as soon possible, I already taken training of Oracle Apps technical for one of the Delhi Institute & also having a good knowledge of SQL, PL/SQL, oracle apps, D2K. and till the time not able to select which module would be good for more please help me out. Amit Kumar

Lib Posted on: 2012-01-22 17:42:00 By: engalim
Hi I face a problem when i try to apply patch after clone the PROD, I got the following error when i try to enable mint. mood error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory Best regards, Ali

apply maintenance patch to 11.5.10.2
Posted on: 2012-01-28 08:51:38 By: summerkool07

Edited By: summerkool07
On: 2012-01-29 10:13:41

Hi Kishore as said above i have searched many docs an d metalink for upgrading from 11.5.9 to 11.5.10.2 i understood it but i can't implement, am still a learner so i dont know how to start please help... my email:summerkool07@gmail.com

Hi Kishore,
I usually visit this site and this is very informative and really appreciate for the Knowledge sharing...
Am looking for applying maintenance patch to 11.5.9.2 to upgrade to 11.5.10.2 please provide the solution for same
any help...
thanks

Re: apply maintenance patch to 11.5.10.2 Posted on: 2012-02-23 16:57:57 By: akr14feb
Please shoot a mail to akr14feb@gmail.com Regards Kishroe

Oracle Identity Mangement Posted on: 2012-01-30 14:29:17 By: Farhan
Hi, Kishore i need your help in oracle identity management . Please share info about Oracle identity Management. Your reply will be highly appreciated.. Regards Farhan

Re: Oracle Identity Mangement Posted on: 2012-02-24 23:53:39 By: akr14feb
Please shoot a mail, I shall guide you..

guide me
Posted on: 2012-02-12 22:15:26 By: sudheer

sir,
i am doing my btech 3rd year in ece.I want to do ms in cse i have learnt sql/plsql(can you tell me is this course useful in my way to become dba) and shortly going to undergo dba course.sir can you please guide me what courses i have to take after completing dba course and i am intended to get oca and ocp certifications so please guide me about this certifications and suggest me some tips to pave a path from a btech ece student to a dba.

Re: guide me Posted on: 2012-02-22 18:36:47 By: bhargav
Hi, i am very much interested to do certification on oracle apps dba.So, i want to know what exams i have to clear before making a attempt on oracle apps DBA. I have learnt linux5.5,sql,Oracle DBA and apps DBA. Hope You can help me...Thanks to this website developers

Re: guide me Posted on: 2012-02-23 16:53:38 By: akr14feb
Plese go through this link http://appsdba.info/index.php?module=pagemaster&PAGE_user_op=view_page&PAGE_id=47&MMN_position=35:35

Re: guide me Posted on: 2012-02-23 16:56:54 By: akr14feb
Hi, Start with Oracle DBA, linux etc once you are confident, go for certification, then you can try Oracle RAC or Oracle Apps DBA Thanks Kishore

Oracle Apps clarification
Posted on: 2012-02-28 16:27:18 By: srieros

Edited By: srieros
On: 2012-02-28 16:27:46

Hello kishore,

I am working as a Oracle DBA i have 2 yrs of experience. I would like to build my career as a Oracle Apps DBA. Please let me know if i am making the right choice or not(by opting for Oracle Apps DBA)???

In my current organisation there is no Oracle Apps DBA vacany, so once i get myself trained in Oracle Apps i have to move out to another concern.So am i a bit nervous thinking if i could get a job in Oracle APPS DBA, as i have just 2 yrs of experience that too in Oracle DBA.
And finally please suggest a good training centre for Oracle Apps DBA in chennai.

Your website is really great, many thanks for your help.

Regards,
Sri

Re: Oracle Apps clarification Posted on: 2012-03-07 21:13:18 By: akr14feb
Sure, it would great if you could update to Oracle Apps DBA, shoot a mail to akr14feb@gmail.com. Regards Kishore

i need your help plz guide me: Posted on: 2012-03-11 15:48:51 By: namrata
sir, my name is namrata sharma and i got through mca in dec 2011 from ignou. i want to make my career in oracle but i am confused that what should be my first step???? please help me

Re: i need your help plz guide me: Posted on: 2012-03-14 21:08:34 By: akr14feb
Hi, To start a career in Oracle Database Administration, here are the steps > start with Oracle sql/plsql > Oracle DBA > Gain knowledge on Linux/Unix Have a system at your place, install and practise these topics. Let me know for further help Regards A.Kishore

Hi Posted on: 2012-03-24 12:38:58 By: lsh
Hi kishore, im new to this site,i complted my Oracle apps course, presently im job less now im trying on Oracle apps,i have 3yrs gap, now i want to change my field,so now i need Oracle apps projects and resume format also,can u advise me how to move forward

No Subject
Posted on: 2012-04-02 07:48:16 By: Shiva

Hi Kishore,

Thanks for sharing your knowledge and experience with us.this is a great site and very informative specially for starters who are looking for information about orcale apps.

I have found this blog when trying to get some information about orcale apps and its really good place to be here. I have done my Masters in IT from Australian university and how looking to do specialisation in any field and move on with it.through one of my friends suggestion i have started thinking of doing orcale apps ,but i have no idea where to start, how to start and how to prepare.

kishore can you please guide me through this and help me out in building my career.

thanks
Shiva

Re: Posted on: 2012-04-07 10:03:13 By: akr14feb
Welcome to the world of Oracle Apps Well to gain knowledge of Oracle Apps, here are steps > Oracle DBA > Linux/Unix Administration > Oracle Apps DBA All the Best !!! Revert for further queries

oracle dba Posted on: 2012-04-05 11:59:49 By: ekta
hello sir, i m doing the core dba course.pls tell me wat is oracle apps dba and pls give knowledge about oracle modules.i want to become an oracle dba but also wants to know little knowldge abt oracle apps modules.

Re: oracle dba
Posted on: 2012-04-07 10:08:45 By: akr14feb

Hi,

You are mixing Oracle DBA and Oracle Apps funcationals modules, a Oracle Apps DBA need not know about the Apps modules, there are different people working on Oracle Apps

> Funcational Consultants / Apps Domains Analysts / business Analysts
> Technical Consultants
> Oracle Apps DBA / System Adminsitrators
> Linux / Unix Adminstrators

Each area is a ocean and you need to choose the right path, for a Oracle DBA, Oracle Apps DBA is related where he works on below activities

> Installation
> Patches
> AD Administration
> Cloning
> System Adminstrations
> Upgrades
> Backups etc

Revert for further queries

future guidance
Posted on: 2012-04-13 19:06:21 By: sunil_t

Hi sir,I am sunil,currently working in mahindra satyam as a network administrator.I have been looking your posts since a long time and they inspired me a lot.you are simply amazing.
I felt that this is the right place for my queries to be answered.
I am B.SC(comp. science) graduate.Do i have any opportunities to become a Oracle DB administrator with my degree.If so what how can i be?
here is my profile for your reference.
Educational qualification:B.SC.(Comp.science,2010 passedout)
occupation:network administrator in mahindra satyam since 2011.
awaiting your valuable response.
thank you.

regards,
sunil kumar

Re: future guidance Posted on: 2012-08-14 21:44:19 By: akr14feb
Sure Sunil, you can become of Database Administrator, most of my friends with Bsc/Bcom have entered have are good positions Send me a mail to akr14feb@gmail.com for further queries A.Kishore

please guide me Posted on: 2012-04-17 17:00:25 By: akkapalli	Edited By: akkapalli On: 2012-04-17 17:02:54
hi kishore sir im not able to my login home page from my windows internet explorer i installed apps r12 on vmvare ans services are successfully started apps and database pinging each other linux and windows

Re: please guide me Posted on: 2012-08-14 21:45:52 By: akr14feb
Have u made entries in the hosts file in windows c:\windows\system32\drivers\etc hosts files

oracle apps dba Posted on: 2012-04-30 16:42:42 By: mallikarjunreddy	Edited By: mallikarjunreddy On: 2012-04-30 16:47:16
Hi Sir, I am mallikarjunreddy working as a core oracle dba in small company.Here i don't have much work to do.I am not able to decide myself either to learn RAC DBA OR APPS DBA and iam having just 1.7 years of experence.kindly please give me advice wheather I should go for oracle dba rac course or apps dba. Thanks, mallikarjunreddy9985@gmail.com

Re: oracle apps dba Posted on: 2012-05-10 10:36:41 By: akr14feb
If you ask me, I would say go for Oracle Apps DBA, shoot me a mail @ akr14feb@gmail.com for more details Regards Kishore

Re: oracle apps dba Posted on: 2012-07-23 19:33:23 By: shahzad53
sir, curent i am working as a oracle core dba in saudi arabia, planning to become apps dba but some of my friends telling me that before appsdba course you should have minimum knowledge to oracle application server 10g after that you study appsdba course, Kindly guide me. Regards, shahzad Khan Saudi Arabia.

Re: oracle apps dba Posted on: 2012-10-05 09:53:17 By: akr14feb
I don't think so, for learning Oracle Apps DBA, u need Oracle DBA on linux or Unix platform with 1 to 2 experience Regards Kishore

Re: oracle apps dba
Posted on: 2012-08-31 20:01:24 By: murthy

Edited By: murthy
On: 2012-08-31 20:03:09

for mailid addition

HI, I am working in wipro infotech as a systemadmin/database admin from past 4 years. I have competed OCA and taken training on oacleappstechnical11i earlier.I completed M.B.A

Here i don't have much work on oracle in this project. I am not able to decide myself either to learn oracleappsdba or SAP BASIS. my mail id is ramana.chaganti@yahoo.com
Please suggest us to better career.

Apache Posted on: 2012-06-18 12:58:02 By: kumar777
1) How will check Apache is working in Front-end and Back End? 2)Write down the methods to identify whether the application is in maintenance mode or not? 3)What happens when the result of unsetting APPLCSF? 4)What are the tables updated when you apply application patch? 5)How Application login works? 6)How to change the HTTP port in R12?

Recovery Issue
Posted on: 2012-07-18 21:37:45 By: oradbase

Edited By: oradbase
On: 2012-07-18 21:39:55

Excellent job, Really I Appreciate you for sharing great Knowledge.

Currently I facing a problem in Recovery.

One Month back I perform Complete Cold Backup.

DB Server Crash , DB is in Archive Mode i have all Archive Logs & Current Control File.

I Prepare New Server with Same IP , HOSTNAME , USERs & Groups , & same path location for oracle home , I install Oracle Software.

Restore Last Month Cold Backup to appropriated path.

The Main Problem is one non-system datafile is corrupt in cold backup, while recover i am getting porblem.

1) i Have last Month Cold Backup but non-system DBF is Corrupt.

2)I have all Archive Log Files

3) I have Current Control File.

I try , start instance in mount by using current controlfile & offline corrupted dbf & Move corrupted dbf.
SQL> i create new datafile with same name
then try to recovery.

Still i am getting problem.

Can you please Send me Step by Step on this Scenario

Regards,
OraDbase

Please provide 1Z0-238 study material. Posted on: 2012-08-16 12:58:32 By: mbaliyan
Hi Kishore, This is very usefull forum to learn. I want to go with oracle apps certification EBS R12: Install, Patch and Maintain Applications - 1Z0238. Please provide softlink for study material or derictly mail this to my mail id : mkb.simi@gmail.com or baliyan.mkb@gmail.com

Problem with Apps os user while installing Posted on: 2012-09-20 19:41:15 By: ashok
Dear Kishore, I got same user for DB OS user and APPS OS user at the time of installation.Can you clear this problem. Regards, Ashok

Re: Problem with Apps os user while installing Posted on: 2012-09-27 20:36:25 By: murthy
hi, I Completed MBA(Finance & marketing) and also completed OCA 9i. I Have 4+ years experience as a IT administration but don't have bachelor computer degree. I am interestin to learn oracledba & apps dba Please suggest us for can i choose my career path as ORACLE DBA or APPSDBA. Please suggest us. Thanks&Regards Murthy 9959226779

Upgradation Doubts 11i to R12 from danesh khan
Posted on: 2012-10-03 17:42:39 By: akr14feb

Edited By: akr14feb
On: 2012-10-03 17:49:40

Hi Kishore.

This is Danesh, new to world of APPS i had seen your blog its good & informative.

I started interviews in Apps. because in institutes they will not tell the proper up-gradation and real-time scenarios.

I am having some doubts in 11i to R12 upgrade pls check.

1. During upgradation why we have to drop MRC schema?

2. Why ADI patch is required?

3. Why ATG patches required?

4. why we have to create or increase the size of tablespaces & which tablespaces we have to create? during upgrade?

5. why we have to apply autoconfig patches? because autoconfig is already present?

6. Can i practice a basic upgrade in my laptop from 11i to R12? what i need?

7. why we have to apply patchset 19 for developer? for 11i what is the patch version for developer?

8. we have to increase the block size also during upgrade?

9. What are symbolic links? when it is required?

10. One of my friend said every upgrade is different what it mean?

Danesh,

Here are my responses

1. During upgradation why we have to drop MRC schema?

Kishore - if you are upgrading from 11.5.9 or 11.5.10.2 to R12 we don't MRC, I am not sure with earlier version. I think that schema is not available in 11.5.9 or 11.5.10.2

2. Why ADI patch is required?

Kishore - See these threads/docs.

version of ADI release?
http://forums.oracle.com/forums/thread.jspa?messageID=4234809

Note: 144270.1 - How to Find ADI (Applications Desktop Integrator) Patches on My Oracle Support?
Note: 184090.1 - How to Find and Download the Latest Applications Desktop Integrator (ADI) Patches via Metalink
Note: 382973.1 - How to Get the Latest Version of ADI Patches From Metalink

Thanks,
Hussein

3. Why ATG patches required?

Kishore - If you want 11.5.10.2 to work with 11g database then we apply interoperability patches, ATG rollup 7 is mandatory before you can upgrade

4. why we have to create or increase the size of tablespaces & which tablespaces we have to create? during upgrade?

Kishore - 11.5.9 follow "one product -- one schema", R12 uses OATM techonology, In OATM fewer tablespaces are used, patch 7197489 has more details which creates the necessary tablespaces.

5. why we have to apply autoconfig patches? because autoconfig is already present?

Kishore - It is always advisible to keep autoconfig patches to the latest, this may be a pre-req for other patches

6. Can i practice a basic upgrade in my laptop from 11i to R12? what i need?

Kishore It depents on the configuration you have, if you have 4 GB with 400 GB HDD u can try

7. why we have to apply patchset 19 for developer? for 11i what is the patch version for developer?

Kishore - This is pre-req, if you are upgrading the database to latest version. Refer interoperability patches note

8. we have to increase the block size also during upgrade?

Kishore - I have never done during my upgrade experience

9. What are symbolic links? when it is required?

Kishore - In computing, a symbolic link (also symlink or soft link) is a special type of file that contains a reference to another file

If you install R12 on Oracle Enterprise linux, apache fails and here is the solution

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Also, we create a symbolic link for the Apps environement file as follows instead of copying it

APPSEBS.env -> /d02/oracle/EBS/apps/apps_st/appl/APPSEBS_linux1.env

10. One of my friend said every upgrade is different what it mean?

Kishore - Yes, your friend is right, I have done 5 upgrades and each was different experiences, one was 11.5.9 to R12.1.3, other was OS upgrade AIX to Linux and Application upgrade from 11.5.10.2 to R12.1.3. The experience count but it may slightely vary.

Have a Great Day !!!

Queries from Sohail
Posted on: 2012-10-03 18:11:43 By: akr14feb

Query 1

Hi Kishore.

This is Sohail fresher to APPS hunting for a job. It was nice to see your blog its very informative.specially patching & Cloining.

i have some doubts pls clear.

1. when i submitted Active users request only the result is displaying request submitted sucessfully. i think this request is submitted to check how many acitve users are connected to the application.

purpose for submitting this request.

Thanks in Advance.
Sohail

Here is my responses

Hmm, the Active users - only will let us know the Active users in out database but not connected users

Use the below link to the connected users

http://onlineappsdba.blogspot.in/2008/05/count-total-number-of-users-connected.html

Thanks
Kishore

Thank u kishore

Sohail

Query 2

Hi Kishore,

Hope you are fine, pls check this doubt.

In one of my friends company every first week of the month they are running Accounting report from front end.

which is generating huge archive logs and they are increasing space also in archive logs destination.

They are using R12.

My doubt is just to understand this business application.

1. What is this accounting report & when to run this accounting report.
2. Why it is taking more space in archive log destination.
3. Accounting report is a request which will submitted by the application users ?

Pls clear this.

Regard's.

Kishore

Honestly for a Apps DBA it doesn't matter what report they run, if they require space we just add them, there ends the story, we don't really care what a program does.

Thanks
Kishore

Thank u somuch
Sohail

Query 3

Hi Kishore.

Hope you are fine.

1. what is the difference between EXADATA & Oracle E-Business Suite?

2. what is the difference between ORACLE10g AS & Oracle E-Business Suite?

Today i given one interview on core dba this company is having very large setup they said & they are maintainng

Exadata & Oracle10g AS.

Hi -

Oracle Exadata is a database appliance with support for both OLTP and OLAP workloads. It was initially designed in collaboration between Oracle Corporation and Hewlett Packard where Oracle designed the database, operating system (based on the Oracle Linux distribution), and storage software whereas HP designed the hardware for it

ORacle EBS is for maintaining Oracle Applications like Oracle Finiancials , ORacle HRMS , Oracle manufacturing etc

ORACLE10g AS is an application server mainly for http requests..., now it is been replaced by Fusion middleware - Weblogic Server

Thanks
Kishore

Query 4

1. Where apps passwd stores in R12?

Kishore - apps password is not stored in Oracle R12

2. How to clone a application in 11i & R12 if your application contains Custom Top? pls tell the steps.

Kishore - Clone steps remain the same for custom top, for custom top u only do one change

cd $APPL_TOP

-- create and modify the location in the below file

customDEV_racerp.env

Thanks & Regard's,

Sohail.

Query 5

1. Dataguard protect your database save how you protect the application can we configure data guard in oracle application to save from disaster recovery?

( Interview Question)

Thanks & Regard's,

Sohail.

Hi Sohail,

for apps tier, every one hour we just sync files from PROD to disaster recovery site, we actually use rsync command, which will only copy the changed values

Kishore

Hi Kishore,

Thanks for your reply. before runnning this rysnc command how we have to configure data guard in application level?

i know how to configure dataguard in database level.

Pls tell me the steps how to do this. this is an interview question asked me france bank. i need the steps pls.

Hi,

The below commad is the syntax for rsync, which does a smart copy, the command can be scheduled to run evey one hour

rsync -rltp -v prodappl /x06/oracle/testssc/ &
rsync -rltp -v prodcomn /x06/oracle/testssc/ &
rsync -rltp -v prodora /x06/oracle/testssc/ &

Regards
Kishore

Thanks Kishore. for resync doubt

Sohail

Query 6

Hi Kishore. Hope you are fine. pls check these doubts in Cmclean.

1. what is the difference between cmclean.sql and EXEC FND_CONC_CLONE.SETUP_CLEAN;
2. where is the location of cmclean.sql script?
3. why after running cmclean we have to give commit;
4. When to run cmclean.sql ?
5. when to run EXEC FND_CONC_CLONE.SETUP_CLEAN ?

Regard's,
Sohail.

1. what is the difference between cmclean.sql and EXEC FND_CONC_CLONE.SETUP_CLEAN;

cmclean is normally used when cm doesn't come up, EXEC FND_CONC_CLONE.SETUP_CLEAN will clean fnd_nodes tables after we run autoconfig on db and apps tier which populate the table

2. where is the location of cmclean.sql script?

cmclean is available at Oracle Metalink, attached the same

3. why after running cmclean we have to give commit;

it cleans the concurrent requests which are either lost which are called runaway processes or not completed, once we run this scripts it fixed this issues and we do need to commit to make the changes permanent

4. When to run cmclean.sql ?

when cm is not coming up, sometimes we bring down the database without shutting the concurrent processsion server, all the requests are in middle, the cm not come up, so you need to run cmclean to make this requests closed so that cm can come up

Sohail

Hi Kishore

You Said..

Cm clean is normally used when cm doesn't come up Ok its fine.

1. But still not understood why to run this EXEC FND_CONC_CLONE.SETUP_CLEAN you said it will clean fnd _nodes tables after we run autoconfig.

what it will clean from fnd _nodes ?

2. After running cm clean we have to run this EXEC FND_CONC_CLONE.SETUP_CLEAN or plstell me the sequence of running this two commands?

3. How we have to run cmclean after downloading from metallink from which node and what is the syntax? & what are the prerequisites. like in your attachment i read we have to

bring down concurrent managers.....

EXEC FND_CONC_CLONE.SETUP_CLEAN is only used for when you clone from PROD to TEST or when database name is changed.

cmclean is used when cm doesn't come up

bring down application, all concurrent managers should be down

now run cmclean.sql connecting as apps user

Sohail

NOW ITS CLEAR

Re: Queries from Sohail
Posted on: 2012-10-05 09:40:27 By: akr14feb

1. OATM feature is it club all the tablespaces into 14 tablespaces i think?

pls explain OATM how it reduces the burden on application and how easy for apps dba to manage by comparing to
old version of tablespaces ?

Kishore - For apps version 11.5.10 and older, each product had one tablespace, using OATM u can convert tablespaces to fewer tablespaces, in net u should get the information, we did for couple of clients

2. can i add datafile or resize APPS_TS_TX_DATA ?

Kishore - Yes, we normally suggest 20% fee space, if it is less then we add datafile

3. if data is inserting on a datafiles which is connected to APPS_TS_TX_DATA and that datafile table is indexed

how APPS_TS_TX_IDX will grow my doubt is how rapidly APPS_TS_TX_IDX will grow?

Kishore - Why you are worried about it, we normally have maintain the database leave other to Oracle to maintain

5. How to administrator APPS_TS_TX_IDX tablespace like adding or rebuilding indexes?

Kishore - The same way you do for any tablespace. For adding we use the below command

alter tablespace APPS_TS_TX_IDX add datafile '/d01/oracle/TEST/db/apps_st/data/a_txn_ind19.dbf' size 200m autoextend on next 200m maxsize 2000m;

Doubts in Forms & Reports - RAJ CHAUDHRY
Posted on: 2012-10-03 18:24:29 By: akr14feb

Hi Kishore

In realtime

1. When we have to compile forms & when we have to compile reports?

2. What will happen when we compile forms ? pls tell what happen internally.

3. What will happen when we compile reports? how this compilation happens internally.

Regards,

Raj.

Hi Raj,

1. When we have to compile forms & when we have to compile reports?

Kishore - mostly for custom forms and custom reports, we only compile forms but for reports it is just a copy in binary format

2. What will happen when we compile forms ? pls tell what happen internally.

Below commands are used for compile forms,once compilation is done, fmx (runtime version) is copied to corresponding custom top location which is mentioned as output_file

11i
f60gen userid=apps/apps module=xxtest.fmb output_file=$XXTEST_TOP/forms/US/xxerp.fmx module_type=form

R12
frmcmp_batch module=xxerp.fmb userid=apps/apps compile_all=special batch=yes output_file=$XXTEST_TOP/forms/US/xxerp.fmx

3. What will happen when we compile reports? how this compilation happens internally.

There is no compilation of reports, we directly copy the rdf file

Kishore

Ugg Boots Outlet
Posted on: 2012-11-03 11:35:50 By: hyz

Should you not take advantage of powder you won't use a stream-lined with a reflection, thus both locate a plastic tote having a integrated reflection or even find a small lightweight reflect that you could put on your own eco friendly beauty totes.
Eco friendly aesthetic hand bags are generally similarly attractive journeying as they are able maintain all your makeup vegetation in one place,Coach Outlet Online which can be much more organized as compared to leaving behind the cosmetics goods bodyweight inside your toiletries handbag.Cheap Polo Shirts Having environmentally friendly beauty totes manufactured from natural cotton in journeying looks a lot more classy rather than padding every one of the cosmetics within a large bag.
If you wish to end up being uncluttered plus much more organized, Christian Louboutin Shoes Outlet why won't you are making use of beauty tote in your house?Replica Rolex Wathches There is a constant identified a way regarding maintaining makeup paint brushes directly into hands when you find yourself in a rush in the morning. Ugg Boots Outlet Environmentally friendly beauty hand bags involving organic cotton are accessible in numerous hues and classy looks for more details you can just click here: - www.thecotton totes.org

Database refress Posted on: 2012-11-05 19:36:53 By: Ndivhuwo
Hi Can you please share or post a step by step guide to regfresh only apps database, thus dbtier and not the entire tech stack... no AppsTier. Thanks in advance

OBIEE 11g
Posted on: 2012-11-08 17:53:19 By: yogeshbhujbal

Hello Sir,

I installed obiee 11.1.1.5 on linux 64 bit. I refer your documents but i want to install & connect to OBIA 7.9.6.3 as well as i wants to install informatica 9.0.1 hotfix 2 with DAC 10.1.3.4.1. These all are wants to inter connect with apps R12 environment. So can you please help me how to do these things.
Your documents are really very good..
You are doing really great job.

Thanks & best Regards,

Yogesh Bhujbal.