ORA-01034: Oracle not available 2004-05-03 - By Rui Miguel Borges
Set the ORACLE_SID
|-- --Original Message-- --
|From: Miguel Albuquerque [mailto:mfoacs@(protected)]
|Sent: segunda-feira, 3 de Maio de 2004 13:41
|To: Reidy, Ron
|Cc: suse-oracle@(protected)
|Subject: RE: [suse-oracle] ORA-01034 (See ORA-01034.ora-code.com): ORACLE not available
|
|
|yes it's all set up and database is running...
|
|
|rcoracle status
|
|###############################################################
|##############
|# Begin of O R A C L E status
|section #
|###############################################################
|##############
|
|
|Kernel Parameters
|Shared memory: SHMMAX= 3294967296 SHMMNI= 4096 SHMALL=
|2097152 Semaphore values: SEMMSL, SEMMNS, SEMOPM, SEMMNI:
|1250 32000 100 256
|
|Database-Instances
|Instance ora8 is up \(autostart: Y\)
|
|TNS-Listener: up
|
|Web-Server (Apache httpd): down (0 processes)
|
|Process list for user oracle:
| PID TTY STAT TIME COMMAND
| 2119 ? S 0:00 /bin/sh /usr/X11R6/bin/kde
| 2135 ? S 0:02 /opt/gnome/bin/medusa-idled
| 2158 ? S 0:00 kdeinit: Running...
| 2161 ? S 0:00 kdeinit: dcopserver --nosid
| 2166 ? S 0:00 kdeinit: klauncher
| 2169 ? S 0:00 kdeinit: kded
| 2178 ? S 0:00 kdeinit: klaptopdaemon
| 2185 ? S 0:01 /opt/kde3/bin/artsd -F 10 -S 4096 -s 5 -m
|artsmessage -l 3 -f
| 2190 ? S 0:00 kdeinit: knotify
| 2191 ? S 0:00 kwrapper ksmserver
| 2193 ? S 0:00 kdeinit: ksmserver
| 2194 ? S 0:01 kdeinit: kwin -session
|117f000002000108308604000000202480000_1083579769_277100
| 2196 ? S 0:00 kdeinit: kwrited
| 2198 ? S 0:01 kdeinit: kdesktop
| 2201 ? S 0:02 kdeinit: kicker
| 2202 ? S 0:00 kdeinit: kio_file file
|/tmp/ksocket-oracle/klauncher9pnWSa.slave-socket
|/tmp/ksocket-oracle/kdesktopdojdAb.slave-socket
| 2207 ? S 0:00 kdeinit: klipper
| 2211 ? S 0:00 kgpg
| 2213 ? S 0:00 susewatcher -caption SuSE Update Checker
|-icon kinternet.png -miniicon kinternet.png --quiet
| 2222 ? S 0:00 kdeinit: kmix -session
|117f000002000108308605000000202480009_1083579769_248545
| 2223 ? S 0:00 kdeinit: konqueror --preload
| 2227 ? S 0:00 kalarmd --login
| 2230 ? S 0:08 kdeinit: konsole
| 2231 pts/1 S 0:00 /bin/bash
| 3554 pts/3 S 0:00 -bash
| 3854 pts/4 S 0:00 /bin/bash
| 5494 ? S 0:00 /opt/kde3/bin/kdesud
| 6125 ? S 0:00 ora_pmon_ora8
| 6127 ? S 0:00 ora_dbw0_ora8
| 6129 ? S 0:00 ora_lgwr_ora8
| 6131 ? S 0:00 ora_ckpt_ora8
| 6133 ? S 0:00 ora_smon_ora8
| 6135 ? S 0:00 ora_reco_ora8
| 6137 ? S 0:00 ora_snp0_ora8
| 6139 ? S 0:00 ora_snp1_ora8
| 6141 ? S 0:00 ora_snp2_ora8
| 6143 ? S 0:00 ora_snp3_ora8
| 6145 ? S 0:00 ora_s000_ora8
| 6147 ? S 0:00 ora_d000_ora8
| 6149 ? S 0:00 ora_d001_ora8
| 6409 ? S 0:00 /opt/oracle/product/8.1.7/bin/tnslsnr
|LISTENER -inherit
| 6430 ? S 0:00 dbsnmp
| 6433 ? S 0:00 dbsnmp
| 6437 ? S 0:00 oracleora8
|(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
| 6456 ? S 0:00 /opt/oracle/product/8.1.7/bin/cmadmin cman
| 6458 ? S 0:00 oracleora8
|(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
| 6460 ? S 0:00 /opt/oracle/product/8.1.7/bin/cmgw
| 6461 ? S 0:00 /opt/oracle/product/8.1.7/bin/cmadmin cman
| 6462 ? S 0:00 /opt/oracle/product/8.1.7/bin/cmadmin cman
| 6602 pts/4 S 0:00 svrmgrl
| 6603 ? S 0:00 oracleora8
|(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
|
|###############################################################
|##############
|# End of O R A C L E
|section #
|###############################################################
|##############
|
|
|I've fixed but i don't understand why.
|
|I've done :
|
|oracle@(protected):~>svrmgrl
|SVRMGR>connect internal as sysoper
|Password:
|Connected.
|SVRMGR>startup force
|<<some text come here, total system global area etc etc>>
|Database mounted. Database opened.
|
|and now i can connect...
|
|I've restarted the database twice, it works now. But i just
|don't understand what happend and why! drive me nuts! Besides
|this command overwrite your SGA with a new copy, and i would
|like to avoid it in the future....
|
|Any ideas?
|
|
|On Mon, 2004-05-03 at 13:28, Reidy, Ron wrote:
|> 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.
|--
|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
|
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
