1 2 3 4 Previous Next 78 Replies Latest reply on Jul 17, 2015 4:37 AM by Ujjwal Rana Go to original post
      • 15. Re: ORA-12547: TNS:lost contact : Error received while trying to login from sqlplus / as sysdba

        please post last 100 or so line from file below

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

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

          Hi,

          sqlplus "/as sysdba" .....why are you testing this ? as you have stated that no database installed

          sqlplus sys/sys@orcl as sysdba   .... have you tested whether this server "storage.castrading.com " reachable or not  (where the database is up and running or not)

          Blindly with out going through comments you are just posting outputs which are not required

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

          Then you try use oracle binaries to create some listener not with grid binaries (you are just running super fast, be patient understand what said and what happening)

          Note - if you are not installed the database (as you know) then why are you trying to connect database orcl..so many times (how could that would be possible and posting outputs so many times)

           

          - Pavan Kumar N

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

            [grid@storage Desktop]$ tail -f /u01/app/grid/diag/tnslsnr/storage/listener/alert/log.xml -n 100

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:14:43 * service_died * LsnrAgt * 12537

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:43.658+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:14:43 * version * 0

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:43.743+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=54.174.31.254)(PORT=1521)(IP=FIRST))

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:43.743+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:14:43 * service_register * LsnrAgt * 12545

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:43.743+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>TNS-12545: Connect failed because target host or object does not exist

            TNS-12560: TNS:protocol adapter error

              TNS-00515: Connect failed because target host or object does not exist

               Linux Error: 99: Cannot assign requested address

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:44.769+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>WARNING: Subscription for node down event still pending

            </txt>

            </msg>

            <msg time='2015-07-15T21:14:44.770+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:14:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.559+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>WARNING: Subscription for node down event still pending

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.559+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:15:43 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.637+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:15:43 * service_died * LsnrAgt * 12537

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.677+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:15:43 * version * 0

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.747+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>Error listening on: (ADDRESS=(PROTOCOL=TCP)(HOST=54.174.31.254)(PORT=1521)(IP=FIRST))

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.747+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:15:43 * service_register * LsnrAgt * 12545

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:43.747+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>TNS-12545: Connect failed because target host or object does not exist

            TNS-12560: TNS:protocol adapter error

              TNS-00515: Connect failed because target host or object does not exist

               Linux Error: 99: Cannot assign requested address

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:44.776+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>WARNING: Subscription for node down event still pending

            </txt>

            </msg>

            <msg time='2015-07-15T21:15:44.776+05:45' org_id='oracle' comp_id='tnslsnr'

            type='UNKNOWN' level='16' host_id='storage.castrading.com'

            host_addr='192.168.0.227'>

            <txt>15-JUL-2015 21:15:44 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=storage.castrading.com)(USER=grid))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=186647296)) * status * 0

            </txt>

            </msg>

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

              OS/networking mis-configuration is root cause

               

              fix the problem reported below

               

              <txt>TNS-12545: Connect failed because target host or object does not exist

              TNS-12560: TNS:protocol adapter error

                TNS-00515: Connect failed because target host or object does not exist

                 Linux Error: 99: Cannot assign requested address

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

                Hi Pavan,

                What about the exisiting LISTENERCONF ...the one i have created inside grid ? Do you want me to delete that ? please let me know ???

                 

                QUESTION : sqlplus sys/sys@orcl as sysdba   .... have you tested whether this server "storage.castrading.com " reachable or not  (where the database is up and running or not)


                ANSWER :

                 

                sqlplus sys/sys@orcl as sysdba (REGARDING THIS DO YOU WANT ME SHOW THE OUTPUT of sqlplus sys/sys@orcl as sysdba ) If it is then here it is :-

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

                SQL*Plus: Release 11.2.0.1.0 Production on Wed Jul 15 21:29:30 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

                 

                REGARDING WHETHER server "storage.castrading.com " reachable or no. HERE IS THE OUTPUT FROM GRID AND ORACLE

                [oracle@storage ~]$ ping storage.castrading.com

                PING storage.castrading.com (192.168.0.227) 56(84) bytes of data.

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=1 ttl=64 time=0.035 ms

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=2 ttl=64 time=0.045 ms

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=3 ttl=64 time=0.044 ms

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=4 ttl=64 time=0.044 ms

                 

                 

                [grid@storage Desktop]$ ping storage.castrading.com

                PING storage.castrading.com (192.168.0.227) 56(84) bytes of data.

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=1 ttl=64 time=0.045 ms

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=2 ttl=64 time=0.043 ms

                64 bytes from storage.castrading.com (192.168.0.227): icmp_seq=3 ttl=64 time=0.046 ms

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

                  Hi,

                   

                  1. You can leave that listener.

                  2. Try to login to this server 192.168.0.227, check verify any db instance is up and running

                  ps -ef |grep pmon (If its running then ) check for listener

                   

                  Note - I just hoping that you are trying to correct password of sysdba

                   

                  - Pavan Kumar N

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

                    SINCE I HAVE INSTALLED ORACLE GRID. I HAVE POSTED THE OUTPUT OF ps -ef |grep pmon from following user :


                    FROM GRID USER

                    [grid@storage Desktop]$ ps -ef |grep pmon

                    grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                    grid      3748  2934  0 21:37 pts/0    00:00:00 grep pmon

                     

                    [grid@storage Desktop]$ su - oracle

                    Password:


                    FROM ORACLE USER

                    [oracle@storage ~]$ ps -ef |grep pmon

                    grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                    oracle    3779  3755  0 21:37 pts/0    00:00:00 grep pmon

                     

                    [oracle@storage ~]$ su - root

                    Password:


                    FROM ROOT USER

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

                    grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                    root      3807  3783  0 21:38 pts/0    00:00:00 grep pmon

                    [root@storage ~]#

                     

                    One more thing since this is a test server only therefore password for sys is sys.

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

                      Hi,

                       

                      1.  storage.castrading.com is this same server from where you are trying sys connections (then man you confused this time, by so many posts)

                      2. You need to first install oracle binaries, different from GRID.

                      3, then during installation or after software installation you need create database (dbca). You can't kick of dbca from grid.

                       

                      Note - storage.castrading.com (I was thinking this is totally different server)

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

                        Ujjwal Rana wrote:

                         

                        SINCE I HAVE INSTALLED ORACLE GRID. I HAVE POSTED THE OUTPUT OF ps -ef |grep pmon from following user :


                        FROM GRID USER

                        [grid@storage Desktop]$ ps -ef |grep pmon

                        grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                        grid      3748  2934  0 21:37 pts/0    00:00:00 grep pmon

                         

                        [grid@storage Desktop]$ su - oracle

                        Password:


                        FROM ORACLE USER

                        [oracle@storage ~]$ ps -ef |grep pmon

                        grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                        oracle    3779  3755  0 21:37 pts/0    00:00:00 grep pmon

                         

                        [oracle@storage ~]$ su - root

                        Password:


                        FROM ROOT USER

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

                        grid      2452     1  0 20:30 ?        00:00:00 asm_pmon_+ASM

                        root      3807  3783  0 21:38 pts/0    00:00:00 grep pmon

                        [root@storage ~]#

                        The output of the ps command is not dependent on who executes it.  You either have the privilege to execute it, or you don't.  You'll see that if you will actually examine the above results.  The only variance is the session id and parent session id in the line that reports 'grep pmon', and that is because that line is reporting your own grep command which, of course, is different as you are executing it from a different process every time.

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

                          Hi,

                                Have you installed oracle home , All the logs show you are using grid home not the actual oracle home. ??

                           

                          Thanks

                          Lingesh R

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

                            Pavan,

                            I have already installed oracle binaries as well. Here is the complete steps which i have followed for installing oracle binaries :-

                             

                            Linux Setup steps for Oracle 11gR2 Installation with Grid

                            1. Check Minimum Required RAM & Swap Space

                            # free -m

                            1 GB RAM

                            1.5 GB swap space

                             

                            2. Check Minimum Disk space requirements:

                            # df -h

                            /tmp --> 1GB

                            /u01 --> 8.3 GB (3.8 GB for Database Software + 4.5 for Grid Software)

                             

                            3. Install required RPMs.

                            . Insert RHEL/CentOS DVD into the DVD-ROM

                             

                            # mkdir -p /stage/Disk1

                             

                            # df -h

                             

                            # cp -r /media/RH<TAB>/* /stage/Disk1

                             

                            # cd /stage/Disk1/Packages

                             

                            # rpm -ivh createrepo<TAB> deltarpm<TAB> python-deltarpm<TAB>

                             

                            # createrepo /stage/Disk1/Packages

                             

                            # cd /etc/yum.repos.d

                             

                            # vi packages.repo

                            [server]

                            name=server's packages

                            baseurl=file:///stage/Disk1/Packages

                            enabled=1

                            gpgcheck=0


                            # yum -y install compat-libcap1*i686* compat-libcap1*86_64* compat-libstdc+

                            +*x86_64* elfutils-devel*x86_64* elfutils-libelf-devel*x86_64* gcc-c++*x86_64*

                            glibc*i686* glibc-devel*i686* libaio*i686* libaio-devel*x86_64* libattr*i686*

                            libcap*i686* libgcc*i686* libstdc++-devel*x86_64* libtool-ltdl*i686* ncurses-

                            devel*i686* ncurses-libs*i686* nss-softokn-freebl*i686* pdksh*x86_64*

                            readline*686* glibc-devel*x86_64* java*

                             

                            4. Configure Kernel

                            # vi /etc/sysctl.conf

                            kernel.shmall = 2097152

                            kernel.shmmax = 982431744

                            kernel.shmmni = 4096

                            kernel.sem = 250 32000 100 128

                            fs.file-max = 6815744

                            fs.aio-max-nr = 1048576

                            net.ipv4.ip_local_port_range = 9000 65500

                            net.core.rmem_default = 262144

                            net.core.rmem_max = 4194304

                            net.core.wmem_default = 262144

                            net.core.wmem_max = 1048576

                             

                            # sysctl -p

                             

                            5. Specify Resource Limitations

                            # vi /etc/pam.d/login

                            session required pam_limits.so

                             

                            # vi /etc/security/limits.conf

                            oracle soft nproc 2047

                            oracle hard nproc 16384

                            oracle soft nofile 1024

                            oracle hard nofile 65536

                            grid soft nproc 2047

                            grid hard nproc 16384

                            grid soft nofile 1024

                            grid hard nofile 65536

                             

                            6. Specify Shell Limitations

                            # vi /etc/profile

                            if [ \$USER = "oracle" ] || [ \$USER = "grid" ]; then

                            if [ \$SHELL = "/bin/ksh" ]; then

                            ulimit -p 16384

                            ulimit -n 65536

                            else

                            ulimit -u 16384 -n 65536

                            fi

                            fi

                            umask 022

                             

                            7. Disable SELinux

                            # setenforce 0

                             

                            # vi /etc/sysconfig/selinux

                            SELINUX=disabled

                             

                            8. Disable Firewall

                            # iptables -F

                            # service iptables save

                            # chkconfig iptables off

                            9. Creating OS groups and users.

                            # groupadd asmadmin

                            # groupadd asmdba

                            # groupadd asmoper

                            # groupadd oinstall

                            # groupadd dba

                            # groupadd oper

                            # useradd -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid grid

                            # useradd -g oinstall -G dba,oper,asmdba -d /home/oracle oracle

                            # passwd grid

                            # passwd oracle

                             

                            10. Creating necessary directories (INSIDE ROOT # )

                             

                            # mkdir -p /u01/app/grid

                            # mkdir -p /u01/app/11.2.0/grid

                            # chown -R grid:oinstall /u01

                            mkdir -p /u01/app/oracle

                            chown oracle:oinstall /u01/app/oracle

                            chmod -R 775 /u01

                             

                            11. Specify neccessary environment variables

                            # su – oracle

                             

                             

                            $ vi .bash_profile

                            ORACLE_SID=orcl; export ORACLE_SID

                            ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME

                            JAVA_HOME=/usr/local/java; export JAVA_HOME

                            ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

                            ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME

                            ORACLE_TERM=xterm; export ORACLE_TERM

                            NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT

                            TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

                            ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

                            PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

                            PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

                            PATH=${PATH}:/u01/app/common/oracle/bin

                            export PATH

                            LD_LIBRARY_PATH=$ORACLE_HOME/lib

                            LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

                            LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

                            export LD_LIBRARY_PATH

                            CLASSPATH=$ORACLE_HOME/JRE

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

                            export CLASSPATH

                            THREADS_FLAG=native; export THREADS_FLAG

                            export TEMP=/tmp

                            export TMPDIR=/tmp

                            umask 022

                             


                            # su - grid

                            $ vi .bash_profile

                            ORACLE_SID=+ASM; export ORACLE_SID

                            JAVA_HOME=/usr/local/java; export JAVA_HOME

                            ORACLE_BASE=/u01/app/grid; export ORACLE_BASE

                            ORACLE_HOME=/u01/app/11.2.0/grid; export ORACLE_HOME

                            ORACLE_TERM=xterm; export ORACLE_TERM

                            NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"; export NLS_DATE_FORMAT

                            TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN

                            ORA_NLS11=$ORACLE_HOME/nls/data; export ORA_NLS11

                            PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin

                            PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

                            PATH=${PATH}:/u01/app/common/oracle/bin

                            export PATH

                            LD_LIBRARY_PATH=$ORACLE_HOME/lib

                            LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib

                            LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib

                            export LD_LIBRARY_PATH

                            CLASSPATH=$ORACLE_HOME/JRE

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib

                            CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

                            export CLASSPATH

                            THREADS_FLAG=native; export THREADS_FLAG

                            export TEMP=/tmp

                            export TMPDIR=/tmp

                            umask 022

                             

                             

                            12. Specify Hostname

                            # vi /etc/hosts

                            127.0.0.1 <Hostname> localhost localhost.localdomain

                             

                            Sorry this time  I have mentioned all the complete steps for oracle installation knowingly which is somewhat long and the other reason is to provide you the clear vision of the complete oracle grid installation which i have installed in my pc.

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

                               

                               

                              12. Specify Hostname

                              # vi /etc/hosts

                              127.0.0.1 <Hostname> localhost localhost.localdomain

                              You should also have a line with the actual IP address and host name.  All you have now is the line for the loopback.

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

                                Please ignore the above hostname configuration and take this as an actual host configuration

                                 

                                [root@storage ~]# cat /etc/hosts

                                127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

                                ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

                                192.168.0.227 storage.castrading.com localhost localhost.localdomain localhost4 localhost4.localdomain4

                                [root@storage ~]#

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

                                  Hi,

                                   

                                  Okay can you check  (is that 64 bit or 32 bit)

                                  rpm -qa | grep ^libaio)

                                   

                                  check for whether stick bit is set of "$ORACLE_HOME/bin/oracle" (not grid one)

                                  Try to re-install based on OS 32 bit or 64 bit

                                   

                                  libaio & libaio-devel package

                                   

                                  Update once re-installed try dbca

                                   

                                  - Pavan Kumar N

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

                                    Ujjwal Rana wrote:

                                     

                                    Please ignore the above hostname configuration and take this as an actual host configuration

                                     

                                    [root@storage ~]# cat /etc/hosts

                                    127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

                                    ::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

                                    192.168.0.227 storage.castrading.com localhost localhost.localdomain localhost4 localhost4.localdomain4

                                    [root@storage ~]#

                                    Also a mal-formed hosts file.

                                    All of the 'localhost' references, in all their forms, should reference ONLY the 127.0.0.1 address.

                                     

                                    Think about it for a second. 

                                    All network traffic is routed by ip address.  The use of host names is a convenience, but the name must be mapped to an ip address before anything can be routed to it.

                                    The entire purpose of the hosts file is to map a name to an ip address.  So with your hosts file the way it is, where do you want 'localhost' to go? 

                                    1 2 3 4 Previous Next