Przejdź do głównej zawartości

オラクル | oracle blog | Kamil Piórek | kamil.piorekk@gmail.com

Szukaj na tym blogu

SQLnet.ora EXCLUDE NODE after ORA-01017 Invalid Username/Password

listopada 03, 2016

Pobierz link
Facebook
X
Pinterest
E-mail
Inne aplikacje

SQLnet.ora EXCLUDE NODE

after ORA-01017 Invalid Username/Password Ha#@! To DO @!

Pobierz link
Facebook
X
Pinterest
E-mail
Inne aplikacje

Komentarze

Prześlij komentarz

Popularne posty

RMAN DUPLICATE ORA-19838 RMAN-06054 || ORA-19838: Cannot use this control file to open database || RMAN-06054: media recovery requesting unknown archived log

****************************************************************************************** RMAN DUPLICATE ORA-19838 RMAN-06054 **** Rman Script connect catalog '<rmanuser>/<rmanuser_pwd>@<tns_for_rman_catalog>'; connect auxiliary / ; run { allocate auxiliary channel t1_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t2_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t3_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; allocate auxiliary channel t4_db device type sbt parms="ENV=(NB_ORA_SERV=<hostname>, NB_ORA_CLIENT=<hostname>)"; duplicate database <src_db_name> to <dsT-db_name>; release channel t1_db; release channel t2_db; release channel t3_db; release channel t4_db; } ************************************...

ORA-00305: log 1 of thread 1 inconsistent; belongs to another database

log_file_name_convert fail ;) ORA-00305 DUPLICATE| RMAN ORA-00305 | REDO ORA-00305 ORA-00305: log 1 of thread 1 inconsistent; belongs to another database Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00305: dziennik 6 wątku 1 jest niezgodny; należy do innej bazy danych ORA-00312: dziennik online 6 wątek 1: '/oradb1/scomm/redo06.log' Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00305: dziennik 7 wątku 1 jest niezgodny; należy do innej bazy danych ORA-00312: dziennik online 7 wątek 1: '/oradb1/scomm/redo07.log' Errors in file /oracle/app/product/diag/rdbms/scomm/scomm/trace/scomm_m000_2253032.trc: ORA-00316: dziennik 8 wątku 1, typ 0 w nagłówku nie jest plikiem dziennika ORA-00312: dziennik online 8 wątek 1: '/oradb1/scomm/redo08.log' SQL> select GROUP#, status,MEMBERS ,archived from v$log ; GROUP# STATUS MEMBERS ARC ---------- ---------------- ---------...

Enterprise Manager Target Relocation | EM Traget New Agent | EM Target new host

Procedure to replace EM agents to new target. Hand made after documented by oracle option failed. >> emcli relocate_targets -src_agent="hostnamec:9999" -dest_agent="hostnamea:9999" -target_name=preprod_pccdb -target_type=oracle_database -copy_from_src -force=yes -ignoreTimeSkew=yes ##### SELECT 'emcli relocate_targets -src_agent=hostnamec -dest_agent=hostnamea -target_name='||target_name -target_type='||target_type 'as relocate_target FROM MGMT_TARGETS where TARGET_TYPE LIKE 'oracle_database' and target_name like 'preprod%' ; Result> 2016.11.04 16:12:53 [ oracle@oms_node_1:/oracle/app/product/middleware/oms/bin ] get_type=oracle_database -copy_from_src -force=yes -ignoreTimeSkew=yesdb-a:9999 -target_name=preprod_pccdb -tar Errors from relocating targets from hostnamec:9999 to hostnamea:9999 Error from target relocation while performing relocation from null to null, ERROR Message: The following pluginsare not of the same versi...

Obsługiwane przez usługę Blogger