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

Community Tip - Learn all about PTC Community Badges. Engage with PTC and see how many you can earn! X

Translate the entire conversation x

sqlplus login issue

gkemner
7-Bedrock

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;
Announcements

Top Tags