RE: Oracle 10g R2

From: Jason Arneil <Jason_at_nominet.org.uk>
Date: Wed, 28 Nov 2007 10:41:39 +0000
Message-ID: <OF204FB90A.72A17E58-ON802573A1.0039E815-802573A1.003AC636@nominet.org.uk>

oracle-l-bounce_at_freelists.org wrote on 27/11/2007 17:37:30:

> This is a reply to my own mail. After i added the server name and
> ip address to the hosts file....... it works. Not sure why. Can
> Jason explain? :)
> Lyall

Check out metalink Note:5486074.8. Looks like this is a bug that is fixed in 10.2.0.4 and 11.1, basically when oracle cannot determine what is the name of the server it is trying to run on, it barfs.

Running strace:

13502 uname({sys="Linux", node="testdb1", ...}) = 0

13502 open("/etc/hosts", O_RDONLY)      = 15
13502 fcntl(15, F_GETFD)                = 0
13502 fcntl(15, F_SETFD, FD_CLOEXEC)    = 0

13502 fstat(15, {st_mode=S_IFREG|0644, st_size=263, ...}) = 0 13502 mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0x2a9757a000
13502 read(15, "# Do not remove the following li"..., 4096) = 263

13502 read(15, "", 4096)                = 0
13502 close(15)                         = 0
13502 munmap(0x2a9757a000, 4096)        = 0

13502 socket(PF_INET, SOCK_DGRAM, IPPROTO_IP) = 15 13502 connect(15, {sa_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("113.148.209.170")}, 28) = 0

13502 fcntl(15, F_GETFL)                = 0x2 (flags O_RDWR)

13502 fcntl(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0 13502 gettimeofday({1196244002, 415644}, NULL) = 0 13502 poll([{fd=15, events=POLLOUT, revents=POLLOUT}], 1, 0) = 1 13502 sendto(15, "\257\316\1\0\0\1\0\0\0\0\0\0\7testdb1\0\0\1\0\1", 25, 0, NULL, 0) = 25
13502 poll([{fd=15, events=POLLIN, revents=POLLIN}], 1, 5000) = 1 13502 ioctl(15, FIONREAD, [100]) = 0 13502 recvfrom(15,
"\257\316\201\203\0\1\0\0\0\1\0\0\7testdb1\0\0\1\0\1\0\0\6\0\1\0\0"..., 1024, 0, {sa_family=AF_INET, sin_port=htons(53), sin_addr=inet_addr("113.148.209.170")}, [16]) = 100

13502 close(15)                         = 0
13502 times(NULL)                       = 1084124408
13502 gettimeofday({1196244002, 416328}, NULL) = 0
13502 times(NULL)                       = 1084124408
13502 write(5, "*** 2007-11-28 10:00:02.416", 27) = 27
13502 write(5, "\n", 1)                 = 1
13502 times(NULL)                       = 1084124408

13502 write(5, "ksedmp: internal or fatal error", 31) = 31

shows that oracle is trying both /etc/hosts and then running a dns query, so I guess fixing either is good!

jason.

Dr. Jason Arneil
DBA
Nominet UK
http://jarneil.wordpress.com

>
> --
> Over 2 Million Holiday Gift Ideas - Take a Look!
> mail.com Shopping

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 28 2007 - 04:41:39 CST