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.)

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

How can we check whether A S M instance is up or down?

0 Answers   Excelacom, HCL,


What is normalization in dbms?

0 Answers  


What is drivermanager getconnection?

0 Answers  


Is it possible to Enable or Disable a Database trigger ?

1 Answers  


Where is the data stored in a database?

0 Answers  






what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?

0 Answers   NIIT, TCS,


Explain meant by 3-tier architecture?

0 Answers  


What is the biggest advantage of rdbms?

0 Answers  


What do you mean by e-r model?

0 Answers  


Why dbms is used?

0 Answers  


What is index and also explain types of indexing in dbms?

0 Answers  


what is the difference between unique and primary key

5 Answers  


Categories