Oracle problem on Red Hat Linux 6.1 
Author Message
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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"...,

- Show quoted text -

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"...,

- Show quoted text -

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"...,

- Show quoted text -

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"...,

- Show quoted text -

Quote:
> 512) =

...

read more »



Wed, 18 Jun 1902 08:00:00 GMT
 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
 
 [ 21 post ]  Go to page: [1] [2]

 Relevant Pages 

1. Problem - Oracle 8.0.5 with Red Hat Linux 6.1

2. Creating Oracle accounts: usernames and passwords under Red Hat Linux 6.1

3. Install Problem Oracle 8i - Red Hat 6.1

4. Oracle 8i EE install problem on Red Hat 6.1

5. Startup of 8i instance on Red Hat Linux 6.1

6. Sqlplus and the 8.1.5.0.2 patch on Red Hat Linux 6.1

7. Installing ICONNECT on LINUX RED HAT 6.1

8. Ingres 2.0 on Red Hat Linux 6.1

9. Stability: Red Hat Linux 6.1/Ingres II/Alpha DS20

10. Oracle 8i/ red hat 6.1 or slackware 7

11. Install of Oracle 805 on red hat 6.1

12. Oracle 8.0.5 on Red Hat 6.1


 
Powered by phpBB® Forum Software