on 08-25-2012 12:51 PM
Hello;
After rester of server during upgrade on preprocessing fase, I get errror when I try start oracle. Dispatch stope for SID and shoadow. I have OS wondows, oracle 11 and opgarde to 7.3:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:\Users\bw1adm>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 25 12:43:36 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 680665088 bytes
Fixed Size 2258192 bytes
Variable Size 348130032 bytes
Database Buffers 322961408 bytes
Redo Buffers 7315456 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4696
Session ID: 81 Serial number: 5
SQL> select * from emp;
ERROR:
ORA-03114: not connected to ORACLE
SQL> startup
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL>
from TOOLOUT.log:
TRACE-INFO: 33: [ dev trc,00000] ORA-01034: ORACLE not available 26 0.063079
TRACE-INFO: 34: ORA-27101: shared memory realm does not exist
TRACE-INFO: 35: [ dev trc,00000] server_detach(con=0,stale=1,srvhp=03B48F68) 19 0.063098
TRACE-INFO: 36: [ dev trc,00000] Server handle (con=0,svchp=03ACF408,srvhp=03B48F68) detached 520 0.063618
TRACE-INFO: 37: [ dev trc,00000] Free server handle 03B48F68 of con=0 18 0.063636
TRACE-INFO: 38: [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1034' 41 0.063677
TRACE-INFO: 39: [ dev trc,00000] set_ocica() -> SQL error code 1034 18 0.063695
TRACE-INFO: 40: [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1034) 13 0.063708
TRACE-INFO: 41: [ dev trc,00000] OCIErrorGet -> SQL error code: 1034 97 0.063805
TRACE-INFO: 42: [ dev trc,00000] ORA-01034: ORACLE not available 21 0.063826
TRACE-INFO: 43: ORA-27101: shared memory realm does not exist
TRACE-INFO: 44: [ dev trc,00000] SAPUSER error or connect error 99=DBSL_ERR_DB, oerr=1034. 22 0.063848
TRACE-INFO: 45: [ dev trc,00000] DbSlConnect(con=0) -> orc=0, 99=DBSL_ERR_DB 14 0.063862
TRACE-INFO: 46: [ dblink ,00000] ***LOG BY2=>sql error 1034 performing CON 60 0.063922
TRACE-INFO: 47: [ dblink ,00000] ***LOG BY0=>ORA-01034: ORACLE not available 20 0.063942
TRACE-INFO: 48: ORA-27101: shared memory realm does not exist
tp=>sapparam(1c): No Profile used.
tp=>sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
ERROR: Connect to BW1 failed (20120824162601, probably wrong environment).
SAPup> Process with PID 4376 terminated with status 232 at 20120824162601!
Any help for this problem. Any idea how can i check shared memory?
Thanks
Hi,
Can you look into Note 1734716 - ORA-01034: Oracle not available
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.