connect string

[pras]

Hi everybody,

I have installed Oracle8i on C(win NT) ...and then i installed DEveloper server on D..when i open report builder (Oracle reports6i) and try to connect with the local database it gives me the error
REP-0501:unable to connect to the specified database
ORA-12203:TNS:unable to connect to destination.

Then i created the service using Net8 assistant.The test was successful...
again i tried to connect but i got the following errors

REP-0501:unable to connect to the specified database
ORA-12154:TNS:could not resolve service name.


Pls help in solving this prob....
help is really apperiatiated...
thanks in advance
pras

[pras]

hi everybody,
Still waiting for the answer...
pras

[pipo]

you've got a problem with your tnsnames.ora file ... can you post your listener.ora and tnsnames.ora files ?

[Shestakov]

Developer server and Oracle8i server use different SQL*net ver.
You can't use IPC protocol (or BEQ-LOCAL) for connect to database on some box.
Set both tnsnames.ora files (on C:\...\NET8\ADMIN and D:\...\NETWORK\ADMIN and try to connect thru TCP/IP.

[pras]

Hi pipo and shestakov,
thanks for ur prompt replies....i am sending u the info u asked for....

On C i installed 8.1.7 and below is it's tnsnames.ora file

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP.SOFTLINK.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gprashant)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = wil.pras.com)
(PRESENTATION = http://admin)
)
)

WIL.SOFTLINK.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = gprashant)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = wil.pras.com)
)
)

EXTPROC_CONNECTION_DATA.SOFTLINK.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)


And on E i installed Developer6i and below is it's tnsnames.ora file....My database name is wil
i.e global name is wil.pras.com and my tcp/ip is 1.0.0.37

Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle73)
(ARGV0 = oracle73ORCL)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Tcp-loopback.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 127.0.0.1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example1.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = Production1)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = SID1)
)
)
Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
Example3.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = nmp.world)
(PROTOCOL = NMP)
(Server = FinanceServer1)
(Pipe = ORAPIPE)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)

wil.softlink.com.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 1.0.0.37)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = wil.pras.com)
)
)

developer_server,developer_server.world=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=GPRASHANT)
(PORT=1949))

pras.prashant.com.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = 1.0.0.37)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = pras.prashant.com)
)
)

Beq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle8i)
(ARGV0 = oracle8iwil)
(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')
)
)
(CONNECT_DATA = (SID = wil)
)
)



Do u require the listener files also.....they are as follows.....
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gprashant)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gprashant)(PORT = 2481))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = wil.pras.com)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = wil)
)
)




################
# Filename......: listener.ora
# Node..........: local.world
# Date..........: 24-MAY-94 13:23:20
################
LISTENER =
(ADDRESS_LIST =
(ADDRESS=
(PROTOCOL= IPC)
(KEY= oracle.world)
)
(ADDRESS=
(PROTOCOL= IPC)
(KEY= ORCL)
)
(ADDRESS=
(COMMUNITY= TCP.world)
(PROTOCOL= TCP)
(Host= hostname)
(Port= 1521)
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = tftp)
(PROGRAM = tftpd)
)
(SID_DESC =
(SID_NAME = sfinger)
(PROGRAM = sfingerd)
)
)
PASSWORDS_LISTENER = (oracle)



Pls provide me the solutions tell me where i have to change in the above files.....
If possible pls give me the new listener and tnsnames.ora files
If anything u required ....pls write me....

thanks again...and waiting for ur replies..
pras

[pras]

Hi everybody,

Still waiting for the answers......pls reply if anybody knows the solution...

Thanks
pras