When doing Oracle projects in the past, just doing Oracle-based development work (mainly PL / SQL stored procedure), almost have been done for Oracle management, just know how to use exp, IMP these commands to Oracle's backup. At the beginning of this year, I started pondering Oracle because the previous work, I came into contact with OEM. I have been trying to have n times and I will learn it. Today, take the opportunity to sum up your own configuration experience for your reference. (Because I don't know how to map here, all pictures give in the form of reply, I am implemented in the Win2k Server environment, as for Linux, I think it should be small, just a lot of command parameters It is worse than Win2K.) OEM is Oracle Enterprise Manager. To use OEM, you must first configure the managementServer service (ie, OMS) because OEM is running under the support of OMS service. Configuring OMS needs 5 steps, I took every picture of each step, attached to the back of the reply. Open the Enterprise Manager Configuration Assistant by "Start -> Program -> Enterprise Manager-> Configuration Assistant", "Configuration Play" interface shown in Figure 1, we choose to create a new archive ", If you already have a file, you can delete or upgrade, or edit parameters. After selecting it, press the "Next" button, "Select the Database" interface as shown in Figure 2, here you must "log in to the database with DBA privileges", I use System here , Enter the password and service (the default password is Manager, the global database name is ORCL when setting Oracle, so the service is also orcl), press the "Next" button to log in to the information archive login information as shown in Figure 3 "Interface, here you ask" Enter Data Archive Username and Password ", if you do not want to save users and passwords, please select the following" Do not save the username and password "check box, press the" Next "button, appear as shown in Figure 4 "Select the Data Archive User Table Space", I use the default option, you can also specify the relevant options yourself, then press the "Next" button, "Create Data Archive Summary" as shown in Figure 5 Interface, this is just the display of the above configuration information, where we click "Finish" button to start creating a profile library, appearing as shown in Figure 6. When you have just appeared, the middle button is "Show Details". After clicking, the progress screen appears on the right, the intermediate button becomes "hidden detail". When the creation is complete, the "Close" window can use OEM, but must be guaranteed that OMS must have been started before use.
The way to start the OMS under Windows is: At the desktop, select "My Computer", right-click, select "Administrative" of the pop-up menu, enter Computer Management, Select Services and Applications ", or" Start -> Settings -> Control Panel, enter the control panel, open the "Service" in the Administration to enter "Computer Services". After you configure the OMS, "OracleraHome81ManagementServer" service will appear, the default is manual startup, select the right, click the right mouse button, select "Start" in the pop-up menu to start the OMS service. Before starting this service, you must ensure that "ORACleServiceorCl" and "OracleoraHome81 TNSListener" service are started before starting this service. Now we can enter OEM through "Start -> Program -> Enterprise Manager-> Console", display the login interface, the username, and password default is sysman / oem_temp, management server is this name or IP address, if You are the first time you log in, the system enforces you to change the sysman's password, you must remember your own password. Forgot :), then I can't do it. At this time, there was an OEM console. (As shown in Figure 7). Before configuring OEM, you must ensure that you do not install non-Oracle databases in your machine, otherwise the VTO-4400 error will appear after entering the OEM console. That is to find an Oracle database on the node. (The author appeared this error because of the SQL Server database, then deleted SQL Server, found an Oracle database, then install SQLServer, there is no problem) [2005-7-14] There is also other reasons. I yesterday because of the software like VMware on the machine, I caused three IP addresses in my machine, so I also happen, and later deleted the VMware and found the database! So when you happen this error! [/ 2005-7-14] Before starting using the OEM console, it is necessary to make a user (default is the user) of the user (the default is Administrator), because the Win2kServer system default adminstrator is no batch The authority of the job. After entering the control panel, open the control panel, open the management tool, select "Local Security Policy", enter the local security settings window, open the "User Rights Assign" of Local Policy, select the last item "Log in as a batch" and then "Add" on the Administrator user.
