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
4861 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

What are the restrictions applicable while creating views?

0 Answers

Define primary and unique key?

0 Answers

What are the differences between hash join, merge join and nested loops?

0 Answers

Operators used in select statements are?