944149 wrote:post tail end (last 200 or so lines) of the alert log file for this instance
C:\Users\ASHISH>sqlplus / as sysdba
SQL*Plus: Release 18.104.22.168.0 Production on Tue Jul 3 23:12:57 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Sunny kichloo wrote:
Login into sqlplus as SYS user and startup the database
sqlplus sys/<password> as sysdba SQL>startup
If you don't understand why that worked, you probably should not be giving advice.
C:\>sqlplus sys/thisissurelynotmypassword as sysdba SQL*Plus: Release 22.214.171.124.0 Production on Tue Jul 3 11:03:12 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 126.96.36.199.0 - Production SQL>
944149 wrote:SQL> STARTUP
ORACLE instance started.
Total System Global Area 1071333376 bytes
Fixed Size 1375792 bytes
Variable Size 612368848 bytes
Database Buffers 452984832 bytes
Redo Buffers 4603904 bytes
ORA-03113: end-of-file on communication channel
Process ID: 5148
Session ID: 191 Serial number: 3
here path :C:\app\ASHISH\product\11.2.0\dbhome_2\bin
can you tell me how to set variable.