cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

sqlplus login issue

gkemner
1-Newbie

sqlplus login issue

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 2

It seems like the Database is closed.

Login as sqlplus /nolog and then as sysdba to start the database.

The full commands would look like below

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

Startup;
Top Tags