Home » RDBMS Server » Networking and Gateways » TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle (Oracle 11g, Sun OS 5.10)
TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615635] Fri, 06 June 2014 05:40 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

End user is complaining that he is getting ORA error when trying to connect application.
He is saying tha he can access application if he go to another Laptop under his user name,
the issue is that he cannot access from my Laptop
TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle 

Can you guide me how to resolve this ORA error ?

Thanks,
Jack

[Updated on: Fri, 06 June 2014 05:42]

Report message to a moderator

Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615644 is a reply to message #615635] Fri, 06 June 2014 08:11 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
So you guys have decided not to help me henceforth.

[Updated on: Fri, 06 June 2014 08:12]

Report message to a moderator

Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615647 is a reply to message #615644] Fri, 06 June 2014 08:24 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Dude, you do not have a proper concept of reality, do you?

1. Where did you come under the impression that OraFAQ is your company's help desk?
2. Do you think everyone lives in your time zone and gets an email or a call whenever you post a question?
Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615652 is a reply to message #615647] Fri, 06 June 2014 08:52 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Joy,

I know about ORAFAQ .I have been using this forum for many years with multiple accounts.This is the forum where
i get answers quickly and learnt a lot about oracle from this forum.I don't want to comment anything negative about this forum
so i am not writing more.

There was a quarrel in my previous post which forced me to write like that.

Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615656 is a reply to message #615652] Fri, 06 June 2014 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Jack14 wrote on Fri, 06 June 2014 06:52
Joy,

I know about ORAFAQ .I have been using this forum for many years with multiple accounts.This is the forum where
i get answers quickly and learnt a lot about oracle from this forum.I don't want to comment anything negative about this forum
so i am not writing more.

There was a quarrel in my previous post which forced me to write like that.


YOYO!
Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615660 is a reply to message #615656] Fri, 06 June 2014 09:53 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Can i have an answer to my question i posted ?

[Updated on: Fri, 06 June 2014 09:53]

Report message to a moderator

Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615668 is a reply to message #615660] Fri, 06 June 2014 11:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

We owe you nothing.

Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615672 is a reply to message #615652] Fri, 06 June 2014 12:53 Go to previous messageGo to next message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Jack14 wrote on Fri, 06 June 2014 09:52
Joy,

I know about ORAFAQ .I have been using this forum for many years with multiple accounts.This is the forum where


The obvious question is then...Do you have the proper Oracle client installed on that laptop and it is configured correctly? Does each user get their own install?

12222, 00000, "TNS:no support is available for the protocol indicated"
// *Cause: The protocol requested in the ADDRESS portion of the connect
// descriptor identified through the net service name is not available.
// If the supplied ADDRESS is typographically correct then support for
// that protocol is not installed.
// *Action: Install support for the protocol or correct typographical error,
// as appropriate.  Note: if the supplied address was derived from
// resolving the net service name, check the address in the appropriate file
// (TNSNAMES.ORA, LISTENER.ORA) or in the directory server.
Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615686 is a reply to message #615672] Sat, 07 June 2014 00:16 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Thank you Joy
Re: TNS No Such Protocol adaptor Ora- 12222 and Unable to connect oracle [message #615690 is a reply to message #615686] Sat, 07 June 2014 00:56 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You still do not know "oerr" after all these years?
You still do not know this is the FIRST thing to do when you have an error?
You still do not know to search for an Oracle error on the web?

Previous Topic: Problem with No TNS Listener error
Next Topic: How to configure MGW to specific MQ.
Goto Forum:
  


Current Time: Fri Apr 19 13:11:40 CDT 2024