Home » RDBMS Server » Server Administration » TNS name error
TNS name error [message #55599] Mon, 03 February 2003 12:32 Go to next message
Carlos Olmeda
Messages: 22
Registered: January 2003
Junior Member
Good afternoon, I am running Oracle 7.3 I finished creating 3 databases on the same server. I completed creating tablespaces and rollback segements. I try to log in to sql to create users, however I continue to recieve cannot resolve TNS Name when trying to log in to the desired database. I create the user and then assign the proper priveledges, however when I try to log in as that user, I recieve the error. I looked at my tnsnames.ora file and looks to be ok.
can someone please provide information as to what I may be doing wrong?...
Thank you....

Carlos

Report message to a moderator

Re: TNS name error [message #55601 is a reply to message #55599] Mon, 03 February 2003 13:45 Go to previous messageGo to next message
Sanjay
Messages: 236
Registered: July 2000
Senior Member
Check to see that these varaibles are set (properly)

PATH
ORACLE_HOME
ORACLE_SID

Report message to a moderator

Re: TNS name error [message #55639 is a reply to message #55599] Thu, 06 February 2003 01:53 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
No. These are env variables in UNIX shell.

If you have korn shellm then you can set them up with:

$ORACLE_SID=db01
$PATH=$PATH:/$ORACLE_HOME/bin

export ORACLE_SID PATH

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Newbie Question
Next Topic: email trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 07:25:55 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.