Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> FW: I got the TNS blues

FW: I got the TNS blues

From: <kirschw_at_hoffman.army.mil>
Date: Fri, 25 Aug 2000 09:23:22 -0400
Message-Id: <10600.115550@fatcity.com>


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)
Received on Fri Aug 25 2000 - 08:23:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US