How to install oracle11g single instance automatically by rhel6/7 01/17 Update SLTechnology News&Howtos

How to install oracle11g single instance automatically by rhel6/7

2025-01-17 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Shulou(Shulou.com)05/31 Report--

Editor to share with you how to automatically install a single instance of rhel6/7 oracle11g, I believe that most people do not understand, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Due to daily work, it is often necessary to install oracle 11.2.0.4 single instance database on rhel6.X,rhel7.X,CentOS6.X,CentOS7.x (based on file system)

Therefore, an automatic installation script oracle script is written.

The list of all files is as follows:

1. Where the iso file is the image source of the corresponding red hat system (the red hat version is obtained according to cat / etc/redhat-release)

2. Two zip installation packages can be downloaded from SR (search 13390677 to find the corresponding files, note that the file names must be the same)

3. Three rsp files are configuration files for installing oracle, db_install.rsp is used to install database software, dbca.rsp is used to create databases, and netca.rsp is used to create listeners.

4. The sh file is a script written by me, which can be executed directly by root users (requires chmod Ubunx auto_install_oracle_server.sh). During this period, the user needs to enter several information: character set, oracle_sid, host ip address, memory_target.

Since it has only been tested in some versions of Red Hat 6 and 7, there may be some problems. The shell script can be modified specifically.

Operation procedure:

1. Check whether the documents are complete.

Click (here) to collapse or open

[root@testlihb ~] # cd / tmp

[root@testlihb tmp] # ls-lrt

Total 6120464

-rw-r--r-- 1 root root 5871 Apr 28 07:00 netca.rsp # snooping profile

-rwxr--r-- 1 root root 17977 Apr 28 07:00 auto_install_oracle_server.sh # main script

-rw-r--r-- 1 root root 25287 Apr 28 07:00 db_install.rsp # Database software configuration file

-rw-r--r-- 1 root root 44580 Apr 28 07:00 dbca.rsp # database configuration file

-rwxr-xr-x 1 root root 1395582860 Apr 28 07:07 p13390677_112040_Linux-x86-64_1of7.zip # 11.2.0.4 installation package 1

-rwxr-xr-x 1 root root 1151304589 Apr 28 07:12 p13390677_112040_Linux-x86-64_2of7.zip # 11.2.0.4 installation package 2

-rw-r--r-- 1 root root 3720347648 Jul 24 2018 rhel-server-6.4-x86_64-dvd.iso # operating system CD file

[root@testlihb tmp] # chmod uplix auto_install_oracle_server.sh # root gives executable permission

2. Configure the yum source. If you confirm that the yum source has been configured, you can ignore this step.

Click (here) to collapse or open

[root@testlihb tmp] #. / auto_install_oracle_server.sh # root direct execution

= >-seletion-

= > 1.install database # install the database

= > 2.deinstall database # Uninstall the database (only databases installed through this script can be uninstalled)

= > 3.configure local yum # configure yum source

= >-

= > Your choice:3 # choose to configure the yum source. If you confirm that the yum source has been configured, it can be ignored here.

= > please input the iso location (eg:/tmp/xxx.iso): / tmp/rhel-server-6.4-x86_64-dvd.iso # enter the path to the iso file

[OK] = = > the yum configure

3. Install the database

Click (here) to collapse or open

[root@testlihb tmp] #. / auto_install_oracle_server.sh

= >-seletion-

= > 1.install database

= > 2.deinstall database

= > 3.configure local yum

= >-

= > Your choice:1 # install the database

[ok] = = > begin install_db

[ok] = = > current user is root # check whether the current user is root

[OK] = = > the yum configure # check whether the Yum source is normal

[OK] = > the installfile # check whether the oracle installation package exists

[OK] = = > the config file # check whether the configuration file exists

= >-charcaterset seletion

= > 1.AMERICAN_AMERICA.ZHS16GBK

= > 2.AMERICAN_AMERICA.AL32UTF8

= >-

= > Your choice: (default 1): 1 # Select the database character set, there are only two choices here

= > please input sid (less than 8 letters): oragbk # input sid,sid must be less than 8 characters

= > please input memory target (MB): 4096 # input memory, where the ratio of sga to pga is 3:1

= > please input ORACLE_BASE (will auto create): / database/oragbk # oracle software directory (if the directory does not exist, it will be created automatically. If a directory exists, it must be empty)

= > please input host IP address:192.168.75.236 # enter native ip address

[ok] = = > cpu # check cpu

[ok] = = > memory # check memory

[ok] = = > / tmp # check / tmp directory

[ok] = = > swap # check the swap partition

[ok] = > ORACLE_BASE # check the oracle software directory

[OK] = = > the yum configure # check the yum source configuration

[ok] = = > the yum package has been installed # install dependency packages through yum

[ok] = > the sysctl.conf has been backup and change # back up and modify sysctl.conf files

[ok] = > the limits.conf has been backup and change # back up and modify limits.conf files

[ok] = > the login has been backup and change # back up and modify login files

[ok] = > the profile has been backup and change # back up and modify profile files

[ok] = = > the oracle user and oinstall,dba group has been created # create oracle users, oinstall and dba groups

[ok] = > the .bash _ profile has been backup and change # back up and modify the .bash _ profile file

[ok] = > the dir has been created # check and create the oracle_base directory

[ok] = = > the install file has been unzip # extract the oracle installation package

[ok] = > the hosts has been backup and change # back up and modify hosts files

[ok] = > the db_install.rsp has been backup and change # back up and modify db_install.rsp files

[ok] = = > waiting for software install. . . . . . . . . . # it takes a long time to install oracle software here. You can check / tmp/db_install.rsp.log.

[ok] = > software has installed # oracle software installation completed

[ok] = > two script has been run by root # root executes two shell script files

[ok] = > netca.rsp has been backup and change # back up and modify netca.rsp files

[ok] = = > waiting for netca install. # listener is being created here. You don't need to wait too long. You can check / tmp/netca.rsp.log.

[ok] = = > netca has installed # listener creation completed

[ok] = > dbca.rsp has been backup and change # back up and modify dbca.rsp files

Copying database files

1% complete

3% complete

11% complete

18% complete

26% complete

37% complete

Creating and starting Oracle instance

40% complete

45% complete

50% complete

55% complete

56% complete

60% complete

62% complete

Completing Database Creation

66% complete

70% complete

73% complete

85% complete

96% complete

100% complete

Look at the log file "/ database/oragbk/cfgtoollogs/dbca/oragbk/oragbk.log" for further details.

[ok] = = > dbca has installed # Database creation completed

[ok] = = > the install process success

4. Check whether the database is normal.

Click (here) to collapse or open

[root@testlihb tmp] # ps-ef | grep smon_ | grep-v grep

Oracle 12863 1 0 07:34? 00:00:00 ora_smon_oragbk # process exists

[root@testlihb tmp] # su-oracle

[oracle@testlihb ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Apr 28 07:35:09 2018

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL > show parameter name

NAME TYPE VALUE

Cell_offloadgroup_name string

Db_file_name_convert string

Db_name string oragbk

Db_unique_name string oragbk

Global_names boolean FALSE

Instance_name string oragbk

Lock_name_space string

Log_file_name_convert string

Processor_group_name string

Service_names string oragbk

SQL > show parameter memory

NAME TYPE VALUE

Hi_shared_memory_address integer 0

Memory_max_target big integer 0

Memory_target big integer 0

Shared_memory_address integer 0

SQL > show parameter sga

NAME TYPE VALUE

Lock_sga boolean FALSE

Pre_page_sga boolean FALSE

Sga_max_size big integer 3G

Sga_target big integer 3G

SQL > show parameter pga

NAME TYPE VALUE

Pga_aggregate_target big integer 1G

SQL > set lines 150 pages 10000

SQL > select * from nls_database_parameters where PARAMETER='NLS_CHARACTERSET'

PARAMETER VALUE

NLS_CHARACTERSET ZHS16GBK

SQL > exit

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@testlihb ~] $logout

5. Uninstall the database

Click (here) to collapse or open

[root@testlihb tmp] #. / auto_install_oracle_server.sh

= >-seletion-

= > 1.install database

= > 2.deinstall database

= > 3.configure local yum

= >-

= > Your choice:2

Please use oracle to run $ORACLE_HOME/deinstall/deinstall and use root to run / tmp/del_ora.sh # cuts to oracle users to execute scripts, and then cuts to root users to execute scripts

[root@testlihb tmp] # su-oracle

[oracle@testlihb ~] $$ORACLE_HOME/deinstall/deinstall

Checking for required files and bootstrapping...

Please wait...

Location of logs/ tmp/deinstall2018-04-287-36-48AM/logs/

. . .

Specify all Single Instance listeners that are to be de-configured [LISTENER]:

Specify the list of database names that are configured in this Oracle home [oragbk]:

The details of database (s) oragbk have been discovered automatically. Do you still want to modify the details of oragbk database (s)? [n]: y

Specify the type of this database (1.Single Instance Database | 2.Oracle Restart Enabled Database) [1]:

Specify the diagnostic destination location of the database [/ database/oragbk/diag/rdbms/oragbk]:

Specify the storage type used by the Database ASM | FS [FS]:

Specify the list of directories if any database files exist on a shared file system. If 'oragbk' subdirectory is found, then it will be deleted. Otherwise, the specified directory will be deleted. Alternatively, you can specify list of database files with full path [/ database/oragbk/oradata/oragbk,/database/oragbk/fast_recovery_area/oragbk]:

Specify the fast recovery area location, if it is configured on the file system. If 'oragbk' subdirectory is found, then it will be deleted. [/ database/oragbk/fast_recovery_area/ORAGBK]:

Specify the database spfile location [/ database/oragbk/product/11.2.0/db_1/dbs/spfileoragbk.ora]:

Do you want to continue (y-yes, n-no)? [n]: y

. . .

[oracle@testlihb ~] $logout

[root@testlihb tmp] # / tmp/del_ora.sh

6. Check whether the database has been deleted

Click (here) to collapse or open

[root@testlihb tmp] # ps-ef | grep smon_

Root 16003 7948 0 07:45 pts/1 00:00:00 grep smon_

[root@testlihb tmp] # id oracle

Id: oracle: No such user

Here is the specific script:

Auto_install_oracle_server.sh

Click (here) to collapse or open

#! / bin/bash

HOSTNAME= `hostname`

PWD= "$(cd" $(dirname "$0") "& & pwd)"

# 102 remove the last / of the directory

Change_dir () {

Flag=$ {1 million dollars /}

If [- z $flag]; then

ORACLE_BASE=$ {1%?}

}

# # change_dir $dir

# 101 check whether the folder can be used as an ORACLE_BASE directory

Check_dir () {

If [- d $1]; then

If [`ls-al $1 | wc-l`-gt 3]; then

Echo "[fail] = = > the ORACLE_BASE must without any file (s)"

Exit 101

Else

Mkdir-p $1

}

# # read-p "input dir:" dir

# # check_dir $dir

# 0 check whether the incoming parameter is empty

Isnull () {

If [- z $1]; then

Echo $1

Echo "[fail] = > parameter is null"

Exit 0

}

# # isnull $hah

# 1 check whether the Yum source is normal

Check_yum () {

Yum clean all > / dev/null 2 > & 1

Var= `yum repolist | grep repolist | awk-F:'{print $2}'| awk-F,'{print $1}'`

# # echo $var

If [$var-eq 0]; then

Echo "[fail] = = > the yum configure is wrong, see / etc/yum.repos.d/*.repo"

Exit 1

Else

Echo "[OK] = > the yum configure"

}

# # check_yum

# 2 check whether the database installation software has been uploaded

Check_installfile () {

Cd $PWD

If [- f "p13390677_112040_Linux-x86-64_1of7.zip"-a-f "p13390677_112040_Linux-x86-64_2of7.zip"]; then

Echo "[OK] = > the installfile"

Else

Echo "[fail] = = > the $PWD does not have p13390677" 112040 Linux Murray * "

Exit 2

If [- f "dbca.rsp"-a-f "netca.rsp"-a-f "db_install.rsp"]; then

Echo "[OK] = > the config file"

Else

Echo "[fail] = = > the $PWD does not have * .rsp"

Exit 2

}

# # check_installfile

# 3 determine whether the executing user is root or not

Isroot () {

If [$USER! = "root"]; then

Echo "[fail] = > current user is not root"

Exit 3

Else

Echo "[ok] = > current user is root"

}

# # isroot

# 4 get the basic information of input database

Get_information () {

Echo "= >-charcaterset seletion----"

Echo "= > 1.AMERICAN_AMERICA.ZHS16GBK"

Echo "= > 2.AMERICAN_AMERICA.AL32UTF8"

Echo "= > -"

Echo-e "= > Your choice: (default 1):\ c"

Read NLS_LANG

Case $NLS_LANG in

1) NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

CHARACTERSET=ZHS16GBK

2) NLS_LANG=AMERICAN_AMERICA.AL32UTF8

CHARACTERSET=AL32UTF8

*) NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

CHARACTERSET=ZHS16GBK

Esac

Echo-e "= > please input sid (less than 8 letters):\ c"

Read SID

Isnull $SID

Echo-e "= > please input memory target (MB):\ c"

Read MEMORY

Isnull $MEMORY

Echo-e "= > please input ORACLE_BASE (will auto create):\ c"

Read ORACLE_BASE

Isnull $ORACLE_BASE

Check_dir $ORACLE_BASE

Change_dir $ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1

Echo-e "= > please input host IP address:\ c"

Read IP

Isnull $IP

}

# # get_information

# 5 check cpu, memory, disk space

Check_cpu_mem_disk () {

Cpu= `cat / proc/cpuinfo | grep name | wc-l`

# # echo $cpu

If [$cpu-gt 1]; then

Echo "[ok] = > cpu"

Else

Echo "[fail] = = > cpu must more than 1 cores"

Exit 5

Mem= `free-m | grep'+'| awk'{print $4}'`

Mem7= `free-m | grep Mem | awk'{print $7}'`

# # echo $mem

If [[$mem-gt 2048 | | $mem7-gt 2048]]; then

Echo "[ok] = > memory"

Else

Echo "[fail] = = > the memory must more than 2G available"

Exit 5

If [`df-m / tmp | wc-l`-eq 2]; then

Tmp= `df-m / tmp | tail-1 | awk'{print $4}'`

Else

Tmp= `df-m / tmp | tail-1 | awk'{print $3}'`

If [$tmp-gt 120]; then

Echo "[ok] = = > / tmp"

Else

Echo "[fail] = = > / tmp must more than 120MB"

Exit 5

If [`print-m | grep Swap | awk'{print $2}'`- gt 150]; then

Echo "[ok] = > swap"

Else

Echo "[fail] = > swap must more than 150MB"

Exit 5

If [`df-m $ORACLE_BASE | wc-l`-eq 2]; then

Base= `df-m $ORACLE_BASE | tail-1 | awk'{print $4}'`

Else

Base= `df-m $ORACLE_BASE | tail-1 | awk'{print $3}'`

If [$base-gt 8000]; then

Echo "[ok] = > ORACLE_BASE"

Else

Echo "[fail] = = > ORACLE_BASE must more than 20g"

Exit 5

}

# # check_cpu_mem_disk

# 6 install dependency package

Yum_install () {

Check_yum

Yum install-y binutils > / dev/null

Yum install-y compat-libstdc++-33 > / dev/null

Yum install-y elfutils-libelf > / dev/null

Yum install-y elfutils-libelf-devel > / dev/null

Yum install-y gcc > / dev/null

Yum install-y gcc-c++ > / dev/null

Yum install-y glibc-common > / dev/null

Yum install-y glibc-devel > / dev/null

Yum install-y glibc-headers > / dev/null

Yum install-y libaio > / dev/null

Yum install-y libaio-devel > / dev/null

Yum install-y libgcc > / dev/null

Yum install-y libstdc++ > / dev/null

Yum install-y libstdc++-devel > / dev/null

Yum install-y make > / dev/null

Yum install-y sysstat > / dev/null

Yum install-y unzip > / dev/null

Echo "[ok] = > the yum package has been installed"

}

# # yum_install

# 7 modify / etc/sysctl.conf file

Sysctl_set () {

If [!-f / etc/sysctl.conf.lihb_bak]; then

Cp / etc/sysctl.conf / etc/sysctl.conf.lihb_bak

Echo "kernel.shmmni = 4096" > > / etc/sysctl.conf

Echo "kernel.sem = 32000 100128" > > / etc/sysctl.conf

Echo "fs.file-max = 6815744" > > / etc/sysctl.conf

Echo "net.ipv4.ip_local_port_range = 9000 65500" > > / etc/sysctl.conf

Echo "net.core.rmem_default = 1048576" > > / etc/sysctl.conf

Echo "net.core.rmem_max = 4194304" > > / etc/sysctl.conf

Echo "net.core.wmem_default = 262144" > > / etc/sysctl.conf

Echo "net.core.wmem_max = 1048576" > > / etc/sysctl.conf

Echo "fs.aio-max-nr = 1048576" > > / etc/sysctl.conf

/ sbin/sysctl-p > / dev/null 2 > & 1

Echo "[ok] = > the sysctl.conf has been backup and change"

}

# # sysctl_set

# 8 modify / etc/security/limits.conf file

Limits_set () {

If [!-f / etc/security/limits.conf.lihb_bak]; then

Cp / etc/security/limits.conf / etc/security/limits.conf.lihb_bak

Echo "oracle soft nproc 2047" > > / etc/security/limits.conf

Echo "oracle hard nproc 16384" > > / etc/security/limits.conf

Echo "oracle soft nofile 1024" > > / etc/security/limits.conf

Echo "oracle hard nofile 65536" > > / etc/security/limits.conf

Echo "[ok] = > the limits.conf has been backup and change"

}

# # limits_set

# 9 modify / etc/pam.d/login file

Login_set () {

If [!-f / etc/pam.d/login.lihb_bak]; then

Cp / etc/pam.d/login / etc/pam.d/login.lihb_bak

Echo "session required / lib64/security/pam_limits.so" > > / etc/pam.d/login

Echo "[ok] = > the login has been backup and change"

}

# # login_set

# 10 modify / etc/profile file

Profile_set () {

If [!-f / etc/profile.lihb_bak]; then

Cp / etc/profile / etc/profile.lihb_bak

Echo'if ["$USER" = "oracle"]; then'> > / etc/profile

Echo'if ["$SHELL" = "/ bin/ksh"]; then'> / etc/profile

Echo 'ulimit-p 16384' > > / etc/profile

Echo 'ulimit-n 65536' > > / etc/profile

Echo 'else' > > / etc/profile

Echo 'ulimit-u 16384' > > / etc/profile

Echo 'ulimit-n 65536' > > / etc/profile

Echo 'fi' > > / etc/profile

Echo 'umask 022' > > / etc/profile

Echo 'fi' > > / etc/profile

Echo "[ok] = > the profile has been backup and change"

}

# # profile_set

# 11 create oracle users and oinstall,dba user groups

User_group_add () {

If [[`grep "oinstall" / etc/ group` = "]]; then

/ usr/sbin/groupadd-g 1100 oinstall > / dev/null 2 > & 1

If [[`grep "dba" / etc/ group` = "]]; then

/ usr/sbin/groupadd-g 1101 dba > / dev/null 2 > & 1

If [[`grep "oracle" / etc/ passwd` = ""]]; then

/ usr/sbin/useradd-g 1100-G 1101-u 1100-m oracle > / dev/null 2 > & 1

Echo "[ok] = > the oracle user and oinstall,dba group has been created"

Else

Echo "[fail] = > the oracle user has exist"

Exit 11

}

# # user_group_add

# 12 modify / home/oracle/.bash_profile file

Bash_profile_set () {

If [!-f / home/oracle/.bash_profile.lihb_bak]; then

Cp / home/oracle/.bash_profile / home/oracle/.bash_profile.lihb_bak

Echo "> > / home/oracle/.bash_profile

Echo "export ORACLE_BASE=$ORACLE_BASE" > > / home/oracle/.bash_profile

Echo "export ORACLE_HOME=$ORACLE_HOME" > > / home/oracle/.bash_profile

Echo "export ORACLE_SID=$SID" > > / home/oracle/.bash_profile

Echo 'export LD_LIBRARY_PATH=$ORACLE_HOME/lib' > > / home/oracle/.bash_profile

Echo 'stty erase ^ H' > > / home/oracle/.bash_profile

Echo 'export NLS_LANG10=$ORACLE_HOME/nls/data' > > / home/oracle/.bash_profile

Echo 'export ORACLE_HOME_LISTNER=$ORACLE_HOME' > > / home/oracle/.bash_profile

Echo 'export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin' > > / home/oracle/.bash_profile

Echo 'export TEMP=/tmp' > > / home/oracle/.bash_profile

Echo 'export TMPDIR=/tmp' > > / home/oracle/.bash_profile

Echo "export NLS_LANG=$NLS_LANG" > > / home/oracle/.bash_profile

Echo "export NLS_DATE_FORMAT='yyyy-mm-dd hh34:mi:ss'" > > / home/oracle/.bash_profile

Echo 'umask 022' > > / home/oracle/.bash_profile

Echo "[ok] = = > the .bash _ profile has been backup and change"

}

# # bash_profile_set

# 13 create ORACLE_BASE and ORACLE_HOME and data file directories and authorize

Create_dir () {

Mkdir-p $ORACLE_HOME

Mkdir-p $ORACLE_BASE/oradata

Mkdir-p $ORACLE_BASE/oraInventory

Mkdir-p $ORACLE_BASE/flash_recovery_area

Chown-R oracle:oinstall $ORACLE_BASE

Echo "[ok] = > the dir has been created"

}

# # create_dir

# 14 decompress the database installation package

Unzip_file () {

Cd $PWD

/ usr/bin/unzip p13390677_112040_Linux-x86-64_1of7.zip > / dev/null 2 > & 1

/ usr/bin/unzip p13390677_112040_Linux-x86-64_2of7.zip > / dev/null 2 > & 1

Chown-R oracle:oinstall $PWD/database

Echo "[ok] = > the install file has been unzip"

}

# # unzip_file

# 15 modify / etc/hosts file

Hosts_set () {

If [!-f / etc/hosts.lihb_bak]; then

Cp / etc/hosts / etc/hosts.lihb_bak

Echo "$IP $HOSTNAME" > > / etc/hosts

Echo "[ok] = > the hosts has been backup and change"

}

# # hosts_set

# 16 modify db_install.rsp database software installation configuration file

Db_install_set () {

Cd $PWD

Chown oracle:oinstall db_install.rsp

If [!-f db_install.rsp.lihb_bak]; then

Cp db_install.rsp db_install.rsp.lihb_bak

Sed-I "s | lihb_hostname | $HOSTNAME | g" db_install.rsp

Sed-I "s | lihb_location | $ORACLE_BASE/oraInventory | g" db_install.rsp

Sed-I "s | lihb_home | $ORACLE_HOME | g" db_install.rsp

Sed-I "s | lihb_base | $ORACLE_BASE | g" db_install.rsp

Sed-I "s | lihb_globaldbname | $SID | g" db_install.rsp

Sed-I "s | lihb_sid | $SID | g" db_install.rsp

Sed-I "s | lihb_datalocation | $ORACLE_BASE/oradata | g" db_install.rsp

Echo "[ok] = > the db_install.rsp has been backup and change"

}

# # db_install_set

# 17 start installing oracle software

Install_software () {

Su-oracle-c "$PWD/database/runInstaller-silent-force-ignorePrereq-responseFile $PWD/db_install.rsp" > / tmp/db_install.rsp.log

Sleep 10s

Echo-e "[ok] = = > waiting for software install\ c"

While [! `grep "root.sh" / tmp/db_install.rsp.log | wc-l`-eq 1]

Echo-e ".\ c"

Sleep 2s

Done

Echo "."

Echo "[ok] = > software has installed"

$ORACLE_BASE/oraInventory/orainstRoot.sh > / dev/null 2 > & 1

$ORACLE_BASE/product/11.2.0/db_1/root.sh > / dev/null 2 > & 1

Echo "[ok] = > two script has been run by root"

}

# # install_software

# 18 modify netca.rsp snooping installation configuration file

Netca_set () {

Cd $PWD

Chown oracle:oinstall netca.rsp

If [!-f netca.rsp.lihb_bak]; then

Cp netca.rsp netca.rsp.lihb_bak

Echo "[ok] = > netca.rsp has been backup and change"

}

# # netca_set

# 19 start installing monitoring software

Install_netca () {

# ORACLE_HOME=/database/oracle/product/11.2.0/db_1/

Chown-R oracle:dba / var/tmp/.oracle > / dev/null 2 > & 1

Chown-R oracle:dba / tmp/.oracle > / dev/null 2 > & 1

Su-oracle-c "$ORACLE_HOME/bin/netca-silent-responseFile $PWD/netca.rsp" > / tmp/netca.rsp.log

Sleep 2s

Echo-e "[ok] = = > waiting for netca install\ c"

While [! `grep "The exit code is" / tmp/netca.rsp.log | wc-l`-eq 1]

Echo-e ".\ c"

Sleep 1s

Done

Echo "."

Echo "[ok] = > netca has installed"

Chown-R oracle:dba / var/tmp/.oracle > / dev/null 2 > & 1

Chown-R oracle:dba / tmp/.oracle > / dev/null 2 > & 1

}

# # install_netca

# 20 modify dbca.rsp to create database configuration file

Dbca_set () {

Cd $PWD

Chown oracle:oinstall dbca.rsp

If [!-f dbca.rsp.lihb_bak]; then

Cp dbca.rsp dbca.rsp.lihb_bak

# SID=cgkcglxt

# ORACLE_BASE=/database/oracle

# CHARACTERSET=ZHS16GBK

# MEMORY=4096

Sed-I "s | lihb_sid | $SID | g" dbca.rsp

Sed-I "s | lihb_datafiledestination | $ORACLE_BASE/oradata | g" dbca.rsp

Sed-I "s | lihb_recoveryareadestination | $ORACLE_BASE/flash_recovery_area | g" dbca.rsp

Sed-I "s | lihb_characterset | $CHARACTERSET | g" dbca.rsp

Sed-I "s | lihb_totalmemory | $MEMORY | g" dbca.rsp

Sed-I "s | lihb_gdbname | $SID | g" dbca.rsp

Echo "[ok] = > dbca.rsp has been backup and change"

}

# # dbca_set

# 21 start to create a database

Install_dbca () {

# ORACLE_HOME=/database/oracle/product/11.2.0/db_1/

Su-oracle-c "$ORACLE_HOME/bin/dbca-silent-force-responseFile $PWD/dbca.rsp"

Echo "[ok] = > dbca has installed"

}

# # install_dbca

# install_db installation database

Install_db () {

Echo "[ok] = > begin install_db"

# check_dir $dir # check whether the folder can be used as an ORACLE_BASE directory

# isnull $hah # check whether the incoming parameter is empty

Isroot # determines whether the executing user is root

Check_yum # check whether the Yum source is normal

Check_installfile # check whether the database installation software has been uploaded

Get_information # get the basic information of input database

Check_cpu_mem_disk # check cpu, memory, disk space

Yum_install # install dependency package

Sysctl_set # modify / etc/sysctl.conf file

Limits_set # modify / etc/security/limits.conf file

Login_set # modify / etc/pam.d/login file

Profile_set # modify / etc/profile file

User_group_add # create oracle users and oinstall,dba user groups

Bash_profile_set # modify / home/oracle/.bash_profile file

Create_dir # create ORACLE_BASE and ORACLE_HOME and data file directories and authorize

Unzip_file # extract the database installation package

Hosts_set # modify / etc/hosts file

Db_install_set # modify db_install.rsp database software installation configuration file

Install_software # starts installing oracle software

Netca_set # modify netca.rsp snooping installation configuration file

Install_netca # starts installing listening software

Dbca_set # modify dbca.rsp to create database configuration file

Install_dbca # starts to create the database

Echo "[ok] = > the install process success"

}

# # install_db

# deinstall_db uninstalls database software

Deinstall_db () {

PWD= "$(cd" $(dirname "$0") "& & pwd)"

Touch / tmp/del_ora.sh > / dev/null 2 > & 1

Echo "#! / bin/bash" > / tmp/del_ora.sh

Echo "cd $PWD" > > / tmp/del_ora.sh

Echo'rm-rf database' > > / tmp/del_ora.sh

Echo'mv-f db_install.rsp.lihb_bak db_install.rsp > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f netca.rsp.lihb_bak netca.rsp > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f dbca.rsp.lihb_bak dbca.rsp > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f / etc/hosts.lihb_bak / etc/hosts > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f / etc/profile.lihb_bak / etc/profile > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f / etc/pam.d/login.lihb_bak / etc/pam.d/login > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f / etc/security/limits.conf.lihb_bak / etc/security/limits.conf > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'mv-f / etc/sysctl.conf.lihb_bak / etc/sysctl.conf > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'/ sbin/sysctl-p > / dev/null 2 > & 1'> > / tmp/del_ora.sh

Echo'rm-rf / opt/tmp/.oracle' > > / tmp/del_ora.sh

Echo'rm-rf / tmp/.oracle' > > / tmp/del_ora.sh

Echo'rm-rf / opt/ORCLfmap' > > / tmp/del_ora.sh

Echo'rm-rf / etc/oraInst.loc' > > / tmp/del_ora.sh

Echo'rm-rf / etc/oratab' > > / tmp/del_ora.sh

Echo 'userdel-r oracle > / dev/null 2 > & 1' > > / tmp/del_ora.sh

ORACLE_BASE= `cat / home/oracle/.bash_profile | grep ORACLE_BASE | awk-F ='{print $2}'`

Echo "rm-rf $ORACLE_BASE" > > / tmp/del_ora.sh

Chmod uplix / tmp/del_ora.sh

Echo 'please use oracle to run $ORACLE_HOME/deinstall/deinstall and use root to run / tmp/del_ora.sh'

}

# # deinstall_db

# configure_yum configure yum Source

Configure_yum () {

Echo-e "= > please input the iso location (eg:/tmp/xxx.iso):\ c"

Read ISOLOCATION

Mkdir-p / media/lihb_iso

Mount-t iso9660-o loop $ISOLOCATION / media/lihb_iso

Mkdir-p / etc/yum.repos.d/lihb_bak

Mv / etc/yum.repos.d/*.repo / etc/yum.repos.d/lihb_bak

Touch / etc/yum.repos.d/lihb_local.repo

Echo "[lihb_local]" > / etc/yum.repos.d/lihb_local.repo

Echo "name=lihb_local" > > / etc/yum.repos.d/lihb_local.repo

Echo "baseurl= file:///media/lihb_iso" > > / etc/yum.repos.d/lihb_local.repo

Echo "gpgcheck=0" > > / etc/yum.repos.d/lihb_local.repo

Echo "enabled=1" > > / etc/yum.repos.d/lihb_local.repo

Check_yum

}

# # configure_yum

# main Program entry

Main () {

Echo "= >-seletion-"

Echo "= > 1.install database"

Echo "= > 2.deinstall database"

Echo "= > 3.configure local yum"

Echo "= > -"

Echo-e "= > Your choice:\ c"

Read FLAG

Case $FLAG in

1) install_db # install database

2) deinstall_db # uninstall the database

3) configure_yum # configure local yum source

*) exit 200

Esac

}

Main

The following is the content of db_install.rsp:

Click (here) to collapse or open

# # Specify values for the variables listed below to customize # #

# # your installation. # #

# # Each variable is associated with a comment. The comment # #

# # can help to populate the variables with the appropriate # #

# # values. # #

# # IMPORTANT NOTE: This file contains plain text passwords and # #

# # should be secured to have read permission only by oracle user # #

# # or db administrator who owns this installation. # #

# Do not change the following system generated value.

Oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0

# Specify the installation option.

# It can be one of the following:

#-INSTALL_DB_SWONLY

#-INSTALL_DB_AND_CONFIG

#-UPGRADE_DB

Oracle.install.option=INSTALL_DB_SWONLY

# Specify the hostname of the system as set during the install. It can be used

# to force the installation to use an alternative hostname rather than using the

# first hostname found on the system. (e.g.for systems with multiple hostnames

# and network interfaces)

ORACLE_HOSTNAME=lihb_hostname

# Specify the Unix group to be set for the inventory directory.

UNIX_GROUP_NAME=oinstall

# Specify the location which holds the inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

INVENTORY_LOCATION=lihb_location

# Specify the languages in which the components will be installed.

# en: English ja: Japanese

# fr: French ko: Korean

# ar: Arabic es: Latin American Spanish

# bn: Bengali lv: Latvian

# pt_BR: Brazilian Portuguese lt: Lithuanian

# bg: Bulgarian ms: Malay

# fr_CA: Canadian French es_MX: Mexican Spanish

# ca: Catalan no: Norwegian

# hr: Croatian pl: Polish

# cs: Czech pt: Portuguese

# da: Danish ro: Romanian

# nl: Dutch ru: Russian

# ar_EG: Egyptian zh_CN: Simplified Chinese

# en_GB: English (Great Britain) sk: Slovak

# et: Estonian sl: Slovenian

# fi: Finnish es_ES: Spanish

# de: German sv: Swedish

# el: Greek th: Thai

# iw: Hebrew zh_TW: Traditional Chinese

# hu: Hungarian tr: Turkish

# is: Icelandic uk: Ukrainian

# in: Indonesian vi: Vietnamese

# it: Italian

# all_langs: All languages

# Specify value as the following to select any of the languages.

# Example: SELECTED_LANGUAGES=en,fr,ja

# Specify value as the following to select all the languages.

# Example: SELECTED_LANGUAGES=all_langs

SELECTED_LANGUAGES=en

# Specify the complete path of the Oracle Home.

ORACLE_HOME=lihb_home

# Specify the complete path of the Oracle Base.

ORACLE_BASE=lihb_base

# Specify the installation edition of the component.

# The value should contain only one of these choices.

#-EE: Enterprise Edition

#-SE: Standard Edition

#-SEONE: Standard Edition One

#-PE: Personal Edition (WINDOWS ONLY)

Oracle.install.db.InstallEdition=EE

# This variable is used to enable or disable custom install and is considered

# only if InstallEdition is EE.

# true: Components mentioned as part of 'optionalComponents' property

# are considered for install.

# false: Value for 'optionalComponents' is not considered.

Oracle.install.db.EEOptionsSelection=false

# This variable is considered only if 'EEOptionsSelection' is set to true.

# Description: List of Enterprise Edition Options you would like to enable.

# The following choices are available. You may specify any

# combination of these choices. The components you choose should

# be specified in the form "internal-component-name:version"

# Below is a list of components you may specify to enable.

# oracle.oraolap:11.2.0.4.0-Oracle OLAP

# oracle.rdbms.dm:11.2.0.4.0-Oracle Data Mining

# oracle.rdbms.dv:11.2.0.4.0-Oracle Database Vault

# oracle.rdbms.lbac:11.2.0.4.0-Oracle Label Security

# oracle.rdbms.partitioning:11.2.0.4.0-Oracle Partitioning

# oracle.rdbms.rat:11.2.0.4.0-Oracle Real Application Testing

Oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0

# #

# PRIVILEGED OPERATING SYSTEM GROUPS #

#-#

# Provide values for the OS groups to which OSDBA and OSOPER privileges #

# needs to be granted. If the install is being performed as a member of the #

# group "dba", then that will be used unless specified otherwise below. #

# #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System. #

# #

# The DBA_GROUP is the OS group which is to be granted OSDBA privileges.

Oracle.install.db.DBA_GROUP=dba

# The OPER_GROUP is the OS group which is to be granted OSOPER privileges.

# The value to be specified for OSOPER group is optional.

Oracle.install.db.OPER_GROUP=oinstall

# Specify the cluster node names selected during the installation.

# Example: oracle.install.db.CLUSTER_NODES=node1,node2

Oracle.install.db.CLUSTER_NODES=

# This variable is used to enable or disable RAC One Node install.

#-true: Value of RAC One Node service name is used.

#-false: Value of RAC One Node service name is not used.

# If left blank, it will be assumed to be false

Oracle.install.db.isRACOneInstall=

# Specify the name for RAC One Node Service.

Oracle.install.db.racOneServiceName=

# Specify the type of database to create.

# It can be one of the following:

#-GENERAL_PURPOSE/TRANSACTION_PROCESSING

#-DATA_WAREHOUSE

Oracle.install.db.config.starterdb.type=GENERAL_PURPOSE

# Specify the Starter Database Global Database Name.

Oracle.install.db.config.starterdb.globalDBName=lihb_globaldbname

# Specify the Starter Database SID.

Oracle.install.db.config.starterdb.SID=lihb_sid

# Specify the Starter Database character set.

# It can be one of the following:

# AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2

# EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257

# BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6

# AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8

# IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE

# KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950

# ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

Oracle.install.db.config.starterdb.characterSet=AL32UTF8

# This variable should be set to true if Automatic Memory Management

# in Database is desired.

# If Automatic Memory Management is not desired, and memory allocation

# is to be done manually, then set it to false.

Oracle.install.db.config.starterdb.memoryOption=true

# Specify the total memory allocation for the database. Value (in MB) should be

# at least 256 MB, and should not exceed the total physical memory available

# on the system.

# Example: oracle.install.db.config.starterdb.memoryLimit=512

Oracle.install.db.config.starterdb.memoryLimit=

# This variable controls whether to load Example Schemas onto

# the starter database or not.

Oracle.install.db.config.starterdb.installExampleSchemas=false

# This variable includes enabling audit settings, configuring password profiles

# and revoking some grants to public. These settings are provided by default.

# These settings may also be disabled.

Oracle.install.db.config.starterdb.enableSecuritySettings=true

# #

# Passwords can be supplied for the following four schemas in the #

# starter database: #

# SYS #

# SYSTEM #

# SYSMAN (used by Enterprise Manager) #

# DBSNMP (used by Enterprise Manager) #

# #

# Same password can be used for all accounts (not recommended) #

# or different passwords for each account can be provided (recommended) #

# #

# This variable holds the password that is to be used for all schemas in the

# starter database.

Oracle.install.db.config.starterdb.password.ALL=mima_0001

# Specify the SYS password for the starter database.

Oracle.install.db.config.starterdb.password.SYS=

# Specify the SYSTEM password for the starter database.

Oracle.install.db.config.starterdb.password.SYSTEM=

# Specify the SYSMAN password for the starter database.

Oracle.install.db.config.starterdb.password.SYSMAN=

# Specify the DBSNMP password for the starter database.

Oracle.install.db.config.starterdb.password.DBSNMP=

# Specify the management option to be selected for the starter database.

# It can be one of the following:

#-GRID_CONTROL

#-DB_CONTROL

Oracle.install.db.config.starterdb.control=DB_CONTROL

# Specify the Management Service to use if Grid Control is selected to manage

# the database.

Oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=

# #

# SPECIFY BACKUP AND RECOVERY OPTIONS #

#-#

# Out-of-box backup and recovery options for the database can be mentioned #

# using the entries below. #

# #

# This variable is to be set to false if automated backup is not required. Else

# this can be set to true.

Oracle.install.db.config.starterdb.automatedBackup.enable=false

# Regardless of the type of storage that is chosen for backup and recovery, if

# automated backups are enabled, a job will be scheduled to run daily to backup

# the database. This job will run as the operating system user that is

# specified in this variable.

Oracle.install.db.config.starterdb.automatedBackup.osuid=

# Regardless of the type of storage that is chosen for backup and recovery, if

# automated backups are enabled, a job will be scheduled to run daily to backup

# the database. This job will run as the operating system user specified by the

# above entry. The following entry stores the password for the above operating

# system user.

Oracle.install.db.config.starterdb.automatedBackup.ospwd=

# Specify the type of storage to use for the database.

# It can be one of the following:

#-FILE_SYSTEM_STORAGE

#-ASM_STORAGE

Oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE

# Specify the database file location which is a directory for datafiles, control

# files, redo logs.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

Oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=lihb_datalocation

# Specify the backup and recovery location.

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

Oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

# Specify the existing ASM disk groups to be used for storage.

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

Oracle.install.db.config.asm.diskGroup=

# Specify the password for ASMSNMP user of the ASM instance.

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

Oracle.install.db.config.asm.ASMSNMPPassword=

# Specify the My Oracle Support Account Username.

# Example: MYORACLESUPPORT_USERNAME=abc@oracle.com

MYORACLESUPPORT_USERNAME=

# Specify the My Oracle Support Account Username password.

# Example: MYORACLESUPPORT_PASSWORD=password

MYORACLESUPPORT_PASSWORD=

# Specify whether to enable the user to set the password for

# My Oracle Support credentials. The value can be either true or false.

# If left blank it will be assumed to be false.

# Example: SECURITY_UPDATES_VIA_MYORACLESUPPORT=true

SECURITY_UPDATES_VIA_MYORACLESUPPORT=

# Specify whether user doesn't want to configure Security Updates.

# The value for this variable should be true if you don't want to configure

# Security Updates, false otherwise.

# The value can be either true or false. If left blank it will be assumed

# to be false.

# Example: DECLINE_SECURITY_UPDATES=false

DECLINE_SECURITY_UPDATES=true

# Specify the Proxy server name. Length should be greater than zero.

# Example: PROXY_HOST=proxy.domain.com

PROXY_HOST=

# Specify the proxy port number. Should be Numeric and at least 2 chars.

# Example: PROXY_PORT=25

PROXY_PORT=

# Specify the proxy user name. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example: PROXY_USER=username

PROXY_USER=

# Specify the proxy password. Leave PROXY_USER and PROXY_PWD

# blank if your proxy server requires no authentication.

# Example: PROXY_PWD=password

PROXY_PWD=

# Specify the proxy realm. This value is used if auto-updates option is selected.

# Example: PROXY_REALM=metalink

PROXY_REALM=

# Specify the Oracle Support Hub URL.

# Example: COLLECTOR_SUPPORTHUB_URL= https://orasupporthub.company.com:8080/

COLLECTOR_SUPPORTHUB_URL=

# Specify the auto-updates option. It can be one of the following:

#-MYORACLESUPPORT_DOWNLOAD

#-OFFLINE_UPDATES

#-SKIP_UPDATES

Oracle.installer.autoupdates.option=

# In case MYORACLESUPPORT_DOWNLOAD option is chosen, specify the location where

# the updates are to be downloaded.

# In case OFFLINE_UPDATES option is chosen, specify the location where the updates

# are present.

Oracle.installer.autoupdates.downloadUpdatesLoc=

# Specify the My Oracle Support Account Username which has the patches download privileges

# to be used for software updates.

# Example: AUTOUPDATES_MYORACLESUPPORT_USERNAME=abc@oracle.com

AUTOUPDATES_MYORACLESUPPORT_USERNAME=

# Specify the My Oracle Support Account Username password which has the patches download privileges

# to be used for software updates.

# Example: AUTOUPDATES_MYORACLESUPPORT_PASSWORD=password

AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

The following is the content of dbca.rsp:

Click (here) to collapse or open

# # DBCA response file # #

# #-#

# # Specify values for the variables listed below to customize Oracle # #

# # Database Configuration installation. # #

# # Each variable is associated with a comment. The comment identifies the # #

# # variable type. # #

# # Please specify the values in the following format: # #

# # Type: Example # #

# # String: "# #

# # Boolean: True or False # #

# # Number: # #

# # StringList: {","} # #

# # Examples: # #

# # 1. Dbca-progress_only-responseFile # #

# # Display a progress bar depicting progress of database creation # #

# # process. # #

# # 2. Dbca-silent-responseFile # #

# # Creates database silently. No user interface is displayed. # #

# # 3. Dbca-silent-createDatabase-cloneTemplate # #

# #-responseFile # #

# # Creates database silently with clone template. The template in # #

# # responsefile is a clone template. # #

# # 4. Dbca-silent-deleteDatabase-responseFile # #

# # Deletes database silently. # #

# GENERAL section is required for all types of database creations.

[GENERAL]

# Name: RESPONSEFILE_VERSION

# Datatype: String

# Description: Version of the database to create

# Valid values: "11.1.0"

# Default value: None

# Mandatory: Yes

RESPONSEFILE_VERSION = "11.2.0"

# Name: OPERATION_TYPE

# Datatype: String

# Description: Type of operation

# Valid values: "createDatabase"\ "createTemplateFromDB"\ "createCloneTemplate"\ "deleteDatabase"\ "configureDatabase"\ "addInstance" (RAC-only)\ "deleteInstance" (RAC-only)

# Default value: None

# Mandatory: Yes

OPERATION_TYPE = "createDatabase"

#-* End of GENERAL section * *

# CREATEDATABASE section is used when OPERATION_TYPE is defined as "createDatabase".

[CREATEDATABASE]

# Name: GDBNAME

# Datatype: String

# Description: Global database name of the database

# Valid values:. -when database domain isn't NULL

#-when database domain is NULL

# Default value: None

# Mandatory: Yes

GDBNAME = "lihb_gdbname"

# Name: RACONENODE

# Datatype: Boolean

# Description: Set to true for RAC One Node database

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# RACONENODE = "false"

# Name: RACONENODESERVICENAME

# Datatype: String

# Description: Service is required by application to connect to RAC One

# Node Database

# Valid values: Service Name

# Default value: None

# Mandatory: No [required in case RACONENODE flag is set to true]

# RACONENODESERVICENAME =

# Name: POLICYMANAGED

# Datatype: Boolean

# Description: Set to true if Database is policy managed and

# set to false if Database is admin managed

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# POLICYMANAGED = "false"

# Name: CREATESERVERPOOL

# Datatype: Boolean

# Description: Set to true if new server pool need to be created for database

# if this option is specified then the newly created database

# will use this newly created serverpool.

# Multiple serverpoolname can not be specified for database

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# CREATESERVERPOOL = "false"

# Name: FORCE

# Datatype: Boolean

# Description: Set to true if new server pool need to be created by force

# if this option is specified then the newly created serverpool

# will be assigned server even if no free servers are available.

# This may affect already running database.

# This flag can be specified for Admin managed as well as policy managed db.

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# FORCE = "false"

# Name: SERVERPOOLNAME

# Datatype: String

# Description: Only one serverpool name need to be specified

# if Create Server Pool option is specified.

# Comma-separated list of Serverpool names if db need to use

# multiple Server pool

# Valid values: ServerPool name

# Default value: None

# Mandatory: No [required in case of RAC service centric database]

# SERVERPOOLNAME =

# Name: CARDINALITY

# Datatype: Number

# Description: Specify Cardinality for create server pool operation

# Valid values: any positive Integer value

# Default value: Number of qualified nodes on cluster

# Mandatory: No [Required when a new serverpool need to be created]

# CARDINALITY =

# Name: SID

# Datatype: String

# Description: System identifier (SID) of the database

# Valid values: Check Oracle11g Administrator's Guide

# Default value: specified in GDBNAME

# Mandatory: No

SID = "lihb_sid"

# Name: NODELIST

# Datatype: String

# Description: Comma-separated list of cluster nodes

# Valid values: Cluster node names

# Default value: None

# Mandatory: No (Yes for RAC database-centric database)

# NODELIST=

# Name: TEMPLATENAME

# Datatype: String

# Description: Name of the template

# Valid values: Template file name

# Default value: None

# Mandatory: Yes

TEMPLATENAME = "General_Purpose.dbc"

# Name: OBFUSCATEDPASSWORDS

# Datatype: Boolean

# Description: Set to true if passwords are encrypted

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# OBFUSCATEDPASSWORDS = FALSE

# Name: SYSPASSWORD

# Datatype: String

# Description: Password for SYS user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes

SYSPASSWORD = "mima_0001"

# Name: SYSTEMPASSWORD

# Datatype: String

# Description: Password for SYSTEM user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes

SYSTEMPASSWORD = "mima_0001"

# Name: EMCONFIGURATION

# Datatype: String

# Description: Enterprise Manager Configuration Type

# Valid values: CENTRAL | LOCAL | ALL | NONE

# Default value: NONE

# Mandatory: No

# EMCONFIGURATION = "NONE"

# Name: DISABLESECURITYCONFIGURATION

# Datatype: String

# Description: Database Security Settings

# Valid values: ALL | NONE | AUDIT | PASSWORD_PROFILE

# Default value: NONE

# Mandatory: No

# DISABLESECURITYCONFIGURATION = "NONE"

# Name: SYSMANPASSWORD

# Datatype: String

# Description: Password for SYSMAN user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if LOCAL specified for EMCONFIGURATION

# SYSMANPASSWORD = "password"

# Name: DBSNMPPASSWORD

# Datatype: String

# Description: Password for DBSNMP user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if EMCONFIGURATION is specified

# DBSNMPPASSWORD = "password"

# Name: CENTRALAGENT

# Datatype: String

# Description: Grid Control Central Agent Oracle Home

# Default value: None

# Mandatory: Yes, if CENTRAL is specified for EMCONFIGURATION

# CENTRALAGENT =

# Name: HOSTUSERNAME

# Datatype: String

# Description: Host user name for EM backup job

# Default value: None

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# HOSTUSERNAME =

# Name: HOSTUSERPASSWORD

# Datatype: String

# Description: Host user password for EM backup job

# Default value: None

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# HOSTUSERPASSWORD=

# Name: BACKUPSCHEDULE

# Datatype: String

# Description: Daily backup schedule in the form of hh:mm

# Default value: 2:00

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# BACKUPSCHEDULE=

# Name: DVOWNERNAME

# Datatype: String

# Description: DataVault Owner

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if DataVault option is chosen

# DVOWNERNAME = ""

# Name: DVOWNERPASSWORD

# Datatype: String

# Description: Password for DataVault Owner

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if DataVault option is chosen

# DVOWNERPASSWORD = ""

# Name: DVACCOUNTMANAGERNAME

# Datatype: String

# Description: DataVault Account Manager

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: No

# DVACCOUNTMANAGERNAME = ""

# Name: DVACCOUNTMANAGERPASSWORD

# Datatype: String

# Description: Password for DataVault Account Manager

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: No

# DVACCOUNTMANAGERPASSWORD = ""

# Name: DATAFILEJARLOCATION

# Datatype: String

# Description: Location of the data file jar

# Valid values: Directory containing compressed datafile jar

# Default value: None

# Mandatory: No

# DATAFILEJARLOCATION =

# Name: DATAFILEDESTINATION

# Datatype: String

# Description: Location of the data file's

# Valid values: Directory for all the database files

# Default value: $ORACLE_BASE/oradata

# Mandatory: No

DATAFILEDESTINATION = lihb_datafiledestination

# Name: RECOVERYAREADESTINATION

# Datatype: String

# Description: Location of the data file's

# Valid values: Recovery Area location

# Default value: $ORACLE_BASE/flash_recovery_area

# Mandatory: No

RECOVERYAREADESTINATION= lihb_recoveryareadestination

# Name: STORAGETYPE

# Datatype: String

# Description: Specifies the storage on which the database is to be created

# Valid values: FS (CFS for RAC), ASM

# Default value: FS

# Mandatory: No

STORAGETYPE=FS

# Name: DISKGROUPNAME

# Datatype: String

# Description: Specifies the disk group name for the storage

# Default value: DATA

# Mandatory: No

# DISKGROUPNAME=DATA

# Name: ASMSNMP_PASSWORD

# Datatype: String

# Description: Password for ASM Monitoring

# Default value: None

# Mandatory: No

# ASMSNMP_PASSWORD= ""

# Name: RECOVERYGROUPNAME

# Datatype: String

# Description: Specifies the disk group name for the recovery area

# Default value: RECOVERY

# Mandatory: No

# RECOVERYGROUPNAME=RECOVERY

# Name: CHARACTERSET

# Datatype: String

# Description: Character set of the database

# Valid values: Check Oracle11g National Language Support Guide

# Default value: "US7ASCII"

# Mandatory: NO

CHARACTERSET = "lihb_characterset"

# Name: NATIONALCHARACTERSET

# Datatype: String

# Description: National Character set of the database

# Valid values: "UTF8" or "AL16UTF16". For details, check Oracle11g National Language Support Guide

# Default value: "AL16UTF16"

# Mandatory: No

NATIONALCHARACTERSET= "AL16UTF16"

# Name: REGISTERWITHDIRSERVICE

# Datatype: Boolean

# Description: Specifies whether to register with Directory Service.

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# REGISTERWITHDIRSERVICE= TRUE

# Name: DIRSERVICEUSERNAME

# Datatype: String

# Description: Specifies the name of the directory service user

# Mandatory: YES, if the value of registerWithDirService is TRUE

# DIRSERVICEUSERNAME= "name"

# Name: DIRSERVICEPASSWORD

# Datatype: String

# Description: The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory: YES, if the value of registerWithDirService is TRUE

# DIRSERVICEPASSWORD= "password"

# Name: WALLETPASSWORD

# Datatype: String

# Description: The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory: YES, if the value of registerWithDirService is TRUE

# WALLETPASSWORD= "password"

# Name: LISTENERS

# Datatype: String

# Description: Specifies list of listeners to register the database with.

# By default the database is configured for all the listeners specified in the

# $ORACLE_HOME/network/admin/listener.ora

# Valid values: The list should be space separated names like "listener1 listener2".

# Mandatory: NO

LISTENERS = "LISTENER"

# Name: VARIABLESFILE

# Datatype: String

# Description: Location of the file containing variable value pair

# Valid values: A valid file-system file. The variable value pair format in this file

# is =. Each pair should be in a new line.

# Default value: None

# Mandatory: NO

# VARIABLESFILE =

# Name: VARIABLES

# Datatype: String

# Description: comma separated list of name=value pairs. Overrides variables defined in variablefile and templates

# Default value: None

# Mandatory: NO

# VARIABLES =

# Name: INITPARAMS

# Datatype: String

# Description: comma separated list of name=value pairs. Overrides initialization parameters defined in templates

# Default value: None

# Mandatory: NO

# INITPARAMS =

# Name: SAMPLESCHEMA

# Datatype: Boolean

# Description: Specifies whether or not to add the Sample Schemas to your database

# Valid values: TRUE\ FALSE

# Default value: FASLE

# Mandatory: No

# SAMPLESCHEMA=TRUE

# Name: MEMORYPERCENTAGE

# Datatype: String

# Description: percentage of physical memory for Oracle

# Default value: None

# Mandatory: NO

# MEMORYPERCENTAGE = "40"

# Name: DATABASETYPE

# Datatype: String

# Description: used for memory distribution when MEMORYPERCENTAGE specified

# Valid values: MULTIPURPOSE | DATA_WAREHOUSING | OLTP

# Default value: MULTIPURPOSE

# Mandatory: NO

# DATABASETYPE = "MULTIPURPOSE"

# Name: AUTOMATICMEMORYMANAGEMENT

# Datatype: Boolean

# Description: flag to indicate Automatic Memory Management is used

# Valid values: TRUE/FALSE

# Default value: TRUE

# Mandatory: NO

# AUTOMATICMEMORYMANAGEMENT = "TRUE"

# Name: TOTALMEMORY

# Datatype: String

# Description: total memory in MB to allocate to Oracle

# Valid values:

# Default value:

# Mandatory: NO

TOTALMEMORY = "lihb_totalmemory"

#-* End of CREATEDATABASE section * *

# createTemplateFromDB section is used when OPERATION_TYPE is defined as "createTemplateFromDB".

[createTemplateFromDB]

# Name: SOURCEDB

# Datatype: String

# Description: The source database from which to create the template

# Valid values: The format is::

# Default value: none

# Mandatory: YES

SOURCEDB = "myhost:1521:orcl"

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES

SYSDBAUSERNAME = "system"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value: none

# Mandatory: YES

# SYSDBAPASSWORD = "password"

# Name: TEMPLATENAME

# Datatype: String

# Description: Name for the new template.

# Default value: None

# Mandatory: Yes

TEMPLATENAME = "My Copy TEMPLATE"

#-* End of createTemplateFromDB section * *

# createCloneTemplate section is used when OPERATION_TYPE is defined as "createCloneTemplate".

[createCloneTemplate]

# Name: SOURCEDB

# Datatype: String

# Description: The source database is the SID from which to create the template.

# This database must be local and on the same ORACLE_HOME.

# Default value: none

# Mandatory: YES

SOURCEDB = "orcl"

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES, if no OS authentication

# SYSDBAUSERNAME = "sys"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value: none

# Mandatory: YES

# SYSDBAPASSWORD = "password"

# Name: TEMPLATENAME

# Datatype: String

# Description: Name for the new template.

# Default value: None

# Mandatory: Yes

TEMPLATENAME = "My Clone TEMPLATE"

# Name: DATAFILEJARLOCATION

# Datatype: String

# Description: Location of the data file jar

# Valid values: Directory where the new compressed datafile jar will be placed

# Default value: $ORACLE_HOME/assistants/dbca/templates

# Mandatory: NO

# DATAFILEJARLOCATION =

#-* End of createCloneTemplate section * *

# DELETEDATABASE section is used when DELETE_TYPE is defined as "deleteDatabase".

[DELETEDATABASE]

# Name: SOURCEDB

# Datatype: String

# Description: The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value: none

# Mandatory: YES

SOURCEDB = "orcl"

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES, if no OS authentication

# SYSDBAUSERNAME = "sys"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value: none

# Mandatory: YES, if no OS authentication

# SYSDBAPASSWORD = "password"

#-* End of deleteDatabase section * *

# GENERATESCRIPTS section

[generateScripts]

# Name: TEMPLATENAME

# Datatype: String

# Description: Name of the template

# Valid values: Template name as seen in DBCA

# Default value: None

# Mandatory: Yes

TEMPLATENAME = "New Database"

# Name: GDBNAME

# Datatype: String

# Description: Global database name of the database

# Valid values:. -when database domain isn't NULL

#-when database domain is NULL

# Default value: None

# Mandatory: Yes

GDBNAME = "lihb_gdbname"

# Name: SCRIPTDESTINATION

# Datatype: String

# Description: Location of the scripts

# Valid values: Directory for all the scripts

# Default value: None

# Mandatory: No

# SCRIPTDESTINATION =

#-* End of deleteDatabase section * *

# CONFIGUREDATABASE section is used when OPERATION_TYPE is defined as "configureDatabase".

[CONFIGUREDATABASE]

# Name: SOURCEDB

# Datatype: String

# Description: The source database is the SID

# This database must be local and on the same ORACLE_HOME.

# Default value: none

# Mandatory: YES

# SOURCEDB = "orcl"

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES, if no OS authentication

# SYSDBAUSERNAME = "sys"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# You can also specify the password at the command prompt instead of here.

# Default value: none

# Mandatory: YES, if no OS authentication

# SYSDBAPASSWORD =

# Name: REGISTERWITHDIRSERVICE

# Datatype: Boolean

# Description: Specifies whether to register with Directory Service.

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# REGISTERWITHDIRSERVICE= TRUE

# Name: UNREGISTERWITHDIRSERVICE

# Datatype: Boolean

# Description: Specifies whether to unregister with Directory Service.

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# UNREGISTERWITHDIRSERVICE= TRUE

# Name: REGENERATEDBPASSWORD

# Datatype: Boolean

# Description: Specifies whether regenerate database password in OID/Wallet

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# REGENERATEDBPASSWORD= TRUE

# Name: DIRSERVICEUSERNAME

# Datatype: String

# Description: Specifies the name of the directory service user

# Mandatory: YES, if the any of the reg/unreg/regenPasswd options specified

# DIRSERVICEUSERNAME= "name"

# Name: DIRSERVICEPASSWORD

# Datatype: String

# Description: The password of the directory service user.

# You can also specify the password at the command prompt instead of here.

# Mandatory: YES, if the any of the reg/unreg/regenPasswd options specified

# DIRSERVICEPASSWORD= "password"

# Name: WALLETPASSWORD

# Datatype: String

# Description: The password for wallet to created or modified.

# You can also specify the password at the command prompt instead of here.

# Mandatory: YES, if the any of the reg/unreg/regenPasswd options specified

# WALLETPASSWORD= "password"

# Name: DISABLESECURITYCONFIGURATION

# Datatype: String

# Description: Database Security Settings

# Valid values: ALL | NONE | AUDIT | PASSWORD_PROFILE

# Default value: NONE

# Mandatory: No

# DISABLESECURITYCONFIGURATION = "NONE"

# Name: ENABLESECURITYCONFIGURATION

# Datatype: String

# Description: Database Security Settings

# Valid values: true | false

# Default value: true

# Mandatory: No

# ENABLESECURITYCONFIGURATION = "true"

# Name: EMCONFIGURATION

# Datatype: String

# Description: Enterprise Manager Configuration Type

# Valid values: CENTRAL | LOCAL | ALL | NONE

# Default value: NONE

# Mandatory: No

# EMCONFIGURATION = "NONE"

# Name: SYSMANPASSWORD

# Datatype: String

# Description: Password for SYSMAN user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if LOCAL specified for EMCONFIGURATION

# SYSMANPASSWORD = "password"

# Name: DBSNMPPASSWORD

# Datatype: String

# Description: Password for DBSNMP user

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes, if EMCONFIGURATION is specified

# DBSNMPPASSWORD = "password"

# Name: CENTRALAGENT

# Datatype: String

# Description: Grid Control Central Agent Oracle Home

# Default value: None

# Mandatory: Yes, if CENTRAL is specified for EMCONFIGURATION

# CENTRALAGENT =

# Name: HOSTUSERNAME

# Datatype: String

# Description: Host user name for EM backup job

# Default value: None

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# HOSTUSERNAME =

# Name: HOSTUSERPASSWORD

# Datatype: String

# Description: Host user password for EM backup job

# Default value: None

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# HOSTUSERPASSWORD=

# Name: BACKUPSCHEDULE

# Datatype: String

# Description: Daily backup schedule in the form of hh:mm

# Default value: 2:00

# Mandatory: Yes, if ALL is specified for EMCONFIGURATION

# BACKUPSCHEDULE=

#-* End of CONFIGUREDATABASE section * *

# ADDINSTANCE section is used when OPERATION_TYPE is defined as "addInstance".

[ADDINSTANCE]

# Name: DB_UNIQUE_NAME

# Datatype: String

# Description: DB Unique Name of the RAC database

# Valid values:

# Default value: None

# Mandatory: Yes

DB_UNIQUE_NAME = "orcl11g.us.oracle.com"

# Name: INSTANCENAME

# Datatype: String

# Description: RAC instance name to be added

# Valid values: Check Oracle11g Administrator's Guide

# Default value: +

# Mandatory: No

# INSTANCENAME = "orcl1"

# Name: NODELIST

# Datatype: String

# Description: Node on which to add new instance

# (in 10gR2, instance addition is supported on 1 node at a time)

# Valid values: Cluster node name

# Default value: None

# Mandatory: Yes

NODELIST=

# Name: OBFUSCATEDPASSWORDS

# Datatype: Boolean

# Description: Set to true if passwords are encrypted

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# OBFUSCATEDPASSWORDS = FALSE

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES

SYSDBAUSERNAME = "sys"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# Default value: none

# Mandatory: YES

# SYSDBAPASSWORD = "password"

#-* End of ADDINSTANCE section * *

# DELETEINSTANCE section is used when OPERATION_TYPE is defined as "deleteInstance".

[DELETEINSTANCE]

# Name: DB_UNIQUE_NAME

# Datatype: String

# Description: DB Unique Name of the RAC database

# Valid values:

# Default value: None

# Mandatory: Yes

DB_UNIQUE_NAME = "orcl11g.us.oracle.com"

# Name: INSTANCENAME

# Datatype: String

# Description: RAC instance name to be deleted

# Valid values: Check Oracle11g Administrator's Guide

# Default value: None

# Mandatory: Yes

INSTANCENAME = "orcl11g"

# Name: NODELIST

# Datatype: String

# Description: Node on which instance to be deleted (SID) is located

# Valid values: Cluster node name

# Default value: None

# Mandatory: No

# NODELIST=

# Name: OBFUSCATEDPASSWORDS

# Datatype: Boolean

# Description: Set to true if passwords are encrypted

# Valid values: TRUE\ FALSE

# Default value: FALSE

# Mandatory: No

# OBFUSCATEDPASSWORDS = FALSE

# Name: SYSDBAUSERNAME

# Datatype: String

# Description: A user with DBA role.

# Default value: none

# Mandatory: YES

SYSDBAUSERNAME = "sys"

# Name: SYSDBAPASSWORD

# Datatype: String

# Description: The password of the DBA user.

# Default value: none

# Mandatory: YES

# SYSDBAPASSWORD = "password"

#-* End of DELETEINSTANCE section * *

Here are the details of netca.rsp:

Click (here) to collapse or open

# # Specify values for the variables listed below to customize your # #

# # installation. # #

# # Each variable is associated with a comment. The comment # #

# # identifies the variable type. # #

# # Please specify the values in the following format: # #

# # Type Example # #

# # String "Sample Value" # #

# # Boolean True or False # #

# # Number 1000 # #

# # StringList {"String value 1", "String Value 2"} # #

# # This sample response file causes the Oracle Net Configuration # #

# # Assistant (NetCA) to complete an Oracle Net configuration during # #

# # a custom install of the Oracle11g server which is similar to # #

# # what would be created by the NetCA during typical Oracle11g # #

# # install. It also documents all of the NetCA response file # #

# # variables so you can create your own response file to configure # #

# # Oracle Net during an install the way you wish. # #

[GENERAL]

RESPONSEFILE_VERSION= "11.2"

CREATE_TYPE= "CUSTOM"

# Name: SHOW_GUI

# Datatype: Boolean

# Description: This variable controls appearance/suppression of the NetCA GUI

# Pre-req: N/A

# Default: TRUE

# Note:

# This must be set to false in order to run NetCA in silent mode.

# This is a substitute of "/ silent" flag in the NetCA command line.

# The command line flag has precedence over the one in this response file.

# This feature is present since 10.1.0.3.

# SHOW_GUI=false

# Name: LOG_FILE

# Datatype: String

# Description: If present, NetCA will log output to this file in addition to the

# standard out.

# Pre-req: N/A

# Default: NONE

# Note:

# This is a substitute of "/ log" in the NetCA command line.

# The command line argument has precedence over the one in this response file.

# This feature is present since 10.1.0.3.

# LOG_FILE= "" / oracle11gHome/network/tools/log/netca.log ""

[oracle.net.ca]

# INSTALLED_COMPONENTS;StringList;list of installed components

# The possible values for installed components are:

# "net8", "server", "client", "aso", "cman", "javavm"

INSTALLED_COMPONENTS= {"server", "net8", "javavm"}

# INSTALL_TYPE;String;type of install

# The possible values for install type are:

# "typical", "minimal" or "custom"

INSTALL_TYPE= "" typical ""

# LISTENER_NUMBER;Number;Number of Listeners

# A typical install sets one listener

LISTENER_NUMBER=1

# LISTENER_NAMES;StringList;list of listener names

# The values for listener are:

# "LISTENER", "LISTENER1", "LISTENER2", "LISTENER3"

# A typical install sets only "LISTENER"

LISTENER_NAMES= {"LISTENER"}

# LISTENER_PROTOCOLS;StringList;list of listener addresses (protocols and parameters separated by semicolons)

# The possible values for listener protocols are:

# "TCP;1521", "TCPS;2484", "NMP;ORAPIPE", "IPC;IPCKEY", "VI;1521"

# A typical install sets only "TCP;1521"

LISTENER_PROTOCOLS= {"TCP;1521"}

# LISTENER_START;String;name of the listener to start, in double quotes

LISTENER_START= "" LISTENER ""

# NAMING_METHODS;StringList;list of naming methods

# The possible values for naming methods are:

# LDAP, TNSNAMES, ONAMES, HOSTNAME, NOVELL, NIS, DCE

# A typical install sets only: "TNSNAMES", "ONAMES", "HOSTNAMES"

# or "LDAP", "TNSNAMES", "ONAMES", "HOSTNAMES" for LDAP

NAMING_METHODS= {"TNSNAMES", "ONAMES", "HOSTNAME"}

# NOVELL_NAMECONTEXT;String;Novell Directory Service name context, in double quotes

# A typical install does not use this variable.

# NOVELL_NAMECONTEXT = "" NAMCONTEXT ""

# SUN_METAMAP;String; SUN meta map, in double quotes

# A typical install does not use this variable.

# SUN_METAMAP = "" MAP ""

# DCE_CELLNAME;String;DCE cell name, in double quotes

# A typical install does not use this variable.

# DCE_CELLNAME = "" CELL ""

# NSN_NUMBER;Number;Number of NetService Names

# A typical install sets one net service name

NSN_NUMBER=1

# NSN_NAMES;StringList;list of Net Service names

# A typical install sets net service name to "EXTPROC_CONNECTION_DATA"

NSN_NAMES= {"EXTPROC_CONNECTION_DATA"}

# NSN_SERVICE;StringList;Oracle11g database's service name

# A typical install sets Oracle11g database's service name to "PLSExtProc"

NSN_SERVICE= {"PLSExtProc"}

# NSN_PROTOCOLS;StringList;list of coma separated strings of Net Service Name protocol parameters

# The possible values for net service name protocol parameters are:

# "TCP;HOSTNAME;1521", "TCPS;HOSTNAME;2484", "NMP;COMPUTERNAME;ORAPIPE", "VI;HOSTNAME;1521", "IPC;IPCKEY"

# A typical install sets parameters to "IPC;EXTPROC"

NSN_PROTOCOLS= {"TCP;HOSTNAME;1521"}

The above is all the contents of the article "how to automatically install a single instance of oracle11g in rhel6/7". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.