oracle-l-bounce@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l