Re: import/export

Hi,

On 17 Okt., 10:28, sybrandb <sybra..._at_gmail.com> wrote:

> Yet again you are short on information.
> Apparently you are running Oracle 10g on Solaris 10.
> As far as I know Oracle doesn't support Solaris 10 containers.

Its a 64bit Suse-Linux.

> A permission problem on TNS level either has to do with firewall
> settings, or (assuming you did set ORACLE_SID, you didn't tell us),

yeah its set(on both machines) to the same name i use in a jdbc connection string, when i connect to the database from a sql client. ORACLE_HOME also set.

> with insufficient privileges on the Unix shared memory segment which
> implements the SGA.
> The ipcs command would tell you whether the privileges are correct.

source database:
T ID KEY MODE OWNER GROUP Message Queues:
Shared Memory:
m 51 0xb12d8d7c --rw-r----- oracle oinstall Semaphores:
s 11 0x325bb8ac --ra-r----- oracle oinstall

target database:
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

0x00000000 345309184  oracle    640        4194304    27
0x73031e79 132382721  root      666        8840       0
0x00000000 345341954  oracle    640        33554432   27
0x73032128 135528451  root      666        8840       0
0x73036e2a 131301380  root      666        8840       0
0x00000000 345374725  oracle    640        33554432   27
0x00000000 345407494  oracle    640        33554432   27
0x00000000 345440263  oracle    640        33554432   27
0xf351bdd8 345473032  oracle    640        29376512   27

------ Semaphore Arrays --------
key        semid      owner      perms      nsems
0x02d0230c 98304      oracle    640        154

------ Message Queues --------
key        msqid      owner      perms      used-bytes   messages
0x00001f58 0          root       600        0            0

> Only Oracle should have privileges and the Oracle executable should
> have the setuid bit set.

Hm some root entries, how do i correct this?

source:
-rwsr-s--x 1 oracle oinstall 133250280 Mar 5 2007 oracle

target:
-rwsr-s--x 1 oracle oinstall 211031130 Nov 15 2006 oracle Received on Fri Oct 17 2008 - 05:20:33 CDT