1 2 3 Previous Next 78 Replies Latest reply on Jul 17, 2015 4:37 AM by Ujjwal Rana

    ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

    Ujjwal Rana

      Hi,

      I am getting following messages while trying to install database from DBCA. PLEASE HELP ?

       

       

      tns.png

       

      I RECEIVED THE SAME ERROR MESSAGE FROM THE FOLLOWING AS WELL :

       

      [oracle@storage ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 15:59:10 2015

       

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

       

      ERROR:

      ORA-12547: TNS:lost contact

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

          Hi,

           

          Working on Oracle is it for first time (are you a new starter )?

           

          - Pavan Kumar N

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

            ORA-12547: TNS: lost contact

                

                Cause: Partner has unexpectedly gone away, usually during process startup.

             

                Action: Investigate partner application for abnormal termination. On an Interchange, this can happen if the machine is overloaded.

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

              Okay, you know the resolution I believe then please continue. I just asked (are you a new starter )?

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

                yup i am a starter and i am trying to work on oracle but theoritically i understand but practically i am not been able to do it and thats why i asked for the support through oracle community forrum

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

                  THIS IS WHAT I TRIED BUT STILL COULD NOT SOLVE IT.

                   

                  The "TNS lost contact error is most commonly a network error, and you can diagnose it by following my notes on troubleshooting sql*net connectivity errors.

                   

                  Steps to troubleshoot Oracle connectivity:

                   

                  Also I followed this steps as well :

                   

                  To troubleshoot & diagnose Oracle connectivity problems, I did the simplest, outermost level, and follow this checklist:

                   

                  ---Check with "ping" using the IP address ("ping 198.11.34.43")'

                  [grid@example Desktop]$ ping example.test.com

                  PING example.test.com (192.168.0.227) 56(84) bytes of data.

                  64 bytes from example.test.com (192.168.0.227): icmp_seq=1 ttl=64 time=52.0 ms

                  64 bytes from example.test.com (192.168.0.227): icmp_seq=2 ttl=64 time=0.051 ms

                  64 bytes from example.test.com (192.168.0.227): icmp_seq=3 ttl=64 time=0.038 m

                   

                  ---Check with "ping" using DNS name (e.g. "tnsping uranus")

                   

                  [grid@example admin]$

                   

                  --Try telnet to the IP on port 1521 (telnet 1.2.3.4 1521)

                   

                  --Check with "tnsping" using TNS service name

                   

                  [grid@example admin]$ tnsping LISTENERCONF

                   

                  TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 15-JUL-2015 17:36:13

                   

                  Copyright (c) 1997, 2011, Oracle.  All rights reserved.

                   

                  Used parameter files:

                  /u01/app/11.2.0/grid/network/admin/sqlnet.ora

                   

                  Used TNSNAMES adapter to resolve the alias

                  Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = example.test.com)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))

                  OK (0 msec)

                   

                  --Invoke SQL*Plus from the OS command line "sqlplus fred@flintstone".  If this fails, check to ensure that your listener has the flintstone service defined

                  [oracle@example ~]$ sqlplus / as sysdba@orcl

                   

                  SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 17:40:42 2015

                   

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

                   

                  ERROR:

                  ORA-12547: TNS:lost contact

                   

                   

                  Enter user-name:

                   

                   

                  --Sign-on to SQL*Plus and connect with the TNS name ("connect fred/flintstome@service_name")[oracle@example ~]$ sqlplus / as sysdba

                   

                  SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 17:41:16 2015

                   

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

                   

                  ERROR:

                  ORA-12547: TNS:lost contact

                   

                   

                  Enter user-name:

                   

                   

                  AND TRIED THIS ONE AS WELL BY GOING INSIDE $ORACLE_HOME/BIN in grid

                   

                  [grid@example Desktop]$ chmod 6751 oracle

                  ls -ltr oracle

                  -rwsr-s--x    1 oracle   oinstall       136803483 Mar 16 20:32 oracle


                  CAN YOU HELP ME ?

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

                    How will knowing the answer to that help you answer the OP's question?

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

                      Is there a firewall of any sort between you and the database server? I would suggest that the firewall is terminating the connection. If that's the case - you'll need to talk to the networking people to correct that.

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

                        Just to know from which phase, we should start suggesting him, if he knows some thing, then we can go and  ask create listener (else he would come back to us where and how to start listener)

                        Note - Just from example perspective.

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

                          Hi Ujjawal,

                           

                          1. Thanks for sharing the information.

                          2. Appreciate that you did tried from your end

                          3.  tnsping LISTENERCONF ..this is alias name from tnsnames.ora (location : ORACLE_HOME/network/admin)

                              But while connecting from sqlplus

                               sqlplus fred@flintstone ...

                          you are using two different network service   ...try to use "sqlplus fre@LISTENERCONF"

                           

                          4. If you are using flinstone.. check whether it's reachable or not (tnsping flinstone) If it's not reachable then check listener on destination *db server" is up or not

                          5.sqlplus / as sysdba@orcl

                          The above method is suitable when you are residing db server, does orcl net service is it working (check that

                           

                          - Pavan Kumar N

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

                            Hello John,

                            HERE IS THE STATUS OF FIREWALL and YOU MIGHT WANT TO CHECK 1521 PORT AS WELL ...HAVE ADDED NETSTAT output too

                             

                            [root@storage ~]# service iptables status

                            iptables: Firewall is not running.

                            [root@storage ~]#

                             

                            HERE IS THE OUTPUT FROM NETSTAT FOR 1521 PORT

                             

                            [root@storage ~]# netstat -an | grep 1521

                            tcp        0      0 192.168.0.227:61274         192.168.0.227:1521          ESTABLISHED

                            tcp        0      0 :::1521                     :::*                        LISTEN   

                            tcp        0      0 ::ffff:192.168.0.227:1521   ::ffff:192.168.0.227:63611  TIME_WAIT

                            tcp        0      0 ::ffff:192.168.0.227:1521   ::ffff:192.168.0.227:61274  ESTABLISHED

                            [root@storage ~]#

                             

                            Hello Pavan,

                            I do know how to create listener. As I have grid installed in my pc so here is the screen shot of LISTENER CREATED

                             

                            [grid@storage admin]$ netmgr

                             

                            l1.png

                             

                            l2.png

                             

                            or you might want to check information of the following one. Please note :

                             

                            [grid@storage admin]$ pwd

                            /u01/app/11.2.0/grid/network/admin

                             

                            [grid@storage admin]$ cat listener.ora

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

                            # Generated by Oracle configuration tools.

                             

                            SID_LIST_LISTENER =

                              (SID_LIST =

                                (SID_DESC =

                                  (GLOBAL_DBNAME = orcl)

                                  (ORACLE_HOME = /u01/app/11.2.0/grid)

                                  (SID_NAME = orcl)

                                )

                              )

                             

                            LISTENER =

                              (DESCRIPTION =

                                (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]$ 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]$ 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, HOSTNAME, EZCONNECT)

                             

                            SQLNET.AUTHENTICATION_SERVICES= (ALL)

                             

                            NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

                             

                            ADR_BASE = /u01/app/grid

                             

                            [grid@storage admin]$

                             

                            ALSO PLEASE FIND THE tnsnames.ora information inside ORACLE USER as well :-

                             

                            [oracle@storage ~]$ cd $ORACLE_HOME/network/admin

                             

                            [oracle@storage ~]$ cd $ORACLE_HOME/network/admin

                            [oracle@storage admin]$ cat tnsnames.ora

                            # tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/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)

                                )

                              )

                             

                            ORCL =

                              (DESCRIPTION =

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

                                (CONNECT_DATA =

                                  (SERVER = DEDICATED)

                                  (SERVICE_NAME = orcl)

                                )

                              )

                             

                            [oracle@storage admin]$

                             

                            ALSO HERE IS THE OUTPUT FOR lsnrctl status



                            [grid@storage ~]$ lsnrctl status

                             

                            LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUL-2015 20:16:29

                             

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

                             

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

                            STATUS of the LISTENER

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

                            Alias                     LISTENER

                            Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                            Start Date                15-JUL-2015 19:30:02

                            Uptime                    0 days 0 hr. 46 min. 27 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=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                            Services Summary...

                            Service "orcl" has 1 instance(s).

                              Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

                            The command completed successfully

                            [grid@storage ~]$

                             

                            AS YOU CAN NOTICE THAT ASM STATUS HASN'T SHOWN  AT ABOVE LSNRCTL OUTPUT.

                             

                            NOTE : I WOULD LIKE TO SHOW THE CLUSTER UTILITY OUTPUT AS WELL :-


                            [grid@storage ~]$ crs_stat -t

                            Name           Type           Target    State     Host      

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

                            ora.DATA.dg    ora....up.type ONLINE    OFFLINE             

                            ora.FRA.dg     ora....up.type OFFLINE   OFFLINE             

                            ora....ER.lsnr ora....er.type ONLINE    ONLINE    storage   

                            ora.asm        ora.asm.type   ONLINE    OFFLINE             

                            ora.cssd       ora.cssd.type  ONLINE    ONLINE    storage   

                            ora.diskmon    ora....on.type OFFLINE   OFFLINE             

                            ora.evmd       ora.evm.type   ONLINE    ONLINE    storage   

                            ora.ons        ora.ons.type   OFFLINE   OFFLINE             

                            [grid@storage ~]$


                            HERE IS WHAT I DID TO MAKE ora.DATA.dg, ora.FRA.dg , ora.asm , ora.diskmon, ora.ons   TO MAKE ONLINE


                            [grid@storage Desktop]$ crsctl start resource -all

                            CRS-5702: Resource 'ora.DATA.dg' is already running on 'storage'

                            CRS-5702: Resource 'ora.FRA.dg' is already running on 'storage'

                            CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'storage'

                            CRS-5702: Resource 'ora.asm' is already running on 'storage'

                            CRS-5702: Resource 'ora.cssd' is already running on 'storage'

                            CRS-5702: Resource 'ora.evmd' is already running on 'storage'

                            CRS-2501: Resource 'ora.ons' is disabled

                            CRS-2672: Attempting to start 'ora.diskmon' on 'storage'

                            CRS-2676: Start of 'ora.diskmon' on 'storage' succeeded

                            CRS-4000: Command Start failed, or completed with errors.

                             

                            I DON'T KNOW WHY INORDER TO MAKE RUN OF ABOVE RESOURCES EVERY TIME I HAVE TO RUN crsctl start resource -all ..I WONDER WHAT IS THE REASON ?

                             

                            so after crsctl start resource -all HERE IS THE OUTPUT

                             

                            [grid@storage Desktop]$ crs_stat -t

                            Name           Type           Target    State     Host       

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

                            ora.DATA.dg    ora....up.type ONLINE    ONLINE    storage    

                            ora.FRA.dg     ora....up.type ONLINE    ONLINE    storage    

                            ora....ER.lsnr ora....er.type ONLINE    ONLINE    storage    

                            ora.asm        ora.asm.type   ONLINE    ONLINE    storage    

                            ora.cssd       ora.cssd.type  ONLINE    ONLINE    storage    

                            ora.diskmon    ora....on.type OFFLINE   OFFLINE              

                            ora.evmd       ora.evm.type   ONLINE    ONLINE    storage    

                            ora.ons        ora.ons.type   OFFLINE   OFFLINE              

                            [grid@storage Desktop]$

                             

                            [grid@storage Desktop]$ srvctl enable ASM

                            PRCC-1010 : asm was already enabled

                            PRCR-1002 : Resource ora.asm is already enabled

                            [grid@storage Desktop]$ srvctl start ASM

                            PRCC-1014 : asm was already running

                            PRCR-1004 : Resource ora.asm is already running

                            PRCR-1079 : Failed to start resource ora.asm

                            CRS-5702: Resource 'ora.asm' is already running on 'storage'

                            [grid@storage Desktop]$ srvctl status ASM

                            ASM is running on storage

                             

                            AFTER MAKING ALL THE RESOURCES ONLINE crsctl start resource -all HERE IS THE LISTENER OUTPUT

                             

                            [grid@storage Desktop]$ lsnrctl status

                             

                            LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUL-2015 20:40:10

                             

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

                             

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

                            STATUS of the LISTENER

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

                            Alias                     LISTENER

                            Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                            Start Date                15-JUL-2015 20:30:37

                            Uptime                    0 days 0 hr. 9 min. 32 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=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                            Services Summary...

                            Service "orcl" has 1 instance(s).

                            Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

                            The command completed successfully

                            [grid@storage Desktop]$

                             

                             

                             

                             

                             

                             

                             



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

                              Hi Pavan,

                              I tried login with all of this but could not login

                               

                              sqlplus sys@LISTENERCONF

                              sqlplus / as sysdba

                              sqlplus / as sysdba@orcl

                              sqlplus / as sysdba@LISTENERCONF

                               

                              For all above command i have used for login. I received the same error message for all. Here is the error message :

                               

                              [oracle@storage admin]$ sqlplus / as sysdba@orcl

                               

                              SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 20:11:17 2015

                               

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

                               

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              Enter user-name: sys

                              Enter password:

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              Enter user-name: sys

                              Enter password:

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

                               

                              [oracle@storage admin]$ sqlplus / as sysdba@LISTENERCONF

                               

                              SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 20:11:33 2015

                               

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

                               

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              Enter user-name: sys

                              Enter password:

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              Enter user-name: sys

                              Enter password:

                              ERROR:

                              ORA-12547: TNS:lost contact

                               

                               

                              SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

                              [oracle@storage admin]$

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

                                using COPY & PASTE post results from OS commands below

                                 

                                lsnrctl status

                                lsnrctl service

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

                                  Hi,

                                   

                                  1. You have installed grid (good), It's used for ASM/Cluster (RAC) purpose, but not for creating databases. You need to install Oracle Binaries for that, to create database

                                  2. Second thing, storage.castrading.com --is this your local host or some other host ? Since your tnsnames.ora pointing to that host - for Oracle sid-  orcl
                                    storage.castrading.com -- This is the location where database is hosted and you need to connect.

                                  3. SQLNET.AUTHENTICATION_SERVICES=NONE (update it)

                                  4.  Not an appropriate method when you are connecting to remote instance as sysdba

                                   

                                   

                                  sqlplus sys@LISTENERCONF

                                  sqlplus / as sysdba                             

                                  sqlplus / as sysdba@orcl

                                  sqlplus / as sysdba@LISTENERCONF

                                  Not appropriate methods (all are wrong)

                                   

                                  5. Do you have sys password (correct one)?

                                  sqlplus "/as sysdba" it mean is you use OS authorization and your user must member of dba(ORA_DBA) OS group,else operation will fail.

                                  sqlplus sys/pass@sid as sysdba it mean is you use passwordfile authorization .And in this case you need properly configure this file also need set remote_login_passwordfile= EXCLUSIVE or SHARED

                                   

                                  6. Login to server storage.castrading.com (make sure you have listener, instance is up and running)

                                   

                                  - Pavan Kumar N

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

                                    HERE IS THE OUTPUT AS MENTIONED ABOVE :-

                                     

                                    [oracle@storage ~]$ sqlplus "/as sysdba"

                                     

                                    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 20:52:30 2015

                                     

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

                                     

                                    ERROR:

                                    ORA-12547: TNS:lost contact

                                     

                                     

                                    Enter user-name: sys

                                    Enter password:

                                    ERROR:

                                    ORA-12547: TNS:lost contact

                                     

                                     

                                    Enter user-name: sys

                                    Enter password:

                                    ERROR:

                                    ORA-12547: TNS:lost contact

                                     

                                     

                                    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

                                     

                                    [oracle@storage ~]$

                                     

                                     

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

                                     

                                    [oracle@storage ~]$ sqlplus sys/sys@orcl as sysdba

                                     

                                    SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 20:54:04 2015

                                     

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

                                     

                                    ERROR:

                                    ORA-01031: insufficient privileges

                                     

                                     

                                    Enter user-name: sys

                                    Enter password:

                                    ERROR:

                                    ORA-12547: TNS:lost contact

                                     

                                     

                                    Enter user-name: sys

                                    Enter password:

                                     

                                    ERROR:

                                    ORA-12547: TNS:lost contact

                                     

                                     

                                    SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

                                    [oracle@storage ~]$

                                     

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

                                     

                                    [grid@storage Desktop]$ srvctl status ASM

                                    ASM is running on storage

                                     

                                     

                                    AND HERE IS THE LISTENER STATUS

                                     

                                    [grid@storage Desktop]$ lsnrctl status

                                     

                                    LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 15-JUL-2015 20:51:17

                                     

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

                                     

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

                                    STATUS of the LISTENER

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

                                    Alias                     LISTENER

                                    Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

                                    Start Date                15-JUL-2015 20:30:37

                                    Uptime                    0 days 0 hr. 20 min. 39 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=tcp)(HOST=storage.castrading.com)(PORT=1521)))

                                    Services Summary...

                                    Service "orcl" has 1 instance(s).

                                      Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...

                                    The command completed successfully

                                     

                                     

                                    [grid@storage Desktop]$

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

                                     

                                    Please NOTE : I haven't installed database from DBCA. Its because it gives an error message ORA-12547: TNS:lost contact

                                    while installing DATABSE

                                    1 2 3 Previous Next