Today I was configuring an old RDBMS 10.2.0.3 in a HPUX. I have created a database and configured a listener, but when I was testing the network connection I get the next results;
For the tnsping, all was ok;
C:\XXX\BIN> tnsping XXX TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 18-DIC-2017 15:55:05 Copyright (c) 1997, 2005, Oracle. All rights reserved. Archivos de parßmetros utilizados: C:\XXX\network\admin\sqlnet.ora Adaptador TNSNAMES utilizado para resolver el alias Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XXXXXXX)(PORT = XXXXX)) (CONNECT_DATA = (SID = rdb1))) Realizado correctamente (10 mseg)
For the sqlplus, I get the error;
C:\XXX\BIN> sqlplus XXX@XXX SQL*Plus: Release 10.2.0.1.0 - Production on Lun Dic 18 15:55:13 2017 Copyright (c) 1982, 2005, Oracle. All rights reserved. Introduzca la contrase±a: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist HPUX-ia64 Error: 2: No such file or directory
Maybe it can look a problem from Operating System. After a little research work I find the problem in the listener configuration, I was configured the SID_NAME in lowercases. I think moderm versions of Oracle on unix box don’t difference between uppercases or lowercases. In this case I have changed from lowercase and it resolved the problem.
HTH – Antonio NAVARRO