楼主: fable_cao

[FAQ] Oracle10g EM使用中的主机身份证明问题

[复制链接]
论坛徽章:
8
生肖徽章2007版:鸡
日期:2008-01-02 17:35:53生肖徽章2007版:鼠
日期:2008-01-02 17:35:532008新春纪念徽章
日期:2008-02-13 12:43:03ITPUB元老
日期:2011-12-24 20:32:592012新春纪念徽章
日期:2012-01-04 11:53:29
21#
发表于 2007-3-16 08:49 | 只看该作者
XP的专业版还是有的。没有用过HOME版,
不过想一下这些是应该有的。在控制面版里找一下呀

使用道具 举报

回复
论坛徽章:
0
22#
发表于 2007-6-5 14:46 | 只看该作者
终于找到了正解。
windows 2003. + oracle 10g.

使用道具 举报

回复
招聘 : 产品经理/专员
论坛徽章:
67
管理团队2006纪念徽章
日期:2006-04-16 22:44:452012新春纪念徽章
日期:2012-01-04 11:50:442012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:252012新春纪念徽章
日期:2012-02-13 15:12:25版主1段
日期:2012-05-15 15:24:112013年新春福章
日期:2013-02-25 14:51:24夏利
日期:2013-10-10 13:12:33
23#
发表于 2007-6-12 10:40 | 只看该作者
这个问题其实在metalink中也有解释,只是我们很少注意

Goal:
Quick Start Guide: How to Configure Enterprise Manager 9i
Environment:
Oracle Enterprise Manager 9i
Oracle Management Server 9i
Oracle Intelligent Agent 9i
Enterprise Manager Repository
Fix:
How to configure Enterprise Manager 9i when using a three-tier architecture (EM CONSOLE -> MANAGEMENT SERVER -> INTELLIGENT AGENT).
For ease of setup, each tier should each be configured and verified before moving to the next tier. To facilitate this building process, set up the tiers third-tier through first-tier.

A. Configure the Target Nodes (Third-Tier):
To manage nodes and other Oracle services on those nodes, an Intelligent Agent must be configured and running on the node. The Intelligent Agent is installed from the Oracle Server CD. For details on installing an Intelligent Agent, consult your Oracle Server installation Guide or the Intelligent Agent Users Guide.

If the managed node is a Windows NT/2000 system:
        Start the Intelligent Agent (As a default, the Agent is started automatically.)
Setup a Windows Admin user with "Logon as Batch Job" privilege[/COLOR]
1. Start the Intelligent Agent:
To start the Intelligent Agent on Windows NT, perform the following steps:
a. Double-click the Services icon in the Control Panel folder.
b. Select the Oracle<oracle home>Agent service.
c. Click the Start push-button to start the agent.
To stop the agent on Windows NT, perform the following steps:
a. Double-click the Services icon in the Control Panel folder.
b. Select the Oracle<oracle home>Agent service.
c. Click the Stop push-button to stop the agent.
To verify the agent is running, perform any combination of the following:
a. Check the status of Oracle<oracle home>Agent in the control panel services
b. Verify the process dbsnmp.exe is running in the NT Task Manager
c. Type NET START at a command prompt. Oracle<oracle home>Agent should appear in the list of services.
2. Set Up a Windows NT User Account for Running Jobs / Events[/COLOR]

If the managed Node is a UNIX system:
        Verify the post-installation script (root.sh) has been ran
        Verify permissions on the Intelligent Agent (dbsnmp) executable
        Start the Intelligent Agent
1. Run root.sh:
The root.sh script must be ran after each Oracle installation. This script sets the permissions on the Intelligent Agent's executable (dbsnmp). The script will also create/update the oratab file which is used by the Intelligent Agent to determine all the databases discoverable on the system. For each database created, the entry is of the form:
<SID>:<$ORACLE_HOME>:[Y/N]
Verify the oratab file lists each database on the system and follows the correct syntax listed above. The root.sh shell script should have written values of the Oracle Homes and SIDs. If there are no entries in the oratab file, perform the following steps:
> su root
> $ORACLE_HOME/orainst
> ./root.sh
Answer the questions asked. For each database created, the entry is of the form: <SID>:<$ORACLE_HOME>:[Y/N]
You will then be automatically exited out of root.sh.
The agent is normally configured by root.sh as a setuid program. If root.sh was successful, the agent will have been installed as "setuid root" so the agent can run jobs as the user whose name and password are given in the EM Console's Preferred Credentials for that node (server).
2. Check file permissions on dbsnmp:
To verify that root.sh had been run successfully, check the file permissions on dbsnmp:
> cd $ORACLE_HOME/bin
List all relevant details about dbsnmp:
> ls -al dbsnmp
The output of the ls -al command for dbsnmp should be in the form:
-rwsr-xr-x 1 root dba 1497980 Jun 12 21:04 dbsnmp
In this example, root is the owner and the group is dba. The first 10 characters (-rwxr-xr-x) represent the level of permissions set on the executable. The first 4 character (-rws) represents the owners permissions.
For example, the owner has (r)read, (w)write, and (s)setuid on execute. The next 3 characters (r-x) represent the groups permissions. For example, (r)read, (x)execute. Group does not have write permissions. The last 3 characters (r-x) represents the permissions of everyone else or "world". If root is the owner and -rwsr-xr-x are the permissions, then root.sh has been ran successfully.
3. Start the Intelligent Agent on Unix:
On UNIX, the 9i Intelligent Agent uses the "agentctl" utility to start and stop the dbsnmp process. The commands to control the agent are:
agentctl start = To Start the agent on UNIX platform
agentctl stop = To Stop the agent on the UNIX platform
agentctl status = To verify status of the agent

B. Configure the OMS and EM REPOSITORY (Middle Tier)
Checklist -
        Run the Enterprise Manager Configuration Assistant and upgrade / create a new EM Repository.
        Start the Oracle Management Server.

1. Create the EM Repository
How to Configure the Enterprise Manager 9i Management Server and EM Repository, Note 165048.1
2. If not already started, you will need to start the Oracle Management Server (OMS):
To start the OMS on Windows NT, perform the following steps:
a. Double-click the Services icon in the Control Panel folder
b. Select the Oracle<Oracle_Home>ManagementServer service
c. Click the Start push-button to start the OMS
On Solaris:
oemctl start oms
If the OMS fails to start, consult the oms.log file found in the $ORACLE_HOME/sysman/log directory for further information. With the Solaris release of EM 9i, the log file is called oms.nohup.

C. Configuring the EM Console (First-Tier):
Checklist -
        Start the EM Console
        Discover Managed Nodes and their Managed Services
        Set Preferred Logon Credentials
        Test the Job System
1. Start the EM Console:
To launch the console, on Windows NT:
Click Start => Programs => Oracle<oracle home> => Enterprise Manager Console
or from a command prompt, type:
oemapp console
On Solaris, type:
oemapp console

The default EM logon is:
Username=sysman
Password=oem_temp
After entering the default logon, you will be forced to change the initial password - REMEMBER IT!
After logging on, additional EM users can be setup. These users are known only to the EM console/OMS. They are not database accounts but simply users stored in a table in the EM Repository.

使用道具 举报

回复
论坛徽章:
0
24#
发表于 2007-7-11 21:41 | 只看该作者
这个小问题也太害人了

使用道具 举报

回复
论坛徽章:
0
25#
发表于 2007-12-12 17:28 | 只看该作者
不想要密码了咋处理?

使用道具 举报

回复
论坛徽章:
10
每日论坛发贴之星
日期:2007-09-10 01:02:15金色在线徽章
日期:2007-10-03 04:03:16ITPUB新首页上线纪念徽章
日期:2007-10-20 08:38:44数据库板块每日发贴之星
日期:2007-12-20 01:04:15生肖徽章2007版:猴
日期:2008-01-02 17:35:53生肖徽章2007版:鼠
日期:2008-01-02 17:35:53奥运会纪念徽章:摔跤
日期:2008-09-04 09:51:27生肖徽章2007版:狗
日期:2009-03-10 21:24:29ITPUB社区12周年站庆徽章
日期:2013-10-08 17:44:42
26#
发表于 2007-12-19 11:52 | 只看该作者
原帖由 jiayanfei0215 于 2007-3-15 21:28 发表
XP 系统  没有你说的安全策略啊,怎么办? 帮帮忙啊!!



你xp什么版?gpedit.msc在运行里运行看看

使用道具 举报

回复
论坛徽章:
7
授权会员
日期:2007-12-29 10:25:23生肖徽章2007版:鸡
日期:2008-01-02 17:35:53生肖徽章2007版:猴
日期:2008-01-02 17:35:53生肖徽章2007版:兔
日期:2008-01-02 17:35:53生肖徽章2007版:虎
日期:2008-01-02 17:35:53生肖徽章2007版:牛
日期:2008-01-02 17:35:53生肖徽章2007版:鼠
日期:2008-01-02 17:35:53
27#
发表于 2007-12-20 11:10 | 只看该作者
有用的方法

使用道具 举报

回复
论坛徽章:
0
28#
发表于 2008-7-21 11:40 | 只看该作者
我安装的10G的时候administrator是空密码.但是用到导入数据的时候空密码是不行的.我就改了密码.好象就不行了.提示密码错误...

使用道具 举报

回复
论坛徽章:
2
2015年新春福章
日期:2015-03-04 14:51:122015年新春福章
日期:2015-03-06 11:57:31
29#
发表于 2008-12-5 19:07 | 只看该作者
强!!
你怎么知道的呢?
有没有人知道为什么啊?
增强安全性?那在sqlldr里可不用这些啊???

使用道具 举报

回复
论坛徽章:
150
蓝锆石
日期:2011-11-16 22:31:22萤石
日期:2011-11-17 13:05:31祖母绿
日期:2008-06-14 15:23:26海蓝宝石
日期:2011-11-16 22:25:15紫水晶
日期:2011-11-16 22:31:22红宝石
日期:2011-10-09 08:54:30蓝锆石
日期:2009-01-31 15:20:54萤石
日期:2008-12-22 15:22:00祖母绿
日期:2011-11-17 13:13:26海蓝宝石
日期:2008-07-05 14:52:18
30#
发表于 2008-12-10 09:53 | 只看该作者
汗,也困扰了自己很长时间
xp home版这样解决一下:
http://wt.3800hk.com/Soft/zhly/16327.html

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表