1 2 3 Previous Next 40 Replies Latest reply: Feb 4, 2011 10:23 AM by Andy Steel Go to original post RSS
      • 15. Re: ORA-12547: TNS: lost contact
        baskar.l
        Ali,

        Try starting the database manually

        sqlplus "/as sysdba"
        startup

        If not started post the error message in the alert log file.

        thanks,
        baskar.l
        • 16. Re: ORA-12547: TNS: lost contact
          447699
          Thank you

          the error is the same

          ORA-12547: TNS: lost contact

          Ali
          • 17. Re: ORA-12547: TNS: lost contact
            baskar.l
            Ali,

            post

            echo $ORACLE_SID
            echo $ORACLE_HOME

            thanks,
            baskar.l
            • 18. Re: ORA-12547: TNS: lost contact
              447699
              Thank you for your help

              # echo $ORACLE_SID VIS
              # echo $ORACLE_HOME      /d01/oracle/VIS/db/tech_st/11.1.0

              Ali
              • 19. Re: ORA-12547: TNS: lost contact
                447699
                Hi again:

                I have been waiting to get help to resolve ORA-12547: TNS: lost contact

                when I excute ./addbctl.sh start

                to start the database on R12.1 eBusiness Suite on Enterprise Linux 32

                I got a suggestion to use relink all or relink oracle

                But did not work

                Here is my path for oracle

                # echo $ORACLE_SID           VIS
                # echo $ORACLE_HOME      /d01/oracle/VIS/db/tech_st/11.1.0

                Please help

                Ali
                • 20. Re: ORA-12547: TNS: lost contact
                  447699
                  Hi:

                  I have been waiting to get help to sovle this problem.

                  What I tried is to setup the ORACLE_HOME and relink to oracle but could not solve the problem.

                  Does any one has idea how to reslove this problem?

                  I am trying to start the database

                  ./addbctl.sh start

                  What I still get the error is ORA-12547: TNS: lost contact

                  I am running SQL Plus Rel 11.1.0.7.0 on Enterprise Linux

                  in eBusiness Suite Application

                  Please help

                  Ali
                  • 21. Re: ORA-12547: TNS: lost contact
                    sb92075
                    Log onto the system as the Oracle s/w owner
                    CUT lines below & PASTE into terminal/command window above

                    env | sort
                    cat /etc/hosts
                    lsnrctl status
                    cd $ORACLE_HOME/network/admin
                    mv listener.ora listener.20090722.ora
                    lsnrctl start
                    lsnrctl status
                    sqlplus
                    / as sysdba
                    startup
                    select * from v$version;
                    exit


                    Now using CUT commands & results and PASTE whole session back here
                    • 22. Re: ORA-12547: TNS: lost contact
                      447699
                      Hi

                      I still get the same error

                      Ali
                      • 23. Re: ORA-12547: TNS: lost contact
                        sb92075
                        Now using CUT commands & results and PASTE whole session back here
                        • 24. Re: ORA-12547: TNS: lost contact
                          447699
                          Hi:

                          Thank you foour help

                          I use SYSTEM / manager as username/password and here is my output

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

                          [oracle@allsemworks ~]$ env | sort
                          COLORTERM=gnome-terminal
                          CVS_RSH=ssh
                          DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-DtjIoJXLxr,guid=eae8831a5ae48028a5041e004a9058d4
                          DESKTOP_SESSION=default
                          DESKTOP_STARTUP_ID=
                          DISPLAY=:0.0
                          G_BROKEN_FILENAMES=1
                          GDMSESSION=default
                          GDM_XSERVER_LOCATION=local
                          GNOME_DESKTOP_SESSION_ID=Default
                          GNOME_KEYRING_SOCKET=/tmp/keyring-pQTuR0/socket
                          GTK_RC_FILES=/etc/gtk/gtkrc:/home/oracle/.gtkrc-1.2-gnome2
                          HISTSIZE=1000
                          HOME=/home/oracle
                          HOSTNAME=allsemworks.allsemworks.com
                          INPUTRC=/etc/inputrc
                          KDEDIR=/usr
                          KDE_IS_PRELINKED=1
                          KDE_NO_IPV6=1
                          LANG=en_US.UTF-8
                          LESSOPEN=|/usr/bin/lesspipe.sh %s
                          LOGNAME=oracle
                          LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32:*.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00;35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
                          MAIL=/var/spool/mail/oracle
                          ORACLE_BASE=/d01/oracle
                          ORACLE_HOME=/d01/oracle/VIS/db/tech_st/11.1.0
                          ORACLE_SID=VIS
                          PATH=/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/d01/oracle/VIS/db/tech_st/11.1.0/bin:/d01/oracle/VIS/db/tech_st/11.1.0/lib:/usr/local/bin:/usr/bin:/bin:/usr/X11R6/bin:/home/oracle/bin
                          PWD=/home/oracle
                          QTDIR=/usr/lib/qt-3.3
                          QTINC=/usr/lib/qt-3.3/include
                          QTLIB=/usr/lib/qt-3.3/lib
                          SESSION_MANAGER=local/allsemworks.allsemworks.com:/tmp/.ICE-unix/4775
                          SHELL=/bin/bash
                          SHLVL=2
                          SSH_AGENT_PID=4811
                          SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
                          SSH_AUTH_SOCK=/tmp/ssh-bJPTUJ4775/agent.4775
                          TERM=xterm
                          USERNAME=oracle
                          USER=oracle
                          _=/usr/bin/env
                          WINDOWID=52428881
                          XAUTHORITY=/tmp/.gdmKJ2KZU
                          XMODIFIERS=@im=none
                          [oracle@allsemworks ~]$ cat /etc/hosts
                          # Do not remove the following line, or various programs
                          # that require network functionality will fail.
                          127.0.0.1 allsemworks.allsemworks.com allsemworks localhost.localdomain localhost
                          ::1 localhost6.localdomain6 localhost6
                          [oracle@allsemworks ~]$ lsnrctl status

                          LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 22-AUG-2009 16:53:14

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

                          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
                          Start Date 22-AUG-2009 16:47:14
                          Uptime 0 days 0 hr. 5 min. 59 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Log File /d01/oracle/diag/tnslsnr/allsemworks/listener/alert/log.xml
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=allsemworks.allsemworks.com)(PORT=1521)))
                          The listener supports no services
                          The command completed successfully
                          [oracle@allsemworks ~]$ cd $ORACLE_HOME/network/admin
                          [oracle@allsemworks admin]$ mv listener.ora listener.20090722.ora
                          mv: cannot stat `listener.ora': No such file or directory
                          [oracle@allsemworks admin]$ lsnrctl start

                          LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 22-AUG-2009 16:53:14

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

                          TNS-01106: Listener using listener name LISTENER has already been started
                          [oracle@allsemworks admin]$ lsnrctl status

                          LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 22-AUG-2009 16:53:14

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

                          Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
                          Start Date 22-AUG-2009 16:47:14
                          Uptime 0 days 0 hr. 5 min. 59 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Listener Log File /d01/oracle/diag/tnslsnr/allsemworks/listener/alert/log.xml
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=allsemworks.allsemworks.com)(PORT=1521)))
                          The listener supports no services
                          The command completed successfully
                          [oracle@allsemworks admin]$ sqlplus

                          SQL*Plus: Release 11.1.0.7.0 - Production on Sat Aug 22 16:53:14 2009

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

                          Enter user-name: SYSTEM
                          SP2-0306: Invalid option.
                          Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
                          where <logon> ::= <username>[<password>][@<connect_identifier>] [edition=value] | /
                          Enter user-name: SYSTEM
                          Enter password:
                          ERROR:
                          ORA-12547: TNS:lost contact


                          Enter user-name:

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

                          Ali
                          • 25. Re: ORA-12547: TNS: lost contact
                            sb92075
                            Nowhere in my previous post did I mention anything about using "SYSTEM" account to login to Oracle

                            If you can't or won't follow directions, then I'll stop trying to assist.
                            The reality is that SQL*Net is NOT required to start Oracle DB.
                            Once again using the "oracle" account CUT the lines below & PASTE into terminal/command window

                            netstat -a | grep LISTEN | grep 1521
                            ps -ef | grep ora_ | grep mon
                            sqlplus
                            / as sysdba
                            startup
                            select * from v$version;
                            exit

                            Now using CUT commands & results and PASTE whole session back here
                            • 26. Re: ORA-12547: TNS: lost contact
                              447699
                              Thank you again for your support

                              for SQLPlus I use the default username / password

                              but the out put is the same.

                              This time First I start the listner which works fine and then I try to start the database and then I copy and paste the command that you post

                              Here is the whole result
                              +++++++++++++++++++++++++++++++++==

                              [root@allsemworks VIS_allsemworks]# ./addlnctl.sh start VIS

                              You are running addlnctl.sh version 120.1.12010000.2

                              Logfile: /d01/oracle/VIS/db/tech_st/11.1.0/appsutil/log/VIS_allsemworks/addlnctl.txt

                              Starting listener process VIS ...


                              addlnctl.sh: exiting with status 0
                              [root@allsemworks VIS_allsemworks]# ls
                              adautocfg.sh addbctl.sh adexecsql.pl adpreclone.pl adstrtdb.sql
                              adchknls.pl addlnctl.sh adlsnodes.sh adstopdb.sql
                              [root@allsemworks VIS_allsemworks]# addbctl.sh start
                              bash: addbctl.sh: command not found
                              [root@allsemworks VIS_allsemworks]# ./addbctl.sh start

                              You are running addbctl.sh version 120.1


                              Starting the database VIS ...


                              SQL*Plus: Release 11.1.0.7.0 - Production on Sat Aug 22 17:24:19 2009

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

                              ERROR:
                              ORA-12547: TNS:lost contact



                              addbctl.sh: exiting with status 9

                              [root@allsemworks VIS_allsemworks]# netstat -a | grep LISTEN | grep 1522
                              [root@allsemworks VIS_allsemworks]# ps -ef | grep ora_ | grep mon
                              [root@allsemworks VIS_allsemworks]# sqlplus

                              SQL*Plus: Release 11.1.0.7.0 - Production on Sat Aug 22 17:24:40 2009

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

                              Enter user-name: / as sysdba
                              SP2-0306: Invalid option.
                              Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER|SYSASM}]
                              where <logon> ::= <username>[<password>][@<connect_identifier>] [edition=value] | /
                              Enter user-name: / as sysdba
                              ERROR:
                              ORA-12547: TNS:lost contact


                              Enter user-name:

                              ============+++++++++++++++++++=

                              Ali
                              • 27. Re: ORA-12547: TNS: lost contact
                                sb92075
                                I directed to do
                                Once again using the "oracle" account CUT the lines below & PASTE into terminal/command window

                                & you are running a root!
                                root@allsemworks VIS_allsemworks# ls
                                I asked for CUT & PASTE!

                                netstat -a | grep LISTEN | grep 1521
                                & you do the following
                                root@allsemworks VIS_allsemworks# netstat -a | grep LISTEN | grep 1522

                                Enjoy your mystery!
                                Since you can't or won't follow direction, You're On Your Own (YOYO)!
                                • 28. Re: ORA-12547: TNS: lost contact
                                  447699
                                  Thank you

                                  When I install the database I change from 1521 to 1522.

                                  So based on your comment I use 1522.

                                  My setup do not know 1521 only know 1522 if this make you sad

                                  Thank you God will send some one or other to solve my problem

                                  Can some one know how to solve the above problem?

                                  Please help

                                  Ali
                                  • 29. Re: ORA-12547: TNS: lost contact
                                    sb92075
                                    When I install the database I change from 1521 to 1522.
                                    Previous output disagrees with you (see above in this thread)
                                    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
                                    If you knew as much as you think you do, you would not be flailing around begging for answers.

                                    You don't know, what you don't know!