1 2 3 4 5 6 Previous Next 78 Replies Latest reply on Jul 17, 2015 4:37 AM by Ujjwal Rana Go to original post
      • 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.