Installing Oracle 11G RAC on Linux 6

vi /etc/hosts

10.254.28.11jwdb01

10.254.28.12jwdb02

10.254.28.13    jwdb01-vip

10.254.28.14jwdb02-vip

6.6.7.101jwdb01-priv

6.6.7.102jwdb02-priv

10.254.28.15jwdb-scan

vi /etc/sysctl.conf

#oracle rac config parameter

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 1054504960

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

[root@jwdb01 ~]# vi /etc/pam.d/login

#%PAM-1.0

auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so

auth       include      system-auth

account    required     pam_nologin.so

account    include      system-auth

password   include      system-auth

# pam_selinux.so close should be the first session rule

session    required     pam_selinux.so close

session    required     pam_loginuid.so

session    optional     pam_console.so

# pam_selinux.so open should only be followed by sessions to be executed in the user context

session    required     pam_selinux.so open

session    required     pam_namespace.so

session    optional     pam_keyinit.so force revoke

session    include      system-auth

-session   optional     pam_ck_connector.so

session    required     pam_limits.so

# End of file

vi /etc/security/limits.conf

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

grid                soft    nproc   2047

grid                hard    nproc   16384

grid                soft    nofile  4096

grid                hard    nofile  65536

grid                soft    stack   10240

[root@jwdb01 ~]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# groupadd -g 500 oinstall

groupadd -g 501 dba

useradd -u 501 -g oinstall -G dba oracle

passwd oracle[root@jwdb01 ~]# groupadd -g 501 dba

[root@jwdb01 ~]# useradd -u 501 -g oinstall -G dba oracle

[root@jwdb01 ~]# passwd oracle

Changing password for user oracle.

New password: 

BAD PASSWORD: it is based on a dictionary word

BAD PASSWORD: is too simple

Retype new password: 

passwd: all authentication tokens updated successfully.

[root@jwdb01 ~]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# useradd -u 500 -g oinstall -G dba grid

passwd grid[root@jwdb01 ~]# passwd grid

Changing password for user grid.

New password: 

BAD PASSWORD: it is too short

BAD PASSWORD: is too simple

Retype new password: 

passwd: all authentication tokens updated successfully.

[root@jwdb01 ~]# 

[root@jwdb01 ~]# id grid

uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(dba)

[root@jwdb01 ~]# id oracle

uid=501(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

vi /etc/security/limits.d/90-nproc.conf

# Change this

*          soft    nproc    1024

# To this

* - nproc 16384

chown -R oracle.dba /oracle

mkdir -p /home/oracle/app/grid

mkdir -p /home/oracle/app/asm

mkdir -p /home/oracle/app/product/db

chown -R grid:dba /home/oracle/app

chown -R grid:dba /home/oracle/app/asm

chown -R grid:dba /home/oracle/app/grid

chown -R oracle:dba /home/oracle/app/db/product/11.2

chmod -R 775 /home/oracle/app

grid

export ORACLE_BASE=/home/oracle/app/grid                

export ORACLE_HOME=/home/oracle/app/asm                 

export ORACLE_SID=+ASM1                        

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask 022

mkdir -p /home/u01/app/grid

mkdir -p /home/u01/app/asm

mkdir -p /home/u01/db/product/11.2

chown -R grid:oinstall /home/u01/app

chown -R grid:oinstall /home/u01/app/asm

chown -R grid:oinstall /home/u01/app/grid

chown -R oracle:oinstall /home/u01/db/product/11.2

chmod -R 775 /home/u01/app

grid

export ORACLE_BASE=/home/u01/app/grid                

export ORACLE_HOME=/home/u01/app/asm                 

export ORACLE_SID=+ASM1                        

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask 022

oracle

export ORACLE_BASE=/home/u01/db                     

export ORACLE_HOME=$ORACLE_BASE/product/11.2

export ORACLE_SID=dzxjdb1

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle/sql:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/oracm/lib:/lib:/usr/lib:/usr/local/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

umask=022

useradd -g tellin -d /home/uportal -m -s /usr/bin/csh uportal

usermod -d  /u01  grid

usermod -d  /u01  grid

切換到root用戶，使用usermod命令，例如usermod -d /tmp test (test為你的用戶名)，使用該命令請確保該用戶下沒有運行的軟件或進程

ntp

ntp時間同步

202.112.128.33

[root@jwsysdb02 etc]# mv ntp.conf ntp.conf.bak

[root@jwsysdb02 etc]# vi ntp.conf

server 202.112.128.33 prefer

driftfile /var/lib/ntp/drift

broadcastdelay 0.008

/etc/init.d/ntpd start

存儲的設備處理步驟：

root@jwdb01 by-path]# sfdisk -s

/dev/sdc: 209715200

/dev/sdd:   2097152

/dev/sde:   2097152

/dev/sdb: 209715200

/dev/sda: 292935982

/dev/sdi:   2097152

/dev/sdg: 209715200

/dev/sdh:   2097152

/dev/sdf: 209715200

/dev/mapper/vg_jwdb01-lv_root:  52428800

/dev/mapper/vg_jwdb01-lv_swap:   4194304

/dev/sdj: 209715200

/dev/sdk: 209715200

/dev/sdl:   2097152

/dev/sdm:   2097152

/dev/sdn: 209715200

/dev/sdo: 209715200

/dev/sdp:   2097152

/dev/sdq:   2097152

/dev/mapper/vg_jwdb01-lv_home: 235798528

/dev/mapper/data2: 209715200

/dev/mapper/ocr2:   2097152

/dev/mapper/ocr1:   2097152

/dev/mapper/data1: 209715200

/dev/mapper/data1p1: 209712478

/dev/mapper/ocr1p1:   2096451

/dev/mapper/data2p1: 209712478

/dev/mapper/ocr2p1:   2096451

total: 3127098992 blocks

[root@jwdb01 by-path]# 

[root@jwdb01 by-path]# 

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr1

ocr1    ocr1p1  

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr1p1

[root@jwdb01 by-path]# chmod 0660 /dev/mapper/ocr2p1

[root@jwdb01 by-path]# 

[root@jwdb01 by-path]# 

[root@jwdb01 by-path]# raw /dev/mapper/ocr1p1 /dev/raw/raw1

Usage:

  raw /dev/raw/rawN <major> <minor>

  raw /dev/raw/rawN /dev/<blockdev>

  raw -q /dev/raw/rawN

  raw -qa

[root@jwdb01 by-path]# raw /dev/raw/raw1 /dev/mapper/ocr1p1

/dev/raw/raw1:  bound to major 253, minor 7

[root@jwdb01 by-path]# raw /dev/raw/raw2 /dev/mapper/ocr2p1

/dev/raw/raw2:  bound to major 253, minor 9

[root@jwdb01 by-path]# raw -qa

/dev/raw/raw1:  bound to major 253, minor 7

/dev/raw/raw2:  bound to major 253, minor 9

[root@jwdb01 by-path]# cd /dev/raw

[root@jwdb01 raw]# ls -lrt

total 0

crw-rw----. 1 root disk 162, 0 Mar  9 15:36 rawctl

crw-rw----. 1 root disk 162, 1 Mar  9 19:33 raw1

crw-rw----. 1 root disk 162, 2 Mar  9 19:33 raw2

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr1p1

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr1

3600b342212af8cad3666d6158d0000da

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/ocr2

3600b342ea1bc4eddbcfbd001cd0000d4

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/data1

3600b342513d1ae1d508dd7034d0000d7

[root@jwdb01 raw]# /sbin/scsi_id -g -u -d /dev/mapper/data2

3600b34292a10124d90fcdec9bd0000dc

[root@jwdb01 raw]# chown -R grid:oinstall /dev/raw/raw1

[root@jwdb01 raw]# chown -R grid:oinstall /dev/raw/raw2

[root@jwdb01 raw]# chmod 660 /dev/raw/raw1

[root@jwdb01 raw]# chmod 660 /dev/raw/raw2

[root@jwdb01 raw]# raw -qa

/dev/raw/raw1:  bound to major 253, minor 7

/dev/raw/raw2:  bound to major 253, minor 9

[root@jwdb01 raw]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# /home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb01 ~]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# 

[root@jwdb01 ~]# /home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /home/u01/app/asm

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

  root wallet

  root wallet cert

  root cert export

  peer wallet

  profile reader wallet

  pa wallet

  peer wallet keys

  pa wallet keys

  peer cert request

  pa cert request

  peer cert

  pa cert

  peer root cert TP

  profile reader root cert TP

  pa root cert TP

  peer pa cert TP

  pa peer cert TP

  profile reader pa cert TP

  profile reader peer cert TP

  peer user cert

  pa user cert

Adding Clusterware entries to upstart

CRS-2672: Attempting to start 'ora.mdnsd' on 'jwdb01'

CRS-2676: Start of 'ora.mdnsd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'jwdb01'

CRS-2676: Start of 'ora.gpnpd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'jwdb01'

CRS-2672: Attempting to start 'ora.gipcd' on 'jwdb01'

CRS-2676: Start of 'ora.cssdmonitor' on 'jwdb01' succeeded

CRS-2676: Start of 'ora.gipcd' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'jwdb01'

CRS-2672: Attempting to start 'ora.diskmon' on 'jwdb01'

CRS-2676: Start of 'ora.diskmon' on 'jwdb01' succeeded

CRS-2676: Start of 'ora.cssd' on 'jwdb01' succeeded

ASM created and started successfully.

Disk Group CRSDG created successfully.

clscfg: -install mode specified

Successfully accumulated necessary OCR keys.

Creating OCR keys for user 'root', privgrp 'root'..

Operation successful.

CRS-4256: Updating the profile

Successful addition of voting disk 51f01ae0711a4fa1bfb2edf48a5e7e7d.

Successfully replaced voting disk group with +CRSDG.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   51f01ae0711a4fa1bfb2edf48a5e7e7d (/dev/raw/raw1) [CRSDG]

Located 1 voting disk(s).

CRS-2672: Attempting to start 'ora.asm' on 'jwdb01'

CRS-2676: Start of 'ora.asm' on 'jwdb01' succeeded

CRS-2672: Attempting to start 'ora.CRSDG.dg' on 'jwdb01'

CRS-2676: Start of 'ora.CRSDG.dg' on 'jwdb01' succeeded

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@jwdb02 ~]# /home/u01/app/oraInventory/orainstRoot.sh

Changing permissions of /home/u01/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

Changing groupname of /home/u01/app/oraInventory to oinstall.

The execution of the script is complete.

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# /home/u01/app/asm/root.sh

Performing root user operation for Oracle 11g 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /home/u01/app/asm

Enter the full pathname of the local bin directory: [/usr/local/bin]: 

   Copying dbhome to /usr/local/bin ...

   Copying oraenv to /usr/local/bin ...

   Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Using configuration parameter file: /home/u01/app/asm/crs/install/crsconfig_params

Creating trace directory

User ignored Prerequisites during installation

Installing Trace File Analyzer

OLR initialization - successful

Adding Clusterware entries to upstart

CRS-4402: The CSS daemon was started in exclusive mode but found an active CSS daemon on node jwdb01, number 1, and is terminating

An active cluster was found during exclusive startup, restarting to join the cluster

Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@jwdb02 ~]# su - grid

[grid@jwdb02 ~]$ 

[grid@jwdb02 ~]$ 

[grid@jwdb02 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01

vi /etc/rc.local

 chown -R grid:oinstall /dev/mapper/ocr1p1 

 chown -R grid:oinstall /dev/mapper/ocr2p1 

 chown -R grid:oinstall /dev/mapper/data1p1 

 chown -R grid:oinstall /dev/mapper/data2p1 

 sleep 3

 chmod 660 /dev/mapper/ocr1p1 

 chmod 660 /dev/mapper/ocr2p1 

 chmod 660 /dev/mapper/data1p1 

 chmod 660 /dev/mapper/data2p1 

sleep 3

raw /dev/raw/raw1 /dev/mapper/ocr1p1 

raw /dev/raw/raw2 /dev/mapper/ocr2p1

raw /dev/raw/raw3 /dev/mapper/data1p1 

raw /dev/raw/raw4 /dev/mapper/data2p1 

sleep 3

 chown -R grid:oinstall /dev/raw/raw1

 chown -R grid:oinstall /dev/raw/raw2

 chown -R grid:oinstall /dev/raw/raw3

 chown -R grid:oinstall /dev/raw/raw4

 chmod 660 /dev/raw/raw1

 chmod 660 /dev/raw/raw2

 chmod 660 /dev/raw/raw3

 chmod 660 /dev/raw/raw4

應用連接配置連接IP

10.254.28.15

即scan-ip

虛擬IP--vip

10.254.28.13

10.254.28.14

端口：1521

第一個節點(28.11)

root用戶下執行

1.停止11g rac

su - oracle -c "srvctl stop instance -d orcl -i orcl1"

su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

2.啟動11g rac

su - root -c "/home/u01/app/asm/bin/crsctl start crs"

sleep 120

su - oracle -c "srvctl start instance -d orcl -i orcl1"

第二個節點(28.12)

root用戶下執行

1.停止11g rac

su - oracle -c "srvctl stop instance -d orcl -i orcl2"

su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

2.啟動11g rac

su - root -c "/home/u01/app/asm/bin/crsctl start crs"

sleep 120

su - oracle -c "srvctl start instance -d orcl -i orcl2"

crs_stat -t的用法

在grid用戶下，執行

crs_stat -t

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora....02.lsnr application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01  

注明：gsd

ora.jwdb01.gsd

ora.jwdb02.gsd

ora.gsd

已經廢棄了額offline是正常的

其他所有項，target online，state(狀態) online

假如出現offline，表示11g grid rac有問題，需要檢查

shutdown immediate

incon/incon    connect,dba,resource     incon.dbf   

 orcl   bhjw/bhjw    connect,dba,resource   bhjw.dbf

create tablespace incon    

datafile '+DATADG' 

autoextend on  

next 5m maxsize 20480m  

extent management local;  

create user incon identified by incon  

default tablespace incon;

create tablespace  bhjw

datafile '+DATADG' 

size 5000m  

autoextend on  

next 5m maxsize 20480m  

extent management local;  

create user  bhjw identified by  bhjw

default tablespace  bhjw;

grant connect,dba to incon;

grant connect,dba to bhjw; 

測試

[root@jwdb01 ~]# su - oracle

[oracle@jwdb01 ~]$ 

[oracle@jwdb01 ~]$ 

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:25:00 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> 

SQL> 

SQL> 

SQL> 

SQL> create tablespace incon    

  2  datafile '+DATADG' 

  3  autoextend on  

  4  next 5m maxsize 20480m  

  5  extent management local; 

Tablespace created.

SQL> create user incon identified by incon  

  2  default tablespace incon；

  3  

SQL> 

SQL> create user incon identified by incon  

  2  default tablespace incon;

User created.

SQL> 

SQL> 

SQL> grant connect,dba to incon;

Grant succeeded.

SQL> 

SQL> 

SQL> create tablespace  bhjw

  2  datafile '+DATADG' 

  3  size 5000m  

  4  autoextend on  

  5  next 5m maxsize 20480m  

  6  extent management local;

Tablespace created.

SQL> 

SQL> create user  bhjw identified by  bhjw

  2  default tablespace  bhjw;

User created.

SQL> 

SQL> 

SQL> grant connect,dba to bhjw;     

Grant succeeded.

SQL> show paramater name

SP2-0158: unknown SHOW option "paramater"

SP2-0158: unknown SHOW option "name"

SQL> show parameter name

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

cell_offloadgroup_name               string

db_file_name_convert                 string

db_name                              string      orcl

db_unique_name                       string      orcl

global_names                         boolean     FALSE

instance_name                        string      orcl1

lock_name_space                      string

log_file_name_convert                string

processor_group_name                 string

service_names                        string      orcl

SQL> !

[oracle@jwdb01 ~]$ ps -ef|grep LOCAL

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora....02.lsnr application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01      

[grid@jwdb01 ~]$ 

[grid@jwdb01 ~]$ 

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:48:39 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

SQL> 

SQL> 

SQL> shutdown abort

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@jwdb01 ~]$ 

[oracle@jwdb01 ~]$ 

[oracle@jwdb01 ~]$ ps -ef|grep smon

oracle   51634 51102  0 21:49 pts/3    00:00:00 grep smon

root     62097     1  6 20:04 ?        00:06:24 /home/u01/app/asm/bin/osysmond.bin

grid     62240     1  0 20:04 ?        00:00:00 asm_smon_+ASM1

[oracle@jwdb01 ~]$ 

[grid@jwdb01 ~]$ 

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora....02.lsnr application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb02      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01 

[oracle@jwdb01 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 9 21:50:08 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 4.4896E+10 bytes

Fixed Size                  2263296 bytes

Variable Size            7381976832 bytes

Database Buffers         3.7447E+10 bytes

Redo Buffers               64831488 bytes

Database mounted.

Database opened.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

[oracle@jwdb01 ~]$ ps -ef|grep smon

oracle   52029     1  0 21:50 ?        00:00:00 ora_smon_orcl1

oracle   52216 51102  0 21:50 pts/3    00:00:00 grep smon

root     62097     1  6 20:04 ?        00:06:30 /home/u01/app/asm/bin/osysmond.bin

grid     62240     1  0 20:04 ?        00:00:00 asm_smon_+ASM1

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora....02.lsnr application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01  

[root@jwdb02 ~]# su - oracle -c "srvctl stop instance -d orcl -i orcl2"

[root@jwdb02 ~]# 

[root@jwdb02 ~]# 

[root@jwdb02 ~]# su - root -c "/home/u01/app/asm/bin/crsctl stop crs"

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.crsd' on 'jwdb02'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'jwdb02'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.CRSDG.dg' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.registry.acfs' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.ARCHDG.dg' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'jwdb02'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.jwdb02.vip' on 'jwdb02'

CRS-2677: Stop of 'ora.ARCHDG.dg' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.DATADG.dg' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.registry.acfs' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.jwdb02.vip' on 'jwdb02' succeeded

CRS-2672: Attempting to start 'ora.jwdb02.vip' on 'jwdb01'

CRS-2676: Start of 'ora.jwdb02.vip' on 'jwdb01' succeeded

CRS-2677: Stop of 'ora.CRSDG.dg' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'jwdb02'

CRS-2677: Stop of 'ora.asm' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'jwdb02'

CRS-2677: Stop of 'ora.ons' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'jwdb02'

CRS-2677: Stop of 'ora.net1.network' on 'jwdb02' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'jwdb02' has completed

CRS-2677: Stop of 'ora.crsd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.crf' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.ctssd' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.evmd' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.asm' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'jwdb02'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'jwdb02'

CRS-2677: Stop of 'ora.evmd' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.crf' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.asm' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'jwdb02'

CRS-2677: Stop of 'ora.drivers.acfs' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'jwdb02' succeeded

CRS-2677: Stop of 'ora.ctssd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'jwdb02'

CRS-2677: Stop of 'ora.cssd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'jwdb02'

CRS-2677: Stop of 'ora.gipcd' on 'jwdb02' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'jwdb02'

CRS-2677: Stop of 'ora.gpnpd' on 'jwdb02' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'jwdb02' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@jwdb02 ~]# 

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....SM2.asm application    ONLINE    ONLINE    jwdb02      

ora....02.lsnr application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.gsd application    OFFLINE   OFFLINE               

ora.jwdb02.ons application    ONLINE    ONLINE    jwdb02      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb02      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01   

[grid@jwdb01 ~]$ crs_stat -t

Name           Type           Target    State     Host        

------------------------------------------------------------

ora.ARCHDG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora.CRSDG.dg   ora....up.type ONLINE    ONLINE    jwdb01      

ora.DATADG.dg  ora....up.type ONLINE    ONLINE    jwdb01      

ora....ER.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora....N1.lsnr ora....er.type ONLINE    ONLINE    jwdb01      

ora.asm        ora.asm.type   ONLINE    ONLINE    jwdb01      

ora.cvu        ora.cvu.type   ONLINE    ONLINE    jwdb01      

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               

ora....SM1.asm application    ONLINE    ONLINE    jwdb01      

ora....01.lsnr application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.gsd application    OFFLINE   OFFLINE               

ora.jwdb01.ons application    ONLINE    ONLINE    jwdb01      

ora.jwdb01.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora.jwdb02.vip ora....t1.type ONLINE    ONLINE    jwdb01      

ora....network ora....rk.type ONLINE    ONLINE    jwdb01      

ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    jwdb01      

ora.ons        ora.ons.type   ONLINE    ONLINE    jwdb01      

ora.orcl.db    ora....se.type ONLINE    ONLINE    jwdb01      

ora....ry.acfs ora....fs.type ONLINE    ONLINE    jwdb01      

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    jwdb01      

[grid@jwdb01 ~]$ 

備份，

exp，如果是登陸linux服務器的oracle用戶下，請使用全庫導出full=y參數，外加buffer=1000000，使用system/oracle

歸檔清除，稍后提供

11g存儲

多路徑裸盤，分區建lvm，然后raw設備綁定。

或者多路徑裸盤udev綁定

Base System > Base

Base System > Client management tools

Base System > Compatibility libraries

Base System > Hardware monitoring utilities

Base System > Large Systems Performance

Base System > Network file system client

Base System > Performance Tools

Base System > Perl Support

Servers > Server Platform

Servers > System administration tools

Desktops > Desktop

Desktops > Desktop Platform

Desktops > Fonts

Desktops > General Purpose Desktop

Desktops > Graphical Administration Tools

Desktops > Input Methods

Desktops > X Window System

Applications > Internet Browser

Development > Additional Development

Development > Development Tools

rpm -Uvh binutils-2.*

rpm -Uvh compat-libstdc++-33*

rpm -Uvh elfutils-libelf-0.*

rpm -Uvh libaio-0.*

rpm -Uvh libaio-devel-0.*

rpm -Uvh sysstat-9.*

rpm -Uvh glibc-2.*

rpm -Uvh glibc-common-2.*

rpm -Uvh glibc-devel-2.* glibc-headers-2.*

rpm -Uvh ksh-2*

rpm -Uvh make-3.*

rpm -Uvh libgcc-4.*

rpm -Uvh libstdc++-4.*

rpm -Uvh libstdc++-4.*.i686*

rpm -Uvh libstdc++-devel-4.*

rpm -Uvh gcc-4.*x86_64*

rpm -Uvh gcc-c++-4.*x86_64*

rpm -Uvh --allfiles elfutils-libelf-0*x86_64* elfutils-libelf-devel-0*x86_64*

rpm -Uvh elfutils-libelf-0*i686* elfutils-libelf-devel-0*i686*

rpm -Uvh libtool-ltdl*i686*

rpm -Uvh ncurses*i686*

rpm -Uvh readline*i686*

rpm -Uvh unixODBC*

vi /etc/sysctl.conf

#oracle rac config parameter

fs.aio-max-nr = 1048576

fs.file-max = 6815744

#kernel.shmall = 2097152

#kernel.shmmax = 1054504960

kernel.shmmni = 4096

# semaphores: semmsl, semmns, semopm, semmni

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_default=262144

net.core.wmem_max=1048586

vi /etc curity mits.conf

oracle              soft    nproc   2047

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

grid                soft    nproc   2047

grid                hard    nproc   16384

grid                soft    nofile  4096

grid                hard    nofile  65536

grid                soft    stack   10240

vi /etc/pam.d/login

session    required     pam_limits.so

groupadd -g 500 oinstall

groupadd -g 501 dba

useradd -u 501 -g oinstall -G dba oracle

passwd oracle

useradd -u 500 -g oinstall -G dba grid

passwd grid

[root@oradb1 ~]# id oracle

uid=501(oracle) gid=500(oinstall) groups=500(oinstall),501(dba)

[root@oradb1 ~]# id grid

uid=500(grid) gid=500(oinstall) groups=500(oinstall),501(dba)

解開grid包的時候

rpm -Uvh cvuqdisk*

cat /etc/hosts

127.0.0.1   localhost

#rac 112 config

#scan-ip

192.168.56.30 racdb-scan

#public-ip

192.168.56.31 racdb1

192.168.56.33 racdb2

#private-ip

10.10.10.31     racdb1-priv

10.10.10.33     racdb2-priv

#virtual-ip

192.168.56.32 racdb1-vip

192.168.56.34 racdb2-vip

vi /etc curity mits.d/90-nproc.conf

# Change this

*          soft    nproc    1024

# To this

* - nproc 16384

cat /etc linux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

#     enforcing - SELinux security policy is enforced.

#     permissive - SELinux prints warnings instead of enforcing.

#     disabled - No SELinux policy is loaded.

SELINUX=disabled

# SELINUXTYPE= can take one of these two values:

#     targeted - Targeted processes are protected,

#     mls - Multi Level Security protection.

SELINUXTYPE=targeted 

 service iptables stop

 chkconfig iptables off

/oracle/grid

/oracle/asm

/oracle 

# mkdir -p  /u01/app/11.2.0/grid

# mkdir -p /u01/app/grid

# mkdir -p /u01/app/oracle

# chown grid:oinstall /u01/app/11.2.0/grid

# chown grid:oinstall /u01/app/grid

# chown oracle:oinstall /u01/app/oracle

# chmod -R 775 /u01/

# chown -R grid:oinstall /u01

楊東 22:24:18 

mkdir -p /u01/app/grid

mkdir -p /u01/app/11.2/grid

mkdir -p /u01/oracle/product/11.2 

chown -R oracle:oinstall /u01/oracle

chown -R grid:oinstall /u01

chmod -R 775 /u01

#grid

export ORACLE_BASE=/u01/app/grid                

export ORACLE_HOME=/u01/app/11.2/grid                 

export ORACLE_SID=+ASM1                        

export NLS_LANG=AMERICAN_AMERICA.UTF8

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export ORACLE_TERM=xterm

export PATH=.:${PATH}:$ORACLE_HOME/bin

export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

echo ORACLE_SID=$ORACLE_SID

echo ORACLE_BASE=$ORACLE_BASE

echo ORACLE_HOME=$ORACLE_HOME

#oracle

export ORACLE_BASE=/u01/oracle                     

export ORACLE_HOME=$ORACLE_BASE/product/11.2

export ORACLE_SID=oradb1

export NLS_LANG=AMERICAN_AMERICA.zhs16gbk

export NLS_DATE_FORMAT="yyyy-mm-dd hh34:mi:ss"

export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:$ORACLE_BASE/common/oracle/bin

export ORACLE_PATH=${PATH}:$ORACLE_BASE/common/oracle l:.:$ORACLE_HOME/rdbms/admin

export LD_LIBRARY_PATH=$ORACLE_HOME b:$ORACLE_HOME/oracm b: b:/usr b:/usr/local b

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib

export ORACLE_TERM=xterm 

echo ORACLE_SID=$ORACLE_SID

echo ORACLE_BASE=$ORACLE_BASE

echo ORACLE_HOME=$ORACLE_HOME