RelationalDBDesign 




DB Creation   «Prev  Next»
Lesson 5 Starting Server Manager
Objective Start Server Manager and connect to a database.
Starting Server Manager
We have been through a lot of work just to figure out the command to start a program. You should now know the name for your Server Manager executable, so let us start it. If you are not running Oracle software, just make sure you know the executable name for the version that you will eventually be running.
If you are running Oracle, go ahead and issue the command.
If you are on Windows NT, you will need to open a command prompt window first.
The following example was done under NT using Oracle release 8.0.4:
C:\ORANT\BIN>svrmgr30
Oracle Server Manager Release 3.0.4.0.0 - Production
(c) Copyright 1998, Oracle Corporation.
All Rights Reserved.
Oracle8 Release 8.0.4.0.0 - Production
PL/SQL Release 8.0.4.0.0 - Production
SVRMGR>


Connecting to a database
After you start Server Manager, the next step is to connect to a database. You can do this by using the CONNECT command. The following example shows one way to connect to your default database. The internal keyword tells Server Manager that you want to connect as an administrative user.
Note: On Unix systems, you must be a member of the DBA group to connect as internal.
SVRMGR> connect internal
Connected.
Depending on choices that you made when you installed Oracle, you might be prompted for a password.
This is a special password known as the internal password.
The default for that password is “oracle,” but if you chose a different internal password when you installed Oracle, use that. If someone else created this database, and you do not know the internal password, then you should ask the person who created the database to help you connect to it.
Go ahead and try connecting to your default database.
There exists a GUI version of Server Manager, but we will not address the GUI version in this course.