Oracle problem on Red Hat Linux 6.1
Author |
Message |
ddf_.. #1 / 21
|
 Oracle problem on Red Hat Linux 6.1
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. -- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.***.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
Yogesh Sharm #2 / 21
|
 Oracle problem on Red Hat Linux 6.1
check the http://yogeshsharma.tripod.com oracle 8i installation instruction. You reuire to setup oracle environment as described there including LD_LIBRARY etc. for all the users who are going to use oracle. Quote:
> 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. > -- > David Fitzjarrell > Oracle Certified DBA > Sent via Deja.com http://www.deja.com/ > Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #3 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote: > check the http://yogeshsharma.tripod.com oracle 8i installation > instruction. You reuire to setup oracle environment as described there > including LD_LIBRARY etc. for all the users who are going to use oracle.
> > 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. > > -- > > David Fitzjarrell > > Oracle Certified DBA > > Sent via Deja.com http://www.deja.com/ > > Before you buy.
Let me clarify this a bit further -- the environment for all users accessing the Oracle instance is the same, whether it be for the 'oracle' user or any other UNIX login. The envirnoment is not the problem. Something else is causing this and I cannot discover what it is. So, has anyone else experienced this? Is there anyone who can shed some light on this issue? -- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
Dennis Edwar #4 / 21
|
 Oracle problem on Red Hat Linux 6.1
check $ORACLE_HOME/bin/oracle using "ls -l". Is the group execute bit set? It should be. And ownership should normally be "oracle:dba". Did you perhaps try something like tar'ing the directory tree back as oracle? Quote:
> 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. > -- > David Fitzjarrell > Oracle Certified DBA > Sent via Deja.com http://www.deja.com/ > Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #5 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote: > check $ORACLE_HOME/bin/oracle using "ls -l". Is the group execute bit set? > It should be. And ownership should normally be "oracle:dba".
The owner, group and permissions on the $ORACLE_HOME/bin/oracle file should be: -rwsr-xr-x oracle dba They are; if they weren't I would get an "ORACLE not available" error. I don't. This is an initial installation of Oracle on Linux. I have 12 years experience installing and administering Oracle on UNIX and I've not seen this problem before. I am seeing it now on Linux and I am not certain why. The environment is set for every user wanting to access the database so that is not an issue. Something else is happening, and I'd like to find out what. If anyone has had any experience with this error on Linux let me know what is happening and how to correct it. Quote: > Did you perhaps try something like tar'ing the directory tree back as > oracle?
No, and I wouldn't try that, either.
Quote: > > 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. > > -- > > David Fitzjarrell > > Oracle Certified DBA > > Sent via Deja.com http://www.deja.com/ > > Before you buy.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
Dennis Edwar #6 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote: > They are; if they weren't I would get an "ORACLE not available" error. > I don't. This is an initial installation of Oracle on Linux.
I think that it's a good working hypothesis that the problem is permissions-related. Things that come to mind are: 1) Setgid problem (already dismissed) 2) permissions on required files (libraries) 3) permissions on directories (x vs r especially) I suppose there's also a possibility that the env vars (like LD_LIBRARY_PATH) are set slightly differently for oracle and not-oracle; but I seem to remember you dismissed that idea as well. Just for reference, here's my permissions on the lib in question and the containing directory. Maybe it'll help - or ring a bell.
-rw-r--r-- 1 oracle dba 4847 Jun 14 1999 libskgxp8.so -rw-r--r-- 1 oracle dba 4847 Jun 10 1999 libskgxpd.so
drwxr-x--x 2 oracle dba 2048 Aug 19 1999 .
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
Dudley Iris #7 / 21
|
 Oracle problem on Red Hat Linux 6.1
This is a bit of a shot in the dark, but when you don't know what the problem is .... Redhat's default permisions on user directories protect them from access by other users. So if you used useradd to create the Oracle user and put the oracle distribution under that tree, then other users would not be able to get to the libraries even though the library and the lib directory all have the right permisions. Dudley Irish Ars Magna, Inc. Quote:
> > They are; if they weren't I would get an "ORACLE not available" error. > > I don't. This is an initial installation of Oracle on Linux. > I think that it's a good working hypothesis that the problem is > permissions-related. Things that come to mind are: > 1) Setgid problem (already dismissed) > 2) permissions on required files (libraries) > 3) permissions on directories (x vs r especially) > I suppose there's also a possibility that the env vars (like > LD_LIBRARY_PATH) are set slightly differently for oracle and not-oracle; but > I seem to remember you dismissed that idea as well. Just for reference, > here's my permissions on the lib in question and the containing directory. > Maybe it'll help - or ring a bell.
> -rw-r--r-- 1 oracle dba 4847 Jun 14 1999 libskgxp8.so > -rw-r--r-- 1 oracle dba 4847 Jun 10 1999 libskgxpd.so
> drwxr-x--x 2 oracle dba 2048 Aug 19 1999 .
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
bmt #8 / 21
|
 Oracle problem on Red Hat Linux 6.1
I managed to get Oracle8iR2 installed and running (on Redhat6.1) without any major problems. Will sit down and write up my notes into a howto in a few days. the hangup that caused me the most problems was setting swap file large enough to prevent the create database form{*filter*}... I used the howto for 8i (or original release) and that worked Ok, was at something like fwn.fortwayne.com, Quote:
> > check $ORACLE_HOME/bin/oracle using "ls -l". Is the group execute bit > set? > > It should be. And ownership should normally be "oracle:dba". > The owner, group and permissions on the $ORACLE_HOME/bin/oracle file > should be: > -rwsr-xr-x oracle dba > They are; if they weren't I would get an "ORACLE not available" error. > I don't. This is an initial installation of Oracle on Linux. I have 12 > years experience installing and administering Oracle on UNIX and I've > not seen this problem before. I am seeing it now on Linux and I am not > certain why. The environment is set for every user wanting to access > the database so that is not an issue. Something else is happening, and > I'd like to find out what. If anyone has had any experience with this > error on Linux let me know what is happening and how to correct it. > > Did you perhaps try something like tar'ing the directory tree back as > > oracle? > No, and I wouldn't try that, either.
> > > 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. > > > -- > > > David Fitzjarrell > > > Oracle Certified DBA > > > Sent via Deja.com http://www.***.com/ > > > Before you buy. > -- > David Fitzjarrell > Oracle Certified DBA > Sent via Deja.com http://www.***.com/ > Before you buy.
-- ===================================================================
University of Queensland, St Lucia, Brisbane, Australia. ===================================================================
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
St Erroneou #9 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote:
> 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
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #10 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote: > > They are; if they weren't I would get an "ORACLE not available" error. > > I don't. This is an initial installation of Oracle on Linux. > I think that it's a good working hypothesis that the problem is > permissions-related. Things that come to mind are: > 1) Setgid problem (already dismissed) > 2) permissions on required files (libraries) > 3) permissions on directories (x vs r especially) > I suppose there's also a possibility that the env vars (like > LD_LIBRARY_PATH) are set slightly differently for oracle and not-oracle; but > I seem to remember you dismissed that idea as well. Just for reference, > here's my permissions on the lib in question and the containing directory. > Maybe it'll help - or ring a bell.
> -rw-r--r-- 1 oracle dba 4847 Jun 14 1999 libskgxp8.so > -rw-r--r-- 1 oracle dba 4847 Jun 10 1999 libskgxpd.so
> drwxr-x--x 2 oracle dba 2048 Aug 19 1999 .
The directory and file permissions all match your listing. I am getting an 'unable to open transport' error -- any clues? -- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #11 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote: > > 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
I am getting an 'unable to open transport' error from nsopen. Any clues? I don't get this when I'm connected to the server as 'oracle'. -- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
David Pomphrey - DN #12 / 21
|
 Oracle problem on Red Hat Linux 6.1
Brings back !happy memories. I used to try to get Oracle to run on Redhat 6.1 but I stopped after I remembered that there's more to life than ......(you get the drift). Go with Sun Solaris (Intel) instead is my advice. David N. Pomphrey OCP [DBA] MCP [TCP/IP] B.Tech. Glasgow, Scotland. The Internet Engineering Task Force (IETF) : http://www.ietf.org/ 'Standards Track' RFCs : ftp://ftp.isi.edu/in-notes/std/std1.txt "The Internet Changes Everything" ====================================================================== Quote:
> > > They are; if they weren't I would get an "ORACLE not available" > error. > > > I don't. This is an initial installation of Oracle on Linux. > > I think that it's a good working hypothesis that the problem is > > permissions-related. Things that come to mind are: > > 1) Setgid problem (already dismissed) > > 2) permissions on required files (libraries) > > 3) permissions on directories (x vs r especially) > > I suppose there's also a possibility that the env vars (like > > LD_LIBRARY_PATH) are set slightly differently for oracle and > not-oracle; but > > I seem to remember you dismissed that idea as well. Just for > reference, > > here's my permissions on the lib in question and the containing > directory. > > Maybe it'll help - or ring a bell.
> > -rw-r--r-- 1 oracle dba 4847 Jun 14 1999 libskgxp8.so > > -rw-r--r-- 1 oracle dba 4847 Jun 10 1999 libskgxpd.so
> > drwxr-x--x 2 oracle dba 2048 Aug 19 1999 .
> The directory and file permissions all match your listing. I am getting > an 'unable to open transport' error -- any clues? > -- > David Fitzjarrell > Oracle Certified DBA > Sent via Deja.com http://www.deja.com/ > Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #13 / 21
|
 Oracle problem on Red Hat Linux 6.1
Quote:
> > > 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 > I am getting an 'unable to open transport' error from nsopen. Any > clues? I don't get this when I'm connected to the server as 'oracle'. > -- > David Fitzjarrell > Oracle Certified DBA > Sent via Deja.com http://www.deja.com/ > Before you buy.
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() = 15476 rt_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 XFSZ UNUSED], 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) --- rt_sigprocmask(SIG_BLOCK, [], NULL, 8) = 0 rt_sigprocmask(SIG_UNBLOCK, [], NULL, 8) = 0 sigreturn() = ? (mask now []) close(12) = 0 close(13) = 0 lseek(10, 10240, SEEK_SET) = 10240 read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10240 read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512 lseek(10, 8192, SEEK_SET) = 8192
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) = 10240 read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512 lseek(10, 3584, SEEK_SET) = 3584 read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 3584, SEEK_SET) = 3584 read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 3584, SEEK_SET) = 3584 read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., 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) = 10752 read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10240 read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 10240 read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., 512) = 512 lseek(10, 2048, SEEK_SET) = 2048 read(10, "\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., 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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 79872 read(10, "\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., 512) = 512 lseek(10, 79872, SEEK_SET) = 79872 read(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) = 85504 read(10,
... read more »
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #14 / 21
|
 Oracle problem on Red Hat Linux 6.1
***** Is there anyone who can shed some light on this? I cannot believe that no one else has experienced this before. *****
Quote:
> > > > 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 > > I am getting an 'unable to open transport' error from nsopen. Any > > clues? I don't get this when I'm connected to the server as 'oracle'. > > -- > > David Fitzjarrell > > Oracle Certified DBA > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > 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() = 15476 > rt_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 XFSZ > UNUSED], 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) --- > rt_sigprocmask(SIG_BLOCK, [], NULL, 8) = 0 > rt_sigprocmask(SIG_UNBLOCK, [], NULL, 8) = 0 > sigreturn() = ? (mask now []) > close(12) = 0 > close(13) = 0 > lseek(10, 10240, SEEK_SET) = 10240 > read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10240 > read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., > 512) = 512 > lseek(10, 8192, SEEK_SET) = 8192
> 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) = 10240 > read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., > 512) = 512 > lseek(10, 3584, SEEK_SET) = 3584 > read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 3584, SEEK_SET) = 3584 > read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 3584, SEEK_SET) = 3584 > read(10, "\21\0\254\0\0\0n\0\255\0\0\0\203\0\256\0\0\0\227\0\257"..., > 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) = 10752 > read(10, "!\0C\3\0\0\316\0D\3\0\0\326\0E\3\0\0\336\0F\3\0\0\360\0"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10240 > read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 10240 > read(10, "\"\0!\3\0\0\324\0\"\3\0\0\334\0#\3\0\0\345\0$\3\0\0\351"..., > 512) = 512 > lseek(10, 2048, SEEK_SET) = 2048 > read(10,
"\26\0\0\0\0\0\214\0d\0\0\0\251\0e\0\0\0\256\0f\0\0\0\267"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 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) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) = 512 > lseek(10, 79872, SEEK_SET) = 79872 > read(10,
"\21\0\344\22\0\0n\0\210\23\0\0\243\0\211\23\0\0\252\0\212"..., Quote: > 512) =
... read more »
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
 |
ddf_.. #15 / 21
|
 Oracle problem on Red Hat Linux 6.1
That is truly a nice thought, however the financial resources are not in place for such an ambitious undertaking; alas, I am saddled with Red Hat Linux 6.1 for the interim. The interesting thing about this is that the remote network connections work quite nicely; it is the local connections that fail to complete for Linux users other than 'oracle'. This truly has me baffled.
Quote:
> Brings back !happy memories. > I used to try to get Oracle to run on Redhat 6.1 but I stopped after I > remembered that there's more to life than ......(you get the drift). > Go with Sun Solaris (Intel) instead is my advice. > David N. Pomphrey OCP [DBA] MCP [TCP/IP] B.Tech. > Glasgow, Scotland. > The Internet Engineering Task Force (IETF) : http://www.ietf.org/ > 'Standards Track' RFCs : ftp://ftp.isi.edu/in-notes/std/std1.txt > "The Internet Changes Everything" > ======================================================================
> > > > They are; if they weren't I would get an "ORACLE not available" > > error. > > > > I don't. This is an initial installation of Oracle on Linux. > > > I think that it's a good working hypothesis that the problem is > > > permissions-related. Things that come to mind are: > > > 1) Setgid problem (already dismissed) > > > 2) permissions on required files (libraries) > > > 3) permissions on directories (x vs r especially) > > > I suppose there's also a possibility that the env vars (like > > > LD_LIBRARY_PATH) are set slightly differently for oracle and > > not-oracle; but > > > I seem to remember you dismissed that idea as well. Just for > > reference, > > > here's my permissions on the lib in question and the containing > > directory. > > > Maybe it'll help - or ring a bell.
> > > -rw-r--r-- 1 oracle dba 4847 Jun 14 1999 libskgxp8.so > > > -rw-r--r-- 1 oracle dba 4847 Jun 10 1999 libskgxpd.so
> > > drwxr-x--x 2 oracle dba 2048 Aug 19 1999 .
> > The directory and file permissions all match your listing. I am getting > > an 'unable to open transport' error -- any clues? > > -- > > David Fitzjarrell > > Oracle Certified DBA > > Sent via Deja.com http://www.deja.com/ > > Before you buy.
-- David Fitzjarrell Oracle Certified DBA Sent via Deja.com http://www.deja.com/ Before you buy.
|
Wed, 18 Jun 1902 08:00:00 GMT |
|
|
Page 1 of 2
|
[ 21 post ] |
|
Go to page:
[1]
[2] |
|