Pages: 2/12 First page Previous page 1 2 3 4 5 6 7 8 9 10 Next page Final page [ View by Articles | List ]

"ORA-12528"

[不指定 2010/03/22 16:32 | by askwan ]
today,i create a duplicate database from a source databse
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 22-MAR-2010 16:23:38
…………
  Instance "test1", status BLOCKED, has 1 handler(s) for this service...
The command completed successfully

when connect to instance test,
"ORA-12528: TNS:listener: all appropriate instances are blocking new connections"

read metalink 419440.1,found that from all oracle 9i to oracle 11g have this problem !
what cause of this problem is, although  instance starts, but did not register to the listener.
Instance through the PMON process to listen on the register, while the PMON process requires
the instance start in the MOUNT status!
then editor $ORACLE_HOME/network/admin/listener.ora
add :
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_NAME = test1)
      (ORACLE_HOME =  /u01/app/oracle/product/11.2.0/db_1)
      (SID_NAME = test1)
    )
  )

then restart listener,and then
Instance "test1", status UNKNOWN, has 1 handler(s) for this service...l
Tags: ,
DataBase | Comments(0) | Trackbacks(0) | Reads(493)

Streaming Replication in postgresql 9.0

[不指定 2010/03/18 14:46 | by askwan ]
     Streaming Replication (SR) is an important new feature in postgresql 9.0 ,it can provides the capability to continuously ship and apply the WAL XLOG records to some number of standby servers in order to keep them current.
and,this new feature has included in PostgreSQL 9.0 Alpha4.

now, i write this article to test and experience this new feature !

env:
OS version: debian lenny 5.0 x86_64
Postgresql version : 9.0 alpha4
IP: 192.168.0.156


my planning is below

Master:
====================================
installded : /usr/local/pgsql_master
DATA=/usr/local/pgsql_master/data
port:5432
Archive_dest:/usr/local/pgsql_master/data/archive_master

Standby:
=====================================
installded : /usr/local/pgsql_standby
DATA=/usr/local/pgsql_standby/data
port:5433
Archive_dest:/usr/local/pgsql_standby/data/archive_standby



step 1 : download PostgreSQL 9.0 Alpha4 and install postgresql for both master and standby
Tags: , , , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(557)

Oracle Block Change Tracking

[不指定 2010/03/16 17:27 | by askwan ]
Oracle Block Change Tracking is a new feature in oracle 10g ,it can improve RMAN incremental backup proformance by recording changed blocks in each datafile use a change tracking file.If change tracking is enabled, RMAN uses the change tracking file to identify changed blocks for incremental backup, thus avoiding the need to scan every block in the datafile.
Identify current database enable block change tracking feature or not:
SQL> select filename,status,bytes from v$block_change_tracking;

FILENAME
--------------------------------------------------------------------------------
STATUS          BYTES
---------- ----------

DISABLED

Enabling and Disabling Change Tracking:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
*
ERROR at line 1:
ORA-19773: must specify change tracking file name

ENABLE BCT:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
  2  USING FILE '/opt/oracle/oracle/flash_recovery_area/CAPITALV/rman_change_track.f' REUSE;

Database altered.
SQL> select filename,status,bytes from v$block_change_tracking;

FILENAME
--------------------------------------------------------------------------------
STATUS          BYTES
---------- ----------
/opt/oracle/oracle/flash_recovery_area/CAPITALV/rman_change_track.f
ENABLED      11599872

Tags: , , , ,
DataBase | Comments(0) | Trackbacks(0) | Reads(542)

configuration oracle data guard for testing

[不指定 2010/03/11 14:39 | by askwan ]
OS: CentOS 5.4 x86_64
Oracle: Oracle 10.2.0.1 64bit for linux
  
题外话：有些东西长时间不接触，而理解又不深刻的话，慢慢就淡忘了。。。
这个笔记是边参考文档oracle 10g《Data Guard Concepts and Administration》，边验证记录下的
仅供参考

单机环境配置oracle 10g dataguard (physical standby)
IP：192.168.0.21
预期规划如下：

主库：
db_name=dg1
sid=dg1  
db_unique_name=primary  
network_service_name=primary_21

ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/dg1
归档日志路径=/u01/oracle/oradata/dg1/archive
警告跟踪等日志文件路径=/u01/oracle/admin/dg1/

从库：
dg_name=dg1
sid=standby  
db_unique_name=standby  
network_service_name=standby_21

ORACLE_BASE=/u01/oracle
ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
数据文件路径=/u01/oracle/oradata/standby
归档日志路径=/u01/oracle/oradata/standby/archive
警告跟踪等日志文件路径=/u01/oracle/admin/standby



1 准备工作
Tags: ,
DataBase | Comments(0) | Trackbacks(0) | Reads(376)
Pages: 2/12 First page Previous page 1 2 3 4 5 6 7 8 9 10 Next page Final page [ View by Articles | List ]