This requires root access to the machine. One team member should be in charge of root commands.
root
using ssh
:
ssh -l root machine_name
useradd
, create your account with primary group arsdigit
and secondary group dba
useradd -g arsdigit -G dba -m username(see
man useradd
for more details about this step.)
passwd username
svrmgrl
Note: you must be in the dba
group to use svrmgrl
(this should have been accomplished in step 2.)
$ svrmgrl
Oracle Server Manager Release 3.1.5.0.0 - Production
(c) Copyright 1997, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production
SVRMGR> connect internal
Connected.
SVRMGR> select file_name from dba_data_files;
Example results:
/ora8/m01/app/oracle/oradata/ora8/system01.dbf
/ora8/m01/app/oracle/oradata/ora8/oemrep01.dbf
/ora8/m01/app/oracle/oradata/ora8/rbs01.dbf
/ora8/m01/app/oracle/oradata/ora8/temp01.dbf
/ora8/m01/app/oracle/oradata/ora8/users01.dbf
/ora8/m01/app/oracle/oradata/ora8/indx01.dbf
/ora8/m01/app/oracle/oradata/ora8/drsys01.dbf
/ora8/m02/oradata/ora8/jsc01.dbf
m0n
subdirectories in the above listing) separate from the Oracle system data files. In this example, we'll use /ora8/m02/oradata/ora8/
.
autoextend
. This allows the tablespace's storage capacity to grow as the size of the data grows.
SVRMGR> create tablespace service_name datafile '/ora8/m02/oradata/ora8/service_name01.dbf' size 50m autoextend on default storeage ( pctincrease 0);
database_password
with the appropriate password.)
SVRMGR> create user service_name identified by database_password default tablespace service_name
temporary tablespace temp quota unlimited on service_name;
SVRMGR> grant connect, resource, ctxapp to service_name;
To export: