Re: ORACLE not available

From the installation and users guide...

Table 4-1 Access Permissions on Oracle Directories and Files Directories/Files Permissions Comments All database, redo log, and control files (extensions for these files are typically.dbf,.log, and.ctl)
 640

rw-r----
 To maintain discretionary access to data, all databases, redo logs, and control files must be readable only by the oracle account and OSDBA group.

$ORACLE_HOME/bin/
 751

rwxr-x--x
 Must be writable by the oracle software owner, and executable by all users.

The oracle executable, and the following network executables: cmctl,cmadmin,cmgw, names, namesctl, tnsping, osslogin, trcroute,trcasst, onrsd,oemevent, oratclsh,dbsnmp, lsnrctl,and tnslsnr.  6751

rws-r-s--x

 The 6 sets the setuid bit so the executables run as the oracle user and dba group, regardless of who executes them.

All other executables.
 751

rwxr-x--x
 Must be writable by the oracle software owner, and executable by all users.

$ORACLE_HOME/lib/
 755

rwxr-xr-x
 The directory is readable, writable, and executable by the owner, readable and executable by all other users.

All files under $ORACLE_HOME/
lib/
 644

rw-r--r--
 The files are readable and writable by the owner, read-only for all other users.

$ORACLE_HOME/rdbms/log
 751

rwxr-x--x
 Restricts access to log files to the oracle account and OSDBA group.

Product subdirectories such as $ORACLE_HOME/sqlplus or $ORACLE_HOME/rdbms  751

rwxr-x--x
 Restricts access to log files to the oracle account and OSDBA group.

Files in $ORACLE_HOME/
sqlplus or $ORACLE_HOME/
rdbms
 644

rw-r--r--
 The files are readable and writable by the owner, read-only for all other users.

$ORACLE_HOME/
network/trace
 777 or 730

rwxrwxrwx

or

rwx-wx---
 777 allows broad access to view and create trace files during development. Use 730 in a production environment to ensure that only members of the OSDBA group have access to trace files.

All files under product admin directories, like $ORACLE_HOME/ rdbms/admin and $ORACLE_HOME/sqlplus/admin  644

-rw-r--r--
 SQL scripts should typically be run as the SYS

Hth,

Sybrand Bakker, Oracle DBA

<softdesigner_at_my-deja.com> wrote in message news:8pbbis$agl$1_at_nnrp1.deja.com...
> I am new to Oracle. I just installed Oracle 8i on a Solaris 2.6 machine
> as user oracle. The database is up and running. If I login in as
> oracle, I can run "sqlplus system/manager". However, running the same
> command as different user I get the ERROR: ORA-01034: ORACLE not
> available message, even though the database is running at that moment
> (tnsping returns Ok). I can run a simple java program connecting to the
> database via jdbc thin driver successfully. It seems to be a permission
> problem when it comes to using sqlplus. Because of this issue the
> initiation of WebLogic EJB server fails. Any suggestion on how to
> tackle this problem is greatly appreciated. Thanks :)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 08 2000 - 15:08:10 CDT