Oracle Listener Error on Red hat 5


 
Thread Tools Search this Thread
Operating Systems Linux Red Hat Oracle Listener Error on Red hat 5
# 1  
Old 11-23-2011
Data Oracle Listener Error on Red hat 5

Hello everybody, the reason why im posting this thread is because i've installed an oracle test database on RHEL 5, on a localhost (Since it is for test)... the thing is, after i have installed the DB it works just fine, but after i re start it, i get the following errors when i want to go into the sqlplus....

Code:
[oracle@localhost ~]$ sqlplus system

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 22 22:28:10 2011

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

Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

Smilie
i already checked my listener.ora and i get this...
Code:
[oracle@localhost admin]$ more listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/n
etwork/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    )
  )

and sqlnet.ora gives me this...

Code:
[oracle@localhost admin]$ more sqlnet.ora
# sqlnet.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/net
work/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

tnsnames.ora goes like...


Code:
[oracle@localhost admin]$ more tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/n
etwork/admin/tnsnames.ora
# Generated by Oracle configuration tools.

PRUEBADB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = PRUEBADB)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

I've searched over the web and i have found nothing... And i already thank you for your time. Hope you can help me.
# 2  
Old 11-23-2011
You need to first check if your oracle env setting is correct.

what are the value of oracle env variables

ORACLE_SID and ORACLE_HOME
# 3  
Old 11-23-2011
The values are...

Code:
[oracle@localhost~]$ echo $ORACLE_HOME

/u01/app/oracle/product/10.2.0/db_1

and ...

Code:
[oracle@localhost~]$ echo $ORACLE_SID
TESTDB

# 4  
Old 11-25-2011
The Oracle System ID (SID) is used to uniquely identify a particular database on a system.

your ORACLE_SID should be the
PHP Code:
PRUEBADB 
# 5  
Old 11-25-2011
Error Same trouble

Quote:
Originally Posted by amitranjansahu
The Oracle System ID (SID) is used to uniquely identify a particular database on a system.

your ORACLE_SID should be the
PHP Code:
PRUEBADB 
Ok, i already re installed the DB and im having the same problem, and this time my ORACLE_SID value is PRUEBADB. Any thoughts???
# 6  
Old 11-29-2011
are you able to connect a sysdba

PHP Code:
sqlplus '/ as sysdba' 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Red Hat: Error connecting using secure shell

Hi All, I am getting below error when I try to connect with ssh. Not sure why the error is on.I am able to connect from a different login from the same server (local: rhe/home/s3>) ssh acces1@91.1.12.102 Connection closed by 91.1.12.102 (local: rhe/home/s3>) ssh redhlinx102 Connection... (7 Replies)
Discussion started by: arunkumar_mca
7 Replies

2. Linux

Error on smbclient login on Red Hat

I have the smbclient installed and I am able to see information from the '-L' option. But when I attempt to login I'm getting the "NT_STATUS_BAD_NETWORK_NAME". I was hoping for help, because I'm not sure what is supposed to go into the smb.conf file. My goal is to transfer files from my Linux... (2 Replies)
Discussion started by: islanderman
2 Replies

3. Red Hat

collect red hat linux error logs

Hi, I have two questions,first of all is where can I collect more error logs(the log under /var/log/messages), also give the corresponding explain is grateful.The second one is the log under various versions(such as red hat,suse,etc) is the same or not. Thanks for answers. (1 Reply)
Discussion started by: zhaoyy
1 Replies

4. UNIX for Dummies Questions & Answers

how to know if i use "Red Hat Enterprise Linux" or "Red Hat Desktop" ?

how to know if i use "Red Hat Enterprise Linux" or "Red Hat Desktop" ? (2 Replies)
Discussion started by: ahmedamer12
2 Replies

5. Emergency UNIX and Linux Support

Unable to connect to oracle in red hat linux

Hi Gurus, I have installed the oracle xpress 10g edition in my red hat linux and saw the message that it has been installed successfully ,but after that I started the database by going through application->database->start database and after that i open the sql prumt but when i tried to connect... (18 Replies)
Discussion started by: sanjay.login
18 Replies

6. Red Hat

Oracle client for Red Hat linux on IBM PPC64

Hi , Am trying to install oracle 10g client on Red Hat Linux in an IBM PPC machine. when i try to install during linking am getting the below error My software details : Oracle Version : 10.2.0 Red Hat Version : 5.5 Server Hardware : PPC 64 Error from the logs : /usr/bin/make -f... (7 Replies)
Discussion started by: mugunthanvh
7 Replies

7. Infrastructure Monitoring

Test if Oracle listener is running

Hi All , I am new to shall scripting, i want write an script for oracle tns and listener. If tns working i want o/p as "Listener and TNS are working" else o/p should be ""Listener and TNS are not Working" below is the command in unix to check the tns status, if no output it means TNS... (3 Replies)
Discussion started by: abdul bari
3 Replies

8. Red Hat

Buffer I/O error in red hat linux boot up

I get error message when boot up red hat linux Buffer I/O error on device hdc ,logical block XX ... /dev/hdc:read failed after 0 of 2048 at 0 : input/output error ..... I paste the /etc/fstab file in here /dev/hdc is cdrom How can I fix it Please advice # cat /etc/fstab # This file... (3 Replies)
Discussion started by: chuikingman
3 Replies

9. Linux

red hat check error log

Hi All, Where should start checking error on red hat? I want to check error on system, paging, memory, pci, external storage, etc. I few advise will do and highly appreciated. Thanks, itik (3 Replies)
Discussion started by: itik
3 Replies
Login or Register to Ask a Question