[askdba] Re: Oracle 9i Installation Procedure/Instructions fo r Solaris/Unix
- From: Rajesh Puneyani <rajpuneyani@xxxxxxxxx>
- To: askdba@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 16:00:02 -0400
Thank you Todd,
It really helps.
Do you have any checklist or document that you refer while installing
Oracle 9i fresh on a unix server..in terms of memory requirement,
space requirement, and other system level settings etc.
Thank you again.
Regards
On Fri, 15 Oct 2004 11:42:53 -0400, Pepling, Todd C. <tpepling@xxxxxxx> wrote:
> 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:
