OraFAQ Forum: Client Tools » SQL*PLUS, TOAD and Command Prompt

Home » Other » Client Tools » SQL*PLUS, TOAD and Command Prompt

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL*PLUS, TOAD and Command Prompt [message #288913]

Wed, 19 December 2007 00:58

Muddassar
Messages: 28
Registered: March 2007

Junior Member

Hi,
I am trying to connect to an Oracle instance using the 'System' user and its password.
I AM ABLE TO DO THAT when i connect through SQL*PLUS.
But when i try to connect through TOAD or the 'sqlplus' command in Windows Command Promt, i get TNS Error:
ORA-12154: TNS:could not resolve service name.
Can anyone suggest, why is this happening ?

Report message to a moderator

Re: SQL*PLUS, TOAD and Command Prompt [message #288926 is a reply to message #288913]

Wed, 19 December 2007 01:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just make sure you have proper tns entries in your tnsnames.ora file.
Almost every oracle client will require its "own" tnsnames.ora.
May be sqlplus is using a different one or not using at all (if the instance is local).
Please search forum. Too many postings deal with this.

Report message to a moderator

Re: SQL*PLUS, TOAD and Command Prompt [message #288974 is a reply to message #288926]

Wed, 19 December 2007 03:22

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

In order not to maintain multiple TNSNAMES.ORA files, you might choose to create only one, but set the environment variable called TNS_ADMIN and point it to that "universal" file (actually, a directory it is stored in). For example, on MS Windows it would look like

M:\>set tns_admin
tns_admin=C:\0_Oracle_library

Report message to a moderator

Re: SQL*PLUS, TOAD and Command Prompt [message #288981 is a reply to message #288974]

Wed, 19 December 2007 03:37

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Or you could use "IFILE". Link

MHE

Report message to a moderator

Previous Topic:	how to know which system db iam accessing
Next Topic:	geting error when trying to connect to oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 30 07:41:44 CDT 2026