0:注意了,IP地址一定要用固定的,不要用DHCP
1:安装完Win7后,启用Administrator用户,并为其设置密码,以Administrator用户登录安装,这才是真正的“捅有超级权限的用户”,这样安装Oracle出错率更少
-------------------------------------------------------------------------------------------------------------------
2:在安装oracle前,修改个重要验证文件,进入ORACLE安装程序所在的目录,
(1)打开并编辑:stage/prereq/db/refhost.xml,加入如下内容:
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
(2)打开并编辑:install/oraparam.ini,在最后加入如下内容
[Windows-6.1-required]
#Minimum display colours for OUI to run
MIN_DISPLAY_COLORS=256
#Minimum CPU speed required for OUI
#CPU=300
[Windows-6.1-optional]
-------------------------------------------------------------------------------------------------------------------
3:当安装完oracle(企业管理器;数据库实例;监听器;网络服务名)后要添加最基础的几个环境变量,才可正常使用oracle常用工具
ORACLE_BASE=F:/oracle
ORACLE_HOME=%ORACLE_BASE%/product/10.2.0/db_1
ORACLE_SID=MANAGER #注意大小写
-------------------------------------------------------------------------------------------------------------------
4:在启动dbconsole前,必须更改两个文件
%ORACLE_HOME%/sysman/config/emd.properties
%ORACLE_HOME%/$HOSTNAME/sysman/config/emd.properties
在其最后加入(如果存在就修改,否则添加):注:$HOSTNAME为你的计算机名
#add by collonn
agentTZRegion=Asia/Shanghai
#agentTZRegion=GMT+8
#Asia/Shanghai这样的值可以在%ORACLE_HOME%/sysman/admin/supportedtzs.lst中找到你自己所在的时区
#注意,两个文件都要改,否则,错误依旧
-------------------------------------------------------------------------------------------------------------------
5:tnsnames.ora示例
MANAGER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = collonn-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MANAGER)
)
)
LOCALHOST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SID = MANAGER)
(SERVER = MANAGER)
)
)
-------------------------------------------------------------------------------------------------------------------
6:KO