Badal wrote:at this point then do as below
I am new to oracle administration. I instlled 11gR2 on windows 7 64 bit. It was working fine. Then I applied the patch DB 184.108.40.206 Patch 10: 10432045 . I can nolong connect. I tried a lot and ead lot of blogs. But now thoroughly confused! I am giving soem info that you may need. Please help!!!!
* All oracle related services are set to automatic start up and are all up
When tried sqlplus i got
ORA-12514: TNS:listener does not currently know of service requested in connect
As sysdba, I got this:
C:\windows\system32>sqlplus / as sysdba
SQL*Plus: Release 220.127.116.11.0 Production on Sat Mar 3 11:08:44 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
Badal wrote:so now the DB is up & online; so ENJOY!
Thanks for the quick response. Here is teh result
ORACLE instance started.
Total System Global Area 5110898688 bytes
Fixed Size 2184592 bytes
Variable Size 2701134448 bytes
Database Buffers 2399141888 bytes
Redo Buffers 8437760 bytes