OraFAQ Forum: Windows » TNS protocol adapter error when ;log in sqlplus for oralce 11g client for window 7(64 bit)

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))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

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

Report message to a moderator

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

BlackSwan
Messages: 26766
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

BlackSwan
Messages: 26766
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 13:44:56 CDT 2024