974422 wrote:What changed?
For some time everything worked fine den suddenly it stopped working.
When i try to connect using command line interface i get error:How?
C:\Users>sqlplus test/test SQL*Plus: Release 126.96.36.199.0 Production on L÷ Dec 1 22:17:40 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Process ID: 0 Session ID: 0 Serial number: 0 Enter user-name: ^C C:\Users>sqlplus / as sysdba SQL*Plus: Release 188.8.131.52.0 Production on L÷ Dec 1 22:18:02 2012 Copyright (c) 1982, 2010, 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 523108352 bytes Fixed Size 1384672 bytes Variable Size 356519712 bytes Database Buffers 159383552 bytes Redo Buffers 5820416 bytes Database mounted. Database opened. SQL>
Also, If i go to services and restart OracleServiceXE i can connect for for 10-15 secs. but after dat same thing happens. Cant connect again. :(Connect how? Via sqlplus or SQL Developer?