Прописал все как на рабочей станции Windiws 2000 т.е.
Файл sqlnet.ora
names.default_domain = world
name.default_zone = world
names.directory_path = (TNSNAMES)
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Файл tnsnames.ora
FIS8_1D.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = TCP.WORLD)(PROTOCOL = TCP)(HOST = 192.168.15.147)(PORT = 1521))
)
(CONNECT_DATA =
(GLOBAL_NAME = FIS8_1D.WORLD)
(SID = D8V1)
)
)
Окружение
[sash@linux-soz ~]$ printenv
SSH_AGENT_PID=2417
HOSTNAME=linux-soz.ainf.ru
DESKTOP_STARTUP_ID=
SHELL=/bin/bash
TERM=xterm
HISTSIZE=1000
NLS_LANG=AMERICAN_AMERICA.CL8MSWIN1251
GTK_RC_FILES=/etc/gtk/gtkrc:/home/sash/.gtkrc-1.2-gnome2
WINDOWID=41943120
USER=sash
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;0
1:or=01;05;
37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.
bat=00;32:
*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;
31:*.zip=00;31:
*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.c
pio=00;31:*.jpg=00;
35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
GNOME_KEYRING_SOCKET=/tmp/keyring-0y4bQD/socket
SSH_AUTH_SOCK=/tmp/ssh-SleZpy2375/agent.2375
KDEDIR=/usr
SESSION_MANAGER=local/linux-soz.ainf.ru:/tmp/.ICE-unix/2375
TNS_ADMIN=/home/sash
MAIL=/var/spool/mail/sash
DESKTOP_SESSION=default
PATH=/usr/kerberos/bin:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/sash/bin
GDM_XSERVER_LOCATION=local
INPUTRC=/etc/inputrc
PWD=/home/sash
LANG=ru_RU.UTF-8
GDMSESSION=default
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
HOME=/home/sash
SHLVL=2
GNOME_DESKTOP_SESSION_ID=Default
LOGNAME=sash
DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-o02GlkKAdA,guid=b76b5c44915ab863309496ea29ee8200
LESSOPEN=|/usr/bin/lesspipe.sh %s
DISPLAY=:0.0
G_BROKEN_FILENAMES=1
COLORTERM=gnome-terminal
XAUTHORITY=/home/sash/.Xauthority
_=/usr/bin/printenv
[sash@linux-soz ~]$
Файлы sqlnet.ora и tnsnames.ora расположил в /home/sash
Затем делаю
[sash@linux-soz ~]$ sqlplus internal/oracle@fis8_1d.world
SQL*Plus: Release 10.1.0.4.0 - Production on Sat May 6 15:07:33 2006
Copyright © 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
[sash@linux-soz ~]$
[sash@linux-soz ~]$ sqlplus internal/oracle@fis8_1d
SQL*Plus: Release 10.1.0.4.0 - Production on Sat May 6 15:07:46 2006
Copyright © 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name:
На рабочей станции Windows 2000 с этоми-же sqlnet.ora и tnsnames.ora
эти команды проходчт нормально :lol:
[sash@linux-soz ~]$ ping 192.168.15.147
PING 192.168.15.147 (192.168.15.147) 56(84) bytes of data.
64 bytes from 192.168.15.147: icmp_seq=1 ttl=128 time=2.94 ms
64 bytes from 192.168.15.147: icmp_seq=2 ttl=128 time=0.188 ms
64 bytes from 192.168.15.147: icmp_seq=3 ttl=128 time=0.184 ms
--- 192.168.15.147 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 2002ms
rtt min/avg/max/mdev = 0.184/1.104/2.942/1.299 ms
[sash@linux-soz ~]$
Чего-же всетаки не хватает
