Imao sam slicnih problema sa TOAD-om i XE ali zbog karakter seta u kojem je baza. Cini mi se da si napisao u prethodnoj temi da ti EMS lepo radi. Da li je TOAD bas neophodan?
Zbog specificnosti baze jedino sam uspeo da sa programom DreamCoder radim bez ikakvih problema. Freeware je i meni je dovoljan za ono sto radim...
http://www.download3k.com/Busi...Coder-for-Oracle-Freeware.html

Ako neće preko TNS-a, probaj sa tabom direct, kucaj host port i čekiraj servise name pa upiši kako ti se zove baza (u besplatnoj verziji je uvek XE).
Ako ni to ne uspe, proveri da li su podignuti oracle servisi (tns listener .... , ne znam tačno nazive, zauzmu nešto manje od 1 GB rama)

problem je što ems radi sa express verzijom, sa enterprise neće.


u Toad-u kraj TNSNames je x dok je kod express verziji bila kvačica.

Toad je najbolji i ima najbolji sql editor.

probao sam i direct, pa ništa.

jedino se mogu spojiti s oracle sql developerom koji je koma i preko web aplikacije što dolazi u instalaciji.

na stranici
http://asktoad.com/DWiki/doku....tly._what_could_the_problem_be

piše ako se u putanji nalazi ")" da je to bug u oracle clientu.

pošto koristiim win xp 64 bit , toad-a mi stavio u program files (x86).

onda sam ponovno instalirao u C:\Toad i opet dobivam grešku.

probam se spojiti sa ems sql serverom i opet ista greška.

a s oraclovim sql managerom ide bez problema.

Evo nesto iz TOAD helpa (moja verzija je 9.0.1, ako to nesto znaci)

------------------------

Hints and Tips: Unable To Resolve TNS Name
You must have a full install of a 32 bit version of SQL*Net. Connecting by SQL*Plus is NOT verification that SQL*Net is installed. If you cannot connect to Oracle using Toad, your Oracle client software is not installed correctly. Re-install the SQL*Net client from the Oracle setup disks or CD ROMs. Or, if you have installed OEM, NetAssist, Oracle Lite, or any other Oracle software recently, remove that software and see if you can connect using Toad. Oracle's own software are the worst culprits for stomping on SQL*Net settings.

Also make sure that SQL*Net is attempting to use the correct TNSNames files by confirming that the registry setting:

HKEY_LOCAL_MACHINE\Software\Oracle\TNS_ADMIN

specifies the correct folder where your TNSNAMES.ORA file lives.

----------------------

Kod mene je ova vrednost prazna

Moj Tnsnames.ora, pristupam serveru iz mreze...

#This is a SQL*Net Configuration file generated by SQL*Net Easy Configuration.
#Attention: Do not modify this file yourself.
#If you do, your SQL*Net Easy Configuration may not function properly.

XE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = xx.xx.xx.xx)(Port = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xe.db)
(SID = xe)
)
)

XE.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SID = xe)
)
)

TCP-LOOPBACK.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (COMMUNITY = tcp.world)(PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
)
(CONNECT_DATA =
(SID = ORCL)
)
)

U C:\WINDOWS\system32\drivers\etc
imam hosts fajl
u njemu je

# Copyright (c) 1993-1999 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost





Probaj i to da dodas

proradilo.



hvala na primjeru.

treba dodati i service name i sid te .db kod service name-a.

odabrati drugi tab.

i sve radi

Eto, problem resen!