Question

在oracle中使用enpterprise manage怎么启动数据库实例

Answer 1

OEM企业管理器-Oracle emterprise manager

安装oracle的时候自动安装的。

1、启动OEM

[oracle@oracle3 oracle]$ emctl start dbconsole --启动命令
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://oracle3:1158/em/console/aboutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.

2、访问OEM--BS模式

http://IP地址:1158/em/console/aboutApplication

3、解决OEM中标签乱码的问题--bug，linux-bug，缺少一个字体文件

[oracle@oracle3 rpm10g32]$ ll zys*
-rw-r--r-- 1 root root 9249332 2007-11-06 zysong.ttf --字体文件。

A 将OEM服务停止

[oracle@oracle3 rpm10g32]$ emctl stop dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://oracle3:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.

B 在服务器上创建路径

[oracle@oracle3 rpm10g32]$ cd /usr/share/fonts/
[oracle@oracle3 fonts]$ ll
总计 56
drwxr-xr-x 2 root root 4096 02-08 08 :23 bitmap-fonts
drwxr-xr-x 2 root root 4096 02-08 08 :13 bitstream-vera
drwxr-xr-x 4 root root 4096 02-08 08 :51 chinese
drwxr-xr-x 4 root root 4096 02-08 08 :47 default
drwxr-xr-x 2 root root 4096 02-08 08 :32 dejavu-lgc
drwxr-xr-x 2 root root 4096 02-08 08 :32 liberation
drwxr-xr-x 3 root root 4096 02-08 08 :51 zh_TW

[root@oracle3 ~]# cd /usr/share/fonts/
[root@oracle3 fonts]# mkdir zh_CN
[root@oracle3 fonts]# cd zh_CN
[root@oracle3 zh_CN]# mkdir TrueType --创建的路径

C 将字体文件拷贝到这个路径下：

[root@oracle3 zh_CN]# cp /u01/rpm10g32/zysong.ttf TrueType/

D 替换缺省的字符集

需要替换两个地方

[oracle@oracle3 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jdk/jre/lib
[oracle@oracle3 lib]$ cp font.properties.zh_CN.Redhat font.properties

[oracle@oracle3 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jre/1.4.2/lib
[oracle@oracle3 lib]$ cp font.properties.zh_CN.Redhat font.properties

E 清理缓存图片

[oracle@oracle3 lib]$ cd $ORACLE_HOME
[oracle@oracle3 db_1]$ cd oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
[oracle@oracle3 zhs]$ rm *.gif

4、将服务重启

[oracle@oracle3 zhs]$ emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://oracle3:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control .............................. started.
------------------------------------------------------------------
Logs are generated in directory /u01/oracle/product/10.2.0/db_1/oracle3_ORCL/sysman/log

5、验证：http://IP地址:1158/em/console/aboutApplication

这个OEM可以不安装的，但是选择安装软件和建库一起执行是必须安装的。
只有单独创建数据库的时候可以选择不安装。

Answer 2

你不用那么麻烦。。
如果只是想有图形界面对数据库操作方便使用plsqldeveloper就够了
至于你说的那个一般是用来管理数据库用的。。