Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Instance initialization and Login into Database

Nischal ManguJan 22 2011 — edited Jan 22 2011

Hello !!

I am a new DBA student and I am learning how to run the Oracle instance, mount the DB and open it. However, I am using the SQL*Plus and by default I have switched all the 'Automated' process to 'Manual' so that my PC doesn't get slower when I boot it everyday. Now, this is creating a problem when I boot my computer first thing in the morning and try to run the Instance. I do 'Run' the Database from the 'Services' and try to logon using the command:

sqlplus sys as sysdba

and feed the password. It still gives me a TNS error. Anyone have any idea how do I login into my database daily without any hassle? What are the commands to start the instance and get into the DB?

Thanks

Nischal