Home » SQL & PL/SQL » Client Tools » Unable to connect database. (Oracle 10.2.0.1.0 R2)
Unable to connect database. [message #544394] Tue, 21 February 2012 08:53 Go to next message
orafaq_user
Messages: 16
Registered: November 2006
Junior Member
[oracle@localhost ~]$ sqlplus system/password

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:20:09 2012

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

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


=================================================================
But when i am using SID name while connecting to database i am able to connect...

[oracle@localhost ~]$ sqlplus system/password@apple

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 21 20:21:42 2012

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>


I have only one database...

TNS.......

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

APPLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 72.0.0.11)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apple)
)
)

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



Re: Unable to connect database. [message #544395 is a reply to message #544394] Tue, 21 February 2012 08:56 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
your ORACLE_SID evironment is probably set wrong.
Re: Unable to connect database. [message #544396 is a reply to message #544395] Tue, 21 February 2012 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/


what is OS name & version?
Re: Unable to connect database. [message #544397 is a reply to message #544396] Tue, 21 February 2012 09:02 Go to previous messageGo to next message
orafaq_user
Messages: 16
Registered: November 2006
Junior Member
OS is Fedora 7.
ORACLE_SID=APPLE
Re: Unable to connect database. [message #544401 is a reply to message #544397] Tue, 21 February 2012 09:06 Go to previous messageGo to next message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
post results from OS commands

id
env | sort
ps -ef | grep -i pmon
Re: Unable to connect database. [message #544402 is a reply to message #544401] Tue, 21 February 2012 09:08 Go to previous messageGo to next message
orafaq_user
Messages: 16
Registered: November 2006
Junior Member
[oracle@localhost ~]$ id
uid=500(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)
[oracle@localhost ~]$ env | sort
CLASSPATH=/u01/app/oracle/product/10.2.0/db_1/JRE:/u01/app/oracle/product/10.2.0/db_1/jlib:/u01/app/oracle/product/10.2.0/db_1/rdbms/ jlib
COLORTERM=gnome-terminal
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-JFEhkltWXP,guid=7dc98e24425531734ee993004f43ab65
DESKTOP_SESSION=default
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
GDMSESSION=default
GDM_XSERVER_LOCATION=local
GNOME_DESKTOP_SESSION_ID=Default
GNOME_KEYRING_SOCKET=/tmp/keyring-tkihsl/socket
GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=localhost.localdomain
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
MAIL=/var/spool/mail/oracle
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_HOSTNAME=localhost.localdomain
ORACLE_SID=APPLE
ORACLE_TERM=xterm
PATH=/u01/app/oracle/product/10.2.0/db_1/bin:/usr/sbin:/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/home/oracle/bin
PWD=/home/oracle
SESSION_MANAGER=local/unix:/tmp/.ICE-unix/3670
SHELL=/bin/bash
SHLVL=2
SSH_AGENT_PID=3859
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_AUTH_SOCK=/tmp/ssh-FZQfYl3670/agent.3670
TERM=xterm
TMP=/tmp
USERNAME=oracle
USER=oracle
_=/usr/bin/env
WINDOWID=56623179
XAUTHORITY=/tmp/.gdm6FFIAW
XDG_SESSION_COOKIE=8fdc1246b6abb6c0aa7f4b004f41bd00-1329834821.812088-379492179
[oracle@localhost ~]$ ps -ef | grep -i pmon
oracle 3825 1 0 20:03 ? 00:00:00 ora_pmon_apple
oracle 5192 5166 0 20:40 pts/0 00:00:00 grep -i pmon
[oracle@localhost ~]$

[Updated on: Tue, 21 February 2012 10:07] by Moderator

Report message to a moderator

Re: Unable to connect database. [message #544405 is a reply to message #544402] Tue, 21 February 2012 09:13 Go to previous message
BlackSwan
Messages: 22725
Registered: January 2009
Senior Member
ORACLE_SID is CaseSensiTive

APPLE is different from apple

export ORACLE_SID= apple
Previous Topic: Running Query using CSV file as a reference
Next Topic: Issue with sqlplus
Goto Forum:
  


Current Time: Tue Sep 02 01:07:06 CDT 2014

Total time taken to generate the page: 0.18720 seconds