Home » RDBMS Server » Server Administration » TNS listener error please help
TNS listener error please help [message #250358] Mon, 09 July 2007 14:46 Go to next message
cplusplus
Messages: 2
Registered: July 2007
Junior Member
I am new to oracle, i installed and was able to work with forms 6i and oracle 10 g database withotu any problem.

yesterday i installed oracle 10g forms developer suite on the same machine without uninstalling 6i forms.

now the problem is i cannot able to loginto sql plus nor connect the forms to database via forms.

i am getting TNS error and Listener error.

With oracle forms 6 i( it looks like using 8 version sql editor.)
for forms 6 i i modified the TNSNames.ora file, but here on oracle forms 10g, where should i update for the TNS names, i do not see folder net80/admin

please help thank you very much.
Re: TNS listener error please help [message #250360 is a reply to message #250358] Mon, 09 July 2007 14:53 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Your Listener is running?

Lsnrctl status?
lsnrctl start
Re: TNS listener error please help [message #250525 is a reply to message #250360] Tue, 10 July 2007 06:14 Go to previous messageGo to next message
cplusplus
Messages: 2
Registered: July 2007
Junior Member
here is the error message, all i am doing is trying to connect via oracle 10g forms developer.

when i try to compile my forms, the system is asking me would you like to connect to database i gues, when i input username, pwd and database info:

i get this message:
ORA-12154: TNS: Could not resolve the connect identifier specified.


this all started after i installed orcale 10 g developer suite.

But while installing oracle 10g dev suite, it never gave me the choices to enter username password etc...

can i manually configure the listener and TNS both for oracle 10g developer suite.
Thank you.
Re: TNS listener error please help [message #250548 is a reply to message #250525] Tue, 10 July 2007 07:09 Go to previous messageGo to next message
crussed_sonu
Messages: 51
Registered: July 2007
Location: Delhi
Member
Hi



I First u stop ur listner then again start it through services.msc



it might be work


cheers
Re: TNS listener error please help [message #250569 is a reply to message #250548] Tue, 10 July 2007 08:59 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
crussed_sonu wrote on Tue, 10 July 2007 08:09

I First u stop ur listner then again start it through services.msc



Please respond in some earth language and not an alien one. No one can tell if you are leaving out letters by mistaker or abbreviating. What an example of total mutilation of a language this is.
Re: TNS listener error please help [message #250573 is a reply to message #250569] Tue, 10 July 2007 09:11 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Laughing Laughing
Previous Topic: Autoextend on/off ?
Next Topic: Statpack Error
Goto Forum:
  


Current Time: Mon Dec 02 09:50:01 CST 2024