Albin Chandy
Albin Chandy

Reputation: 59

How to restart an oracle 11g database in windows 10 machine

Accidently killed the oracle 11g process via task manager. Sql plus login throws error ERROR: ORA-12560: TNS:protocol adapter error

Upvotes: 2

Views: 1877

Answers (1)

4dc0
4dc0

Reputation: 453

Log in with SQLPlus as sys using this command:

sqlplus / as sysdba

then shutdown the database using this command:

SHUTDOWN IMMEDIATE;

then startup the instance, mount the database, and open the database with this command:

STARTUP;

Upvotes: 2

Related Questions