|
|
|
|
| Re: TNS listner [message #116686 is a reply to message #116685] |
Thu, 21 April 2005 06:56   |
gp185007
Messages: 45
Registered: April 2005
Location: Mumbai
|
Member |
|
|
Thanks for reply ,
1. My sql*plus was working ok previously....
2. I am using SQL 9i ..
3. i am using developer (forms / reports 9i ) but getting an error message of frm 90928 but it is not related to TNS listner because sql was working ok previously ....
|
|
|
|
|
|
|
|
| Re: TNS listner [message #117068 is a reply to message #117054] |
Sun, 24 April 2005 06:59 |
gp185007
Messages: 45
Registered: April 2005
Location: Mumbai
|
Member |
|
|
yes , i have installed ORACLE 9i database and and sql client on the same machine ....
but this time when i left database name blank ( only user name and password i entered ) while logging in SQL it worked ....
But before this my 9i developer application was working fine ....
But this time it is not working ..
whenever at the time to connect to the database i left that field blank i get an error message of " TNS protocol adapter error " and when i enter global database name it gives same error for developer
"TNS : no tns listner "
Any help will be really appreciable
|
|
|
|
| Re: TNS listner [message #117074 is a reply to message #117068] |
Sun, 24 April 2005 10:18 |
adamjsawyer
Messages: 79
Registered: April 2005
Location: Perth, Western Australia ...
|
Member |
|
|
It's possible that there are multiple copies of TNS files (ie: one for the DB/sql, and another for developer). Sometimes when the files aren't synchronised with each other, login problems can develop. I'm only guessing here though.
I do know that if a No TNS Listener error occurs, you should try running the Net Configuration Assistant, it may be able to tell you if the listener is there or not. The listener is an oracle service, and you can see if it's running by running the mmc program (Start->run->mmc) and one of the snap-ins can show you what services are there, and if they're running or stopped. Depending on you PC configuration, the Services snap in may be available directly from your Control Panel->Administrative Tools.
Beyond that I can't really help, I'm only a noob myself 
good luck
adam
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
