Looks like the listener.ora is set for TCP and you're calling BEQ? Or am I
just reading it wrong?
--
Bill Thater Certified ORACLE DBA
Telergy, Inc. thaterw_at_telergy.net
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
"We are different, in essence from other men.
If you want to will something run 100m.
If you want to experience something run a marathon"
Emil Zatopek
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: kirschw_at_hoffman.army.mil
[mailto:kirschw_at_hoffman.army.mil]
Sent: Friday, August 25, 2000 10:25 AM
To: Multiple recipients of list ORACLE-L
Subject: FW: I got the TNS blues
Sorry if you get this twice... haven't seen it posted on the
list yet.
> -----Original Message-----
> From: Kirsch, Walter J, PERSCOM
> Sent: Thursday, August 24, 2000 8:50 PM
> To: Multiple recipients of list ORACLE-L
> Subject: I got the TNS blues
>
> Windows NT 4.0 Service Pack 4
> Oracle 8.1.6 Enterprise Edition for NT
>
> I have a requirement to create a tnsnames alias for a
local connection
> (for SilverStream) running on the same box as the
database. SilverStream
> documentation demands such.
>
> Here's what I did: I installed 8.1.6 using the Installer,
and created
> the database by adjusting the scripts from Configuration
Manager. I was
> able to connect, obviously, to svrmgrl and sql*plus from
the NT command
> line without a connect string - that is, "sqlplus
system/manager" worked
> fine, and continued to do so throughout this recounting.
>
> I don't remember if I tried "Start>Programs>...>SQL Plus"
before
> attempting a tnsnames entry. But it hasn't worked during
or since,
> failing with an "ora-12154: TNS could not resolve service
name". Other
> clues: Both SQL Plus, above, and "services" from "lsnrctl"
at the
> command line causes a Dial-Up Networking box to pop up,
stating that it
> couldn't reach the host "ptempo", and did I want to dial
up a remote
> network. The box is named "ptempo" and is connected to
nothing.
>
> Anybody got a clue on how to get this to work? Is there
source of clear
> documentation on this stuff? Net8 Administration manual
makes my head
> hurt.
>
>
> ---------
> Here's the BEQ entry I ginned up from stuff on metalink
for the
> tnsnames entry:
> ---------
>
> beq_alias =
> (description=
> (address_list=
> (address=(protocol=beq)
> (program=oracle)
> (argv0=oracleserviceptmp)
>
(args='(description=(local=yes)(address=(protocol=beq)))')
> )
> )
> (connect_data=(sid=ptmp)(service_name=prstmpo.xy))
> )
>
> --------
> Here's the initptmp.ora entries:
> --------
>
> db_name = "prstmpo"
>
> db_domain = xy
>
> instance_name = ptmp
>
> service_names = prstmpo.xy
>
> global_names = true
>
>
>
> And the sqlnet.ora -------------------------
>
> names.default_domain = domain.x.com
>
> sqlnet_authentication_services=(nts)
>
> names.directory_path=(tnsnames,hostname)
>
>
> -----------
> And listener.ora
> -----------
> listener =
> (description_list =
> (description =
> (address_list =
> (address = (protocol = tcp)(host = ptempo)
> (port = 1521))
> )
> (address_list =
> (address = (protocol = ipc)(key = extproc))
> )
> )
> )
>
> sid_list_listener =
> (sid_list =
> (sid_desc =
> (sid_name = plsextproc)
> (oracle_home = d:\oracle\ora81)
> (program = extproc)
> )
>
>
>
>
>
>
--
Author:
INET: kirschw_at_hoffman.army.mil
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail
message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
the message BODY, include a line containing: UNSUB ORACLE-L
Received on Fri Aug 25 2000 - 08:53:12 CDT
