oracle数据库访问地址,Oracle 数据库控制系统的启动方法与访问地址

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 the

ORACLE_UNQNAME environment variable, then set this variable and run the

emctl command again. Set the variable to the database unique name (the value of the

DB_UNIQUE_NAME database parameter). A typical value for

DB_UNIQUE_NAME is

orcl.

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. The dbconsole service is listed as OracleDBConsoleOracle_sid, where Oracle_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 OracleDBConsoleOracle_sid service.

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.

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 is 1158, 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 for REPOSITORY_URL in the $ORACLE_HOME/Oracle_sid/sysman/config/emd.properties file, where Oracle_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 or SYSTEM, 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.