1 2 3 Previous Next 43 Replies Latest reply: May 8, 2013 11:07 AM by user12069648 Go to original post RSS
      • 15. Re: Oracle error ora-12545
        858318
        This just doesn't add up. Ok, from one single session:
        tnsping jdevm
        sqlplus <username>/<pswd>@jdevm
        And make sure your password does NOT have a '@' in it.
        copy and paste entire session
        [oracle@SRVJDEENT admin]$ tnsping jdevm

        TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 31-DEC-2012 21:40:47

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

        Used parameter files:
        /u01/app/oracle/product/11ovm/client_1/network/admin/sqlnet.ora


        Used TNSNAMES adapter to resolve the alias
        Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SRVJDEDBS)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = jdevm)))
        OK (10 msec)
        [oracle@SRVJDEENT admin]$ sqlplus jde/jde@jdevm

        SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 31 21:41:09 2012

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

        [oracle@SRVJDEENT admin]$
        • 16. Re: Oracle error ora-12545
          sb92075
          Joseph wrote:
          [oracle@SRVJDEENT admin]$ sqlplus jde/jde@jdevm

          SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 31 21:41:09 2012

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

          [oracle@SRVJDEENT admin]$
          does listener log file show anything for the connect attempt above?

          consider packet sniffing (using Ethereal or WireShark) to see what actually happens on the network
          • 17. Re: Oracle error ora-12545
            Mark Williams-Oracle
            Hi,

            Pardon me for jumping into a running thread... just a thought that in addition to the advice, etc. from Ed and the "left coaster" (aka SB), it might be worthwhile getting an strace of the sqlplus session.

            Something like:
            strace -f -tt -o strace.out sqlplus jde/jde@jdevm
            No guarantees, but might reveal something of interest.

            Regards,

            Mark
            • 18. Re: Oracle error ora-12545
              EdStevens
              Mark Williams wrote:
              Hi,

              Pardon me for jumping into a running thread... just a thought that in addition to the advice, etc. from Ed and the "left coaster" (aka SB), it might be worthwhile getting an strace of the sqlplus session.

              Something like:
              strace -f -tt -o strace.out sqlplus jde/jde@jdevm
              No guarantees, but might reveal something of interest.

              Regards,

              Mark
              I agree. It's looking very bizarre that sqlplus seems to be exiting with no feedback at all. I'm afraid I'm out of ideas at that point.
              • 19. Re: Oracle error ora-12545
                858318
                strace -f -tt -o strace.out sqlplus jde/jde@jdevm
                [oracle@SRVJDEENT admin]$ strace -f -tt -o strace.out sqlplus jde/jde@jdevm
                [ Process PID=20618 runs in 32 bit mode. ]

                SQL*Plus: Release 11.2.0.1.0 Production on Mon Dec 31 22:06:30 2012

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

                [oracle@SRVJDEENT admin]$

                I do not know how to manage those logs
                You should tell me what is next

                or i should execute this command where the DB is ?
                sb92075
                does listener log file show anything for the connect attempt above?
                where can i find listener log ?
                Can you also give quick small tutorial install config for ethereal or wireshark ?
                I dont use these tools
                • 20. Re: Oracle error ora-12545
                  sb92075
                  Joseph wrote:

                  where can i find listener log ?
                  on the DB Server system issue the following OS command

                  lsnrctl status

                  one of the output line show the complete pathname to the listener log file
                  • 21. Re: Oracle error ora-12545
                    Mark Williams-Oracle
                    [ Process PID=20618 runs in 32 bit mode. ]

                    It seems you are running a 32-bit version of sqlplus on, perhaps, a 64-bit linux install - is that correct?

                    Have you examined the content of the strace output file?
                    • 22. Re: Oracle error ora-12545
                      858318
                      log_63.xml
                      <msg time='2012-12-29T09:14:51.003+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:14:51 * service_update * jdevm * 0
                      </txt>
                      </msg>
                      <msg time='2012-12-29T09:15:21.004+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:15:21 * service_update * jdevm * 0
                      </txt>
                      </msg>
                      <msg time='2012-12-29T09:15:35.255+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:15:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=37520)) * establish * jdevm * 0
                      </txt>
                      </msg>
                      <msg time='2012-12-29T09:15:35.937+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:15:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=37521)) * establish * jdevm * 0
                      </txt>
                      </msg>
                      <msg time='2012-12-29T09:15:48.178+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:15:48 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=37525)) * establish * jdevm * 0
                      </txt>
                      </msg>
                      <msg time='2012-12-29T09:15:51.006+01:00' org_id='oracle' comp_id='tnslsnr'
                      type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                      host_addr='192.168.0.191'>
                      <txt>29-DEC-2012 09:15:51 * service_update * jdevm * 0
                      </txt>
                      </msg>
                      just part of the log file from /u01/app/oracle/diag/tnslsnr/SRVJDEDBS/listener/alert
                      log.xml 1.6mb
                      log_63.xml 10mb
                      in this dir /u01/app/oracle/diag/tnslsnr/SRVJDEDBS/listener/trace
                      listener.log 302mb
                      Mon Dec 31 22:25:33 2012
                      31-DEC-2012 22:25:33 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=2390)) * establish * jdevm * 0
                      31-DEC-2012 22:25:33 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=2391)) * establish * jdevm * 0
                      31-DEC-2012 22:25:34 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=2392)) * establish * jdevm * 0
                      31-DEC-2012 22:25:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=2393)) * establish * jdevm * 0
                      31-DEC-2012 22:25:36 * service_update * jdevm * 0
                      Mon Dec 31 22:25:48 2012
                      31-DEC-2012 22:25:48 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=2398)) * establish * jdevm * 0
                      Mon Dec 31 22:28:49 2012
                      31-DEC-2012 22:28:49 * service_update * jdevm * 0
                      Mon Dec 31 22:30:35 2012
                      31-DEC-2012 22:30:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=13847)) * establish * jdevm * 0
                      31-DEC-2012 22:30:36 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=13848)) * establish * jdevm * 0
                      Mon Dec 31 22:30:48 2012
                      31-DEC-2012 22:30:48 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=13855)) * establish * jdevm * 0
                      Mon Dec 31 22:32:10 2012
                      31-DEC-2012 22:32:10 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=jdevm)) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=13880)) * establish * jdevm * 0
                      31-DEC-2012 22:32:10 * service_update * jdevm * 0
                      Mon Dec 31 22:32:38 2012
                      31-DEC-2012 22:32:38 * service_update * jdevm * 0
                      Mon Dec 31 22:33:08 2012
                      31-DEC-2012 22:33:08 * service_update * jdevm * 0
                      Mon Dec 31 22:33:38 2012
                      31-DEC-2012 22:33:38 * service_update * jdevm * 0
                      Mon Dec 31 22:34:08 2012
                      31-DEC-2012 22:34:08 * service_update * jdevm * 0
                      Mon Dec 31 22:34:38 2012
                      31-DEC-2012 22:34:38 * service_update * jdevm * 0
                      Mon Dec 31 22:34:54 2012
                      31-DEC-2012 22:34:54 * service_update * jdevm * 0
                      Mon Dec 31 22:35:35 2012
                      31-DEC-2012 22:35:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=60453)) * establish * jdevm * 0
                      31-DEC-2012 22:35:36 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=60454)) * establish * jdevm * 0
                      31-DEC-2012 22:35:39 * service_update * jdevm * 0
                      Mon Dec 31 22:35:48 2012
                      31-DEC-2012 22:35:48 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=60461)) * establish * jdevm * 0
                      Mon Dec 31 22:37:17 2012
                      31-DEC-2012 22:37:17 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=60485)) * establish * jdevm * 0
                      • 23. Re: Oracle error ora-12545
                        sb92075
                        tail -f log.xml

                        or

                        tail -f listener.log

                        in one terminal window then do as below from a different terminal window

                        sqlplus jde/jde@jdevm

                        does either of the two log file show the connection attempt from sqlplus?
                        • 24. Re: Oracle error ora-12545
                          858318
                          It seems you are running a 32-bit version of sqlplus on, perhaps, a 64-bit linux install - is that correct?
                          yes it is correct
                          Have you examined the content of the strace output file?
                          where is this file?
                          I do a search 'find' but no result
                          • 25. Re: Oracle error ora-12545
                            858318
                            tail -f log.xml (SRVJDEDBS - DB)
                            host_addr='192.168.0.191'>
                            <txt>01-JAN-2013 00:55:34 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12209*)) * establish * jdevm * 0
                            </txt>
                            </msg>
                            <msg time='2013-01-01T00:55:35.588+01:00' org_id='oracle' comp_id='tnslsnr'
                            type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                            host_addr='192.168.0.191'>
                            <txt>01-JAN-2013 00:55:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12210*)) * establish * jdevm * 0
                            </txt>
                            </msg>
                            <msg time='2013-01-01T00:55:47.859+01:00' org_id='oracle' comp_id='tnslsnr'
                            type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                            host_addr='192.168.0.191'>
                            <txt>01-JAN-2013 00:55:47 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12213*)) * establish * jdevm * 0
                            </txt>
                            </msg>
                            <msg time='2013-01-01T00:57:48.779+01:00' org_id='oracle' comp_id='tnslsnr'
                            type='UNKNOWN' level='16' host_id='SRVJDEDBS'
                            host_addr='192.168.0.191'>
                            <txt>01-JAN-2013 00:57:48 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jdevm)(CID=(PROGRAM=sqlplus)(HOST=SRVJDEENT)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.192)(*PORT=42793*)) * establish * jdevm * 0
                            </txt>
                            </msg>
                            tail -f listener.log (SRVJDEDBS - DB)
                            ST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(PORT=19721)) * establish * jdevm * 0
                            01-JAN-2013 00:52:34 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=19722*)) * establish * jdevm * 0
                            01-JAN-2013 00:52:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=19723*)) * establish * jdevm * 0
                            Tue Jan 01 00:55:34 2013
                            01-JAN-2013 00:55:34 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12209*)) * establish * jdevm * 0
                            01-JAN-2013 00:55:35 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12210*)) * establish * jdevm * 0
                            Tue Jan 01 00:55:47 2013
                            01-JAN-2013 00:55:47 * (CONNECT_DATA=(SID=jdevm)(CID=(PROGRAM=perl@SRVJDEDBS)(HOST=SRVJDEDBS)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.191)(*PORT=12213*)) * establish * jdevm * 0
                            Tue Jan 01 00:57:48 2013
                            01-JAN-2013 00:57:48 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=jdevm)(CID=(PROGRAM=sqlplus)(HOST=SRVJDEENT)(USER=oracle))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.192)(*PORT=42793*)) * establish * jdevm * 0
                            Tue Jan 01 00:59:00 2013
                            01-JAN-2013 00:59:00 * service_update * jdevm * 0
                            01-JAN-2013 00:59:09 * service_update * jdevm * 0
                            and in a third terminal (SRVJDEENT - Client)
                            [oracle@SRVJDEENT ~]$ sqlplus jde/jde@jdevm

                            SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 1 00:57:28 2013

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

                            [oracle@SRVJDEENT ~]$

                            does either of the two log file show the connection attempt from sqlplus?
                            The two log file show connection attempt from sqlplus


                            why value of PORT change every time ?
                            • 26. Re: Oracle error ora-12545
                              858318
                              HAPPY NEW YEAR 2013 !!!
                              • 27. Re: Oracle error ora-12545
                                858318
                                Hello

                                sb92075 and Mark Williams I have answered to your questions !!!

                                Any ideas ?
                                • 28. Re: Oracle error ora-12545
                                  858318
                                  I found the file 'strace.out' in /u01/app/oracle/product/11ovm/client_1/network/admin
                                  Here is a snippet

                                  20618 22:06:30.188651 execve("/u01/app/oracle/product/11ovm/client_1/bin/sqlplus", ["sqlplus", "jde/jde@jdevm"], [* 26 vars */]) = 0
                                  20618 22:06:30.190957 brk(0) = 0x8622000
                                  20618 22:06:30.191391 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xfffffffff7f56000
                                  20618 22:06:30.191720 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
                                  20618 22:06:30.192144 open("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
                                  20618 22:06:30.192464 stat64("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/sse2", 0xffa47fcc) = -1 ENOENT (No such file or directory)
                                  20618 22:06:30.192769 open("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
                                  20618 22:06:30.193065 stat64("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686", 0xffa47fcc) = -1 ENOENT (No such file or directory)
                                  • 29. Re: Oracle error ora-12545
                                    EdStevens
                                    Joseph wrote:
                                    I found the file 'strace.out' in /u01/app/oracle/product/11ovm/client_1/network/admin
                                    Here is a snippet

                                    20618 22:06:30.188651 execve("/u01/app/oracle/product/11ovm/client_1/bin/sqlplus", ["sqlplus", "jde/jde@jdevm"], [* 26 vars */]) = 0
                                    20618 22:06:30.190957 brk(0) = 0x8622000
                                    20618 22:06:30.191391 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xfffffffff7f56000
                                    20618 22:06:30.191720 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory)
                                    20618 22:06:30.192144 open("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/sse2/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
                                    20618 22:06:30.192464 stat64("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/sse2", 0xffa47fcc) = -1 ENOENT (No such file or directory)
                                    20618 22:06:30.192769 open("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686/libsqlplus.so", O_RDONLY) = -1 ENOENT (No such file or directory)
                                    20618 22:06:30.193065 stat64("/u01/app/oracle/product/11ovm/client_1/lib/tls/i686", 0xffa47fcc) = -1 ENOENT (No such file or directory)
                                    That's a lot of (No such file or directory) messages.

                                    Just sayin' ...