Xref: alice comp.databases.oracle.server:83155
Path: alice!news-feed.fnsi.net!newsxfer.visi.net!nntp.primenet.com!nntp.gctr.net!newsfeed.mathworks.com!news.maxwell.syr.edu!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: kal121@my-deja.com
Newsgroups: comp.databases.oracle.server
Subject: service name problem
Date: Thu, 03 Feb 2000 00:08:22 GMT
Organization: Deja.com - Before you buy.
Lines: 44
Message-ID: <87agtj$9oj$1@nnrp1.deja.com>
X-Article-Creation-Date: Thu Feb 03 00:08:22 2000 GMT
X-Http-User-Agent: Mozilla/4.61 [en] (X11; U; Linux 2.2.12-20 i586)
X-Http-Proxy: 1.0 x30.deja.com:80 (Squid/1.1.22) for client 63.226.198.3
X-MyDeja-Info: XMYDJUIDkal121

I am trying to invoke sqlplus from a client machine. I am running
oracle8i for LinuxRH6.1, v8.1.5.0.2.

--I try to invoke sqlplus:
$ sqlplus joe/secret@dbserver

--and get this error message:
SQL*Plus: Release 8.1.5.0.0 - Production on Wed Feb 2 15:22:24 2000

(c) Copyright 1999 Oracle Corporation.  All rights reserved.

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

The listener on the server is up and running.
I have a feeling I am not configuring the tnsnames.ora file on the
client properly. Specifically, I don't what I should set the service
name to! I've tried several different combinations of
my database name and domain names. Nothing seems to work.

For example, I've tried:
given:
database name = i815, domain name = mydbserver.dev.xyz.com

1. service_name = i815.mydbserver.dev.xyz.com
2. service_name = i815.dev.xyz.com
3. service_name = i815

None of the above works.

from the Net8 Admin guide:
"The service name is a string that is the global database name, a name
comprised of the database name and domain name"

I do not have any global names set. Maybe that is part of the problem.

Somebody please help.
Thanks



Sent via Deja.com http://www.deja.com/
Before you buy.