Oracle 8i and Solaris 8 issues

From: Craig Despres <csdespres_at_home.com>
Date: 2000/05/10
Message-ID: <VP5S4.109994$U4.877716_at_news1.rdc1.az.home.com>#1/1

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 CEST