Re: Questions on being DBA of Oracle V6
Date: 7 Jan 1995 13:26:29 GMT
Message-ID: <3em4q5$73d_at_cpccux0.cphk.hk>
Sze Shun Sum (alan_at_cs.ust.hk) wrote:
: 1. How to display the existing databases in Oracle/sqlplus/sqldba ??
: (like the command "sp_helpdb" in Sybase)
What do you mean by existing? In file system or running? For both cases,
there are no offical method. But you can check the file 'oratab' or
'tnsname.ora' in '/etc' or '/var/opt/oracle' for existing database on
file system(given that the dba update those file). For the later, i think you
need to check the process in OS level, like solaris, you can use 'ps -ef |
grep ora_pmon' to find out all running database.
: 2. How to create a new database??
i. create a config file for your new database. the file usually call
'$ORACLE_HOME/dbs/initXXX.ora' where XXX is the database name.
ii. set the environment varable ORACLE_SID to the new database name.
iii. enter sqldba.
iv. type 'startup nomount'
and 'connect internal'
v. type 'create database XXX
datafile '/usr/local/oracle/dbs/systemXXX.dbf' size 10M; ' (just for example)
vi. create other tablespace you need to have. vii. run some script in $ORACLE/rdbms/admin to initialize the data dictionary like catalog.sql
this is the simpliest way to create a oracle database in unix base system.
: 3. What is the use of the controlfiles (*.dbf) under ORACLEHOME/dbs ??
(*.dbf) doesn't mean it is control files. In fact, you can specify the
name of control file in initXXX.ora.
Anyway, the control files store the information about the location of
all database file and redo log files.
: 4. Someone told me that I could create a new user and state that
: it is a new database. Is this ok??
What do you mean? I don't understand.
: Thanks for help.
: -- Alan
: --
: ___ _
: / _ \| |__ _ _ _ | Name: Sze Shun Sum, Alan E-mail: alan_at_cs.ust.hk
: | _ | / _` | ' \ | Office: Rm 4212, HKUST, Clear Water Bay, HongKong
: |_| |_|_\__,_|_||_| | Phone: (852)2358-8836 Favorite: Bridge,Basketball
Received on Sat Jan 07 1995 - 14:26:29 CET