Login or Register to Ask a Question and Join Our Community


Emergency UNIX and Linux Support

Unable to connect to oracle in red hat linux

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Homework and Emergencies Emergency UNIX and Linux Support Unable to connect to oracle in red hat linux
# 1  
Old 01-17-2011
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 by using "system" and the corresponding passowrd ,it is throwing an error.(for error please see below)

Code:
SQL> show user
USER is ""
SQL> conn system
Enter password: 
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

please guide me how to resolve the issue

operating system details

Code:
[root@dhcppc0 ~]# uname -a
Linux dhcppc0 2.6.18-164.el5PAE #1 SMP Tue Aug 18 15:59:11 EDT 2009 i686 i686 i386 GNU/Linux

it is read hat linux 5

waiting your reply.
longlive
# 2  
Old 01-17-2011
Looks like Oracle did not start in the first place. Check the ps list to verify.

tyler_durden
# 3  
Old 01-17-2011
thanks Tyler,

I saw by using ps -ef|grep oracle
Code:
[biswa@dhcppc0 ~]$ ps -ef|grep oracle
biswa 4761 4685 0 13:29 pts/1 00:00:00 grep oracle

no oracle process is showing

Please guide me how to solve this

---------- Post updated at 04:05 PM ---------- Previous update was at 01:32 PM ----------

Hi ,

I checked with the status command and got the following outputs below
Code:
[root@dhcppc0 ~]# /etc/init.d/oracle-xe status

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-JAN-2011 15:46:39

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dhcppc0)(PORT=1521)))
TNS-12545: Connect failed because target host or object does not exist
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist

please help me to resolve this above issue.

God bless you all.

Moderator's Comments:
Mod Comment Please use code tags.
Last edited by Scott; 01-17-2011 at 06:45 AM.. Reason: Please use code tags
# 4  
Old 01-17-2011
Hello sanjay.login,

Have you defined a database yet or just installed the software? To define the database, you will need to decide all sorts of things, not least the data file sizes and locations (including if they are raw devices or files in the filesystem)

There is a whole procedure to create a database before you can sign on. How much have you got through?





Robin
Liverpool/Blackburn
UK
# 5  
Old 01-17-2011
You'll have to set some environment variables first for SQL*Plus to connect to the correct instance, especially ORACLE_SID. There's a handy script for that in /usr/lib/oracle/xe/app/oracle/product/<version>/server/bin/oracle_env.sh
# 6  
Old 01-17-2011
I suggest you watch this You Tube video on how to install it: How to install Oracle 10g Express on Linux
# 7  
Old 01-17-2011
hi puldi,

the error is not related to env variable setting,i installed in red hat 4 it was working fine the same way i did today for red hat 5 it is not working

the status is saying unable to start the database (in previous post)..

and for your reference the below is the line inside the env.sh script
Code:
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`
export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH
export PATH
if [ $?LD_LIBRARY_PATH ]
then
        LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
else
        LD_LIBRARY_PATH=$ORACLE_HOME/lib
fi
export LD_LIBRARY_PATH
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Fedora

Which is the better platform to learn UNIX/Linux (Kali Linux Vs. Red Hat or other)?

I just started a new semester and I started my UNIX class yesterday. I've already decided to use python along with my learning process but what I really want to use with it is Kali as my UNIX/Linux platform to learn off of since I already wanted to learn Cyber Sec. anyways. I just wanted to know if... (12 Replies)
Discussion started by: ApacheOmega
12 Replies

2. Red Hat

Unable to connect "Reliance Netconnect" on Redh Hat Linux 5

Hi Friends, Can someone help me with below issue , thanks. Subject : Unable to configure "Reliance NetConnect" on RHEL 5 Here some helpful information : # lsusb Bus 001 Device 001: ID 0000:0000 Bus 001 Device 002: ID 8087:0020 Bus 001 Device 003: ID 192f:0416 Bus 002 Device... (0 Replies)
Discussion started by: arunraj192
0 Replies

3. 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

4. Red Hat

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... (5 Replies)
Discussion started by: blacksteel1988
5 Replies

5. Red Hat

System unable to register with Red Hat Networks

ISSUE: The system is unable to register with Redhat network (RHN). SYSTEM DETAILS: RHEL6 (2.6.32-131.2.1.el6.x86_64). The firewall is turned off. I have network connectivity. There is no GUI. All work is done from the command line. The following files are installed:... (4 Replies)
Discussion started by: SmithJ
4 Replies

6. Red Hat

x-win client connect red hat

Hi, I use red hat linux ES 5.5 32 bit . There is x win(startx) installed. I wan to use XP at another computer and connect the x-win(startx) through IP network . Which software/freeware I can use ??? Please advice .. Is it free ??? (0 Replies)
Discussion started by: chuikingman
0 Replies

7. 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

8. Red Hat

connect Xwin by xdmp in red hat linux

I use redhat linux enterprise 4 , I setup and enable the xdmp already. I want to use XMing in window XP to connect to x server in this red hat linux and start the x-window . But I fail as it is no response from red hatl inux and time out ... Please advice what I need to do in the linux OS ??? (1 Reply)
Discussion started by: chuikingman
1 Replies

9. UNIX for Advanced & Expert Users

How do I connect windows xp to Linux Red hat unix

I just bought a new pc and my unix software is installed on my old computer. I want to take the hard disk outta my old pc and then install it on my new pc so my new pc has 2 hard drives. now, after my pc new has 2 hard drives, one being unix the other being windows xp, i want to be able to... (7 Replies)
Discussion started by: TRUEST
7 Replies

10. UNIX for Dummies Questions & Answers

Red Hat Linux 6.0

Ok here is my problem i do not know the command to load a driver for my network card in Ted hat linux 6.0 could sombody give me a hand. and if there is anyone that has a list of commands for red hat that would be great also (2 Replies)
Discussion started by: bbutler3295
2 Replies
Login or Register to Ask a Question