Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle problem on Red Hat Linux 6.1
In article <8iqugc$geu$1_at_nnrp1.deja.com>,
ddf_dba_at_my-deja.com wrote:
> In article <8ipqqt$en2$1_at_soap.pipex.net>,
> "St Erroneous" <ishamael_at_erroneous.demon.co.uk> wrote:
> > <ddf_dba_at_my-deja.com> wrote in message
news:8inq7o$5jk$1_at_nnrp1.deja.com...
> > > This is an interesting problem that I hope someone can help with.
As
> > > the 'oracle' system user I can invoke SQL*Plus and everything runs
as
> > > expected. However, when I connect to the system as any other user
and
> > > attempt to run SQL*Plus the following message is generated:
> > >
> > > oraclePROTIME: error in loading shared libraries: libskgxp8.so:
cannot
> > > open shared object file: No such file or directory
> > > ERROR: ORA-12547: TNS:lost contact
> > >
> > > I KNOW the file is there since, as I stated earlier, the 'oracle'
system
> > > user can invoke SQL*Plus and everything runs fine. As far as I
know
the
> > > file permissions are set correctly and, as evidenced by the
ability
of
> > > 'oracle' to use SQL*Plus everything must be in place. What is
causing
> > > this? Any insight would be most helpful.
> >
> > Try
> >
> > strace -o /tmp/sqlplus_trace.log sqlplus
> >
> > and check what's happening as the $ORACLE_HOME/lib libraries are
open()ed.
> >
> > -michael E
> >
> >
>
>
Here are the contents of the trace log from the 'nsopen' command. Any assistance will be greatly appreciated.
write(9, "nsopen: ", 8) = 8 write(9, "opening transport...\n", 21) = 21 brk(0x813f000) = 0x813f000 pipe([11, 12]) = 0 pipe([13, 14]) = 0 fork() = 15476rt_sigprocmask(SIG_BLOCK, [PIPE], NULL, 8) = 0 rt_sigaction(SIGPIPE, {0x40547460, ~[ILL ABRT BUS FPE SEGV XCPU XFSZ UNUSED], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0
rt_sigprocmask(SIG_UNBLOCK, [PIPE], NULL, 8) = 0 rt_sigprocmask(SIG_BLOCK, [CHLD], NULL, 8) = 0 rt_sigaction(SIGCHLD, {0x40547460, ~[ILL ABRT BUS FPE SEGV XCPU XFSZUNUSED], SA_RESTART|0x4000000}, {SIG_DFL}, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [CHLD], NULL, 8) = 0
close(11) = 0 close(14) = 0 read(13, "", 64) = 0--- SIGCHLD (Child exited) ---
sigreturn() = ? (mask now []) close(12) = 0 close(13) = 0 lseek(10, 10240, SEEK_SET) = 10240read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512
_llseek(9, 0, [2181], SEEK_CUR) = 0 write(9, "nserror: ", 9) = 9 write(9, "entry\n", 6) = 6 lseek(10, 10240, SEEK_SET) = 10240read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512
_llseek(9, 0, [2196], SEEK_CUR) = 0 write(9, "nserror: ", 9) = 9 write(9, "nsres: id=0, op=65, ns=12547, ns"..., 70) = 70 lseek(10, 10240, SEEK_SET) = 10240read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512
_llseek(9, 0, [2275], SEEK_CUR) = 0 write(9, "nsopen: ", 8) = 8 write(9, "unable to open transport\n", 25) = 25 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2308], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "entry\n", 6) = 6 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2321], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "1620 bytes at 0x813d820\n", 24) = 24 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2352], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "normal exit\n", 12) = 12 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2371], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "entry\n", 6) = 6 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2384], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "428 bytes at 0x813cd60\n", 23) = 23 lseek(10, 10752, SEEK_SET) = 10752read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512
_llseek(9, 0, [2414], SEEK_CUR) = 0 write(9, "nsmfr: ", 7) = 7 write(9, "normal exit\n", 12) = 12 lseek(10, 10240, SEEK_SET) = 10240read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512
_llseek(9, 0, [2433], SEEK_CUR) = 0 write(9, "nsopen: ", 8) = 8 write(9, "error exit\n", 11) = 11 lseek(10, 10240, SEEK_SET) = 10240read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512
_llseek(9, 0, [2452], SEEK_CUR) = 0 write(9, "nscall: ", 8) = 8 write(9, "error exit\n", 11) = 11 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2471], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " error from nscall\n", 19) = 19 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2499], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " nr err code: 0\n", 18) = 18 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2526], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " ns main err code: 12547\n", 27) = 27 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2562], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " ns (2) err code: 12560\n", 27) = 27 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2598], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " nt main err code: 517\n", 25) = 25 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2632], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " nt (2) err code: 32\n", 24) = 24 lseek(10, 79872, SEEK_SET) = 79872read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512
_llseek(9, 0, [2665], SEEK_CUR) = 0 write(9, "nioqper: ", 9) = 9 write(9, " nt OS err code: 0\n", 23) = 23 lseek(10, 85504, SEEK_SET) = 85504read(10, "\17\0s\24\0\0b\0t\24\0\0k\0u\24\0\0t\0x\24\0\0}\0y\24\0"..., 512) = 512
_llseek(9, 0, [2697], SEEK_CUR) = 0 write(9, "niqme: ", 7) = 7 write(9, "entry\n", 6) = 6 lseek(10, 85504, SEEK_SET) = 85504read(10, "\17\0s\24\0\0b\0t\24\0\0k\0u\24\0\0t\0x\24\0\0}\0y\24\0"..., 512) = 512
_llseek(9, 0, [2710], SEEK_CUR) = 0 write(9, "niqme: ", 7) = 7 write(9, " reporting ns (2) error: (12547)"..., 54) = 54 lseek(10, 85504, SEEK_SET) = 85504read(10, "\17\0s\24\0\0b\0t\24\0\0k\0u\24\0\0t\0x\24\0\0}\0y\24\0"..., 512) = 512
_llseek(9, 0, [2771], SEEK_CUR) = 0 write(9, "niqme: ", 7) = 7 write(9, "exit\n", 5) = 5 lseek(10, 13312, SEEK_SET) = 13312read(10, "\25\0\23\4\0\0\206\0\24\4\0\0\242\0\25\4\0\0\260\0\26\4"..., 512) = 512
_llseek(9, 0, [2783], SEEK_CUR) = 0 write(9, "nladget: ", 9) = 9 write(9, "entry\n", 6) = 6 lseek(10, 13312, SEEK_SET) = 13312read(10, "\25\0\23\4\0\0\206\0\24\4\0\0\242\0\25\4\0\0\260\0\26\4"..., 512) = 512
_llseek(9, 0, [2798], SEEK_CUR) = 0 write(9, "nladget: ", 9) = 9 write(9, "exit\n", 5) = 5 lseek(10, 13312, SEEK_SET) = 13312read(10, "\25\0\23\4\0\0\206\0\24\4\0\0\242\0\25\4\0\0\260\0\26\4"..., 512) = 512
_llseek(9, 0, [2812], SEEK_CUR) = 0 write(9, "nladtrm: ", 9) = 9 write(9, "entry\n", 6) = 6 lseek(10, 13312, SEEK_SET) = 13312read(10, "\25\0\23\4\0\0\206\0\24\4\0\0\242\0\25\4\0\0\260\0\26\4"..., 512) = 512
_llseek(9, 0, [2827], SEEK_CUR) = 0 write(9, "nladtrm: ", 9) = 9 write(9, "exit\n", 5) = 5 lseek(10, 82944, SEEK_SET) = 82944read(10, "\v\0\v\24\0\0J\0\24\24\0\0y\0\25\24\0\0\177\0\26\24\0\0"..., 512) = 512
_llseek(9, 0, [2841], SEEK_CUR) = 0 write(9, "niotns: ", 8) = 8write(9, "Couldn\'t connect, returning 1254"..., 34) = 34 open("/home/dfitzjarrell/sqlnet.log", O_WRONLY|O_APPEND|O_CREAT, 0666) = 11
fstat(11, {st_mode=S_IFREG|0664, st_size=248393, ...}) = 0 _llseek(11, 248393, [248393], SEEK_SET) = 0 fcntl(11, F_SETFD, FD_CLOEXEC) = 0 write(11, "\n\n******************************"..., 73) = 73 _llseek(11, 0, [248466], SEEK_CUR) = 0 write(11, "\nFatal NI connect error 12547, c"..., 311) = 311 _llseek(11, 0, [248777], SEEK_CUR) = 0gettimeofday({961586160, 212303}, NULL) = 0 write(11, "\n VERSION INFORMATION:\n\tTNS for"..., 150) = 150 _llseek(11, 0, [248927], SEEK_CUR) = 0 write(11, " Time: 21-JUN-00 06:16:00\n", 27) = 27 _llseek(11, 0, [248954], SEEK_CUR) = 0 write(11, " Tracing to file: /usr/local/or"..., 88) = 88
_llseek(11, 0, [249042], SEEK_CUR) = 0 write(11, " Tns error struct:\n", 20) = 20 _llseek(11, 0, [249062], SEEK_CUR) = 0 write(11, " nr err code: 0\n", 19) = 19 _llseek(11, 0, [249081], SEEK_CUR) = 0 write(11, " ns main err code: 12547\n", 28) = 28 _llseek(11, 0, [249109], SEEK_CUR) = 0open("/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/network/mesg/tns us.msb", O_RDONLY) = 12
fcntl(12, F_SETFD, FD_CLOEXEC) = 0 lseek(12, 0, SEEK_SET) = 0read(12, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(12, 512, SEEK_SET) = 512read(12, "\2331\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
write(11, " ", 4) = 4 _llseek(11, 0, [249113], SEEK_CUR) = 0 write(11, "TNS-12547: TNS:lost contact\n", 28) = 28 _llseek(11, 0, [249141], SEEK_CUR) = 0 write(11, " ns secondary err code: 12560"..., 33) = 33 _llseek(11, 0, [249174], SEEK_CUR) = 0 write(11, " nt main err code: 517\n", 26) = 26 _llseek(11, 0, [249200], SEEK_CUR) = 0 lseek(12, 14848, SEEK_SET) = 14848read(12, "\16\0\1\2\0\0\\\0\2\2\0\0x\0\3\2\0\0\243\0\4\2\0\0\336"..., 512) = 512
write(11, " ", 4) = 4 _llseek(11, 0, [249204], SEEK_CUR) = 0 write(11, "TNS-00517: Lost contact\n", 24) = 24 _llseek(11, 0, [249228], SEEK_CUR) = 0 write(11, " nt secondary err code: 32\n", 30) = 30 _llseek(11, 0, [249258], SEEK_CUR) = 0 lseek(10, 11264, SEEK_SET) = 11264read(10, "!\0d\3\0\0\316\0e\3\0\0\332\0f\3\0\0\347\0g\3\0\0\357\0"..., 512) = 512
_llseek(9, 0, [2883], SEEK_CUR) = 0 write(9, "nsbfrfl: ", 9) = 9 write(9, "entry\n", 6) = 6 lseek(10, 11264, SEEK_SET) = 11264read(10, "!\0d\3\0\0\316\0e\3\0\0\332\0f\3\0\0\347\0g\3\0\0\357\0"..., 512) = 512
_llseek(9, 0, [2898], SEEK_CUR) = 0 write(9, "nsbfrfl: ", 9) = 9 write(9, "normal exit\n", 12) = 12 lseek(10, 12800, SEEK_SET) = 12800read(10, "\f\0\7\4\0\0P\0\10\4\0\0\225\0\t\4\0\0\256\0\n\4\0\0\277"..., 512) = 512
_llseek(9, 0, [2919], SEEK_CUR) = 0 write(9, "snlsodx_destroy: ", 17) = 17 write(9, "entry\n", 6) = 6 lseek(10, 12800, SEEK_SET) = 12800read(10, "\f\0\7\4\0\0P\0\10\4\0\0\225\0\t\4\0\0\256\0\n\4\0\0\277"..., 512) = 512
_llseek(9, 0, [2942], SEEK_CUR) = 0 write(9, "snlsodx_destroy: ", 17) = 17 write(9, "exit\n", 5) = 5 lseek(10, 83968, SEEK_SET) = 83968read(10, "\f\0*\24\0\0P\0+\24\0\0\201\0002\24\0\0\240\0003\24\0\0"..., 512) = 512
_llseek(9, 0, [2964], SEEK_CUR) = 0 write(9, "nigtrm: ", 8) = 8 write(9, "Count in the NI global area is n"..., 37) = 37 lseek(10, 83968, SEEK_SET) = 83968read(10, "\f\0*\24\0\0P\0+\24\0\0\201\0002\24\0\0\240\0003\24\0\0"..., 512) = 512
_llseek(9, 0, [3009], SEEK_CUR) = 0 write(9, "nigtrm: ", 8) = 8write(9, "Count in the NL global area is n"..., 37) = 37 open("/usr/local/oracle/8i/u01/app/oracle/product/8.1.5/rdbms/mesg/oraus .msb", O_RDONLY) = 13
fcntl(13, F_SETFD, FD_CLOEXEC) = 0 lseek(13, 0, SEEK_SET) = 0read(13, "\25\23\"\1\23\3\t\t\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 256) = 256
lseek(13, 512, SEEK_SET) = 512read(13, "1\35z[\16x\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
close(13) = 0 lseek(5, 512, SEEK_SET) = 512read(5, "\335\2\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 512) = 512
lseek(5, 1024, SEEK_SET) = 1024read(5, "\23\0\'\0005\0M\0]\0l\0\177\0\216\0\240\0\350\0\371\0\2"..., 512) = 512
lseek(5, 6656, SEEK_SET) = 6656read(5, "\16\0\351\0\0\0\\\0\352\0\0\0\226\0\353\0\0\0\246\0\354"..., 512) = 512
write(1, "ERROR:\n", 7) = 7 write(1, "ORA-12547: TNS:lost contact\n", 28) = 28 write(1, "\n\n", 2) = 2
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.Received on Thu Jun 22 2000 - 00:00:00 CDT