Guys,

I've got a problem with Oracle 10g on a Solaris 10 x86. I was able to
install and create a database successfully. I saw a lot of Oracle
processes running, but after the server restart I can find only one
Oracle-related process running:

/u01/app/oracle/product/10.1.0/db_1/bin/ocssd.bin

More than that, when I'm trying to connect to it, I receive the
following:

oracle@downtown:~>sqlplus

SQL*Plus: Release 10.1.0.3.0 - Production on Wed Dec 15 16:28:09 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Intel SVR4 UNIX Error: 2: No such file or directory

But I remember it worked fine just after install.

I also have got such messages in the dmesg output:

Dec 8 18:00:41 downtown root: [ID 702911 user.alert] (Oracle CSSD will
be run out of init)

And also I receive some error messages on console.

The oracle user has the following environment variables set:

ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE

ORACLE_SID=oradb
export ORACLE_SID

ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export ORACLE_HOME

TNS_ADMIN=$ORACLE_HOME/network/admin
export TNS_ADMIN
Can you please advise me how I can make it run?

Thank you.

Your problem can be traced to 'installing before reading documentation'

PLEASE read the DBA guide at http://docs.oracle.com and specifically
lookup the STARTUP command in SQLPLUS.

One variant that will work for a while is

sqlplus /NOLOG
connect / as sysdba
startup
exit

Note that the above probably requires you to have started you listener
using

lsnrctl start

by default.

After a while, (in part because you do not have enough background to
protect yourself and the database/instance from your mistakes, such as
an abrupt shutdown) you may need to do an optional restore and a
recovery, and the above commands and parameters may need to change.

As another variant, check out the "emctl start dbconsole" in the docco.

Thanks, I already figured this, however it worked fine without "lsnrctl
start".

I'll look at the docs, thank you for pointing me at.