Home » SQL & PL/SQL » SQL & PL/SQL » Host String,Username,Password
Host String,Username,Password [message #242501] Sat, 02 June 2007 23:33 Go to next message
g.s1223
Messages: 17
Registered: May 2007
Junior Member
I'm a beginner and I want to know what to find in the tnsnames.ora.I'm using the Oracle 8.0 which came along with forms 6i.

The following code was found it in E:\orant\NET80\TNSAPI
=====================================================
eq-local.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = beq.world)
(PROTOCOL = BEQ)
(PROGRAM = oracle80)
(ARGV0 = oracle80ORCL)
(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)
)
)
tftp.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = tftp)
)
)
sfinger.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = tcp.world)
(PROTOCOL = TCP)
(Host = hostname)
(Port = 1521)
)
)
(CONNECT_DATA = (SID = sfinger)
)
)

Re: Host String,Username,Password [message #242502 is a reply to message #242501] Sat, 02 June 2007 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>I want to know what to find in the tnsnames.ora
HUH?
V8.0 has NOT been supported in more than a decade.
What problem are you really trying to solve?

Please read & FOLLOW the #1 STICKY post as stated in the top post in this forum.
Re: Host String,Username,Password [message #242901 is a reply to message #242501] Tue, 05 June 2007 08:07 Go to previous messageGo to next message
g.s1223
Messages: 17
Registered: May 2007
Junior Member
I need to find out what is the username,password and host string for sql plus 8.0 from the tnsnames.ora as scott/tiger and system/manger are not working.If sql plus 8.0 is not supported would it be fine to download 9i or 10g and use that sql plus which comes along with it ?
Re: Host String,Username,Password [message #242915 is a reply to message #242901] Tue, 05 June 2007 09:02 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Closed. Continue in your other thread.

MHE
Previous Topic: output in pl/sql
Next Topic: SQL Natural Join
Goto Forum:
  


Current Time: Fri Dec 09 17:43:05 CST 2016

Total time taken to generate the page: 0.10094 seconds