This discussion is archived
1 2 3 Previous Next 43 Replies Latest reply: May 8, 2013 9:07 AM by user12069648 Go to original post RSS
  • 15. Re: Oracle error ora-12545
    joseph619 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    joseph619 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Employee ACE
    Currently Being Moderated
    [ 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
    joseph619 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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
    joseph619 Newbie
    Currently Being Moderated
    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
    joseph619 Newbie
    Currently Being Moderated
    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
    joseph619 Newbie
    Currently Being Moderated
    HAPPY NEW YEAR 2013 !!!
  • 27. Re: Oracle error ora-12545
    joseph619 Newbie
    Currently Being Moderated
    Hello

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

    Any ideas ?
  • 28. Re: Oracle error ora-12545
    joseph619 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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' ...

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points