ORA-01034, ORA-27101 and HPUX-ia64 Errors

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

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s