# allow root ssh
\n1) Modify PermitRootLogin to yes in \/etc\/ssh\/sshd_config.
\n2) Comment out the \u201cCONSOLE=\/dev\/console\u201d line in \/etc\/default\/login.
\n3) Remove \u201ctype=role\u201d from the root entry in \/etc\/user_attr.<\/p>\n
# for ssh X11 forwarding
\npkg install xauth
\n\/etc\/ssh\/sshd_config:
\n # X11 tunneling options
\n X11Forwarding yes
\n X11DisplayOffset 10
\n X11UseLocalhost yes<\/p>\n
svcadm restart svc:\/network\/ssh:default<\/p>\n
# check network cards
\ndladm show-phys
\ndladm show-link
\nipadm show-if
\nipadm show-addr<\/p>\n
# change profile to fixed
\nnetadm enable -p ncp DefaultFixed<\/p>\n
# setup network to public network
\nipadm create-ip net0
\nipadm create-addr -T static -a 192.168.1.19\/24 net0\/acme
\nsvccfg -s network\/dns\/client setprop config\/nameserver=net_address: “(192.168.1.1)”<\/p>\n
root@solaris:~# svccfg
\nsvc:> select dns\/client<\/p>\n
svc:\/network\/dns\/client> select dns\/client
\nsvc:\/network\/dns\/client> setprop config\/nameserver=net_address: “(192.168.1.1)”
\nsvc:\/network\/dns\/client> refresh
\nsvc:\/network\/dns\/client> validate<\/p>\n
svc:\/network\/dns\/client> select name-service\/switch
\nsvc:\/system\/name-service\/switch> setprop config\/host = astring: “files dns”
\nsvc:\/system\/name-service\/switch> refresh
\nsvc:\/system\/name-service\/switch> validate<\/p>\n
# set defaultrouter\/nameserver:
\necho “192.168.1.1” >> \/etc\/defaultrouter
\necho “192.168.1.1” >> \/etc\/resolv.conf<\/p>\n
# setup network to storage network
\ndladm set-linkprop -p mtu=9000 net1
\nipadm create-ip net1
\nipadm create-addr -T static -a 192.168.100.19\/24 net1\/acme<\/p>\n
# user and groups
\ngroupadd -g 1000 oinstall
\ngroupadd -g 1001 dba
\nuseradd -u 1000 -g oinstall -G dba -m oracle
\nmkdir -p \/app\/11.2.0\/grid
\nmkdir -p \/app\/oracle
\nchown -R oracle:oinstall \/app
\nchmod -R 775 \/app\/<\/p>\n
# set swap to ram=swap size (for below 16g RAM, for more than 16g RAM set swap fix to 16g)
\nzfs set volsize=4g rpool\/swap<\/p>\n
# packages
\npkg install SUNWarc
\npkg install SUNWbtool
\npkg install SUNWcsl
\npkg install SUNWhea
\npkg install SUNWlibC
\npkg install SUNWlibm
\npkg install SUNWlibms
\npkg install SUNWsprot
\npkg install SUNWtoo
\npkg install SUNWi1cs
\npkg install SUNWi15cs
\npkg install motif<\/p>\n
# 12.1.0.2
\npkg install x11-info-clients<\/p>\n
file-descriptor-limit:
\n add a line to \/etc\/system and reboot:
\n set rlim_fd_max=1024<\/p>\n
# allow oracle user to use more than 25% of system memory (execute as root user!)
\nprojadd -p 100 -c ‘Oracle Database’ -U oracle -G dba -K ‘project.max-shm-memory=(privileged,3G,deny)’ DB
\nusermod -K project=DB oracle<\/p>\n
# iscsi static connect for asm disks
\niscsiadm add static-config iqn.2013-06.nas.solarisvm.asm,192.168.100.8:3260
\niscsiadm modify discovery –static enable<\/p>\n
<\/p>\n
# prepare local disk for ASM
\nformat
\nAVAILABLE DISK SELECTIONS:
\n0. c8t0d0 <IET-VIRTUAL-DISK-0001-40.00GB>
\n\/pci@0,0\/pci15ad,1976@10\/sd@0,0
\n1. c8t1d0 <IET-VIRTUAL-DISK-0001 cyl 2046 alt 2 hd 128 sec 32>
\n\/pci@0,0\/pci15ad,1976@10\/sd@1,0
\n2. c8t2d0 <IET-VIRTUAL-DISK-0001 cyl 5219 alt 2 hd 255 sec 63>
\n\/pci@0,0\/pci15ad,1976@10\/sd@2,0
\n3. c8t3d0 <IET-VIRTUAL-DISK-0001 cyl 5219 alt 2 hd 255 sec 63>
\n\/pci@0,0\/pci15ad,1976@10\/sd@3,0
\n4. c8t4d0 <IET-VIRTUAL-DISK-0001 cyl 5219 alt 2 hd 255 sec 63>
\n\/pci@0,0\/pci15ad,1976@10\/sd@4,0<\/p>\n
format> fdisk
\nformat> label
\nformat> partition
\npartition> p<\/p>\n
Volume: ASM00D1
\nCurrent partition table (original):
\nTotal disk cylinders available: 5218 + 2 (reserved cylinders)<\/p>\n
Part Tag Flag Cylinders Size Blocks
\n0 unassigned wm 0 0 (0\/0\/0) 0
\n1 unassigned wm 0 0 (0\/0\/0) 0
\n2 backup wu 0 – 5217 39.97GB (5218\/0\/0) 83827170
\n3 unassigned wm 0 0 (0\/0\/0) 0
\n4 unassigned wm 0 0 (0\/0\/0) 0
\n5 unassigned wm 0 0 (0\/0\/0) 0
\n6 unassigned wm 0 0 (0\/0\/0) 0
\n7 unassigned wm 0 0 (0\/0\/0) 0
\n8 boot wu 0 – 0 7.84MB (1\/0\/0) 16065
\n9 unassigned wm 0 0 (0\/0\/0) 0<\/p>\n
partition> 0<\/p>\n
Enter partition id tag[unassigned]: usr
\nEnter partition permission flags[wm]:
\nEnter new starting cyl[1]:
\nEnter partition size[0b, 0c, 1e, 0.00mb, 0.00gb]: 5217c
\npartition> label
\nReady to label disk, continue? y<\/p>\n
# change owner and permission for disks
\nchown oracle:oinstall \/dev\/rdsk\/c8t1d0s0
\nchmod 660 \/dev\/rdsk\/c8t1d0s0<\/p>\n
# add a new disk to an existing diskgroup:<\/p>\n
> sqlplus \/ as sysasm<\/p>\n
SQL> select name, path from v$asm_disk;<\/p>\n
NAME
\n——————————
\nPATH
\n——————————————————————————–<\/p>\n
\/dev\/rdsk\/c8t6d0s0<\/strong><\/p>\n DATA_0003 DATA_0001 DATA_0004 <\/p>\n","protected":false},"excerpt":{"rendered":" # allow root ssh 1) Modify PermitRootLogin to yes in \/etc\/ssh\/sshd_config. 2) Comment out the \u201cCONSOLE=\/dev\/console\u201d line in \/etc\/default\/login. 3) Remove \u201ctype=role\u201d from the root entry in \/etc\/user_attr. # for ssh X11 forwarding pkg install xauth \/etc\/ssh\/sshd_config: # X11 tunneling options X11Forwarding yes X11DisplayOffset 10 X11UseLocalhost yes svcadm restart svc:\/network\/ssh:default # check network cards dladm … Continue reading Setup Solaris 11.1 \/ 11.2 for Oracle Database with ASM<\/span>
\n\/dev\/rdsk\/c8t2d0s0<\/p>\n
\n\/dev\/rdsk\/c8t3d0s0
\nNAME
\n——————————
\nPATH
\n——————————————————————————–
\nDATA_0002
\n\/dev\/rdsk\/c8t4d0s0<\/p>\n
\n\/dev\/rdsk\/c8t5d0p0
\nSQL> alter diskgroup data add disk ‘\/dev\/rdsk\/c8t6d0s0’;<\/p>\n