--------------OEM和isqlplus工具---------------
==OEM是和数据库有关系,创建一个实例,就会有一套OEM,和数据库软件没有关系。
==OEM——oracle企业管理器(对于数据库来说不是必须的),
oracle自己开发的web模式的性能监控和管理的工具。
=使用有局限性:1、必须配置web
2、如果监听器的属性发生了变化(端口号、主机名、IP),OEM都需要重新配置
1、启动OEM
[oracle@oracle253 ~]$ 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://oracle253: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/oracle253_ORCL/sysman/log
2、停止OEM
[oracle@oracle253 ~]$ 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://oracle253:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
3、解决标签乱码问题
查看字体文件
[oracle@oracle253 ~]$ cd /usr/share/fonts/
在/usr/share/fonts/下
创建目录:zh_CN/TrueType
[oracle@oracle253 ~]$ cd /usr/share/fonts/zh_CN/TrueType
将字体文件copy到这个目录下(root下):
/usr/share/fonts/zh_CN/TrueType/zysong.ttf
切换到oracle用户,替换缺省字符集字体的配置文件
[oracle@oracle253 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jdk/jre/lib
[oracle@oracle253 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@oracle253 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jre/1.4.2/lib
[oracle@oracle253 lib]$ cp font.properties.zh_CN.Redhat font.properties
清理缓存图片:
[oracle@oracle253 zhs]$ pwd
/u01/oracle/product/10.2.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
[oracle@oracle253 zhs]$ rm *.gif
4、验证
[oracle@oracle253 zhs]$ emctl start dbconsole
访问地址:http://192.168.56.102:1158/em
isqlplus工具——用来执行SQL语句
1、启动
[oracle@oracle253 zhs]$ isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
2、访问地址:
http://oracle253:5560/isqlplus/
3、停止
isqlplusctl stop
==OEM是和数据库有关系,创建一个实例,就会有一套OEM,和数据库软件没有关系。
==OEM——oracle企业管理器(对于数据库来说不是必须的),
oracle自己开发的web模式的性能监控和管理的工具。
=使用有局限性:1、必须配置web
2、如果监听器的属性发生了变化(端口号、主机名、IP),OEM都需要重新配置
1、启动OEM
[oracle@oracle253 ~]$ 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://oracle253: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/oracle253_ORCL/sysman/log
2、停止OEM
[oracle@oracle253 ~]$ 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://oracle253:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
... Stopped.
3、解决标签乱码问题
查看字体文件
[oracle@oracle253 ~]$ cd /usr/share/fonts/
在/usr/share/fonts/下
创建目录:zh_CN/TrueType
[oracle@oracle253 ~]$ cd /usr/share/fonts/zh_CN/TrueType
将字体文件copy到这个目录下(root下):
/usr/share/fonts/zh_CN/TrueType/zysong.ttf
切换到oracle用户,替换缺省字符集字体的配置文件
[oracle@oracle253 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jdk/jre/lib
[oracle@oracle253 lib]$ cp font.properties.zh_CN.Redhat font.properties
[oracle@oracle253 lib]$ pwd
/u01/oracle/product/10.2.0/db_1/jre/1.4.2/lib
[oracle@oracle253 lib]$ cp font.properties.zh_CN.Redhat font.properties
清理缓存图片:
[oracle@oracle253 zhs]$ pwd
/u01/oracle/product/10.2.0/db_1/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
[oracle@oracle253 zhs]$ rm *.gif
4、验证
[oracle@oracle253 zhs]$ emctl start dbconsole
访问地址:http://192.168.56.102:1158/em
isqlplus工具——用来执行SQL语句
1、启动
[oracle@oracle253 zhs]$ isqlplusctl start
iSQL*Plus 10.2.0.1.0
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Starting iSQL*Plus ...
iSQL*Plus started.
2、访问地址:
http://oracle253:5560/isqlplus/
3、停止
isqlplusctl stop