when we login sql editor using username and password then it says this error &q

when we login sql editor using username and password then it
says this error "could not resolve service name" then what
can we do at client side.( here thing is tnsnames.ora file
is ok till yesterday and worked well, but now it giving error.)

Question Posted / anuradha

2 Answers
4900 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when we login sql editor using username and password then it says this error "could not resolv..

Answer / kd

check "TNSNAMES" is listed as one of the naming method in
NAMES.DIRECTORY_PATH parameter in sqnnet.ora.

Is This Answer Correct ?

0 Yes

0 No

when we login sql editor using username and password then it says this error "could not resolv..

Answer / wilz

Try out this !!
click search --> type sqlnet.ora --> Right click and open
the file with Notepad --> Now change the authentication
services to NONE as shown below

SQLNET.AUTHENTICATION_SERVICES = (None)

Try SQL Editor now !!

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Database Management Interview Questions

Which is better saving files in database or in file system?

0 Answers

What do you understand by clause in sql?

0 Answers

How do I add a file to a database?

0 Answers

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.