Shulou(Shulou.com)06/01 Report--

1 、 To Find Swap, RAM, and OS Version

For Solaris operating system, check the methods of Swap, RAM, and OS Version:

Swap-l

/ usr/sbin/prtconf | grep-I memory

Uname-r

2 、 To Determine the Unix Kernel Parameters

Solaris

/ etc/system

COMMAND TO SEARCH

"/ etc/sysdef | grep SHM" or "/ etc/sysdef | grep SEM"

3. Allocation of resources

# id-p oracle

Uid=1001 (oracle) gid=1003 (oinstall) projid=3 (default)

# projadd-U oracle-p 1001-c "Oracle Kernel Parameters Setting" user.oracle

Where:

-U: specifies the list of users applied to the project.

-c: description of the project.

-p: non-negative integer, item ID number.

# id-p oracle

Uid=1001 (oracle) gid=1003 (oinstall) projid=1001 (user.oracle)

# projmod-a-K "project.max-shm-memory= (priv,17179869184,deny)" user.oracle (set maximum shared memory to 12G, system physical memory to 32G, in bytes.)

# projmod-a-K "project.max-shm-memory= (priv,1073741824,deny)" user.oracle (set maximum shared memory to 1G, system physical memory to 2G, in bytes.)

# projmod-a-K "project.max-sem-ids= (priv,100,deny)" user.oracle

# projmod-a-K "process.max-sem-nsems= (priv,256,deny)" user.oracle

# projmod-a-K "project.max-shm-ids= (priv,100,deny)" user.oracle

=

The second article on installation:

# the following operations are performed in the environment of ROOT users

# switch to root user

Su root

# set virtual memory

Zfs set volsize=4G rpool/swap

Zfs list

# set fixed IP

Netadm list

Netadm enable-p ncp DefaultFixed

Ipadm create-ip net0

Ipadm show-addr

Ipadm delete-addr net0/v4

Ipadm create-addr-T static-a 192.168.56.111 Universe 24 net0/v4

Route-p add default 192.168.1.1-ifp net0

Netstat-rn

# set DNS

Svccfg-s dns/client

Setprop config/nameserver = (8.8.8.8 114.114.114.114)

Listprop config

Svcadm refresh dns/client

Svcadm restart dns/client

Svccfg-s name-service/switch

Setprop config/host= "files dns"

Listprop config

# create a directory:

Mkdir-p / export/home/oracle

# establish oracle users and dba,oinstall user groups

Groupadd dba

Groupadd oinstall

Useradd-g oinstall-G dba-m-d / export/home/oracle-s / usr/bin/bash oracle

Passwd oracle

Chown-R oracle:dba / export/home/oracle

# set system kernel parameters

Projadd-U oracle user.oracle

Projmod-a murk "project.max-shm-memory= (priv,4g,deny)" user.oracle

Projmod-a murk "project.max-sem-ids= (priv,100,deny)" user.oracle

Projmod-a murk "process.max-sem-nsems= (priv,500,deny)" user.oracle

Projmod-a murk "project.max-shm-ids= (priv,100,deny)" user.oracle

# View system kernel parameters

Cat / etc/project

# set system network parameters

Ipadm set-prop-p smallest_anon_port=9000 tcp

Ipadm set-prop-p largest_anon_port=65500 tcp

Ipadm set-prop-p smallest_anon_port=9000 udp

Ipadm set-prop-p largest_anon_port=65500 udp

# View system network parameters

Ipadm show-prop | grep anon | egrep 'tcp | udp'

# load solaris11 offline package

Mount-F hsfs / export/home/solaris/sol-11_2-repo.iso / mnt

Pkg publisher

Pkg set-publisher-G'*'- g / mnt/repo solaris

Pkg publisher

# check the package

Pkginfo-i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWpool SUNWpoolr SUNWsprot SUNWtoo SUNWuiu8 SUNWmfrun SUNWxwfsw SUNWxwplt SUNWi1cs SUNWi15cs assembler

# install the package

Pkg install compatibility/packages/SUNWxwplt SUNWmfrun SUNWhea SUNWi1cs SUNWi15cs assembler

# the following operations are performed in the environment of oracle users

# switch to oracle user (log in to X Desktop with oracle username)

# decompress the oracle package

Unzip solaris.x64_11gR2_database_1of2-d / export/home/oracle/

Unzip solaris.x64_11gR2_database_2of2-d / export/home/oracle/

# set oracle user database startup parameters: the following operations are performed in the oracle user environment

Vi .profile

ORACLE_BASE=/export/home/oracle/app/oracle;export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0;export ORACLE_HOME

ORACLE_SID=testdb

TMP=/tmp;export TMP

TMPDIR=/tmp;export TMPDIR

LD_LIBRARY_PATH=$ORACLE_HOME/lib

PATH=$PATH:/usr/bin:/usr/sbin:$ORACLE_HOME/bin

Export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH

Umask 022

# on the X desktop

Cd database

Export DISPLAY=192.168.17.1:0.0

. / runInstaller-ignoreSysPrereqs-force-ignorePrereq

# the following operations are performed in the environment of root users

# switch to root user

Su solaris

Su root

# execute Oracle 11Gr2 to complete the installation script

/ export/home/oracle/app/oraInventory/orainstRoot.sh

/ export/home/oracle/app/oracle/product/11.2.0/dbhome_1/root.sh

-- the following can be configured without configuration:

# set oracle 11g to start automatically

1: build / etc/init.d/oracle

Vi / etc/init.d/oracle

#! / usr/sbin/sh

Case "$1" in

'start')

Su-oracle-c "dbstart" &

Su-oracle-c "emctl start dbconsole" &

'stop')

Su-oracle-c "emctl stop dbconsole" &

Su-oracle-c "dbshut" &

*)

Echo "Usage: $0 {start | stop}"

Exit 1

Esac

2: connect the file to the startup item

Ln-s / etc/init.d/oracle / etc/rc2.d/S100oracle

Ln-s / etc/init.d/oracle / etc/rc3.d/S100oracle

Ln-s / etc/init.d/oracle / etc/rc0.d/K100oracle

3 modify "N" in / var/opt/oracle/oratab to "Y"

Vi / var/opt/oracle/oratab

4 modify dbstart dbshut script

Vi / export/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbstart

# ORACLE_HOME_LISTNER=$1

ORACLE_HOME_LISTNER=$ORACLE_HOME

Export ORACLE_HOME_LISTNER

Vi / export/home/oracle/app/oracle/product/11.2.0/dbhome_1/bin/dbshut

# ORACLE_HOME_LISTNER=$1

ORACLE_HOME_LISTNER=$ORACLE_HOME

Export ORACLE_HOME_LISTNER

# View ORACLE 11G process

Ps-ef | grep tnslsnr

Ps-ef | grep-I "ora_"

# Database EM

Emctl start dbconsole

Emctl stop dbconsole

Emctl status dbconsole

=

Solaris 11 install Oracle 11GR2 RAC

The installation process is divided into the following four steps

First, installation preparation

Second, lower installation

Third, related settings

Fourth, common mistakes

First, installation preparation

1, "build oracle"

Log in with root, and create the oracle user and the dba group it belongs to

Su-

# groupadd dba

# groupadd oinstall

# groupadd asmdba

# groupadd asmadmin

# useradd-g oinstall-G dba,asmdba,asmadmin-m-d / export/home/oracle-s / usr/bin/bash oracle

# passwd oracle

2. Set system parameters

Execute the following command

# projadd-U oracle-K "project.max-shm-memory= (priv,5g,deny)" user.oracle

# projmod-sK "project.max-sem-nsems= (priv,512,deny)" user.oracle

# projmod-sK "project.max-sem-ids= (priv,128,deny)" user.oracle

# projmod-sK "project.max-shm-ids= (priv,128,deny)" user.oracle

The configuration can be checked through the "prctl-I project user.oracle" command

Execute the following command

# ipadm set-prop-p smallest_anon_port=9000 tcp

# ipadm set-prop-p largest_anon_port=65500 tcp

# ipadm set-prop-p smallest_anon_port=9000 udp

# ipadm set-prop-p largest_anon_port=65500 udp

Concurrent authentication

# ipadm show-prop | grep anon | egrep 'tcp | udp'

Tcp largest_anon_port rw 65500 65500 65535 1024-65535

Tcp smallest_anon_port rw 9000 9000 32768 1024-65535

Udp largest_anon_port rw 65500 65500 65535 1024-65535

Udp smallest_anon_port rw 9000 9000 32768 1024-65535

Edit / etc/ssh/sshd_config with root and modify the LoginGraceTime value to 0

LoginGraceTime 0

Import configuration

# svcadm restart ssh

3, build the oracle directory

# mkdir / opt/oracle

# mkdir / opt/oracle/112

# mkdir / opt/grid/112

# chown-R oracle:dba / opt/oracle

# chown-R oracle:dba / opt/grid

4. Set up oracle environment capacity.

Edit / home/oracle/.bash_profile and add the following lines:

ORACLE_BASE=/opt/oracle

ORACLE_HOME=$ORACLE_BASE/112

ORACLE_SID=ORA11GR2

CRS_HOME=/opt/grid/112

LD_LIBRARY_PATH=$ORACLE_HOME/lib:$CRS_HOME/lib

PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin:$CRS_HOME/bin

Export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH

After saving, the configuration takes effect through the following command

Su-oracle

Cd / home/oracle

. .bash _ profile

Second, lower installation

1. Configure and install required packages

Download "repository" image file

The following address:

Http://download.oracle.com/otn/solaris/express/sol-11-exp-201011-repo-full-iso-a.zip

Http://download.oracle.com/otn/solaris/express/sol-11-exp-201011-repo-full-iso-b.zip

Unscramble the file:

Unzip sol-11-exp-201011-repo-full-iso-a.zip

Unzip sol-11-exp-201011-repo-full-iso-b.zip

Combination file

Cat sol-11-exp-201011-repo-full.iso-a sol-11-exp-201011-repo-full.iso-b > sol-11-exp-201011-repo-full.iso

The image of a man.

# mount-F hsfs-o ro `lofiadm-a / home/oracle/sol-11-exp-201011-repo- full.iso` / mnt

Set the profile to local repository

# pkg set-publisher-Pe-O file:///mnt/repo/ solaris

Or use online repository

# pkg set-publisher-Pe-O http://pkg.oracle.com/solaris/release solaris

Carry out a package inspection

# pkginfo-i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWpool SUNWpoolr SUNWsprot SUNWtoo SUNWuiu8 SUNWfont-xorg-core SUNWfont-xorg-iso8859-1 SUNWmfrun SUNWxorg-client-programs SUNWxorg-clientlibs SUNWxwfsw SUNWxwplt

Packages: package SUNWbtool SUNWlibms SUNWpool SUNWpoolr SUNWsprot SUNWtoo SUNWuiu8 is generally installed by default

Carry out the installation of spare packages

# pkg install compatibility/packages/SUNWxwplt SUNWmfrun SUNWarc SUNWhea SUNWlibm

2, lower oracle 11g

The following address:

Http://www.oracle.com/technology/software/products/database/oracle11g/112010_sparc_x64soft.html

For Grid (CRS)

Unzip solaris.x64_11gR2_grid.zip

For database

Unzip solaris.x64_11gR2_database_1of2.zip

Unzip solaris.x64_11gR2_database_2of2.zip

3, for installation

For Grid (CRS)

Cd grid

. / runInstaller

For database

Cd database

. / runInstaller

Third, related configuration

1, use root to run the following script

# / opt/oracle/oraInventory/orainstRoot.sh

# / opt/oracle/102/root.sh

Fourth, common mistakes

1, error: [INS-13001] Environment does meet minimum requirements. Are you sure you want to continue?

Download oracle 10098816 and install it

2, error: Checking monitor: must be configured to display at least 256colors > > Could not execute auto check for display colors using command / usr/openwin/bin/xdpyinfo. Check if the DISPLAY variable is set. Failed

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.