-
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
-
hi everybody,
Still waiting for the answer...
pras
-
you've got a problem with your tnsnames.ora file ... can you post your listener.ora and tnsnames.ora files ?
-
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.
-
tnsnames.ora and listener.ora
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
-
Hi everybody,
Still waiting for the answers......pls reply if anybody knows the solution...
Thanks
pras
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|