############################################################################# # Begin of O R A C L E status section # #############################################################################
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
