CREATE the ASM for ORACLE on Solaris 10!

最新推荐文章于 2025-08-08 00:05:28 发布
最新推荐文章于 2025-08-08 00:05:28 发布 · 115 阅读 · 0
文章标签：

#数据库 #操作系统

# df -h
Filesystem size used avail capacity Mounted on
/dev/dsk/c0d0s0 4.6G 4.3G 265M 95% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 1.1G 928K 1.1G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
sharefs 0K 0K 0K 0% /etc/dfs/sharetab
/usr/lib/libc/libc_hwcap1.so.1
4.6G 4.3G 265M 95% /lib/libc.so.1
fd 0K 0K 0K 0% /dev/fd
swap 1.1G 228K 1.1G 1% /tmp
swap 1.1G 60K 1.1G 1% /var/run
/dev/dsk/c0d0s7 3.7G 2.8G 807M 79% /export/home
/vol/dev/dsk/c1t0d0/vmwaretools
1.5M 1.5M 0K 100% /cdrom/vmwaretools
# format
Searching for disks...done


AVAILABLE DISK SELECTIONS:
0. c0d0 <DEFAULT cyl 1171 alt 2 hd 255 sec 63>
/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0
1. c0d1 <VMware V-0000000000000000-0001-4.00GB>
/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0
Specify disk (enter its number): ^C
# zpool create asmdisks c0d1
# df -h
Filesystem size used avail capacity Mounted on
/dev/dsk/c0d0s0 4.6G 4.3G 265M 95% /
/devices 0K 0K 0K 0% /devices
ctfs 0K 0K 0K 0% /system/contract
proc 0K 0K 0K 0% /proc
mnttab 0K 0K 0K 0% /etc/mnttab
swap 1.1G 928K 1.1G 1% /etc/svc/volatile
objfs 0K 0K 0K 0% /system/object
sharefs 0K 0K 0K 0% /etc/dfs/sharetab
/usr/lib/libc/libc_hwcap1.so.1
4.6G 4.3G 265M 95% /lib/libc.so.1
fd 0K 0K 0K 0% /dev/fd
swap 1.1G 228K 1.1G 1% /tmp
swap 1.1G 60K 1.1G 1% /var/run
/dev/dsk/c0d0s7 3.7G 2.8G 807M 79% /export/home
/vol/dev/dsk/c1t0d0/vmwaretools
1.5M 1.5M 0K 100% /cdrom/vmwaretools
asmdisks 3.9G 1K 3.9G 1% /asmdisks
# chown oracle:dba /asmdisks
# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ dd if=/dev/zero of=/asmdisks/_file_disk1 bs=1k count=500000
500000+0 records in
500000+0 records out
$ dd if=/dev/zero of=/asmdisks/_file_disk2 bs=1k count=500000
500000+0 records in
500000+0 records out
$ dd if=/dev/zero of=/asmdisks/_file_disk3 bs=1k count=1000000
1000000+0 records in
1000000+0 records out
$ dd if=/dev/zero of=/asmdisks/_file_disk4 bs=1k count=1000000
1000000+0 records in
1000000+0 records out
$ exit
# lofiadm -a /asmdisks/_file_disk1
/dev/lofi/1
# lofiadm -a /asmdisks/_file_disk2
/dev/lofi/2
# lofiadm -a /asmdisks/_file_disk3
/dev/lofi/3
# lofiadm -a /asmdisks/_file_disk4
/dev/lofi/4
# ls -lL /dev/lofi/*
brw------- 1 root sys 144, 1 May 13 14:59 /dev/lofi/1
brw------- 1 root sys 144, 2 May 13 15:00 /dev/lofi/2
brw------- 1 root sys 144, 3 May 13 15:00 /dev/lofi/3
brw------- 1 root sys 144, 4 May 13 15:00 /dev/lofi/4
# mknod /asmdisks/vdisk1 c 144 1
mknod /asmdisks/vdisk2 c 144 2
mknod /asmdisks/vdisk3 c 144 3
mknod /asmdisks/vdisk4 c 144 4# # #
#
# chown oracle:dba /asmdisks/vdisk1
# chown oracle:dba /asmdisks/vdisk2
# chown oracle:dba /asmdisks/vdisk3
# chown oracle:dba /asmdisks/vdisk4#
# chown oracle:dba /asmdisks/vdisk4
# ps -ef|grep ocssd
oracle 4587 4478 0 14:32:55 ? 0:04 /export/home/oracle/product/10g/bin/ocssd.bin
root 4752 4649 0 15:04:26 pts/1 0:00 grep ocssd
# su - oracle
Sun Microsystems Inc. SunOS 5.10 Generic January 2005
$ mkdir -p $ORACLE_BASE/asm/+ASM/bdump
mkdir -p $ORACLE_BASE/asm/+ASM/cdump
mkdir -p $ORACLE_BASE/asm/+ASM/hdump
$ mkdir -p $ORACLE_BASE/asm/+ASM/pfile
mkdir -p $ORACLE_BASE/asm/+ASM/udump$ $ $
$ more /export/home/oracle/product/10g/dbs/init+ASM.ora
###########################################
# Automatic Storage Management
###########################################
# _asm_allow_only_raw_disks=false
# asm_diskgroups='TESTDB_DATA1'

# Default asm_diskstring values for supported platforms:
# Solaris (32/64 bit) /dev/rdsk/*
# Windows NT/XP //./orcldisk*
# Linux (32/64 bit) /dev/raw/*
# HPUX /dev/rdsk/*
# HPUX(Tru 64) /dev/rdisk/*
# AIX /dev/rhdisk/*
# asm_diskstring=''

#asm_diskstrin 用于定义实例启动时搜索可用的ASM磁盘的路径，这个参数很重要。
#还有另外一个参数asm_diskgroups 用于定义ASM实例启动时自动加载的diskgroups，当CREATE #DISKGROUP时会自动在参数文件里写入。

###########################################
# Diagnostics and Statistics
###########################################
background_dump_dest=$ORACLE_BASE/asm/+ASM/bdump
core_dump_dest=$ORACLE_BASE/asm/+ASM/cdump
user_dump_dest=$ORACLE_BASE/asm/+ASM/udump

###########################################
# Miscellaneous
###########################################
instance_type=asm
compatible=10.1.0.4.0

###########################################
# Pools
###########################################
large_pool_size=12M

###########################################
# Security and Auditing
###########################################
remote_login_passwordfile=exclusive
$ export ORACLE_SID=+ASM
ORACLE_SID=+ASM: is not an identifier
$ ORACLE_SID=+ASM
$ export ORACLE_SID
$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Wed May 13 15:09:21 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> startup

ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1278640 bytes
Variable Size 57441616 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> create spfile from pfile;

File created.

SQL> shutdown immediate
ORA-15100: invalid or missing diskgroup name


ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1278640 bytes
Variable Size 57441616 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted


SQL> show parameter spfile;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /export/home/oracle/product/10
g/dbs/spfile+ASM.ora
bash-3.00# chown -h oracle:dba c0d1
bash-3.00# ls -lrt
total 126
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:a,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:b,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:c,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:d,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:e,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s5 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:f,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s6 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:g,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s7 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:h,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s8 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:i,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s9 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:j,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s10 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:k,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s11 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:l,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s12 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:m,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s13 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:n,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s14 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:o,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0s15 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:p,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0p0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:q,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0p1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:r,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0p2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:s,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0p3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:t,raw
lrwxrwxrwx 1 root root 54 Apr 13 19:34 c0d0p4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@0,0:u,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:a,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:b,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:c,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:d,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:e,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s5 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:f,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s6 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:g,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s7 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:h,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s8 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:i,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s9 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:j,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s10 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:k,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s11 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:l,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s12 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:m,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s13 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:n,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s14 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:o,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0s15 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:p,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0p0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:q,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0p1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:r,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0p2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:s,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0p3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:t,raw
lrwxrwxrwx 1 root root 52 Apr 13 19:34 c1t0d0p4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@1/sd@0,0:u,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:a,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:b,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:c,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:d,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:e,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s5 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:f,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s6 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:g,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s8 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:i,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s9 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:j,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s10 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:k,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s11 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:l,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s12 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:m,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s13 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:n,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s14 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:o,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1s15 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:p,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1p0 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:q,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1p1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:r,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1p2 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:s,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1p3 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:t,raw
lrwxrwxrwx 1 root root 54 Apr 24 14:41 c0d1p4 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:u,raw
lrwxrwxrwx 1 oracle dba 55 May 6 13:19 c0d1 -> ../../devices/pci@0,0/pci-ide@7,1/ide@0/cmdk@1,0:wd,raw
USE the DBCA to creat the ASM diskgroup!
SQL> startup
ASM instance started

Total System Global Area 83886080 bytes
Fixed Size 1278640 bytes
Variable Size 57441616 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

iteye_4537
关注
22、Oracle数据库迁移与非ASM到ASM环境迁移全解析
delta的博客
07-03 20
本文深入解析了Oracle数据库迁移的多种方法，包括异构备用数据库迁移、Oracle Streams迁移，以及从非ASM到ASM环境的三种迁移场景。详细介绍了每种迁移方式的原理、操作步骤、流程图以及适用场景，同时对比了不同迁移方法的优缺点和操作复杂度。通过本文学，读者可以全面了解Oracle数据库迁移的关键技术，并根据实际需求选择最适合的迁移方案，确保迁移过程的安全性与高效性。
Redhat5.4+Oracle 10g RAC+ASM+RAW的安装文档
linghao00的专栏
08-10 6550
基于Redhat 5 和redhat 4 的RAC 区别在对raw的处理上。 之前做的是redhat 4.7 的 RAC 实验。 准备做一个Redhat 5.4 的环境。 RAC 的一些理论东西： http://blog.youkuaiyun.com/tianlesoftware/a
solaris 10 如何挂载外接磁盘？
Simple life
04-04 8274
一、如何挂外存储上的磁盘到/mnt目录下。 步骤如下： 1、先将服务器关闭。打开磁盘柜，稳定后(大约1～2分钟)，开启服务器。 2、启动命令行，输入format命令，将会显示如下部分信息：      3、上面显示的是对磁盘进行raid操作后的阵列名。要挂载相应的盘，需要在标识符后加上"si"，其实i为0,1,2…… 4、在命令行中输入如下命令：mount  /dev/dsk/c13t6000B5D0006A0000006A
在Solaris平台中ASM所需磁盘的Format过程
congjiaqing0635的博客
06-30 424
近期在增加ASM磁盘过程中遇到如下错误： SQL> alter diskgroup datadg add disk '/dev/rac/DBdg01' rebalance power 0; alter...
solaris 10 安装 oracle 11g R2内核参数设置
upcorange的专栏
03-28 6492
1、根据oracle安装文档给出的建议，要配置如下参数内容，原文内容如下 Parameter Replaced by Resource Control Recommended Value noexec_user_stack NA 1 semsys:seminfo_semmni pro
oracle 11g r2 asm install on solaris 10 sparc
事后诸葛亮的程序人生（微信：zq9017197）
03-09 4225
Database Quick Installation Guide for Oracle Solaris on SPARC (64-Bit)  1、内存要求 # /usr/sbin/prtconf | grep "Memory size" Memory size: 65536 Megabytes                           --这里是64GB。 #
oracle asm操作,Oracle ASM操作详细方法
weixin_42311349的博客
04-05 804
Oracle ASM操作详细步骤一.检查虚拟机的相关配置：[root@rac1 ~]# ifconfig eth0eth0 Link encap:Ethernet HWaddr 00:0C:29:E3:7D:59inet addr:10.1.1.210 Bcast:10.1.1.255 Mask:255.255.255.0inet6 addr: fe80::20c:29ff:fee...
oracle10g asm 命令,创建 Oracle10g ASM 数据库（1）
weixin_33293858的博客
04-15 152
搭建一个测试环境，能够进行ASM的管理学习：Normal07.8 磅02falsefalsefalseEN-USZH-CNX-NONE硬件配置IBM Xseries 346Xen 3.6G，4G内存，70G硬盘+36G+36G硬盘2软件配置RHEL 5.3，Oracle10gfor Linux 64bit环境说明本环境使用IBM服务器上安装RHEL 5.3的64位系统，硬盘两块，分别为76G和36...
oracle asm结构,深入了解Oracle ASM
weixin_42297665的博客
04-13 2601
ASM基础概念相关文章链接：Automatic Storage Management是Oracle 在版本10g中率先(对比其他RDBMS)提出的数据库存储自动解决方案，在版本11g中得到进一步升华。ASM提供了数据库管理所需要的一个简单、有效的存储管理接口，该接口实现了跨服务器和存储平台。 ASM是文件系统filesystem和volume manager卷管理软件的一体化，专门为Oracle的...
Vmware上安装Solaris10+Oracle10gRAC+ASM
阿九的宅基地
04-15 2023
作者 阿九【转载时请务必以超链接形式标明文章原始出处和作者信息】  在Vmware上安装Solaris10+Oracle10gRAC+ASM   作者：杨九荣 QQ：47538I607        邮箱：daisycutter-y@163.com 一、安装环境介绍： CPU : Genuine Intel 2140 ROM: 2G
Oracle ASM 管理
微风
09-01 2105
自动存储管理即ASM（Automatic Storage Management)，是Oracle提供的一项管理磁盘的功能，它是一种以纯软件方式实现的逻辑卷管理器，功能上提供了基于Oracle数据文件的条带化和可选的镜像。ASM的知识同时涉及了数据库管理和系统管理两大领域。 物理卷：指的是独立磁盘，或磁盘分区或磁盘RAID结构。 逻辑卷：LVM（Logical Volume Manager),以软件方式将虚拟磁盘呈现给用户，LVM是操作系统级别的。提供了磁盘管理的灵活性，可靠性，具有条带，镜像和快照等功能。
Solaris11.4环境下Oracle11g RAC系统配置指南
"该文档详细介绍了在Solaris 11.4操作系统上安装Oracle 11g R2 RAC的前期准备步骤。包括了检查安装包、创建系统用户和组、以及创建目录并授权等关键任务。" 在安装Oracle 11g R2 Real Application Clusters (RAC) ...
在Solaris上安装配置Oracle 11g RAC详细步骤
详细介绍如何在solaris上安装配置oracle11g rac 一、安装Solaris10操作系统 1. 安装Solaris10操作系统，具体过程从略，只指出需要注意的几点。 二、安装Oracle 11g RAC 1. 在两个RAC节点的主机上安装Oracle 11g ...
需求EAV模型的优化与思考
HAN_789的博客
08-06 330
针对EAV（Entity-Attribute-Value）存储模型及Elasticsearch集成需求，以下是详细方案设计和实现建议。
知识随记-----Qt 实用技巧：自定义倒计时按钮防止用户频繁点击
最新发布
筏的博客
08-08 489
用户点击后按钮进入倒计时状态，倒计时结束后才能再次点击
mysql 实现列转行和行转列
质量不太好的博客
08-04 816
mysql 实现列转行和行转列
菜鸟集团招Java研发啦
jobleap.cn求职助手首页
08-04 416
菜鸟集团招聘JAVA研发工程师，工作地点杭州。岗位职责包括分布式系统开发、高性能服务端程序设计、搜索引擎模块实现及海量数据处理。要求精通JAVA等编程语言，熟悉网络编程、Linux环境和数据库技术，具备扎实的算法基础。优先考虑有互联网实习经历、ACM竞赛获奖或学术成果的候选人。该职位面向具备良好学习能力和团队协作精神的技术人才。
ORACLE复杂查询
ZZH1120KQ的博客
08-04 1518
在Oracle数据库中，逻辑判断和条件判断是两个密切相关但又不完全相同的概念。逻辑判断主要关注的是根据逻辑运算符（如AND、OR、NOT）对条件表达式的结果进行逻辑运算，从而得出最终的布尔值（true或false）。条件判断则更侧重于根据给定的条件或表达式来判断某个操作是否应该执行，或者应该执行哪个分支的操作。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值