|
INTERVIEW QUESTIONS
ORACLE APPS
AOL
DETAILS
Question: How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Answer: One of the easiest ways is to run the product if you can. Running Reports designer will give you the Reports version, running SQL*Plus will give you its version etc. Another easy way is to launch the Oracle Installer and look in the installed products on the right side. It will list all the products installed with their versions. Another way is to look at the .rgs file. This file is located in $ORACLE_HOME/orainst On UNIX, it will be called unix.rgs. On the PC, it will be called Windows.rgs. This file will list all the products installed and their versions. Note though that this file is not always correct. For example, patching Reports from 2.5.5.4 to 2.5.5.8 will not show up in this file as the new version. Running Reports Designer is the best way of getting the correct version. Also, on UNIX there is an executable called 'inspdver'. It is located in $ORACLE_HOME/orainst. Running it will produce a display of all the installed products. It just pulls the information from unix.rgs, so it may show the wrong information as well.
|
|
|
Category |
AOL Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 7796 users |
Added on |
7/29/2011 |
Views |
69893 |
Rate it! |
|
|
Question:
How do I find the version of an installed product? (such as Reports, SQL*Net etc.)
Answer:
One of the easiest ways is to run the product if you can. Running Reports designer will give you the Reports version, running SQL*Plus will give you its version etc. Another easy way is to launch the Oracle Installer and look in the installed products on the right side. It will list all the products installed with their versions. Another way is to look at the .rgs file. This file is located in $ORACLE_HOME/orainst On UNIX, it will be called unix.rgs. On the PC, it will be called Windows.rgs. This file will list all the products installed and their versions. Note though that this file is not always correct. For example, patching Reports from 2.5.5.4 to 2.5.5.8 will not show up in this file as the new version. Running Reports Designer is the best way of getting the correct version. Also, on UNIX there is an executable called 'inspdver'. It is located in $ORACLE_HOME/orainst. Running it will produce a display of all the installed products. It just pulls the information from unix.rgs, so it may show the wrong information as well. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Why does Help->Tools->Examine ask for a password?
|
View Answer
|
|
How do I submit a concurrent request from PL/SQL?
|
View Answer
|
|
How do I generate a message file (usaeng.msb)?
|
View Answer
|
|
How do I find the name of a form?
|
View Answer
|
|
How do I find out what the currently installed release of Applications is?
|
View Answer
|
|
How do I check if Multi-org is installed?
|
View Answer
|
|
What are the logfile and output file naming conventions?
|
View Answer
|
|
Where do concurrent request logfiles and output files go?
|
View Answer
|
|
How do i recover the responsibility in apps if it is disabled?
|
View Answer
|
|
I have applied a patch. at the time of applying he update a table and suddenly he gives the error that table is lock. Now what i do?
|
View Answer
|
|
I have run a request but it is not completed. His status is (running normal) and those requests are giving after this he will be completed.So,now what steps i have follow for the unning request?
|
View Answer
|
|
How cam i changes in custom.pll? After changes how can i send on the server and what's effect in this condition?
|
View Answer
|
|
How can i implementing and managing the custom schema? please give me quick reply.
|
View Answer
|
|
What is '$flex$ and '$profile$, Waht is the use of '$flex$'?
|
View Answer
|
|
What is quick code? why is it called a quick code? What is steps of defining a quick code?
|
View Answer
|
|
What is the difference between organization id and master organization id?
|
View Answer
|
|
What so you mean by Hierarchical and non Hierarchical security type in value set?
|
View Answer
|
|
What is US directory under any TOP?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All AOL Interview Questions & Answers - Exam Mode /
Learning Mode
|