This discussion is archived
1 2 Previous Next 23 Replies Latest reply: May 16, 2013 7:20 AM by SShubhangi Go to original post RSS
  • 15. Re: ORA-12560 : TNS Protocol adapter error
    SShubhangi Newbie
    Currently Being Moderated
    THaanks a lot Guys...

    Finally someting is started working... :)

    After copying tnsnames.ora in C:\app\User\product\11.2.0\client_1\network\admin

    when I am executing from command prompt like
    c:\> sqlplus login/password@XE
    iit works like below
    C:>sqlplus system/*****@XE
    
    SQL*Plus: Release 11.2.0.3.0 Production on Tue May 14 00:25:13 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    Now I m having only question is that when I am launching sqlplus from folder
    C:\app\user\product\11.2.0\client_1

    it still gives error like
    SQL*Plus: Release 11.2.0.3.0 Production on Tue May 14 00:25:13 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    Ente username : system
    enter password :
    
    ERROR :
    ORA-12560 : TNS Protocol adapter error
    why i m getting this error now ?
  • 16. Re: ORA-12560 : TNS Protocol adapter error
    sb92075 Guru
    Currently Being Moderated
    SQL*Plus: Release 11.2.0.3.0 Production on Tue May 14 00:25:13 2013
    How is it that you are using V11.2 software (see above) to access a V10.2 database (see below)?
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    you can NOT use wrong version/different version client to access a local DB!
  • 17. Re: ORA-12560 : TNS Protocol adapter error
    EdStevens Guru
    Currently Being Moderated
    SShubhangi wrote:
    THaanks a lot Guys...

    Finally someting is started working... :)

    After copying tnsnames.ora in C:\app\User\product\11.2.0\client_1\network\admin

    when I am executing from command prompt like
    c:\> sqlplus login/password@XE
    iit works like below
    C:>sqlplus system/*****@XE
    
    SQL*Plus: Release 11.2.0.3.0 Production on Tue May 14 00:25:13 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
    Now I m having only question is that when I am launching sqlplus from folder
    C:\app\user\product\11.2.0\client_1

    it still gives error like
    SQL*Plus: Release 11.2.0.3.0 Production on Tue May 14 00:25:13 2013
    
    Copyright (c) 1982, 2011, Oracle.  All rights reserved.
    
    Ente username : system
    enter password :
    
    ERROR :
    ORA-12560 : TNS Protocol adapter error
    why i m getting this error now ?
    Hard to say for sure, since you didn't post your actual, full, complete command line that you used to launch sqlplus. But the heavy odds are that you didn't include the '@xe', so it tried to connect to whatever database was indicated by the value of the environment variable 'ORACLE_SID', and that variable wasn't pointing to a valid, local database.
  • 18. Re: ORA-12560 : TNS Protocol adapter error
    1008711 Newbie
    Currently Being Moderated
    Hi ,
    Please check the hosts file , it should have entry like ... 127.0.0.1 localhost
    since its a windows, you will need to check hosts file in windows/system32/drivers/etc
  • 19. Re: ORA-12560 : TNS Protocol adapter error
    SShubhangi Newbie
    Currently Being Moderated
    Hi Steve
    Hard to say for sure, since you didn't post your actual, full, complete command line that you used to launch sqlplus. But the heavy odds are that you didn't include the '@xe', so it tried to connect to whatever database was indicated by the value of the environment variable 'ORACLE_SID', and that variable wasn't pointing to a valid, local database.
    I m launching by double clicking on the sqlplus present in the folder

    C:\app\user\product\11.2.0\client_1
  • 20. Re: ORA-12560 : TNS Protocol adapter error
    yoonas Expert
    Currently Being Moderated
    Are you trying to connect without appending @XE ?

    After starting sqlplus from 11g client folder What happens if you connect it this way?

    Ente username : system/<password>@xe
  • 21. Re: ORA-12560 : TNS Protocol adapter error
    SShubhangi Newbie
    Currently Being Moderated
    Are you trying to connect without appending @XE ?
    Yes.. trying without appending @XE
    After starting sqlplus from 11g client folder What happens if you connect it this way? 
    
    Ente username : system/<password>@xe 
    yes.. it is working if connected as above....
  • 22. Re: ORA-12560 : TNS Protocol adapter error
    sb92075 Guru
    Currently Being Moderated
    you can NOT use V11 client to access local V10 database!
  • 23. Re: ORA-12560 : TNS Protocol adapter error
    SShubhangi Newbie
    Currently Being Moderated
    Thanks sb.. but any reason.. why so ?
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points