Création de configuration DataGuard Broker (Error: ORA-16796: one or more properties could not be)

**lyl2011** · 21/07/2011, 13h53

Bonjour à tous ,

Cela fait 2 semaines que je galère sur la creation de mon environnement dataguard broker.
Je travail sur un environnement (redhat 5 oracle 11G R1).

----------------------------------------------------------------------------------
BASE PRINCIPALE
----------------------------------------------------------------------------------

Procesus de creation

-J'ai créé une base principale que jai appelé PRIMARY.
-Je l'ai mise en ARCHIVELOG
-Je l'ai mise en FORCE_LOGGING

-J'ai crée 4 standby redo lofile à l'ai de :
PRIMARY>alter database add standby logfile '/rep ' size 50M;

J'ai créer aussi un standby controfile à l'aide de:
PRIMARY>Alter Database Create Standby Controlfile as '/rep/control01.ctl';
que j'ai ensuite tranferer sur ma base de secours en temps que fichier de controle.

Ensuite voici mon listener.ora de PRIMARY ma base principale

LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.132)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PRIMARY)
(ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME=PRIMARY)
)
)

Ensuite voici mon tnsnames.ora de PRIMARY ma base principale

PRIMARY =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = 192.168.159.132)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = PRIMARY)
)
)
SECONDARY=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.159.133)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = SECONDARY)
)
)

--------------------------------------------------------------
Jai créer un fichier de paramètre

PRIMARY> CREATE PFILE FROM SPFILE

Voici mon initPRIMARY.ora après modification

PRIMARY.__db_cache_size=163577856
PRIMARY.__java_pool_size=12582912
PRIMARY.__large_pool_size=4194304
PRIMARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
PRIMARY.__pga_aggregate_target=104857600
PRIMARY.__sga_target=318767104
PRIMARY.__shared_io_pool_size=0
PRIMARY.__shared_pool_size=134217728
PRIMARY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/PRIMARY/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/PRIMARY/control01.ctl','/u01/app/oracle/oradata/PRIMARY/control02.ctl','/u01/app/oracle/oradata/PRIMARY/control03.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PRIMARY'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)'
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_unique_name='PRIMARY'
FAL_Client='PRIMARY'
FAL_Server='SECONDARY'
Log_archive_config='DG_CONFIG=(PRIMARY,SECONDARY)'
Log_archive_dest_1='Location=USE_DB_RECOVERY_FILE_DEST
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
Log_archive_dest_2='Service=SECONDARY lgwr async
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
db_unique_name=SECONDARY'
Log_archive_dest_state_1=ENABLE
Log_archive_dest_state_2=DEFER
Service_names='PRIMARY'
Standby_File_Management='AUTO'

-------------------------------------------------------------------------------------------------
BASE DE SECOURS
-------------------------------------------------------------------------------------------------
voici le contenu de mon fichier initSECONDARY.ora

SECONDARY.__db_cache_size=163577856
SECONDARY.__java_pool_size=12582912
SECONDARY.__large_pool_size=4194304
SECONDARY.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
SECONDARY.__pga_aggregate_target=104857600
SECONDARY.__sga_target=318767104
SECONDARY.__shared_io_pool_size=0
SECONDARY.__shared_pool_size=134217728
SECONDARY.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/SECONDARY/adump'
*.audit_trail='db'
*.compatible='11.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/SECONDARY/control01.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='PRIMARY'
*.db_recovery_file_dest='/u01/app/oracle/flash_recovery_area'
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest='/u01/app/oracle'
*.db_unique_name='SECONDARY'
*.dg_broker_start=TRUE
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PRIMARYXDB)'
*.Fal_client='SECONDARY'
*.fal_server='PRIMARY'
*.log_archive_config='dg_config=(SECONDARY,PRIMARY)'
*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST','valid_for=(ALL_LOGFILES, ALL_ROLES)'
*.log_archive_dest_2='service="PRIMARY"','LGWR ASYNC NOAFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="PRIMARY" net_timeout=30','valid_for=(all_logfiles,primary_role)'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_format='ARC%S_%R.%T'
*.memory_target=422576128
*.log_archive_max_processes=30
*.log_archive_min_succeed_dest=1
*.log_archive_trace=0
*.log_file_name_convert='PRIMARY','SECONDARY'
*.standby_archive_dest=''
*.standby_file_management='AUTO'
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'

Le fichier listener.ora

LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.133)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=SECONDARY)
(ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME=SECONDARY)
)
)

Pour mon fichier de mot de passe j 'ai dupliqué la pricipale que j'ai renommé.

_____________________________________________________
sur mon système de ma base de secours j'ai fait

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
$export ORACLE_SID=SECONDARY
$SQLPLUS / as sysdba
SECONDARY>CREATE SPFILE FROM PFILE;
SECONDARY>STARTUP NOMOUNT
SECONDARY>alter database mount standby database;
SECONDARY>alter database recover managed standby database disconnect from session;

Tout a bien fonctionné !!!

_____________________________________________________
sur mon système de ma base principale j'ai fait

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
$export ORACLE_SID=PRIMARY
$SQLPLUS / as sysdba
PRIMARY>ALTER SYSTEM SET dg_broker_start=TRUE  SCOPE=spfile;
PRIMARY> shutdown abort;
PRIMARY> startup;
PRIMARY> exit

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
DGMGRL> connect sys/manager@primary
Connected.
DGMGRL> CREATE CONFIGURATION ‘sample’ AS PRIMARY DATABASE IS ‘primary’ CONNECT IDENTIFIER IS primary;
Configuration “sample” created with primary database “primary”
DGMGRL> show  configuration
Configuration – sample
Protection Mode: MaxPerformance
Databases:
primary – Primary database
Fast-Start Failover: DISABLED
Configuration Status:
DISABLED

DGMGRL> ADD DATABASE ‘secondary’ AS CONNECT IDENTIFIER IS secondary MAINTAINED A
S PHYSICAL;
Error: ORA-16796: one or more properties could not be imported from the database
Failed. ???

Merci d'avance pour tous ceux qui voudront bien m'aider.

**jkofr** · 21/07/2011, 15h18

Hello,

Et le tnsnames.ora de ta secondary?

Jko

**lyl2011** · 21/07/2011, 15h31

Envoyé par jkofr

Hello,

Et le tnsnames.ora de ta secondary?

Jko

Mon tsnames.ora de la base de secours est similaire a la principale.

**jkofr** · 21/07/2011, 15h50

Hello,

Ok vu, a priori, il te manque les services db_unique_name_DGMGRL.db_domain au niveau de tes listener primary et standby.

Sans ca, ca ne fonctionne pas.

Jko

**lyl2011** · 21/07/2011, 18h20

Apres les modifs voici le contenu de mon listener.ora ,jai fait de même pour la base secours

LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.159.132)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=extproc))))
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=PRIMARY_DGMGRL)
(SERVICE_NAME=PRIMARY)
(ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1)
(SID_NAME=PRIMARY)
)
)

Resultat

[oracle@localhost admin]$ dgmgrl sys/admin@primary
DGMGRL for Linux: Version 11.1.0.6.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Unable to connect to database
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Failed.

qd je fais

[oracle@localhost admin]$ dgmgrl sys/admin
DGMGRL for Linux: Version 11.1.0.6.0 - Production

Copyright (c) 2000, 2005, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
Connected.

Mais j'ai tjr le meme pb ???

**jkofr** · 21/07/2011, 19h41

Hello,

Jette un coup d’œil ici http://download.oracle.com/docs/cd/B...95/install.htm

La configuration network est très importante.

Bon courage
jko

Création de configuration DataGuard Broker (Error: ORA-16796: one or more properties could not be)

Administration Oracle

Vue hybride

Discussions similaires

Partager

Partager