Oracle8 DBA: Network Administration Exam Cram
Covers how to use Oracle8's connection manager, and provides information on the Advanced Network option. Provides examples of both client and server configuration net files for Net8. Acts as an excellent reference for troubleshooting Oracle Net8 problems. Features an exclusive tear-out Cram Sheet with tips, acronyms, and memory joggers (mnemonics) to improve recall immediately before the exam. Includes sections on proven test-taking strategies, time-saving study tips, and shortcuts. \ Oracle...
Search in google:
Covers how to use Oracle8's connection manager, and provides information on the Advanced Network option. Provides examples of both client and server configuration net files for Net8. Acts as an excellent reference for troubleshooting Oracle Net8 problems. Features an exclusive tear-out Cram Sheet with tips, acronyms, and memory joggers (mnemonics) to improve recall immediately before the exam. Includes sections on proven test-taking strategies, time-saving study tips, and shortcuts. Oracle is the industry leader in Database software with a market share of over 60%. Oracle is slow to change its network connection protocols, making Net8 Database Administration a valuable skill. Serves as an invaluable pre-test review for even the most experienced Oracle DBA. Specifically designed to help the reader pass the Oracle8 Network Administration exam for OCP certification. Provides practice questions with detailed explanations of why the right answer is correct and the wrong answer is wrong.
Chapter 1: Oracle OCP Certification Exams\ As experiences go, taking tests is not something that most people eagerly anticipate, no matter how well they're prepared. However, in most cases, familiarity helps ameliorate test anxiety. (In plain English, this means you probably won't be as nervous when you take your fourth or fifth Oracle certification exam as you will be when you take your first.)\ But, no matter whether it's your first test or your tenth, understanding the exam-taking particulars (how much time to spend on questions, the setting you'll be in, and so on) and the testing software will help you concentrate on the material rather than on the environment. Likewise, mastering a few basic test-taking skills should help you recognize-and perhaps even outfox—some of the tricks you're bound to find in some of the Oracle test questions.\ In this chapter, I'll explain the testing environment and software, as well as some proven test-taking strategies you should be able to use to your advantage.\ Assessing Exam-Readiness\ Before you take any Oracle exam, I strongly recommend that you read through and take the Self-Assessment included with this book (it appears just before this chapter, in fact). This will help you compare your knowledge base to the requirements for obtaining an OCP, and it will also help you identify parts of your background or experience that may be in need of improvement, enhancement, or further learning. If you get the right set of basics under your belt, obtaining Oracle certification will be that much easier.\ Once you've gone through the Self-Assessment, you can remedy those topical areas where yourbackground or experience may not measure up to an ideal certification candidate. But you can also tackle subject matter for individual tests at the same time, so you can continue making progress while you're catching up in some areas.\ Once you've worked through an Exam Cram, have read the supplementary materials, and have taken the practice test at the end of the book, you'll have a pretty clear idea of when you should be ready to take the real exam. Although I strongly recommend that you keep practicing until your scores top the 70 percent mark, 75 percent would be a good goal to give yourself some margin for error in a real exam situation (where stress will play more of a role than when you practice). Once you hit that point, you should be ready to go. But if you get through the practice exam in this book without attaining that score, you should keep taking practice tests and studying the materials until you get there. You'll find more information about other practice test vendors in the Self-Assessment, along with even more pointers on how to study and prepare. But now, on to the exam itself The Testing Situation.\ When you arrive at the Sylvan Prometric testing center where you've scheduled your test, you'll need to sign in with a test coordinator. You'll be asked to produce two forms of identification, one of which must be a photo ID. Once youve signed in and your time slot arrives, you'll be asked to leave any books, bags, or other items you brought with you, and you'll be escorted into a closed room. Typically, the room will be Furnished with anywhere from one to six computers, and each workstation is separated from the others by dividers that are designed to keep you from seeing what's happening on someone else's computer.\ You'll be furnished with a pen or pencil and a blank sheet of paper, or in some cases, an erasable plastic sheet and an erasable felt-tip pen. You're allowed to write down any information you want on this sheet, and you can write stuff on both sides of the page. I suggest that you memorize as much as possible of the material that appears on the Cram Sheet (inside the front of this book), and then write that information down on the blank sheet as soon as you sit down in front of the test machine. You can refer to the sheet any time you like during the test, but you'll have to surrender it when you leave the room.\ Most test rooms feature a wall with a large window from which the test coordinator will monitor the room. The test coordinator will have loaded the Oracle certification test that you've signed up for, and you'll be permitted to start as soon as you're seated in front of the machine.\ All Oracle certification exams permit you to take up to a certain maximum amount of time (usually 90 minutes). The computer maintains an on-screen counter/clock so that you can check the time remaining any time you like. Each exam consists of between 60 and 70 questions that are randomly selected from a pool of questions.\ All Oracle certification exams are computer-generated and use a multiplechoice format. Although this might sound easy, the questions are constructed not just to check your mastery of basic facts and figures about Oracle8 DBA topics, but also to evaluate one or more sets of circumstances or requirements. Often, you'll be asked to give more than one answer to a question; likewise, you may be asked to select the best or most effective solution from a range of...
IntroductionxvSelf-AssessmentxxiiiChapter 1Oracle OCP Certification Exams1Assessing Exam-Readiness2The Testing Situation3Test Layout And Design4Using Oracle's Test Software Effectively6Taking Testing Seriously7Question-Handling Strategies7Mastering The Inner Game8Additional Resources9Chapter 2Network Overview13Oracle8 And The Network14Oracle8 Networking Components And Tools22Practice Questions29Need To Know More?34Chapter 3Basic Net8 Architecture35Oracle Net8 Communication36Oracle Net8 Substrates40Name-Resolution Methods45Practice Questions49Need To Know More?55Chapter 4Net8 Server Configuration57Listener Process And Configuration58Server Configuration With Net8 Assistant68Listener Control (Isnrctl) Utility76Practice Questions84Need To Know More?91Chapter 5Net8 Client Configuration93Host Naming Configuration94Local Naming Configuration96Client Configuration With Net8 Assistant103External Naming113Oracle Names114Practice Questions115Need To Know More?121Chapter 6Oracle Names Usage And Configuration123Centralized Naming124Configuration Of Oracle Names Server125Configuration Of The Client For Oracle Names132Controlling And Monitoring The Oracle Names Server137Practice Questions149Need to Know More?154Chapter 7MTS Usage And Configuration155Overview Of MTS156MTS Configuration157Initialization Parameters For MTS160Monitoring And Altering Parameters For MTS166Connection Pooling With MTS173Practice Questions175Need To Know More?180Chapter 8Connection Manager Usage And Administration181Overview Of CMAN182cman.ora File184Configuration Of Connection Manager187Controlling And Monitoring CMAN194Practice Questions197Need To Know More?202Chapter 9Intelligent Agent Usage And Administration203Configuration Of Intelligent Agent204Controlling And Monitoring Intelligent Agent209Practice Questions210Need To Know More?214Chapter 10Troubleshooting Net8215Troubleshooting Overview216Logging In Net8218Tracing In Net8223Trace Assistant229Common Problems With Net8232Practice Questions235Need To Know More?240Chapter 11Security In Net8241Network Security Risks242Data Privacy242Advanced Networking Option Features245Configuration Of ANO249Configuration Of ANO With Net8 Assistant253Practice Questions257Need To Know More?262Chapter 12Sample Test263Questions, Questions, Questions263Picking Proper Answers264Decoding Ambiguity264Working Within The Framework265Deciding What To Memorize266Preparing For The Test266Taking The Test267Sample Test268Chapter 13Answer Key289Appendix AThe listener.ora File303Appendix BThe tnsnames.ora File305Appendix CThe sqlnet.ora File307Appendix DThe names.ora File309Appendix EThe cman.ora File311Glossary313Index319
