Oracle提供了Database Control Console Process,支持B/S网页表单方式去做DBA神秘的命令行的事情。为什么我也安装了Oracle企业版,还是不能访问这个系统呢 ?
看了介绍文档%ORACLE-INSTALL-DIR%\database\doc\server.112\e10897\em_manage.htm#BABBAIHD,一切便明了了。
To access Oracle Enterprise Manager Database Control (Database Control) from a browser, the Database Control console process dbconsole
must be running on the database host computer. The dbconsole
process is automatically started after installation. However, if the system must be restarted, you can start the dbconsole
process manually at the command line or start it as a service in Windows. You can also run commands to stop the dbconsole
process or view its status. If the dbconsole
process is stopped, then it must be manually restarted before you use Database Control.
To start or stop, or to view the status of the dbconsole process from the command line:
-
Configure the operating system environment variables, as described in "Configuring the Operating System Environment Variables".
-
Do one of the following:
-
To start the
dbconsole
process, run the following command:./emctl start dbconsole
-
To stop the
dbconsole
process, run the following command:./emctl stop dbconsole
-
To view the status of the
dbconsole
process, run the following command:./emctl status dbconsole
Note:
If you are prompted to set theORACLE_UNQNAME
environment variable, then set this variable and run theemctl
command again. Set the variable to the database unique name (the value of theDB_UNIQUE_NAME
database parameter). A typical value forDB_UNIQUE_NAME
isorcl
. -
To start or stop dbconsole as a service on Microsoft Windows:
-
Do one of the following:
-
On Windows XP and Windows Server 2003, click Start, and then select Control Panel.
-
On Windows 2000 Server, click Start, select Settings, and then select Control Panel.
The Control Panel window opens.
-
-
Double-click the Administrative Tools icon, and then double-click the Services icon.
The Services window opens.
Oracle Database services begin with
Oracle
. Thedbconsole
service is listed asOracleDBConsole
Oracle_sid
, whereOracle_sid
is the system identifier (SID) for your database instance. The status of this process (either started or stopped) is listed in the Status column. -
Double-click the
OracleDBConsole
service.Oracle_sid
The service properties window opens.
-
In the Startup Type list, ensure that either Manual or Automatic is selected.
-
Do one of the following:
-
To start
dbconsole
, click Start, and then click OK. -
To stop
dbconsole
, click Stop, and then click OK.
-
Accessing the Database Home Page
The Database Home page is the main database management page in Oracle Enterprise Manager Database Control (Database Control).
To access the Database Home page:
-
Ensure that the
dbconsole
process is running on the database host computer.See "Starting and Stopping the Database Control Console Process".
-
In your Web browser, enter the following URL:
https://hostname:portnumber/em
For example, if you installed the database on a host computer named
comp42.example.com
, and the installer indicated that your Enterprise Manager Console HTTP port number is1158
, then enter the following URL:https://comp42.example.com:1158/em
If you have recently installed Oracle Database, you can determine the port number for Database Control on Linux and UNIX systems by viewing the
$ORACLE_HOME/install/portlist.ini
file. Otherwise, you can determine the port number for Database Control by searching forREPOSITORY_URL
in the$ORACLE_HOME/
Oracle_sid
/sysman/config/emd.properties
file, whereOracle_sid
is the system identifier (SID) for your database instance.If the database instance is running, then the Login page appears when you access Database Control. If the database is down and must be restarted, Database Control displays the Startup/Shutdown and Perform Recovery page.
You must do the following to start the database:
-
Click Startup/Shutdown, enter the host login user name and password, and then enter the database login user name and password.
For the database user name and password, enter
SYS
and the password that you specified during installation. -
Click OK to start the database instance, and then in the Confirmation page, click Yes to start the database in open mode.
-
-
Log in to the database with a user account that is authorized to access Database Control.
This user initially could be
SYS
orSYSTEM
, with the password that you specified during database installation.While the
SYSTEM
account can be used to perform day-to-day administrative tasks, Oracle strongly recommends creating a named user accounts for administering the Oracle database to enable monitoring of database activity. To back up, recover, or upgrade the database, you must log in as a SYSDBA user.Database Control displays the Database Home page.