|
|
|
|
|
|
| Re: Connecting to Oracle 10g on Linux [message #489691 is a reply to message #489690] |
Tue, 18 January 2011 09:23   |
JuicyFruit
Messages: 34
Registered: September 2009
|
Member |
 
|
|
content of tnsnames.ora file
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
EMCO =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = linuxOracle.site)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EMC)
)
)
[Updated on: Tue, 18 January 2011 09:23] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: Connecting to Oracle 10g on Linux [message #489702 is a reply to message #489699] |
Tue, 18 January 2011 09:43 |
JuicyFruit
Messages: 34
Registered: September 2009
|
Member |
|
|
Oracle@linuxOracle:~> id
uid=1001(Oracle) gid=1001(oinstall) groups=1000(dba),1001(oinstall)
Oracle@linuxOracle:~> env | sort
ALSA_CONFIG_PATH=/etc/alsa-pulse.conf
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
CPU=i686
CSHEDIT=emacs
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-tDDVcAXlWy,guid=9f4110285f765b354d350eb40000025b
DESKTOP_SESSION=gnome
DISPLAY=:1.0
ENV=/etc/bash.bashrc
FROM_HEADER=
G_BROKEN_FILENAMES=1
GDM_KEYBOARD_LAYOUT=us
GDM_LANG=en_US.utf8
GDMSESSION=gnome
G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-15,CP1252
GNOME_DESKTOP_SESSION_ID=this-is-deprecated
GNOME_KEYRING_CONTROL=/tmp/keyring-JCjsek
GNOME_KEYRING_PID=7478
GTK_IM_MODULE=cedilla
HISTSIZE=1000
HOME=/home/Oracle
HOST=linuxOracle
HOSTNAME=linuxOracle
HOSTTYPE=i386
ICEAUTHORITY=/home/Oracle/.ICEauthority
INPUTRC=/home/Oracle/.inputrc
JAVA_BINDIR=/usr/lib/jvm/java/bin
JAVA_HOME=/usr/lib/jvm/java
JAVA_ROOT=/usr/lib/jvm/java
JDK_HOME=/usr/lib/jvm/java
JRE_HOME=/usr/lib/jvm/jre
LANG=en_US.utf8
LD_LIBRARY_PATH=/u01/app/oracle/product/10.2.0/db_1/lib:/lib:/usr/lib
LESS_ADVANCED_PREPROCESSOR=no
LESSCLOSE=lessclose.sh %s %s
LESSKEY=/etc/lesskey.bin
LESS=-M -I -R
LESSOPEN=lessopen.sh %s
LIBXCB_ALLOW_SLOPPY_LOCK=1
LOGNAME=Oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.xz=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-N --color=tty -T 0
MACHTYPE=i686-suse-linux
MAIL=/var/spool/mail/Oracle
MANPATH=/usr/local/man:/usr/share/man
MINICOM=-c on
MORE=-sl
NNTPSERVER=news
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
ORACLE_SID=EMCO
ORBIT_SOCKETDIR=/tmp/orbit-Oracle
OSTYPE=linux
PAGER=less
PATH=/u01/app/oracle/product/10.2.0/db_1/bin:/home/Oracle/bin:/usr/local/bin:/usr/bin:/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:.
PILOTPORT=usb:
PROFILEREAD=true
PWD=/home/Oracle
PYTHONSTARTUP=/etc/pythonstart
QT_IM_MODULE=xim
QT_IM_SWITCHER=imsw-multi
QT_SYSTEM_DIR=/usr/share/desktop-data
SDK_HOME=/usr/lib/jvm/java
SDL_AUDIODRIVER=pulse
SESSION_MANAGER=local/linuxOracle:@/tmp/.ICE-unix/7498,unix/linuxOracle:/tmp/.ICE-unix/7498
SHELL=/bin/bash
SHLVL=1
SSH_AUTH_SOCK=/tmp/keyring-JCjsek/ssh
TERM=xterm
TMPDIR=/tmp
USERNAME=Oracle
USER=Oracle
_=/usr/bin/env
WINDOWID=75499863
WINDOWMANAGER=/usr/bin/gnome
WINDOWPATH=8
XAUTHLOCALHOSTNAME=localhost
XAUTHORITY=/var/run/gdm/auth-for-Oracle-RAqdyu/database
XCURSOR_THEME=DMZ
XDG_CONFIG_DIRS=/etc/xdg
XDG_DATA_DIRS=/usr/share
XDG_SESSION_COOKIE=4847f38a734e4732a26e376a00000518-1295345548.492662-825962963
XKEYSYMDB=/usr/share/X11/XKeysymDB
XMODIFIERS=@im=local
XNLSPATH=/usr/share/X11/nls
XSESSION_IS_UP=yes
Oracle@linuxOracle:~> lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-JAN-2011 17:29:26
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 18-JAN-2011 16:27:32
Uptime 0 days 1 hr. 1 min. 53 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linuxOracle.site)(PORT=1521)))
Services Summary...
Service "DEFAULT" has 1 instance(s).
Instance "Ecmor", status BLOCKED, has 1 handler(s) for this service...
Service "DEFAULT_XPT" has 1 instance(s).
Instance "Ecmor", status BLOCKED, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Oracle@linuxOracle:~> uname -a
Linux linuxOracle 2.6.34-12-default #1 SMP 2010-06-29 02:39:08 +0200 i686 i686 i386 GNU/Linux
Oracle@linuxOracle:~> lsnrctl service
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 18-JAN-2011 17:32:44
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
Services Summary...
Service "DEFAULT" has 1 instance(s).
Instance "Ecmor", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "DEFAULT_XPT" has 1 instance(s).
Instance "Ecmor", status BLOCKED, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
|
|
|
|
|
|
|
|
| Re: Connecting to Oracle 10g on Linux [message #489726 is a reply to message #489705] |
Tue, 18 January 2011 11:17 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
But before you do what BS says: just what is your instance called? In your first post, you wroteQuote:When I try to set ORACLE_SID=EMC but in your last post you have Quote:ORACLE_SID=EMCO Which is it? The service name and tns alias are also important, and possibly different.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Connecting to Oracle 10g on Linux [message #489754 is a reply to message #489750] |
Tue, 18 January 2011 15:15 |
John Watson
Messages: 8961
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
Hello again - if I were you, I would delete the VirtualBox VM and start again. Heaven knows what went wrong. Just create a new VM, and save it before doing the Oracle install.
Two points, though: first, why not install 11.1 or 11.2, instead 10.2? And second, why not use OEL 5.5, instead of SUSE?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
