Problems with Oracle and Linux ?

From: Tor Arne Rein <rein_at_colibria.com>
Date: 2000/08/05
Message-ID: <398C24C2.369BC6F9@colibria.com>#1/1

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

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