Home » Infrastructure » Linux » Install Oracle10g (10.2.0.1) on CentOS 4.1 (RHEL 4 Update 1)
Install Oracle10g (10.2.0.1) on CentOS 4.1 (RHEL 4 Update 1) [message #135237] Tue, 30 August 2005 10:38 Go to next message
dba477
Messages: 10
Registered: July 2005
Junior Member
1.Install CentOS 4.1

2.Run as root:

# groupadd dba # group of users to be granted SYSDBA system privilege
# groupadd oinstall # group owner of Oracle files
# useradd -c "Oracle software owner" -g oinstall -G dba oracle
# passwd oracle
# mkdir -p /u01/app/oracle
# chown -R oracle.oinstall /u01
# mkdir -p /u02/oradata/wtfdata
# chown -R oracle.oinstall /u02

3. Run as root:-

# rpm -Uvh oracleasm-2.6.9-11.ELsmp-2.0.0-1.i686.rpm \
oracleasmlib-2.0.0-1.i386.rpm \
oracleasm-support-2.0.0-1.i386.rpm
# /etc/init.d/oracleasm configure
# /etc/init.d/oracleasm enable

Create Volumes as desired utilizing command:
# /etc/init.d/oracleasm VLM0X /dev/sdx

Tune /etc/sysctl.conf,/etc/limits.so,/etc/profile and "oracle" account as advised in [1]

Login as oracle:-

$ cd /tmp/database
$./runInstaller

Select " Advanced option" and
create ASM instance in ORACLE_HOME - /u01/app/oracle/oracle/product/10.2.0/db_1
Create volume group during this run
Exit installer.

$ ./runInstaller

Select " Advanced option" and
create new ASM database placed into existing volume's group in
ORACLE_HOME - /u01/app/oracle/oracle/product/10.2.0/db_2
Modify ~oracle/.bash_profile correspondently.
Relogin as oracle.
Next:-

$ sqlplus /nolog

SQL> conn / as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area 285212672 bytes
Fixed Size 1218968 bytes
Variable Size 88082024 bytes
Database Buffers 188743680 bytes
Redo Buffers 7168000 bytes
Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database MastDB flashback on;

Database altered.

SQL> alter database open;

Database altered.

Open Enterpise Manager console.(Enterprise Manager 10g Database Control URL:
http://ServerCentOS41:1158/em)

Create new volume's group for flashback recovery area
and modify corresponding value on Recovery Settings page of EM.

System startup in this case should look like:-

[oracle@ServerCentOS41 ~]$ ./lsnrstart

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-AUG-2005 17:57:41

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2005 17:57:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 30-AUG-2005 17:57:42

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_2/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_2/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1522)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 30-AUG-2005 17:57:42
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/10.2.0/db_2/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/10.2.0/db_2/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1522)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

[oracle@ServerCentOS41 ~]$ dbstart
Processing ASM instance "+ASM": log file /u01/app/oracle/product/10.2.0/db_1/startup.log
Processing Database instance "MastDB": log file /u01/app/oracle/product/10.2.0/db_2/startup.log
[oracle@ServerCentOS41 ~]$ emctl start dbconsole
TZ set to US/Eastern
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://ServerCentOS41:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 10g Database Control ........................ started.
Logs are generated in directory /u01/app/oracle/oracle/product/10.2.0/db_2/ServerCentOS41_MastDB/sysman/log
Gracefull shutdowm EM console 10.2.0.1 [message #135728 is a reply to message #135237] Fri, 02 September 2005 04:08 Go to previous messageGo to next message
dba477
Messages: 10
Registered: July 2005
Junior Member
Each one of listener.ora files generated by runInstaller
might be modified just to place following lines in new
order:-
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))

What will cause:-
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ServerCentOS41)(PORT=1521)))
when listener starts.
Looks like "emctl stop dbconsole" starts work gracefully after
that.
Regarding improved performance due to ASM [message #136653 is a reply to message #135237] Fri, 09 September 2005 06:25 Go to previous message
dba477
Messages: 10
Registered: July 2005
Junior Member
Please view:-
Optimizing Oracle 10g on Linux: Non-RAC ASM vs. LVM
By Bert Scalzo on Wed, 2005-08-31 01:00. Software
http://www.linuxjournal.com/article/8539

Previous Topic: font seting for DS10g on linux
Next Topic: linux
Goto Forum:
  


Current Time: Fri Mar 29 03:40:11 CDT 2024