Archive | Incident Flux RSS de cette section

ORA-00130: invalid listener address

27 mar

. oraenv sqlplus / as sysdba SQL>STARTUP; ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: invalid listener address ‘(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)) Analyse : [oracle@localhost]$ cat /etc/hosts # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 $hostname localhost2 explication: Le nom du serveur est […]

DMON: HEALTH CHECK ERROR: ORA-16766: Redo Apply is stopped & ORA-16826: apply service state is inconsistent

1 mar

Incident: L’un de nos clients qui utilise ça base dataguard en lecture nous signale que les données saisis  en production la veille ne sont toujours pas visibles sur le serveur de dataguard . Analyse : contrôle de la configuration sur la dataguard DGMGRL>show configuration Configuration – db4_dg Protection Mode: MaxPerformance Databases: db3_dg – Primary database […]

RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

16 fév

[ora12c@nsbd48 admin]$ rman target sys/******@ORA11T12 auxiliary sys/******@ORA11T12_stby Recovery Manager: Release 12.1.0.2.0 – Production on Wed Feb 15 13:29:19 2017 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. connected to target database: ORA11T12 (DBID=859624249) RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed […]

ORA-00313: open failed for members of log group 2 of thread 1

3 fév

Chér(e) ami(e) en Oracle Comme toujours je souhaite partagé la solution des incidents oracle et voici encore un startup ORA-00313: open failed for members of log group 2 of thread 1 ORA-00312: online log 2 thread 1: ‘/u01/app/oradata\REDO02.LOG’ Dans cette situation, l’instruction ALTER DATABASE CLEAR LOGFILE ou ALTER DATABASE CLEAR UNARCHIVED LOGFILE peuvent être utilisé […]

ORA-27101: shared memory realm does not exist

14 déc

  Aprés une migration de base d’oracle 10g vers la 11g  je rencontre cette d’erreur .   sqlplus system/manager@DIANET SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 14 11:50:59 2016 Copyright (c) 1982, 2011, Oracle.  All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist IBM AIX RISC System/6000 Error: 2: […]

1234

Unblog.fr | Créer un blog | Annuaire | Signaler un abus