If you can get the listener up, then use the "set" command to set the oracle_sid variable to your database sid....
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
Once the sid is set, use the commands:
Sqlplus /nolog Connect / as sysdba Startup
Dig Deeper on Oracle error messages
Related Q&A from Mike Ault
I am trying to remove carriage returns at the end of clob fields in SQL*Plus. This just nulls out the field in the table. What do I need to change to...continue reading
How to find the definition or structure of a dropped table? I know the table's name but I don't know the columns and datatypes. It no longer exists.continue reading
I'm having a problem with dynamic SQL, specifically getting my incoming parameter into the SQL statement. I am using Oracle 9i and this procedure ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.