Re: Trouble connecting to Linux Oracle from Windows

dbuckingham <member_at_dbfoums.com> wrote in news:1741534.1030421942_at_dbforums.com:

> Hi Daniel and Jason,
>
> Thanks for the replies. Looking at this, if I read the Linux/oracle
> documentation and what I can find on the net, it indicates that if
> this was the issue, then i shouldnt have been able to actually build
> the database in teh first place? However, being new to the whole
> Linux thing, I will not argue that point to much.
>
> As a result, I have re-read the documentation from Technet concerning
> this and noted that there was a way to update the kernel on the fly
> for SHMMAX: echo >/proc/sys/kernel/shmmax
>

There are a few other settings as well, and to make them permanent, you need to compile them into the kernel. That's outside the scope of this group, but look at /usr/include/linux/shm.h to set the variables. Check your distro's support docs to compile the kernel.

> Since my machine has 512MB RAM, I set this to be 0x10000000 (about
> 256Meg), then stoped and started the database and tried to connect
> again from the windows machine.
>
> I am still receiving the same error:
>
> SQL> connect m_lincs/m_lincs_at_bane
> ERROR:
> ORA-03113: end-of-file on communication channel
>
> However, I have noticed that if I use the internal user, I get a
> different error:
>
> SQL> connect internal/oracle_at_bane
> ERROR:
> ORA-24327: need explicit attach before authenticating a user
>
> Jason if I issue a ipcs it indicates that Oracle is taking up about
> 28 megs and has a value of 7 in the nattch column. not sure what all
> this means?
>

Oracle just has a single entry in ipcs? Here's mine right now. My init.ora settings are minimal, since this is on a small box, and it's only for reference and testing. This is a single instance, with no connections.

0x00000000 1062567944oracle    640       4194304   8
0x00000000 1062600713oracle    640       25165824  8
0x00000000 1062633482oracle    640       20971520  8
0x00000000 1062666251oracle    640       29360128  8
0xf5329a28 1062699020oracle    640       29360128  40

So I find it odd that you are only using 28megs, etc...

Try fixing the shared memory settings, compile the kernel, and once everything is back up, see if the problem still exists and report back.

-- 
Jason Baugher 
Virtual Adept Professional Consulting Services
1406 Adams Street, Quincy, IL 62301 - (217) 221-5406
jason@baugher.pike.il.us - http://baugher.pike.il.us/virtualadept