Re: Problems with Oracle and Linux ?

I can only help with the shutdown question. Are you doing a SHUTDOWN IMMEDIATE or just a SHUTDOWN? My instructors for Oracle advised that if I did a plain SHUTDOWN, it may never complete, that it is better to do a SHUTDOWN IMMEDIATE. I hope this helps.

Doug

Tor Arne Rein wrote:

> Hi,
>
> First, I am new to Oracle so it may be something I did terribly wrong in
> my setup, but anyway here are my problems:
>
> I have successfully? installed Oracle 8.1.6.1 R2 on my linux box running
> RedHat 6.2. The box has 256 MB ram, and the kernel is configured to
> comply with the SHM settings recommended in the Oracle docs.
>
> I have set up a normal user that I have created some tables with (from
> sqlplus) and can successfully connect from both java (with the oracle
> JDBC thin driver) and from NT running Embarcadero DBArtisan with SQL Net
> client drivers for NT.
>
> The first problem is that when I from the NT box is inserting rows in a
> table I have created, the java application does not see the new rows
> that I added from NT, the same also when I try to connect with sqlplus.
> (I log in as the same user each time, so I assume it's in the same
> tablespace?)
>
> The second problem is: sometimes when I delete rows from a table, either
> from NT or sqlplus, it hangs, I can still select from an other sqlplus
> window, but no update or inserts.
>
> The third problem is that I cannot shutdown the database, it hangs with
> this message every time i run my shutdown scrips:
>
> --------------------------------------------
> Shutting Oracle8i:
> Oracle Server Manager Release 3.1.6.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
> With the Partitioning option
> JServer Release 8.1.6.0.0 - Production
>
> SVRMGR> Connected.
> SVRMGR>
> ----------------------------------------------
>
> When I try to connect with sqlplus after a while i get an
>
> ORA-01090: shutdown in progress - connection is not permitted
>
> error message.
>
> So, since I am new to Oracle I hope someone could give me some hints
> about what to do about this problems.
>
> Where should I start looking for errors, I can't find any file similar
> to Sybases errorlog file. Is there anything like that for Oracle ?
>
> I'am happy to supply more info if someone would like that.
>
> Any help is greatly appreciated.
>
> Tor Arne Rein
Received on Sat Aug 05 2000 - 00:00:00 CDT