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