Oracle 10g Express on Ubuntu Problems [sqlplus ORA-01034, ORA-27101]
666075Oct 20 2008 — edited Oct 23 2008Hi!
Trying to correctly install and configure 10g Express version on Ubuntu Linux Server 8.04 with no success. I am a Linux and Oracle noob and trying to install database as part of Project.net service.
I've been following Oracle Database Express Edition install guide for linux which I got from Oracle's website.
I installed deb packet with gdebi ...deb (and later reinstalled with dpkg -i ...deb) as described in the guide. Going "by the book" I ran /etc/init.d/oracle-xe configure and confirmed defaults. I set the password for SYS and SYSTEM account. Set DB to autostart. I also ran the /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh, and added this same line to .bashrc file. Then, still following install guide, I wanted to make DB available to remote clients and tried to connect to DB locally, using sqlplus command line. Here the problems start:
----
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 20 11:47:23 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter user-name: system
Enter password:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
----
I tried every combination of upper/lower case, sys and system account - can't connect. Been normal user, root or oracle user - doesn't work.
I searched this forum and google for answer, but none works for me. There were answers suggesting changing ORACLE_SID environment variable, logging on with sysdba account, which yields the following:
---
root@testsrv:/# sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 20 12:06:04 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect system/[passwd] as sysdba
ERROR:
ORA-01031: insufficient privileges
---
I would really want to get this done, so any help would be greatly appreciated. Please note I am very green in Linux and a complete noob in Oracle.
TNX!