|
# 42779
迷
|
|
|
To: eygle
你好,eygle
我下载了windows 2000 server下的oracle9i升级包,名称为P3948480_9206_winnt.zip,将9.2.0.1.0版本升级到9.2.0.6.0,操作如下:
1.执行补丁包Disk1\install\setup.exe文件,安装到原来的oracle_home目录下成功;
2.--设置共享池和JAVA池大于150M
ALTER SYSTEM SET SHARED_POOL_SIZE=''''150M'''' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE=''''150M'''' SCOPE=spfile;
修改相应的表空间大小
3.shutdown immediate
startup migrate到升级模式
执行升级脚本 @D:\oracle\ora92\rdbms\admin\catpatch.sql;
成功
4.还原共享池和JAVA池大小,根据实际情况设置
ALTER SYSTEM SET SHARED_POOL_SIZE=''''48M'''' SCOPE=spfile;
ALTER SYSTEM SET JAVA_POOL_SIZE=''''32M'''' SCOPE=spfile;
shutdown immediate;
STARTUP;
至此升级完毕,但是用sqlplus进去之后,还是看到版本为
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
不知道那里出了问题???
From: 迷 2007.04.06 17:21
|
|
|
|
|
To: 迷
要按照升级手册里面的步骤操作,升级的步骤不止这几步。
From: eygle 2007.04.09 08:57
|
|
|
|
|
# 43226
shadow
|
|
|
To: eygle
你好 eygle
我在数据库恢复当中用到了set newname for datafile命令,但怎么执行rman都提示在新路径不能创建数据文件。
我的流程是这样的:我将产品库的备份拿过来准备在另外一台机器上(分区、目录跟产品库都不同)进行全库恢复 ,控制文件和spfile都成功恢复并且数据库已经启动到mount状态,但在restore database时提示(在之前所有数据文件的set newname for datafile命令都成功了)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 04/06/2007 16:59:44
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '+ORACLEDG/datafile/system.dbf'
我要将它恢复到 /u01/oradata/下
最后我在参数文件配置了db_file_name_convert参数但还是不行。
希望您能指导。是不是我对set newname for datafile命令的理解不对 谢谢
From: shadow 2007.04.06 17:07
|
|
|
|
|
# 42776
rocket_zhao
|
|
|
To: eygle
怎么邮购啊?
From: rocket_zhao 2007.04.03 16:39
|
|
|
|
|
To: rocket_zhao
发邮件给我,我邮寄给你
From: eygle 2007.04.04 22:29
|
|
|
|
|
# 42773
Chi
来自: Mexico
|
|
|
To: Eygle
How did U set your "报警邮件" about the condition of system hardware?It is from OS level or from Oracle.Can give me a suggestion or you steps? I know you are working on Sun Solaris, but maybe I can use as a reference for my AIX 5.3?
From: Chi 2007.04.03 03:06
|
|
|
|
|
To: Chi
EMC的存储可以配置自动发送报警邮件,操作系统一般我们通过mailx发送邮件;现在Oracle10g数据库也可以配置自动发送告警邮件了。
From: eygle 2007.04.03 14:49
|
|
|
|
|