Ask Experts Questions for FREE Help !
Ask
    sunilgupta_hp's Avatar
    sunilgupta_hp Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 11, 2008, 04:22 AM
    Tns protocol adaptar error
    I installed oracle 8i on my PC . But when I started sql plus
    With following login

    User id: system
    Password: manager

    Following error was displayed:
    TNS protocol adapter error 12560

    And I could not log connect to oracle
    Listener service is running at startup
    I restarted the service but problem was not resolved

    What is the solution
    Please tell
    chuckhole's Avatar
    chuckhole Posts: 850, Reputation: 45
    Senior Member
    		  
    #2

    Dec 11, 2008, 09:33 AM
    Your TNS names file (TNSNAMES.ORA) has to be pointing to your Oracle instances. Each instance has a name and will be listening on a port. Example:

    INSTANCE1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server_name)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = service_name )))

    INSTANCE2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = server_name)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = service_name )))

    To test connectivity, go to a command prompt and type TNSPING80 instance_name.

    You should get a reply with an OK.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Oracle Error 12560:tns Protocol Adapter Error [ 3 Answers ]

Hi, Whenever I try to log in using SCOTT/TIGER userid, I get the error "ORA ERROR 12560:TNS PROTOCOL ADAPTER ERROR". I tried starting the listener from administration-> services, but still the problem persists. Can you please suggest a solution?

Help me---ora12560 tns protocol error [ 5 Answers ]

Hi every one am facing some problem regarding oracle 9i I have installed it on my PC with os xp and whenever I log in with 'scott" and "tiger" I get the error ora-12560 tns protocol error can some one please help me regarding this. Also I have tried editing tnsname.ora but I could hardly...

Installation - Oracle 10 / SqlPlusW TNS PROTOCOL ERROR [ 1 Answers ]

My Oracle 10 installation worked well enough to get a SQL prompt and make some tables. I tried some utilities like Quest Toad. Then, I couldn't get into SQLPlusW, or at least the login info didn't work. After many attempts at reinstalling from CD and from CD files copied to my hard disk, then...

What is protocol [ 3 Answers ]

Hi! I have seen the terms like hyper text transfer protocol, tpc/ip protocol etc. Please tell me what this protocols are?

View more questions Search