1 2 Previous Next 23 Replies Latest reply: May 16, 2013 9:20 AM by SShubhangi Go to original post RSS
      • 15. Re: ORA-12560 : TNS Protocol adapter error
        SShubhangi
        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
          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
            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
              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
                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
                  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
                    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
                      you can NOT use V11 client to access local V10 database!
                      • 23. Re: ORA-12560 : TNS Protocol adapter error
                        SShubhangi
                        Thanks sb.. but any reason.. why so ?
                        1 2 Previous Next