Question

In: Computer Science

For the following questions, list the entire path for the indicated file. If you use the...

For the following questions, list the entire path for the indicated file. If you use the variables ORACLE_BASE or ORACLE_HOME, be sure to list their values as well.

  • Find the location of the instance of your database (ORCL).
  • Find the location of the file init.ora .
    What purpose does this file serve?
  • Find the location of the files listener.ora and tnsnames.ora. Identify which file is on the client and which file is on the server.
  • Find the location of the file sqlplus.exe .
    What purpose does this file serve?

Solutions

Expert Solution

Answer 1)

You can find your trace files in $ADR_HOME directory which is by default located at $ORACLE_BASE/diag, and the trace file directories for the instance are located at $ORACLE_HOME/diag/$ORACLE_SID. It can be found in the same level as the bdump directory, udump directory, and cdump directory.

Answer 2)

In UNIX the default location of init.ora is $ORACLE_HOME/dbs>. Whereas in Windows we can find the same in the location %ORACLE_HOME%\database.

Answer 3)

Init.ora is a file created by DBA and is responsible for defining the overall instance configuration like file location, internal optimization parameter, and memory allocation for the instance.

Answer 4)

By default, the tnsnames.ora can be found in the $ORACLE_HOME/network/admin directory on both the client-side and the server-side. Similarly, the listener.ora file by default is located in the same $ORACLE_HOME/network/admin directory on both sides.

Answer 5)

By default, the sqlplus.exe file should be located in the folder C:\oracle\product\10.2 in Windows.

Answer 6)

The file sqlplus.exe is an executable file on computer's harddisk and contains the machine code.


Related Solutions

Use the Main.java file below to read in phrases (entire lines!) and print underscores "_" for...
Use the Main.java file below to read in phrases (entire lines!) and print underscores "_" for each character. Main.java already imports the Scanner class, creates your Scanner object, and reads in the first phrase from the keyboard. Your task is as followed: import java.util.Scanner; public class Main {    public static void main(String[] args) {        Scanner keyboard = new Scanner(System.in);        String phrase = keyboard.nextLine();           //Your code here!    } } Write a nested...
given a input file, parse it and answer the following frequency related questions, using java. -list...
given a input file, parse it and answer the following frequency related questions, using java. -list the most frequent word(s) in the whole file and its frequency. -list sentence(s) with the max. number of occurrences of the word “of” in the entire file and also list the corresponding frequency. program has two arguments; 1st : path to the input text file 2nd : name prefix for the output files ex. $ java assgn1 “./input.txt” “output” outputs: for each question create...
Answer the following questions : "What career path have you chosen? What made you choose this...
Answer the following questions : "What career path have you chosen? What made you choose this path?" in 300-500 words and "How have you used creative thinking/problem solving to help you accomplish your academic or personal goals?" in 500-750 words.
Use the data in the Mod8-2Data file to answer the following questions. The data contains information...
Use the data in the Mod8-2Data file to answer the following questions. The data contains information from a car seat manufacturer on the age of machine (in months) and the cost of repairs (in 10s of $). Run the regression in Minitab and show the regression line on a scatter plot. Assume a level of significance of 5%. Age Repairs10 110 32.767 113 37.668 114 39.252 134 44.314 93 34.262 141 47.616 115 32.474 115 33.898 115 43.345 142 52.637...
following the path of an ejaculated sperm from the vagina to the oocyte list all the...
following the path of an ejaculated sperm from the vagina to the oocyte list all the structures of the female relroductive tract that the sperm must swim through to reach the egg.
PLEASE ANSWER ALL OF THEM. Use the following file listing called intro.txt to answer the questions....
PLEASE ANSWER ALL OF THEM. Use the following file listing called intro.txt to answer the questions. Make sure to use regular expressions. Number your answers 1 through 7. The Unix operating system was pioneered by Ken Thompson and Dennis Ritchie at Bell Laboratories in the late 1960s. One of the primary goals in the design of the Unix system was to create an environment that promoted efficient program development. 1-Write the grep command to output all lines that begin with...
Anatomy. Fully describe the entire path that water travels from the root hair to the hydathode...
Anatomy. Fully describe the entire path that water travels from the root hair to the hydathode as guttation occurs. Correctly use at least the following six anatomical terms in your description: hydathode, stele, tracheid, trichome, vascular bundle, and xylem. Note that you may need to use more terms than this to completely describe this anatomical pathway.
please answer it ASAP, Its URGENT!!! Thanks in advance Describe the entire path of the blood...
please answer it ASAP, Its URGENT!!! Thanks in advance Describe the entire path of the blood flow through the heart starting with blood returning to the heart from the body. Be sure to include each chamber, valve and vessel. Right and left are also important. (answer in ~250 words)
In managing a project of the scale and type indicated below, the Critical path method(CPM) is...
In managing a project of the scale and type indicated below, the Critical path method(CPM) is utilized, composed of the following activities and their durations. Activity Time in days preceding activities A 10 -- B 6 -- C 8 A D 3 B E 7 C G 12 B H 5 C F 3 D, G I 5 E, H J K 8 8 C F, I, J a) Draw a critical path network(CPM) network diagram for this project on...
Please answer the following questions using the data in the attached Excel file. You are thinking...
Please answer the following questions using the data in the attached Excel file. You are thinking of investing in Abercrombie and Fitch Co. (ANF). The returns for ANF are embedded in an Excel document below (Source: yahoo.com). 1.      For the investment in ANF that you are considering, for all of 2012 determine the following items: a) the mean return b) the median return c) the standard deviation d) the variance e) the coefficient of variation The weekly rates of return...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT