TNS Error

[filipe26]

Hi i have a ORA-12541:TNS:no listener when i open pl/sql,then i went to controlpanel->services and i turned on the ORacleOraHome90tnslistener but when im going to open the pl/sql again i receive a windows TNSLSNR.exe error and the service is back to disabled or stopped.How to resolve this?

 

[SantaMufasa]

Filipe,

Instead of using the Control Panel, try opening a Windows command prompt and issuing the commands:

C:\ lsnrctl
LSNRCTL> status

(if the listener appears to be down, then)

LSNRCTL> start

If there is a problem starting the listener, you should see related error messages following the "start" command.

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[filipe26]

Yes if i do that the oracle listener stays opened but when i try to connect with pl/sql tells me:ORA-12500:TNS:the listener could not begin the process of dedicated server(translating) and a windows error TNSLSNR.exe open.I reinstalled oracle and it's the same.

 

[SantaMufasa]

Filipe,

Could you please copy and past your full screen session that shows your PL/SQL interaction (connection, code, et cetera) and the resulting error message?

Thanks,

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[filipe26]

I dont know how to insert pictures in this reply.

 

[SantaMufasa]

Filipe, I'm interested in just the text (not the "pictures"). To insert the text, you should be able to just

1) sweep the text you wish to copy from the screen
2) <cntrl-C> (to copy)
3) then with your cursor in your Tek-Tips-thread reply box, hit <cntrl-V> (to paste)

Also, what interface are you using to run your PL/SQL and receive the error?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com:

Providing remote Database Administration and support services

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[filipe26]

But nothing is made with text i simply open the pl/sql and i receive the error described.

 

[SantaMufasa]

Filipe,

Are you possibly confusing SQL*Plus with PL/SQL? (Don't feel badly if you did...many people do.) I am asking because you say "i simply open the pl/sql and i receive the error described." I don't know what you mean by "opening PL/SQL". There is no standalone PL/SQL interface to Oracle.


Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com:

Providing remote Database Administration and support services

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[filipe26]

Ni,i have a pl/sql program that interages with oracle and when i try to logon with user:scott and pass:tiger it appears that error.

 

[SantaMufasa]

Okay, in that case, let's confirm your connectability to Oracle with SQL*Plus. Can you successfully login/connect to Oracle using SQL*Plus?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com:

Providing remote Database Administration and support services

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[filipe26]

No when i post scott/tiger as user and pass and home2 as database it happens again.