|
|
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
Добрый день коллеги. Не могу разобраться в чем проблема на standby выдает ошибку Error 12154 received logging on to the standby FAL[client, USER]: Error 12154 connecting to node for fetching gap sequence вот ini.файл node.__java_pool_size=67108864 node.__large_pool_size=83886080 node.__oracle_base='/u/app/oracle'#ORACLE_BASE set from environment node.__pga_aggregate_target=2667577344 node.__sga_target=4194304000 node.__shared_io_pool_size=0 node.__shared_pool_size=738197504 node.__streams_pool_size=0 *.audit_file_dest='/u/app/oracle/admin/node/adump' *.audit_trail='db' *.compatible='11.2.0.4.0' *.control_file_record_keep_time=31 *.control_files='/db1/oradata/node/control01.ctl','/db1/oradata/node/control02.ctl' *.db_block_size=8192 *.db_domain='' *.db_name='standby' *.diagnostic_dest='/u/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=nodeXDB)' *.job_queue_processes=1000 *.memory_target=5856638464 *.open_cursors=300 *.processes=350 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=390 *.undo_tablespace='UNDOTBS' *.log_archive_dest_1='LOCATION=/u/app/oracle VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=standby' *.log_archive_dest_2='SERVICE=node lgwr async reopen=15 max_failure=10 optional net_timeout=30 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=node' *.log_archive_start=TRUE *.log_buffer=10485760 *.log_checkpoint_timeout=18000 *.standby_archive_dest='/u/app/oracle' *.standby_file_management='AUTO' *.FAL_SERVER='node' при чем могу конентится со standby на node В чем может быть проблема? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 13:59:00 |
|
||
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
tnsping со standby tnsping primary TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-JUL-2016 17:01:14 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: /u/app/product/11.2.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.220.0.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = node))) OK (0 msec) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 14:04:00 |
|
||
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
1) oracle error description Код: plsql 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. 38. 39. 40. 41. 42. 2) У Вас (это init со standby?): Код: plsql 1. А Вы проверяете: Код: plsql 1. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 14:21:07 |
|
||
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
Mylene*.FAL_SERVER='node' Mylenetnsping primary так он все же primary или node? ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 14:31:47 |
|
||
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
Q.Tarantino, да init файл со стандбая tnsping со standby на primary tnsping primary TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 04-JUL-2016 17:38:21 Copyright (c) 1997, 2013, Oracle. All rights reserved. Used parameter files: /u/app/product/11.2.0/dbhome_1/network/admin/sqlnet.ora Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.220.0.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = node))) OK (0 msec) TNSNAMES.ora STANDBY = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.220.0.4)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = standby) ) ) primary = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.220.0.3)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = node) ) ) ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 14:44:15 |
|
||
|
настройка standby
|
|||
|---|---|---|---|
|
#18+
MyleneQ.Tarantino, да init файл со стандбая ты совсем не читаешь что у тебя спрашивают? посмотри что прописано в fal_server!!! или иди картриджи меняй, это твое. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 04.07.2016, 15:32:32 |
|
||
|
|

start [/forum/topic.php?fid=52&msg=39267645&tid=1887964]: |
0ms |
get settings: |
5ms |
get forum list: |
16ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
73ms |
get topic data: |
10ms |
get forum data: |
4ms |
get page messages: |
36ms |
get tp. blocked users: |
1ms |
| others: | 192ms |
| total: | 343ms |

| 0 / 0 |
