| View previous topic :: View next topic |
| Author |
Message |
Janax
Apprentice
Joined: 17 Aug 2004
Posts: 162
Location: Iowa
|
 Posted: Fri Aug 27, 2004 3:04 pm Post subject: Oracle 10g 'tnsping' works in Debian 64 but not in Gentoo 64 |
 |
|
Hi all,
I've been wondering about something for some time and can't come up with a logical answer. I initially used my old favorite MEPIS (like usual) to get Debian installed on my eMachines m6809 and have been using that as a chroot environment (and working ATI 3-D acceleration). Shortly after that I started experimenting with the 64-bit side, trying both Gentoo and Debian.
I prefer Gentoo's implementation so far just because I found it easier(!) to get things like flash, xine, etc. to work using the emulation libraries. However, in trying to get "Tora" (awesome app!) to work without chroot-ing, I've been troubleshooting the Oracle 10g client install. Naturally the first thing you do is try a 'tnsping', right? Here are the results:
Gentoo (64-bit):
| Code: |
gweber@oculus [9:34] ~
:) $ ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0xffffe000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /lib32/libdl.so.2 (0x5632f000)
libm.so.6 => /lib32/libm.so.6 (0x56332000)
libpthread.so.0 => /lib32/libpthread.so.0 (0x56354000)
libnsl.so.1 => /lib32/libnsl.so.1 (0x563a7000)
libc.so.6 => /lib32/libc.so.6 (0x563bc000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
gweber@oculus [9:34] ~
:) $ tnsping nbtest01
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 27-AUG-2004 09:35:18
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
gweber@oculus [9:46] ~
:) $ uname -a
Linux oculus 2.6.7-gentoo-r13 #1 Wed Aug 11 12:43:16 CDT 2004 x86_64 Mobile AMDAthlon(tm) 64 Processor 3200+ AuthenticAMD GNU/Linux
|
Debian (64-bit):
| Code: |
gweber@oculus:~$ ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0x00000000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /emul/ia32-linux/lib/libdl.so.2 (0x56326000)
libm.so.6 => /emul/ia32-linux/lib/libm.so.6 (0x56329000)
libpthread.so.0 => /emul/ia32-linux/lib/libpthread.so.0 (0x5634b000)
libnsl.so.1 => /emul/ia32-linux/lib/libnsl.so.1 (0x5639c000)
libc.so.6 => /emul/ia32-linux/lib/libc.so.6 (0x563b1000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
gweber@oculus:~$ tnsping nbtest01
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 27-AUG-2004 09:30
:10
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oratest1
.mcld.net)(PORT = 1521)) (CONNECT_DATA = (SID = NBTEST01)))
OK (0 msec)
gweber@oculus:~$ uname -a
Linux oculus 2.6.8.1-oc1.0 #1 Mon Aug 16 11:08:10 CDT 2004 x86_64 GNU/Linux
|
The only difference I really see is that the linux-gate.so.1 => (0x00000000) line resolves to 0x0 in Debian-64, the same way that it does in the chroot-ed 32-bit environment (chroot done from Gentoo-64).
| Code: |
root@oculus:~# chroot /mnt/deb32
root@oculus32:/# ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0x00000000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /lib/tls/libdl.so.2 (0x5632c000)
libm.so.6 => /lib/tls/libm.so.6 (0x5632f000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x56352000)
libnsl.so.1 => /lib/tls/libnsl.so.1 (0x56361000)
libc.so.6 => /lib/tls/libc.so.6 (0x56376000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
|
Googling for linux-gate.so.1 seems to indicate that it is a virtual library that points to some kernel stuff. I know that the Debian-64 is now on 2.6.8.1, but it was using 2.6.7 and still worked the same way. I have the "32-bit emulation" enabled in both (all 3) kernel configs.
Does anyone know why this could be? I'm not running an Oracle server on my laptop and I'm getting close to not having to chroot for anything else now that I got javaws to work. I'd appreciate any thoughts...
Thanks,
Janax |
|
| Back to top |
|
 |
graadz
n00b
Joined: 12 Aug 2002
Posts: 55
Location: Enschede, Netherlands
|
| Posted: Sun Nov 21, 2004 9:45 am Post subject: Re: Oracle 10g 'tnsping' works in Debian 64 but not in Gento |
|
|
You may want to check your tnsnames.ora and sqlnet.ora on correct service names and correct protocols:
oracle@boracle $ oerr tns 3505
03505, 00000, "Failed to resolve name"
// *Cause: The service name you provided could not be found in TNSNAMES.ORA,
// an Oracle Names server, or a native naming service.
// *Action: Verify that you entered the service name correctly. You may need
// to ensure that the name was entered correctly into the network
// configuration.
So, check either with netca or your favourite editor whether your sqlnet.ora and tnsnames.ora contain the correct (same as on your deb machine?) info for your DB instance.
The files should be located in the $ORACLE_HOME/network/admin directory.
G.
| Janax wrote: | Hi all,
I've been wondering about something for some time and can't come up with a logical answer. I initially used my old favorite MEPIS (like usual) to get Debian installed on my eMachines m6809 and have been using that as a chroot environment (and working ATI 3-D acceleration). Shortly after that I started experimenting with the 64-bit side, trying both Gentoo and Debian.
I prefer Gentoo's implementation so far just because I found it easier(!) to get things like flash, xine, etc. to work using the emulation libraries. However, in trying to get "Tora" (awesome app!) to work without chroot-ing, I've been troubleshooting the Oracle 10g client install. Naturally the first thing you do is try a 'tnsping', right? Here are the results:
Gentoo (64-bit):
| Code: |
gweber@oculus [9:34] ~
:) $ ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0xffffe000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /lib32/libdl.so.2 (0x5632f000)
libm.so.6 => /lib32/libm.so.6 (0x56332000)
libpthread.so.0 => /lib32/libpthread.so.0 (0x56354000)
libnsl.so.1 => /lib32/libnsl.so.1 (0x563a7000)
libc.so.6 => /lib32/libc.so.6 (0x563bc000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
gweber@oculus [9:34] ~
:) $ tnsping nbtest01
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 27-AUG-2004 09:35:18
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Message 3511 not found; No message file for product=network, facility=TNSTNS-03505: Message 3505 not found; No message file for product=network, facility=TNS
gweber@oculus [9:46] ~
:) $ uname -a
Linux oculus 2.6.7-gentoo-r13 #1 Wed Aug 11 12:43:16 CDT 2004 x86_64 Mobile AMDAthlon(tm) 64 Processor 3200+ AuthenticAMD GNU/Linux
|
Debian (64-bit):
| Code: |
gweber@oculus:~$ ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0x00000000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /emul/ia32-linux/lib/libdl.so.2 (0x56326000)
libm.so.6 => /emul/ia32-linux/lib/libm.so.6 (0x56329000)
libpthread.so.0 => /emul/ia32-linux/lib/libpthread.so.0 (0x5634b000)
libnsl.so.1 => /emul/ia32-linux/lib/libnsl.so.1 (0x5639c000)
libc.so.6 => /emul/ia32-linux/lib/libc.so.6 (0x563b1000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
gweber@oculus:~$ tnsping nbtest01
TNS Ping Utility for Linux: Version 10.1.0.2.0 - Production on 27-AUG-2004 09:30
:10
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oratest1
.mcld.net)(PORT = 1521)) (CONNECT_DATA = (SID = NBTEST01)))
OK (0 msec)
gweber@oculus:~$ uname -a
Linux oculus 2.6.8.1-oc1.0 #1 Mon Aug 16 11:08:10 CDT 2004 x86_64 GNU/Linux
|
The only difference I really see is that the linux-gate.so.1 => (0x00000000) line resolves to 0x0 in Debian-64, the same way that it does in the chroot-ed 32-bit environment (chroot done from Gentoo-64).
| Code: |
root@oculus:~# chroot /mnt/deb32
root@oculus32:/# ldd /u01/oracle/bin/tnsping
linux-gate.so.1 => (0x00000000)
libclntsh.so.10.1 => /u01/oracle/lib/libclntsh.so.10.1 (0x5556d000)
libnnz10.so => /u01/oracle/lib/libnnz10.so (0x560e5000)
libdl.so.2 => /lib/tls/libdl.so.2 (0x5632c000)
libm.so.6 => /lib/tls/libm.so.6 (0x5632f000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x56352000)
libnsl.so.1 => /lib/tls/libnsl.so.1 (0x56361000)
libc.so.6 => /lib/tls/libc.so.6 (0x56376000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)
|
Googling for linux-gate.so.1 seems to indicate that it is a virtual library that points to some kernel stuff. I know that the Debian-64 is now on 2.6.8.1, but it was using 2.6.7 and still worked the same way. I have the "32-bit emulation" enabled in both (all 3) kernel configs.
Does anyone know why this could be? I'm not running an Oracle server on my laptop and I'm getting close to not having to chroot for anything else now that I got javaws to work. I'd appreciate any thoughts...
Thanks,
Janax |
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
Gentoo on AMD64
