我的论坛主题

• RAC安装又有问题

  2008-09-16 14:37:12   /   Oracle数据库管理

  在节点二执行，有错误[root@rac2 oracle]# /u01/app/oracle/product/10.2.0/crs_1/root.shWARNING: directory '/u01/app/oracle/product/10.2.0' is not owned by rootWARNING: directory '/u01/app/oracle/product' is not owned by rootWARNING: directory '/u01/app/oracle' is not owned by rootChecking to see if Oracle CRS stack is already configuredSetting the permissions on OCR backup directorySetting up NS directoriesFailed to upgrade Oracle Cluster Registry configuration# GSD should b

  查看(226) 评论(14)

• RAC安装错误

  2008-09-15 12:00:55   /   Oracle数据库管理

  第一次安装crs安装成功但少装另一节点，后用oui删除再次安装时，就报错了是不是raw没清，还是其它错误啊特此请教各位了

  查看(266) 评论(22)

• stream同步出错

  2008-08-12 11:12:05   /   Oracle数据库管理

  版本：10.2.1.0两个数据库都是主库：alter system set aq_tm_processes=2 scope=both;alter system set job_queue_processes=10 scope=both;alter system set parallel_max_servers=20 scope=both;alter system set undo_retention=3600 scope=both;alter system set nls_date_format='YYYY-MM-DD HH24:MI:SS' scope=spfile;alter system set streams_pool_size=25M scope=spfile;alter system set utl_file_dir='*' scope=spfile;alter system set open_links=4 scope=spfile;conn strmadmin/strmadmincr

  查看(223) 评论(9)

• 关于stream的一个问题

  2008-08-11 14:31:12   /   Oracle数据库管理

  主库：conn strmadmin/strmadmincreate database link a connect to strmadmin identified by strmadmin using 'a';从库：conn strmadmin/strmadmin@acreate database link www connect to strmadmin identified by strmadmin using 'www';主库：conn strmadmin/strmadminbegindbms_streams_adm.set_up_queue(queue_table => 'master_queue_table',queue_name => 'master_queue');end;/begindbms_streams_adm.add_schema_rules(schema_name => 't',

  查看(124) 评论(1)

• 执行duplicate没反应了

  2008-08-05 13:27:24   /   Oracle数据库管理

  duplicate target database to dupdb_file_name_convert=('E:OracleFilesDatabaseFilesaa','E:OracleFilesDatabaseFilesdup')logfile group 1 ('E:OracleFilesDatabaseFilesdup
  edo01_1.log','E:OracleFilesDatabaseFilesdup
  edo01_2. log') size 1M,group 2 ('E:OracleFilesDatabaseFilesdup
  edo02_1.log','E:OracleFilesDatabaseFilesdup
  edo02_2. log') size 1M;。。。正在执行命令: SET until clause启动 recover 于 2008-08-05 12:53:33分配的通道: ORA_AUX_DISK_1通道 ORA_AUX_DISK_1: sid=265 devtype=DI

  查看(110) 评论(1)

• 连接辅助数据库问题

  2008-08-05 10:17:53   /   Oracle数据库管理

  C:Documents and Settingswww>rman target / auxiliary sys/dup@dup恢复管理器: Release 10.2.0.1.0 - Production on 星期二 8月 5 10:16:07 2008Copyright (c) 1982, 2005, Oracle.All rights reserved.连接到目标数据库: A (DBID=3891897557)RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: 内部恢复管理器程序包初始化失败

  查看(143) 评论(4)

• 虽然报了错，但能顺利打开

  2008-08-04 13:07:17   /   Oracle数据库管理

  RMAN> run {2> set newname for datafile 1 to 'D:oracleproduct10.2.0oradataasystem01.dbf';3> set newname for datafile 2 to 'D:oracleproduct10.2.0oradataaundotbs01.dbf';4> set newname for datafile 3 to 'D:oracleproduct10.2.0oradataasysaux01.dbf';5> set newname for datafile 4 to 'D:oracleproduct10.2.0oradataausers01.dbf';6> sql "alter database rename file ''E:OracleFilesDatabaseFilesAa
  edo01.log''7> to ''D:oracleproduct10.2.0oradataa
  edo01.log'' ";8> sql "alter database re

  查看(191) 评论(6)

• 重建控制文件出错

  2008-07-31 14:38:12   /   Oracle数据库管理

  SQL> CREATE CONTROLFILE REUSE SET DATABASE "WWW" RESETLOGS NOARCHIVELOG2MAXLOGFILES 163MAXLOGMEMBERS 34MAXDATAFILES 1005MAXINSTANCES 86MAXLOGHISTORY 2927LOGFILE8GROUP 1 'D:ORACLEPRODUCT10.2.0ORADATAWWW
  odo01.log' SIZE 10M,9GROUP 2 'D:ORACLEPRODUCT10.2.0ORADATAWWW
  odo02.log' SIZE 10M,10GROUP 3 'D:ORACLEPRODUCT10.2.0ORADATAWWW
  odo03.log' SIZE 10M11DATAFILE12'D:ORACLEPRODUCT10.2.0ORADATAWWWSYSTEM01.DBF',

  查看(160) 评论(6)

• 加hits怎么无效呢

  2008-07-29 11:12:23   /   Oracle数据库管理

  SQL> select * from v$version where rownumselect /* index(big big_idx) */ * from big where object_id

  查看(140) 评论(5)