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
      • 45. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

        post results from OS commands below

         

        hostname

        /sbin/ifconfig

        uname -a

        lsnrctl service

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

          Hi Ujjwal,

           

          1. It's been chat log (all through posts and outputs)2

          2. You have done installation a bit wrong user and permissions (re-link) would be causing issue

          3. Better you de-attach the oracle home from inventory (remove oracle insallaiton binaries)

          4. Do a fresh install, do it with oracle user (as you have seen so many forums members are trying to resolve issue)

          5. Please do correct the hosts file

          6. Now, please follow for de-attaching from inventory
          https://docs.oracle.com/cd/E18283_01/em.112/e12255/oui2_manage_oracle_homes.htm

           

          hope it will solve the issue.

           

          - Pavan Kumar N

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

            [root@storage network-scripts]# more ifcfg-eth1

            DEVICE=eth1

            HWADDR=00:0C:29:67:51:03

            IPADDR=192.168.0.227

            NETMASK=255.255.255.0

            GATEWAY=192.168.0.2

            DNS1=192.168.0.2

            ONBOOT=yes

            BOOTPROTO=static

             

            [root@storage network-scripts]# hostname

            storage.castrading.com

             

            [root@storage network-scripts]#

             

             

            [root@storage network-scripts]# uname -a

            Linux storage.castrading.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

             

            [root@storage network-scripts]# su - oracle

             

            [oracle@storage ~]$ uname -a

             

            Linux storage.castrading.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

             

            [oracle@storage ~]$ su - grid

            Password:

             

            [grid@storage ~]$ uname -a

            Linux storage.castrading.com 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux

             

            [grid@storage ~]$

             

            [grid@storage ~]$ lsnrctl status

             

            LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-JUL-2015 12:52:10

             

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

             

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

            STATUS of the LISTENER

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

            Alias                     LISTENER

            Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

            Start Date                16-JUL-2015 10:35:45

            Uptime                    0 days 2 hr. 16 min. 25 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/11.2.0/grid/log/diag/tnslsnr/storage/listener/alert/log.xml

            Listening Endpoints Summary...

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

              (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.227)(PORT=1521)))

            Services Summary...

            Instance "+ASM", status READY, has 1 handler(s) for this service...

            The command completed successfully

            [grid@storage ~]$ lsrnctl service

            -bash: lsrnctl: command not found

             

            [grid@storage ~]$ lsnrctl service

             

            LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 16-JUL-2015 12:52:27

             

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

             

            Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))

            Services Summary...

            Service "+ASM" has 1 instance(s).

              Instance "+ASM", status READY, has 1 handler(s) for this service...

                Handler(s):

                  "DEDICATED" established:0 refused:0 state:ready

                     LOCAL SERVER

            The command completed successfully

            [grid@storage ~]$

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

              Pavan,

              Actually I wanted to solved this issue without re-installing it. Its because what if the same issue get raised on second time in the near future ? solving this issue is possible only by the help of senior oracle support team. I am looking forward for their help.

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

                Hi ujwal

                 

                check it that the listner status

                lsnrctl stats:

                check it that  the tns is pinging or not ?

                tnsping <tns name>:

                check the listener services having the tns service or not ?

                listener services :

                finally check the firewall issues in  os level ?

                # service iptables save

                # service iptables stop

                # chkconfig iptables off

                #chkconfig -level 123456 iptables off 

                 

                try to connect it again ?

                 

                Thanks & Regards

                Shekar

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

                  [root@storage ~]# service iptables status

                  iptables: Firewall is not running.

                  [root@storage ~]#

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

                    send me the outputs  of the following

                     

                     

                    lsnrctl status,

                    tnsping tns name

                    lsnrctl services

                    echo $ORACLE_HOME

                    Thanks & Regards

                    Shekar

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

                      check your $ORACLE_HOME file permissions once

                       

                       

                      thanks & regards

                      shekar

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

                        Hi Pavan,

                        I have find the reason for ORA-12547: TNS:lost contact .

                         

                        ORA-12547: TNS:lost contact

                         

                        This error was occured because of SQLNET.ORA file...because of SQLNET.AUTHORIZATION_SERVCICE=(NONE)...So when i changed SQLNET.AUTHORIZATION_SERVCICE=(NONE)

                        to SQLNET.AUTHORIZATION_SERVCICE=(ALL).....ORA-12547: TNS:lost contact message got disappeared.

                         

                        Now the another problem that i am facing with is under ASM CREDENTIAL...while installing database from DBCA it ask for the ASMNSMP password and when i give the correct password it then shows following message. If you again give SQLNET.AUTHENTICATION_SERVICES= (NONE) it then accept asmsnmp password :-

                        asmcredentials.png

                         

                        But when i click next and run the setup it again shows ORA-12547: TNS:lost contact error message. So i see that the main cause of this problem is sqlnet.ora.

                        dca.png

                         

                        [grid@storage admin]$ vi sqlnet.ora

                        #NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

                         

                        SQLNET.AUTHENTICATION_SERVICES= (ALL)

                         

                        NAMES.DIRECTORY_PATH= (TNSNAMES, HOSTNAME, EZCONNECT)

                         

                        ADR_BASE = /u01/app/grid

                         

                        Let me know if i was able to make you understand. I BELIEVE WE ARE ALMOST NEAR TO THE SOLUTION.

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

                          You need to have password file asmsnmp

                          orapwd file=$GRID_HOME/orapw+ASM -password= <provide_password> -entries=5
                          export ORACLE_SID=+ASM (based on your ASM instance name)
                          sqlplus "/ as sysdba"
                          create user ASMSNMP identified by <provide_password>;
                          grant sysdba to asmsnmp;
                          select * from V$PWFILE_USERS; ...verify

                          Note - above passwords must be same


                          Try to understand (SQLNET.AUTHENTICATION_SERVICES)
                          https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF2035

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

                            Hi Pavan,

                             

                            I TRIED THIS ONE BUT I RECEIVED ERROR MESSAGE :-

                             

                            [grid@storage admin]$ cd $ORACLE_HOME

                             

                            [grid@storage grid]$ cd dbs/

                             

                            [grid@storage dbs]$ ls

                            ab_+ASM.dat  hc_+ASM.dat  init.ora  orapw+ASM

                             

                             

                            [grid@storage dbs]$ orapwd file=$GRID_HOME/dbs/orapw+ASM -password=asmnepal -entries=5

                            Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

                             

                              where

                                file - name of password file (required),

                                password - password for SYS will be prompted if not specified at command line,

                                entries - maximum number of distinct DBA (optional),

                                force - whether to overwrite existing file (optional),

                                ignorecase - passwords are case-insensitive (optional),

                                nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).

                             

                              There must be no spaces around the equal-to (=) character.

                            [grid@storage dbs]$

                             

                            AND THEN I USED ANOTHER OPTIONS :-

                            I tried to change ASMSNMP password in following way but i could not solve it. Here is what i did :-

                             

                            [grid@storage admin]$ cd $ORACLE_HOME

                             

                            [grid@storage grid]$ cd dbs/

                             

                            [grid@storage dbs]$ ls

                            ab_+ASM.dat  hc_+ASM.dat  init.ora  orapw+ASM

                             

                             

                            [grid@storage dbs]$ orapwd file=$GRID_HOME/dbs/orapw+ASM -password=asmnepal -entries=5

                            Usage: orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

                             

                              where

                                file - name of password file (required),

                                password - password for SYS will be prompted if not specified at command line,

                                entries - maximum number of distinct DBA (optional),

                                force - whether to overwrite existing file (optional),

                                ignorecase - passwords are case-insensitive (optional),

                                nosysdba - whether to shut out the SYSDBA logon (optional Database Vault only).

                             

                              There must be no spaces around the equal-to (=) character.

                             

                            [grid@storage dbs]$

                             

                            ALSO PLEASE HAVE LOOK ON THIS ONE AS WELL. I TRIED THIS AS WELL :-


                            [grid@storage dbs]$ sqlplus / as sysasm

                             

                            SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 16 16:00:11 2015

                             

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

                             

                             

                            Connected to:

                            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

                            With the Automatic Storage Management option

                             

                            SQL> alter user asmsnmp identified by asmnepal;

                             

                            User altered.

                             

                            SQL> grant sysdba to asmsnmp;

                             

                            Grant succeeded.

                             

                            SQL> select * from gv$pwfile_users order by inst_id;

                             

                               INST_ID USERNAME              SYSDB SYSOP SYSAS

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

                                 1 ASMSNMP              TRUE    FALSE FALSE

                                 1 SYS                  TRUE    TRUE  TRUE

                             

                            SQL> grant sysasm to asmsnmp;

                             

                            Grant succeeded.

                             

                            SQL>  grant sysdba to asmsnmp;

                             

                            Grant succeeded.

                             

                            SQL> conn asmsnmp/asmnepal

                            ERROR:

                            ORA-15000: command disallowed by current instance type

                             

                             

                            Warning: You are no longer connected to ORACLE.

                            SQL>

                             

                             

                            [grid@storage dbs]$ sqlplus asmsnmp/asmnepal as sysasm

                             

                            SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 16 16:04:57 2015

                             

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

                             

                             

                            Connected to:

                            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

                            With the Automatic Storage Management option

                             

                            SQL>

                             

                            SQL> select * from gv$pwfile_users order by inst_id;

                             

                               INST_ID USERNAME              SYSDB SYSOP SYSAS

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

                                 1 ASMSNMP                          TRUE    FALSE TRUE

                                 1 SYS                                     TRUE    TRUE  TRUE

                             

                            SQL>

                             

                             

                            [grid@storage dbs]$ sqlplus asmsnmp/asmnepal as sysasm

                             

                            SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 16 16:14:19 2015

                             

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

                             

                             

                            Connected to:

                            Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

                            With the Automatic Storage Management option

                             

                            SQL> show parameter pass

                             

                            NAME                     TYPE     VALUE

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

                            remote_login_passwordfile         string     EXCLUSIVE

                            SQL>

                             

                             

                             

                            NOTE : I HAVEN'T INSTALLED DATABASE FROM DBCA YET. WILL DO ONCE I GET YOUR CONFIRMATION.

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

                              ..$GRID_HOME .. It's just example to use ASM Oracle Home that is $GRID_HOME(an environment variable declared your Linux or $ORACLE_HOME points to grid software binaries),  you directly copy paste everything.

                              Does my environment will match yours, not all - just try to understand, when you perform stuff. Please make sure orapwd password file is get's created

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

                                Actually I wanted to show you other output of ASMSNMP and thats why i copied it and paste it ...just to show you.

                                 

                                The following command is not working

                                [grid@storage dbs]$ orapwd file=$GRID_HOME/dbs/orapw+ASM -password=asmnepal -entries=5

                                 

                                IS THIS THE ONE YOU ARE LOOKING FOR ?

                                 

                                [root@storage ~]# ps -ef|grep pmon

                                grid      2446     1  0 10:36 ?        00:00:04 asm_pmon_+ASM

                                root     12204 12184  0 16:29 pts/1    00:00:00 grep pmon

                                [root@storage ~]#

                                 

                                 

                                [root@storage ~]# ps -ef|grep pmon

                                grid      2446     1  0 10:36 ?        00:00:04 asm_pmon_+ASM

                                root     12204 12184  0 16:29 pts/1    00:00:00 grep pmon

                                 

                                GRID_HOME

                                 

                                [root@storage ~]#  ls -lrt /u01/app/11.2.0/grid/dbs/orapw*

                                -rw-r----- 1 grid oinstall 1536 Jul 16 16:02 /u01/app/11.2.0/grid/dbs/orapw+ASM

                                 

                                 

                                ORACLE_HOME

                                [root@storage 11.2.0]# ls -lrt /u01/app/oracle/product/11.2.0/db_1/dbs/orapw*

                                -rwxrwxr-x 1 grid   oinstall 1536 Jul 10 09:13 /u01/app/oracle/product/11.2.0/db_1/dbs/orapwDBUA0

                                -rwxrwxr-x 1 grid   oinstall 1536 Jul 13 14:18 /u01/app/oracle/product/11.2.0/db_1/dbs/orapwDBUA1

                                -rw-r----- 1 oracle oinstall 1536 Jul 16 13:55 /u01/app/oracle/product/11.2.0/db_1/dbs/orapworcl

                                [root@storage 11.2.0]#

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

                                  I think so, you can try dbca (still I feel it would get fail)