| Loose end questions about instance startup. [message #133925] |
Mon, 22 August 2005 15:44  |
Godfrey T. Degamo
Messages: 12
Registered: July 2005
|
Junior Member |
|
|
I am reading through Oracle 9i: Beginner's Guide. It's a decent enough book, but I had some questions about it. Here's a passage from the chapter entitled 'DBA 101':
startup open
==============
Before an Oracle 9i database can be accessed, it must first be started to get background processes running. As you have learned, these background processes serve many of your requests to the database.
To start an oracle 9i database, first connect to the database using the sysdba privilege. From there, you then issue the database startup open command.
[Illustrated example]
SQL> connect / as sysdba;
SQL> startup open test pfile=/[...]/init.ora;
ORACLE instance started
[...]
So my question is:
1. According to the passage, my "database" isn't up, but the book recommends I connect to it anyways. That sounds confusing, what is the real story?
2. How do you get to an SQL prompt as in the example?
3. When I type at my unix prompt:
connect '/ as sysdba'
I enter sqlplus with the following message:
connected to an idle instance
What does that message mean? Does it mean that there is no Oracle unix-process running at all? That when I type startup open test pfile=...., I will create the Oracle unix-processes?
4. I guess what I'm confused about is the loose interchange between instance and database? How are they related, and what are their differences in Oracle land?
thanks
[Updated on: Mon, 22 August 2005 15:53] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
