| Unable to connect database. [message #544394] |
Tue, 21 February 2012 08:53  |
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 #544402 is a reply to message #544401] |
Tue, 21 February 2012 09:08  |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
