timo nentwig

Hi!

As you'll notice I'm new to oracel I set up 9i r2 on a linux machine but
the attempt to connect to a database (java, jdbc) ends up with the
following:

java.sql.SQLException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:407)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.j ava:259)
at oracle.jdbc.driver.OracleConnection.<init>(OracleC onnection.java:346)
at
oracle.jdbc.driver.OracleDriver.getConnectionInsta nce(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:314)
at java.sql.DriverManager.getConnection(DriverManager .java:512)
at java.sql.DriverManager.getConnection(DriverManager .java:140)
at
com.onseven.dbvis.wrapper.DriverManagerImpl.getCon nection(DriverManagerImpl.java:40)
at com.onseven.dbvis.sql.Database.doConnect(Unknown Source)
at com.onseven.dbvis.sql.Database.access$000(Unknown Source)
at com.onseven.dbvis.sql.Database$ConnectionCommand.e xecute(Unknown Source)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)

Well, I'm not quite sure whether oracle is up and running at all, at least
bin/dbstart did not solve the problem either.

Can somebody help? :-)

Thanks a lot
Timo

sybrand bakker

Oracle is definitely not running. Please look into the alert log as to
the cause of error. The alert log is in the directory pointed to by
the background_dump_dest init.ora parameter.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

timo nentwig

Yes. I noticed that I have to set autostart in /etc/oratab (?!). Afte doing
so dbstart complains about missing the DBs init.ora file. Well, why is this
file not created by the GUI assistant? So, I temporarily took the default
init.ora...

Ok, next thing to find out is how to create db users...

Thanks!
Timo