How to become an Oracle application database administrator
There are two things to be done to change from an ordinary Oracle DBA(Oracle Database Administrator) to an Oracle Applications DBA(Oracle Application Database Administrator). The first thing is how to become an Oracle Applications DBA(Oracle the second thing is you. To understand the architecture behind Oracle applications, that is to say, to understand the architecture of the following products, such as Oracle e-commerce suite, Oracle i database, Siebel products, etc. This paper first describes how to change from an ordinary Oracle DBA to an Oracle Applications DBA(Oracle then describes some aspects of the Oracle application software architecture. How to become an Oracle application database administrator is the first change of role. Oracle Applications DBA(Oracle application database administrator) is a great challenge for ordinary Oracle DBA(Oracle database administrator). For Oracle EBS DBA(Oracle E-Business Suite DBA), it is necessary not only to understand the services of various components of EBS, but also to actively deal with other related personnel. Contact with Oracle application database administrator not only needs to be responsible for daily database management, such as managing, maintaining and tuning the database like other database administrators, but also needs supervision if his application database is an OLTP system. Check Waiting and Locking Oracle E Business Suite There are some functions that DBAs need to complete, such as filling data from external resources into Apps database, or supporting developers to extract data from existing data and then transform their work? As an Oracle Applications DBA(Oracle Application Database Administrator), if you want to better support the Oracle application database, you need to remember the following items carefully. There is no simple and easy document on the internet to familiarize you with Apps DBA. I suggest you go and see the help? Don't patch without many tests and customer approval, and make sure that this patch solves the existing problems and does not bring other new problems? Remember that Oracle applications will have many indexes, and rebuilding the indexes regularly will help improve performance. Of course, this work should be done when the system is idle? Don't try to add additional indexes without asking oracle technical support to improve performance. If you have to do this, remember to keep a file for your record, because when you patch it again, it may automatically restore your changes? Know how to patch correctly, which patch to plan first, then get the patch, then test the patch, and finally record the document? Be aware that some objects in the database may be invalid at any time, and some of your operations will also increase invalid objects. Check the number of these invalid objects regularly, and then recompile utlrpSQ's rdbms/ using UTLRP/under ORACLE HOME/, you need to use SYS to run in your DB. If you encounter an error, you can recompile the invalid object first. If the problem is not solved, you can submit ITAR (Internet-created Technical Assistance Request). Can you read the log? Understand the environment of application database, including operating system and database. When you know your working environment like the back of your hand, everything will become easier. Will you be a leisurely application DBA? In addition, for APPS DB (application database), you may need to create or copy (clone) multiple databases instead of production libraries, such as test and development databases. Of course, how many databases you need depends on your business needs. The development environment database is for developers to report PL/ This environment is developed by SQL, and others can test patches in this environment when developers feel that the data no longer meets the development requirements. Of course, when patches are finally used, they need to be tested in a test environment, because the test database is the closest to the production database environment (the clone mentioned above is one of the application layer and database). Se layer) So when you have these three databases, the patching step is to develop the databases first, then test the databases, and finally apply the architecture application system in the production database environment? If you have studied Oracle forms, used Application Server and Developer Suite to develop, configure and deploy forms and reports, and experienced a lot of management and maintenance work as an Oracle DBA, such as patching and cloning, then you have been able to master OA% content Ora. Cle Apps should be such an application. ERP application software with high speed and low latency uses the best web and database components that Oracle can provide. Am I right? In fact, this is not entirely correct. In the current version, you can see that the earliest version of the application server and the version of Oracle are still? The simplest configuration of EBS environment also includes two servers, called two-tier database layer and middle tier, also called application-tier database layer. In the middle tier, more precisely, there are several services running in the middle tier, which are different, such as OC J report engine forms. You can see that the application server exists in the middle tier, and there are also specific servers of Oracle applications. Generally speaking, there are six kinds of servers that exist in the middle layer and the application layer, namely &; # ; Web server &; # ; Form server &; # ; Report server &; # ; Finder server &; # ; Concurrent processing server &; # ; As for the management server, the other servers listed above are different from the application servers in nature, that is, concurrent processing servers. For the concurrent processing server, we can think of it as an assistant to coordinate the work and process in the process of EBS user request and data processing. In addition, as for modern application servers, not all the services listed above must be on the same server? We can also think of Oracle Apps configuration as the configuration of form and report service and back-end database. What is the physical or logical relationship between app server and database? In the Oracle application world, files generated in the middle tier sometimes need to be placed in the database tier. Most of these files exist in the form of text files, including configuration information. Are other files related to cloning? The following icons help to explain the main components of each layer. This icon comes from the chart of Oracle Applications Concepts Release I, as shown in the following figure. There are many parent directories in the middle layer, two of which should be specially mentioned. These two appear repeatedly in the document. Are they the APPL top and top database layers? What is the database layer like? Surprisingly, the file format of Oracle Apps database may be incredible, not because it is complicated, but because it is not complicated at all. Similarly, in the parent structure, the database has four kinds of data, namely, the data index system and the temporary tablespace location. You may see that all data related to database files are placed in one path or partition, and all indexes are in the same system and in the same path. The same is true for temporary tablespaces. Redo logs can be placed in two locations. You may see hundreds of tablespaces with one or two files. Can you see four table space models? Speaking of redo logs and general redo operations, we can be sure that in the real DBA world, we want redo logs to be stored on a fast disk. Did you put the control file on the disk because of the large amount of writing? If you don't see the control file written in parallel during the transaction waiting, take a look at the installation process of Oracle Apps. This is the case. The current document claims that it is best to allocate the redo log buffer size in MB. Oracle has a note on MetaLink, suggesting that Oracle Apps DBA set the redo log buffer to MB, which is different from the general database. It is not common to set initial parameters in an initial file. How to ensure the reliability when you have to patch OLTP or DSS database when using Oracle Apps? Reliability means only a few minutes of downtime every year. Although it is not so strict, there are still many tests and quality assurance work to be completed in order to provide better service. For end users, you need to know the structure of the application and the meaning of proper nouns. For example, although you don't need to know how the financial module is implemented, you still need to know whether AR borrows AP or GL, so that when you encounter problems, you may know how the data comes in time, and who should you talk to about that module? How do you back up your database? In EBS, the very direct middle-tier components in database backup are somewhat complicated. Fortunately, Oracle has developed a tool called rapid cloning, and the steps are summarized as follows &; # ; Run perl-based scripting language at each layer (create an XML file that contains configuration information but does not affect the source system)&; # ; Copy the relevant parts of each layer to the target system &; # ; Run the config/clone script based on perl language to reconfigure the environment or the context files of each layer? There are complex connections between application middle-tier databases, and often the problems in one place are manifested in other places (a bit like traditional Chinese medicine), or the problems in one place affect another place and then affect other places, and finally affect the overall performance. For example, if a form is not implemented correctly, as a DBA, you may find performance problems first. The decline will give you a headache. The original form or report may be patched and executed differently. Finally, I want to say that what you are contacting and managing now is a much more complicated system than before. Every part of this system can't be seen separately. When you encounter problems, you should consider them as a whole. The application database administrator is a person who knows every part of the system. Conclusion? The threshold of Oracle applications DBA is much higher than that of ordinary Oracle DBA. He should not only have the ability to deal with database problems, but also understand the architecture of the whole application and consider the problem from a big perspective. In short, he plays the role of DBA and system analyst. Lishi Xinzhi/Article/program/Oracle/20 13 1 1/ 165 10