Home » RDBMS Server » Networking and Gateways » remote access (oracle database express, linux)
remote access [message #472867] Tue, 24 August 2010 08:33 Go to next message
pocahontas
Messages: 3
Registered: August 2010
Junior Member
hi,

i install oracle DB XE on linux. Localy i can access db homepage, but remotly, from another computer, i can not. remotly computer is in the same local network. What should i do? i am not linux expert. pls, help me.
Re: remote access [message #472868 is a reply to message #472867] Tue, 24 August 2010 08:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post results from following commands

id
lsnrctl status
env | sort
lsnrctl service
cat /etc/hosts
Re: remote access [message #472957 is a reply to message #472867] Wed, 25 August 2010 00:41 Go to previous messageGo to next message
pocahontas
Messages: 3
Registered: August 2010
Junior Member
oraclebaza:~ # id
uid=0(root) gid=0(root) groups=0(root)
oraclebaza:~ # lsnrctl status
bash: lsnrctl: command not found
oraclebaza:~ # env | sort
ACLOCAL_FLAGS=-I /opt/gnome/share/aclocal
COLORTERM=gnome-terminal
CPU=i686
CSHEDIT=emacs
CVS_RSH=ssh
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-QnPsykCppD,guid=8777734c2dd832b ad767217b3c996a00
DESKTOP_LAUNCH=gnome-open
DESKTOP_SESSION=gnome
DESKTOP_STARTUP_ID=
DISPLAY=:0.0
ENV=/etc/bash.bashrc
FROM_HEADER=
GDMSESSION=gnome
GDM_XSERVER_LOCATION=local
GNOME2_PATH=/usr/local:/opt/gnome:/usr
GNOME_ICON_PATH=/usr/share/images:/usr/share/YaST2/theme/current/icons/48x48/app s:/opt/kde3/share/icons/crystalsvg/32x32/apps:/opt/kde3/share/icons/crystalsvg/3 2x32/devices:/opt/kde3/share/icons/crystalsvg/32x32/mimetypes:/opt/kde3/share/ic ons/crystalsvg/32x32/filesystems:/opt/kde3/share/icons/crystalsvg/32x32/actions: /opt/kde3/share/icons/crystalsvg/48x48/apps:/opt/kde3/share/icons/crystalsvg/48x 48/devices:/opt/kde3/share/icons/crystalsvg/48x48/mimetypes:/opt/kde3/share/icon s/crystalsvg/48x48/filesystems:/opt/kde3/share/icons/crystalsvg/48x48/actions:/o pt/gnome/share/icons/gnome/48x48/apps:/opt/gnome/share/icons/gnome/32x32/apps:/o pt/gnome/share/pixmaps
GNOME_KEYRING_SOCKET=/tmp/keyring-e3HbrY/socket
GPG_AGENT_INFO=/tmp/gpg-D4NMPQ/S.gpg-agent:7683:1
GROFF_NO_SGR=yes
GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
GTK_RC_FILES=/etc/opt/gnome/gtk/gtkrc:/root/.gtkrc-1.2-gnome2
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/root
HOST=oraclebaza
HOSTNAME=oraclebaza
HOSTTYPE=i386
ICEAUTHORITY=/root/.ICEauthority
INFODIR=/usr/local/info:/usr/share/info:/usr/info
INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
INPUTRC=/etc/inputrc
KDEDIR=/opt/kde3
KDEDIRS=/opt/gnome/share/dist/kde-preconf
LANG=POSIX
LC_CTYPE=en_US.UTF-8
LESS=-M -I
LESSCLOSE=lessclose.sh %s %s
LESSKEY=/etc/lesskey.bin
LESSOPEN=lessopen.sh %s
LESS_ADVANCED_PREPROCESSOR=no
LOGNAME=root
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:c d=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:*.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:*.avi=01;35:*.bm p=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=0 1;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aif f=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
LS_OPTIONS=-A -N --color=tty -T 0
MACHTYPE=i686-suse-linux
MAIL=/var/spool/mail/root
MANPATH=/usr/share/man:/usr/local/man:/usr/X11R6/man:/opt/gnome/share/man
MINICOM=-c on
MORE=-sl
NNTPSERVER=news
OPENWINHOME=/usr/openwin
OSTYPE=linux
PAGER=less
PATH=/sbin:/usr/sbin:/usr/local/sbin:/opt/gnome/sbin:/root/bin:/usr/local/bin:/u sr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/mit/ bin:/usr/lib/mit/sbin
PKG_CONFIG_PATH=/usr/local/lib/pkgconfig:/usr/local/share/pkgconfig:/usr/lib/pkg config:/usr/share/pkgconfig:/opt/kde3/lib/pkgconfig:/opt/gnome/lib/pkgconfig:/op t/gnome/lib/pkgconfig:/opt/gnome/share/pkgconfig
PROFILEREAD=true
PWD=/root
PYTHONSTARTUP=/etc/pythonstart
QT_SYSTEM_DIR=/usr/share/desktop-data
SESSION_MANAGER=local/oraclebaza:/tmp/.ICE-unix/7642
SHELL=/bin/bash
SHLVL=1
STYLE=Gilouche
TERM=xterm
TEXINPUTS=::/root/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX:/root/.TeX:/usr/share/d oc/.TeX:/usr/doc/.TeX
TMPDIR=/tmp
USER=root
USERNAME=root
WINDOWID=41943139
WINDOWMANAGER=/usr/bin/dbus-launch --sh-syntax --exit-with-session /usr/X11R6/bi n/gnome
XAUTHLOCALHOSTNAME=oraclebaza
XAUTHORITY=/root/.Xauthority
XCURSOR_THEME=Industrial
XDG_CONFIG_DIRS=/usr/local/etc/xdg/:/etc/xdg/:/etc/opt/gnome/xdg/
XDG_DATA_DIRS=/usr/local/share/:/usr/share/:/etc/opt/kde3/share/:/opt/kde3/share /:/opt/gnome/share/
XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
XMODIFIERS=@im=local
XNLSPATH=/usr/X11R6/lib/X11/nls
XSESSION_IS_UP=yes
_=/usr/bin/env
ftp_proxy=http:--proxy.nekaj.si:80
http_proxy=http:--proxy.nekaj.si:80
https_proxy=http:--proxy.nekaj.si:80
no_proxy=localhost, 127.0.0.1
oraclebaza:~ # lsnrctl service
bash: lsnrctl: command not found
oraclebaza:~ # cat /etc/hosts
#
# hosts This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# "named" name server.
# Syntax:
#
# IP-Address Full-Qualified-Hostname Short-Hostname
#

127.0.0.1 localhost

# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback

fe00::0 ipv6-localnet

ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
101.50.230.12 oraclebaza.nekaj.si oraclebaza
oraclebaza:~ #

----

command lsnrctl not found. did i forget something install?

(// is the same --, i cannot post links, bacouse i'm new on forum)
Re: remote access [message #473005 is a reply to message #472867] Wed, 25 August 2010 06:30 Go to previous message
pocahontas
Messages: 3
Registered: August 2010
Junior Member
i solve problem

thanks for replay anyway

solution:
i should type IP by network settings proxy exception on local machine
Previous Topic: Problems starting Listener and Oracle Services
Next Topic: TNS: listener was not given SID. Access to Oracle 10g ODBC connection
Goto Forum:
  


Current Time: Fri Mar 29 02:56:10 CDT 2024