• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2108
  • Last Modified:

very very urgent ORA-12560: TNS:protocol adapter error

hi
i am getting one error one one of the asp pages

OraOLEDB error '80004005'

ORA-12560: TNS:protocol adapter error

/items/ITEMSlist.asp, line 68

what is this eror
0
samir25
Asked:
samir25
  • 4
  • 3
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please try out these suggestions:
http://www.cryer.co.uk/brian/oracle/ORA12560.htm
0
 
samir25Author Commented:
basically i cannect thru sql plus etc..i can run my pl.sqls only some pages pages are giving this error
why ...somehting to do with network?how can i identify
0
 
auyukselCommented:
This can be caused from the reason that your program can not read your tns configuration file.
Try this:
Move your OracleHome\ora92\network folder
right click admin folder then click security tab
Check  asp.net machine account is in the list and has a read permission
if not add this account and give the necessary permission to it.
Note:If you use windows 2003 try this solution for network service account instead.

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
samir25Author Commented:
i am not using asp.net..asp pages are not working. though other pages runnign directly from the apache server on the same site are working.
this line in asp links to config string...where i provide user id and passowrd. that is oracke cannot be connected only from the asp page...what shoudl i do to debug..
0
 
auyukselCommented:
Okey, sorry for misunderstanding...
But still looks like the security issue. the account using by an asp pages has not got a necessary
credential on oraclehome/ora92/network/admin/tnslistener.config file.
0
 
samir25Author Commented:
how can i chekc that?
0
 
samir25Author Commented:
nothing changed on the server..but recently some changes have been done.what i know of is that
-Hard coded server port and network switch to 100Mb/Full-Duplex
-some updates to QoS.

i dont understand these lines...but this what has been changed
0
 
auyukselCommented:
Are you sure you can connect the database other tools like sqlplus or toad?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now