Home » Infrastructure » Windows » TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) (oracle 11g in window 7(64 bit))
TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) [message #447980] Thu, 18 March 2010 20:18 Go to next message
needurgent
Messages: 18
Registered: October 2009
Location: penang
Junior Member
Hi,
i already complete succesfully install oracle 11g R1 client in window 7 (64 bit), but try log in sqlplus to connect to my database the error caming out with "TNS PROTOCOL ADAPTER ERROR"

-i check through my tnsnames.ora file and working properly.

i urgent need advice.

Regards
TGT
Re: TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) [message #447981 is a reply to message #447980] Thu, 18 March 2010 20:23 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>-i check through my tnsnames.ora file and working properly.
post proof

When was last time this worked?
What changed?


It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Please clarify the number of actual systems involved.
Is Oracle client software installed some system other than DB server?

[Updated on: Thu, 18 March 2010 20:49]

Report message to a moderator

Re: TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) [message #447983 is a reply to message #447981] Thu, 18 March 2010 21:40 Go to previous messageGo to next message
needurgent
Messages: 18
Registered: October 2009
Location: penang
Junior Member
actually the oracle client software is install in local personal computer and to connect to the local database. (by using sqlplus to connect to the local database).note:is window 7 in my pc with 64 bit

when i try log in use sqlplus, the error caming out with ORA-12560
TNS: protocol adapter error.


thanks
TGT
Re: TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) [message #447984 is a reply to message #447983] Thu, 18 March 2010 21:48 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Did you make ANY attempt to follow Installation Guide before starting?
If so, what URL?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors. For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.


ORA-12560 has many causes & therefore many solutions.
If you would have previously actually SEARCHED this forum before posting, you'd get dozens or hundreds of thread with same error.

http://www.orafaq.com/forum/?SQ=51ea894a4a1a7ab9d1967212ad19c17f&t=search&srch=%22TNS%3Aprotocol+adapter+error%22&btn_sub mit=Search&field=subject&forum_limiter=8&search_logic=AND&sort_order=DESC&author=

The reality is when properly configured SQL*Net works.
When mis-configured, it throws errors.

Is any type of Operating System Virtualization installed?

Please keep in mind that currently NO Oracle software has been certified on Windoze 7

Yes, you have an error.
Without additional details, You're On Your Own (YOYO)!

[Updated on: Thu, 18 March 2010 22:06]

Report message to a moderator

Re: TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit) [message #448007 is a reply to message #447983] Fri, 19 March 2010 01:04 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
>actually the oracle client software is install in local personal computer and to connect to the local database.

Beside the posted error, SQL*Net is NOT required to access local DB via sqlplus.

So stop using SQL*Net to access local DB & no TNS error will be generated.

[Updated on: Fri, 19 March 2010 01:04]

Report message to a moderator

Previous Topic: Install oracle 9i in window 7 problem unable to run setup.exe for oracle(64 bit window 7)
Next Topic: Problem while executing a dll throuch External Procedure (merged)
Goto Forum:
  


Current Time: Wed Dec 07 06:55:31 CST 2016

Total time taken to generate the page: 0.15594 seconds