Skip to Main Content

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!

Few question with sqlplus and db startup

_JC_Oct 5 2016 — edited Oct 6 2016

Hi guys,

I have recently started with learning oracle DBA. I am still newbie here.

So i have just some questions which i couldn't find answer on google(actually i got confused).

When i just type sqlplus on terminal

It ask for user name and password. If i give this user name and password then I start an instance and db is not yet up. then give startup command and its mount db,open db.

How does sqlplus come to know which db to startup here, as i didn't gave any db name? is there something like default database?

How i can open up other database from same sqlplus window if they are there.

Also please let me know if i can shutdown a specific db from same sqlplus window.

Can i connect to other db using connect command, if i am already logged into one db. ?

One out of topic question.: DBA use sqlplus command prompt window to mange their task or is there any browser based application that they use to manage with their work.

Many thanks for answering them

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 3 2016
Added on Oct 5 2016
13 comments
705 views