发布时间:2014-01-28 23:00:49
SQL> show parameter control_filesNAME TYPE------------------------------------ ---------------------------------VALUE------------------------------control_files string/u01/oracle/oradata/orcl/control01.ctl, /u01/oracle/oradata/orcl/control02.ctlSQL>&n.........【阅读全文】
发布时间:2014-01-28 21:14:02
参考Dave大神博客,修改了几个地方。Data Guard 环境:操作系统: redhat 5.6 Primary数据库:IP地址:192.168.48.131数据库SID:orclDB_UNIQUE_NAME:orcl_pd Standby数据库:IP地址:192.168.48.132数据库SID:orclDB_UNIQUE_NAME:orcl_st1.主库设置成force logging 模式SQL> alter databas.........【阅读全文】
发布时间:2014-01-28 19:23:01
PING[ARC2]: Heartbeat failed to connect to standby 'orcl_pd'. Error is 16009.Tue Jan 28 17:45:23 2014SQL> show parameter log_archive_dest_2 NAME TYPE------------------------------------ ---------------------------------VALUE------------------------------log_archive_.........【阅读全文】
发布时间:2014-01-27 16:11:24
登录oracle时候,发现乱码:[oracle@dg1 dbs]$ sqlplus "/as sysdba"SQL*Plus: Release 11.2.0.3.0 Production on Mon Jan 27 16:05:06 2014Copyright (c) 1982, 2011, Oracle. All rights reserved.???: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit ProductionWith the .........【阅读全文】
发布时间:2014-01-27 16:09:46
oracl修改编码后启动报错解决方式如下:SQL> startupORA-12700: invalid NLS parameter value (nls_language)#cd /u01/oracle/admin/orcl/pfile/#cp init.ora.027201412544 /u01/oracle/product/dbs/#cd /u01/oracle/product/dbs#mv init.ora.027201412544 initorcl.ora#sqlplus "/as sysdba"SQL> startup.........【阅读全文】