Database Reference
In-Depth Information
Manual Database Design: Step 2
Decide On Instance Identifier (SID)
This will be name of your database instance. It will be unique on
the machine running multiple Oracle instances. This is basically
you set in the Step 01 when you set the environment variable
ORACLE_SID.
Manual Database Design: Step 3
Select Authentication Method for DBA
Normal database users get authenticated by Oracle database only
but DBA or in other words administrators have two methods
through which they can get authenticated one is Operating
System and the other one is password file. For local or remote
database administration you can use either method but you need
a secure network connection for remote administration using
operating system authentication.
In operating system method you don't have to give password and
login to make a connection as SYSDBA. All you have to do is
make yourself member of OSDBA or SYSOPER operating
system group. For example when you tried to connect using
sqlplus to Oracle instance you didn't specify any login and
password, all you did was selected the option Connect as
SYSDBA.
Once someone sends a connection request to Oracle as SYSDBA
without login and password; Oracle contacts the operating
system under which Oracle is running to get the login and
password of the user submitted the request. Remember, to reach
to Oracle running on a server machine, first you logged-in to
server, so server already know who is currently logged in.
If you are system Administrator or you are member operating
system SYSOPER or SYSDBA then Oracle will let you connect
as DBA role which has the power to perform all kinds of DBA
tasks.
Search WWH ::
Custom Search