• 60. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
      Ujjwal Rana

      Ok let me try then but even i don't know why i still feel the same thing.

      • 61. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
        Ujjwal Rana

        Nope same thing occurred again. HERE IS THE SCREENSHOT

         

        asm.png

        • 62. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
          Pavan Kumar

          you should disable SQLNET.AUTHENTICATION_SERVICES =(NONE), as I said in my earlier's post (some time back)

          • 63. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
            Ujjwal Rana

            But if i disable it then again then below error can occurred again ...ok let me try again then

             

            tns.png

            • 65. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
              Pavan Kumar

              Hi,

               

              Can you relink all try

              can you check ulimit settings (I hope you have pasted earler pasted ( check for open files) .. verify unlimit -a as per oracle installation doc

              lost contact directly deals with libaio

              chmod 6751 of oracle binary

              Ensure you have below files

                   $ORACLE_HOME/rdbms/lib/config.o

                  $ORACLE_HOME/bin/oracle

               

              Hope it solve

               

              -Pavan Kumar N

              • 66. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                John Stegeman

                Do you have access to Oracle Support? They are really good with installation issues.

                • 68. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                  Rajasekhara Reddy Burri

                  Hi ujwal

                   

                  chck the permissins for $ORACLE_HOME/,$PATH

                  the error is mainly caused by the either listner  or permissions to your home directories

                   

                  thanks & regards

                  Shekar

                  • 69. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                    Ujjwal Rana

                    Please find the output below :-

                     

                    [oracle@storage Desktop]$ cd $ORACLE_HOME/rdbms/lib/

                     

                    [oracle@storage lib]$ ls -al config.o

                    -rwxrwxr-x 1 grid oinstall 1248 Jul 10 09:03 config.o

                     

                    [oracle@storage lib]$ cd  $ORACLE_HOME/bin/

                     

                    [oracle@storage bin]$ ls oracle

                    oracle

                     

                    [oracle@storage bin]$ ls -al oracle

                    -rwxrwsr-x 1 grid asmadmin 210823812 Jul 10 09:03 oracle

                    [oracle@storage bin]$

                     

                    [root@storage bin]# ls -l oracle

                    -rwsr-s--x 1 grid oinstall 203972117 Jul 10 01:35 oracle

                     

                    [root@storage bin]#

                     

                    ALSO THIS ONE TOO :

                     

                    [grid@storage ~]$ id -a grid

                    uid=501(grid) gid=504(oinstall) groups=504(oinstall),501(asmadmin),502(asmdba),503(asmoper),505(dba)

                     

                    [grid@storage ~]$ exit

                    logout

                     

                     

                    [oracle@storage ~]$ id oracle

                    uid=502(oracle) gid=504(oinstall) groups=504(oinstall),502(asmdba),505(dba),506(oper)

                     

                    [oracle@storage ~]$ ls -ltr $ORACLE_HOME/bin/oracle

                    -rwxrwsr-x 1 grid asmadmin 210823812 Jul 10 09:03 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

                    [

                    [oracle@storage ~]$ ls -ltr $ORACLE_HOME/bin/oracle

                    -rwxrwsr-x 1 grid asmadmin 210823812 Jul 10 09:03 /u01/app/oracle/product/11.2.0/db_1/bin/oracle

                    [oracle@storage ~]$

                    • 70. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                      Rajasekhara Reddy Burri

                      we will check it step by step ujwal

                       

                      first try to connect to sql prompt directly ?

                      sqlplus / as sysdba

                       

                      if it is connecting directly  it is not the permissins problem

                      • 71. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                        Pavan Kumar

                        Still I say it won't get resolved due to "grid asmadmin" they need to be oracle oinstall (that's the standard of Oracle binaries).

                        Since your bequeath connection it failing, I still say it won't get fixed. You need to de-attach from inventory, remove binaries, do a proper installation with correct users (else wasting of your time)

                        • 72. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                          Ujjwal Rana

                          PAVAN I WLL DEINSTALL IT FROM GRID..WHICH IS POSSIBLE FROM GRID USER ONLY...PLEASE FIND THE DEINSTALL ACCEPT ON GRID USER AT BOTTOM. AFTER THEN ONLY I WILL UNINSTALLED IT.


                          [oracle@storage db_1]$ cd  $ORACLE_HOME

                           

                          [oracle@storage db_1]$ ls


                          [oracle@storage db_1]$ ls

                          apex         config  dc_ocm               has               j2ee    lib      oc4j     oraInst.loc  precomp    sqldeveloper                 ucp

                          assistants   crs     deinstall            hs                javavm  log      odbc     ord          racg       sqlj                         uix

                          bin          csmig   demo                 ide               jdbc    md       olap     oui          rdbms      sqlplus                      utl

                          ccr          css     diagnostics          install           jdev    mesg     ons      owb          relnotes   srvm                         wwg

                          cdata        ctx     dv                   install.platform  jdk     mgw      OPatch   owm          root.sh    storage.castrading.com_orcl  xdk

                          cfgtoollogs  cv      emcli                instantclient     jlib    network  opmn     perl         scheduler  sysman

                          clone        dbs     EMStagePatches_orcl  inventory         ldap    nls      oracore  plsql        slax       timingframework

                           

                          [oracle@storage db_1]$ cd deinstall/

                           

                          [oracle@storage deinstall]$ ./dinstall

                           

                          bash: ./dinstall: No such file or directory

                          [oracle@storage deinstall]$ ls

                           

                          deinstall  deinstall.xml  jlib  response  sshUserSetup.sh

                           

                          [oracle@storage deinstall]$ ./deinstall

                          ERROR: Oracle home not owned by user.

                          The user running the deinstall tool is not the same as owner of Oracle home

                          based on inventory ownership.

                          You must run this tool as the same user who installed the software.

                           

                          [oracle@storage deinstall]$ su - grid

                          Password:

                           

                          [grid@storage ~]$ cd $ORACLE_HOME/

                           

                          [grid@storage grid]$ ls

                          assistants   clone  ctss       demo         gns      instantclient  jlib  md       oc4j      oracore      owm      rdbms           slax     utl

                          auth         crf    cv         diagnostics  gpnp     inventory      JRE   mdns     ohasd     oraInst.loc  perl     relnotes        sqlplus  wwg

                          bin          crs    dbs        eons         has      javavm         ldap  mesg     ologgerd  ord          plsql    root.sh         srvm     xdk

                          cdata        csmig  dc_ocm     evm          hs       jdbc           lib   network  OPatch    osysmond     precomp  rootupgrade.sh  sysman

                          cfgtoollogs  css    deinstall  gipc         install  jdk            log   nls      opmn      oui          racg     scheduler       usm

                           

                          [grid@storage grid]$ cd deinstall

                           

                          [grid@storage deinstall]$ ./deinstall

                           

                          [grid@storage deinstall]$ ./deinstall

                           

                          Checking for required files and bootstrapping ...

                          Please wait ...

                          ^C

                          [grid@storage deinstall]$

                          • 73. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                            Ujjwal Rana

                            Hi Pavan,

                            After deinstall..I have reinstalled the grid and oracle as well but i could not still install DBCA. Besides the new progress that has happened AFTER RE-INSTALLING is i am now able to login as sqlplus as / sysdba HERE IS THE OUTPUT

                             

                            [oracle@storage Desktop]$ sqlplus / as sysdba

                             

                            SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 17 07:27:27 2015

                             

                            Copyright (c) 1982, 2009, Oracle.  All rights reserved.

                             

                            Connected to an idle instance.

                             

                            SQL> select * from V$INSTANCE;

                            select * from V$INSTANCE

                            *

                            ERROR at line 1:

                            ORA-01034: ORACLE not available

                            Process ID: 0

                            Session ID: 0 Serial number: 0

                             

                             

                            SQL>

                             

                             

                             

                             

                            As I have mentioned above that i could not install database from dbca its because it again asked for the ASMSNMP password here is the screenshot.

                             

                            asm.png

                             


                            IF YOU WANTED TO SEE THE LISTENER STATUS THEN HERE YOU GO :

                             

                            [oracle@storage ~]$ lsnrctl status

                             

                            LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-JUL-2015 01:01:46

                             

                            Copyright (c) 1991, 2009, Oracle.  All rights reserved.

                             

                            Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

                            STATUS of the LISTENER

                            ------------------------

                            Alias                     LISTENER

                            Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                            Start Date                17-JUL-2015 00:23:42

                            Uptime                    0 days 0 hr. 38 min. 3 sec

                            Trace Level               off

                            Security                  ON: Local OS Authentication

                            SNMP                      OFF

                            Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora

                            Listener Log File         /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml

                            Listening Endpoints Summary...

                              (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

                              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                            The listener supports no services

                            The command completed successfully

                            [oracle@storage ~]$

                             

                            ==================================

                             

                            FILE LISTENER.ORA

                            [grid@storage admin]$ more listener.ora

                            # listener.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/listener.ora

                            # Generated by Oracle configuration tools.

                             

                            LISTENER =

                              (DESCRIPTION_LIST =

                                (DESCRIPTION =

                                  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

                                  (ADDRESS = (PROTOCOL = TCP)(HOST = storage.castrading.com)(PORT = 1521))

                                )

                              )

                             

                            ADR_BASE_LISTENER = /u01/app/grid

                             

                            ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON        # line added by Agent

                            [grid@storage admin]$

                             

                            =========================================

                             

                            FILE TNSNAMSE.ORA


                            [grid@storage admin]$ more tnsnames.ora

                            # tnsnames.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/tnsnames.ora

                            # Generated by Oracle configuration tools.

                             

                            LISTENERCONF =

                              (DESCRIPTION =

                                (ADDRESS_LIST =

                                  (ADDRESS = (PROTOCOL = TCP)(HOST = storage.castrading.com)(PORT = 1521))

                                )

                                (CONNECT_DATA =

                                  (SERVICE_NAME = orcl)

                                )

                              )

                             

                            [grid@storage admin]$

                             

                            ===========================================

                             

                            FILE SQLNET.ORA    

                             

                            [grid@storage admin]$ more sqlnet.ora

                            # sqlnet.ora Network Configuration File: /u01/app/11.2.0/grid/network/admin/sqlnet.ora

                            # Generated by Oracle configuration tools.

                             

                            NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

                             

                            ADR_BASE = /u01/app/grid

                             

                            [grid@storage admin]$

                             

                            ====================================

                             

                            Since all the above *.ora file a fresh installation file. I haven't done any changes while creating listener for the first time. Besides Do you want me to type SQLNET_AUTHORIZATION_SERVICE=(NONE) in order get rid from ASMSNMP credentials ? I will do that once i receive your response. However I do afraid what if ORA-12547: TNS:lost contact error will occured again if i give SQLNET_AUTHORIZATION_SERVICE=(NONE) inside SQLNET.ORA file.

                             

                            WILL LOOK FORWARD HEARING FORM YOU.


                            • 74. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba
                              rchem

                              ASM available on the server?  listener doesn't show ASM instance registered with it.