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 the Community Ranking System, a fun gamification element of the PTC Community. 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;
Announcements

Top Tags