Links
• Home
• Oracle DBA Forum
Frequent Oracle Errors
•TNS:could not resolve the connect identifier specified
•Backtrace message unwound by exceptions
•invalid identifier
•PL/SQL compilation error
•internal error
•missing expression
•table or view does not exist
•end-of-file on communication channel
•TNS:listener unknown in connect descriptor
•insufficient privileges
•PL/SQL: numeric or value error string
•TNS:protocol adapter error
•ORACLE not available
•target host or object does not exist
•invalid number
•unable to allocate string bytes of shared memory
•resource busy and acquire with NOWAIT specified
•error occurred at recursive SQL level string
•ORACLE initialization or shutdown in progress
•archiver error. Connect internal only, until freed
•snapshot too old
•unable to extend temp segment by string in tablespace
•Credential retrieval failed
•missing or invalid option
•invalid username/password; logon denied
•unable to create INITIAL extent for segment
•out of process memory when trying to allocate string bytes
•shared memory realm does not exist
•cannot insert NULL
•TNS:unable to connect to destination
•remote database not found'>ora-02019
•exception encountered: core dump
•inconsistent datatypes
•no data found
•TNS:operation timed out
•PL/SQL: could not find program
•existing state of packages has been discarded
•maximum number of processes exceeded
•error signaled in parallel query server
•ORACLE instance terminated. Disconnection forced
•TNS:packet writer failure
•see ORA-12699
•missing right parenthesis
•name is already used by an existing object
•cannot identify/lock data file
•invalid file operation
•quoted string not properly terminated
ORA-01034: Oracle not available

ORA-01034: Oracle not available

2004-05-03       - By Reidy, Ron

Reply:     1     2     3     4     5     6     7  

Is your Oracle environment set up?  Is the database running?

--
Ron Reidy
Sr. DBA
Array BioPharma, Inc.


-- --Original Message-- --
From:   Miguel Albuquerque [mailto:mfoacs@(protected)]
Sent:   Mon 5/3/2004 4:07 AM
To:   suse-oracle@(protected)
Cc:  
Subject:   [suse-oracle] ORA-01034 (See ORA-01034.ora-code.com): ORACLE not available
Hi all,

Something is horribly wrong with Oracle services, i try to connect using
psqlplus system/paswd and i got

SQL*Plus: Release 8.1.7.0.0 - Production on Mon May 3 12:02:20 2004

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

ERROR:
ORA-01034 (See ORA-01034.ora-code.com): ORACLE not available
ORA-27101 (See ORA-27101.ora-code.com): shared memory realm does not exist
Linux Error: 2: No such file or directory


Enter user-name:

After 3 attempts the login is rejected...

i've digged around mailings archives and i've seen all kinds of answers
but none worked for me.

I've patched dbstart as described at
http://lists.suse.com/archive/suse-oracle/2000-Jul/0051.html, no
success...

Any ideas? help is much appreciated!

--
Macintosh for Productivity
Linux for Development
Palm for Mobility
Windows for Solitaire

   .-.                         e-SecureNet
   /v\      We Run SuSE        Project Manager

  // \\  *The LINUX Experts*   Miguel Albuquerque
 /(   )\                       77, rue de Carouge
  ^^-^^                        1205 - GE, SWITZERLAND
                               Mobile +41 79 543 1935
http://counter.li.org           Linux user #301007
mailto:mfoacs@(protected)     http://www.e-securenet.ch/
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting





This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting