[askdba] Re: Oracle 9i Installation Procedure/Instructions fo r Solaris/Unix
- From: "Pepling, Todd C." <tpepling@xxxxxxx>
- To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 11:42:53 -0400
1) create entry in /var/opt/oracle/oratab with following format:
ORACLE_SID:ORACLE_HOME:AUTO_START_FLAG
Here's an example where ORACLE_SID=orcl and
ORACLE_HOME=/u01/app/oracle/product/9.2.0
orcl:/u01/app/oracle/product/9.2.0:N
2) create init.ora file for your database (example in $ORACLE_HOME/dbs)
Here's a quick example of an initorcl.ora file for the orcl database:
background_dump_dest=/u01/app/oracle/admin/orcl/bdump
control_files=/u02/oracle/orcl/control01.ctl,/u02/oracle/orcl/control02.ctl
core_dump_dest=/u01/app/oracle/admin/orcl/cdump
db_block_size=16k
db_cache_size=50m
db_name=orcl
instance_name=orcl
shared_pool_size=50m
sort_area_size=1m
undo_management=auto
undo_retention=900
undo_tablespace=UNDO
user_dump_dest=/u01/app/oracle/admin/orcl/udump
3) set OS evironment variables:
host:oracle> . oraenv orcl
4) connect to database as sys:
sqlplus '/ as sysdba'
5) startup nomount using init.ora file created in step 2:
SQL> startup nomount pfile=initorcl.ora
6) create the database:
SQL> create database ORCL
logfile
group 1 (
'/u02/oracle/orcl/redolog_g1_m1.rdo',
'/u02/oracle/orcl/redolog_g1_m2.rdo'
) size 102400K reuse,
group 2 (
'/u02/oracle/orcl/redolog_g2_m1.rdo',
'/u02/oracle/orcl/redolog_g2_m2.rdo'
) size 102400K reuse,
group 3 (
'/u02/oracle/orcl/redolog_g3_m1.rdo',
'/u02/oracle/orcl/redolog_g3_m2.rdo'
) size 102400K reuse,
group 4 (
'/u02/oracle/orcl/redolog_g4_m1.rdo',
'/u02/oracle/orcl/redolog_g4_m2.rdo'
) size 102400K reuse
datafile '/u02/oracle/orcl/system_01.dbf' size 512000K reuse
extent management local
default temporary tablespace temp
tempfile '/u02/oracle/orcl/temp_01.dbf' size 1048576k reuse
extent management local uniform size 1m
undo tablespace undo
datafile '/u02/oracle/orcl/undo_01.dbf' size 1048576k reuse
;
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
conn system/manager
@$ORACLE_HOME/sqlplus/admin/pupbld.sql
CREATE TABLESPACE OEM
DATAFILE '/u02/oracle/orcl/oem_01.dbf' SIZE 100M
REUSE
LOGGING
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024k
ONLINE
;
CREATE TABLESPACE RMAN
DATAFILE '/u02/oracle/orcl/rman_01.dbf' SIZE 100M
REUSE
LOGGING
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024k
ONLINE
;
CREATE TABLESPACE USERS
DATAFILE '/u02/oracle/orcl/users_01.dbf' SIZE 10M
REUSE
LOGGING
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024k
ONLINE
;
Of course, you usually want to distribute your files across different mount
points to spread your IO, but that depends on your system (i.e. a storage
array).
7) Setup tnsnames.ora and listener.ora if you want users to connect to the
database remotely.
-----Original Message-----
From: Rajesh Puneyani [mailto:rajpuneyani@xxxxxxxxx]
Sent: Thursday, October 14, 2004 5:16 PM
To: askdba@xxxxxxxxxxxxx
Subject: [askdba] Re: Oracle 9i Installation Procedure/Instructions for
Solaris/Unix
Hi fellows,
Can someone help me with those installation instructions ?
Please point me to some link/address/document (other than Oracle website) .
Regards
On Thu, 14 Oct 2004 12:01:00 -0400, Rajesh Puneyani
<rajpuneyani@xxxxxxxxx> wrote:
> Hi Guys,
>
> I am looking for some crisp and to the point documentation on Oracle
> 9i Installation and Database Creation (manually) on Solaris platform.
>
> Detailed documentation on Oracle website is too much information.
>
> If someone has some personal hands on notes then it would be great.
>
> Thank you very much.
>
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.
Other related posts:
