Skip to main content
G
gkemner1-Visitor
1-Visitor
July 11, 2013
Question

sqlplus login issue

  • July 11, 2013
  • 2 replies
  • 967 views
After installing a patch to my oracle 10g database I get the following error when trying to log into sqlplus

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Any ideas?

Thanks!

2 replies

R
rporzel-51-Visitor
1-Visitor
July 11, 2013
It seems like the Database is closed.

Login as sqlplus /nolog and then as sysdba to start the database.
R
rporzel-51-Visitor
1-Visitor
July 11, 2013
The full commands would look like below

sqlplus /nolog
connect sys/change_on_install as sysdba;
Connected to an idle instance

Startup;
Terms & ConditionsAccessibility statement