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: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

Action :

Il faut  définir le paramètre local_listener et enregistrer la base au près du listener

alter system set LOCAL_LISTENER=’(ADDRESS = (PROTOCOL = TCP)(HOST = SRVPROD05)(PORT = 1531))’ scope=both;

SQL> alter system register;

SQL> show parameter local

NAME                                 TYPE        VALUE
———————————— ———– ——————————
local_listener                       string      (ADDRESS = (PROTOCOL = TCP)(HO
ST = SRVPROD05)(PORT = 1531))

sqlplus system/manager@DIANET

SQL*Plus: Release 11.2.0.3.0 Production on Wed Dec 14 12:19:33 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Release 11.2.0.3.0 – 64bit Production

oraclementvotre

Pas encore de commentaire

Laisser une réponse

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