Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i and Solaris 8 issues

Re: Oracle 8i and Solaris 8 issues

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/10
Message-ID: <957940271.21326.0.pluto.d4ee154e@news.demon.nl>#1/1

The protection of your Oracle files are incorrect. Generally speaking they should be 4755, with the suid bit set for the Oracle executable and the listener. This should be documented in the install guide.

Hth,

Sybrand Bakker, Oracle DBA

Craig Despres <csdespres_at_home.com> schreef in berichtnieuws VP5S4.109994$U4.877716_at_news1.rdc1.az.home.com...
> I will start off with a very simple question: Has anyone successfully
> loaded Oracle 8.1.x on a Sun Ultra server running Solaris 8 in 64 bit
 mode?
>
> I have installed the software and I am coming up with a very strange
 error.
>
> I am able to start the instance with a DBA UNIX and Oracle account using
> svrmgrl, and connect to the database with the same DBA UNIX and Oracle
> account using either svrmgrl and sqlplus, and select from tables, views,
> etc.
>
> When I attempt to connect to the database using another UNIX account,
 using
> sqlplus or svrmgrl, I get an "ORA-01034 - Oracle not available" error
> message.
>
> When I am logged in to the box as my unix DBA account, I can use sqlplus
 to
> log into the database as a non-dba account and everything is fine. I have
> attached output of the issue below:
>
> Any help would be appreciated.
>
> Craig Despres
> ***********************************************
> Logged in as oracle UNIX account at this time
> ***********************************************
> (OrAcleAdmin_at_develop):/opt/oracle/8.1.5/bin->svrmgrl
>
> Oracle Server Manager Release 3.1.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Release 8.1.5.0.0 - Production
> With the Java option
> PL/SQL Release 8.1.5.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 78224784 bytes
> Fixed Size 64912 bytes
> Variable Size 10870784 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 180224 bytes
> Database mounted.
> Database opened.
> SVRMGR> select name from v$database;
> NAME
> ---------
> VTPDEV
> 1 row selected.
> SVRMGR> exit
> Server Manager complete.
>
> (OrAcleAdmin_at_develop):/opt/oracle/8.1.5/bin->sqlplus
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 9 21:42:09 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter user-name: csdespre
> Enter password:
>
> Connected to:
> Oracle8i Release 8.1.5.0.0 - Production
> With the Java option
> PL/SQL Release 8.1.5.0.0 - Production
>
> SQL> exit
> Disconnected from Oracle8i Release 8.1.5.0.0 - Production
> With the Java option
> PL/SQL Release 8.1.5.0.0 - Production
>
> (OrAcleAdmin_at_develop):/opt/oracle/8.1.5/bin->
>
> ***********************************************
> Logged in as regular UNIX account at this time
> ***********************************************
> (OrAcleAdmin_at_develop):/opt/oracle/8.1.5/bin->su - csdespre
> Password:
> Sun Microsystems Inc. SunOS 5.8 Generic February 2000
> (Craig_at_develop):/home/csdespre->sqlplus
>
> SQL*Plus: Release 8.1.5.0.0 - Production on Tue May 9 21:40:49 2000
>
> (c) Copyright 1999 Oracle Corporation. All rights reserved.
>
> Enter user-name: csdespre
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
>
>
> Enter user-name: system
> Enter password:
> ERROR:
> ORA-01034: ORACLE not available
>
>
> Enter user-name:
>
>
>
>
Received on Wed May 10 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US